public void OnInitialize() { SetupConfig(); for (int i = 0; i < SSConfig.BuyRatePermissions.Length; i++) { BuyRatePermissions.Add(SSConfig.BuyRatePermissions[i]); BuyRates.Add(SSConfig.BuyRates[i]); } if (!Directory.Exists(ShopLogs)) { Directory.CreateDirectory(ShopLogs); } if (!File.Exists(ShopLogSavePath)) { File.Create(ShopLogSavePath).Close(); } bool serverbuy = false; bool seehiddenprices = false; bool buy = false; bool buyrate = false; foreach (Group group in TShock.Groups.groups) { if (group.Name != "superadmin") { if (group.HasPermission("serverbuy")) serverbuy = true; if (group.HasPermission("seehiddenprices")) seehiddenprices = true; if (group.HasPermission("buy")) buy = true; if (group.HasPermission("buyrate")) buyrate = true; } } List<string> permlist = new List<string>(); if (!serverbuy) permlist.Add("serverbuy"); if (!seehiddenprices) permlist.Add("seehiddenprices"); if (!buy) permlist.Add("buy"); if (!buyrate) permlist.Add("buyrate"); bool setshop = false; foreach (Group group in TShock.Groups.groups) { if (group.Name != "superadmin") { if (group.HasPermission("setshop")) setshop = true; } } if (!setshop) permlist.Add("setshop"); TShock.Groups.AddPermissions("trustedadmin", permlist); Commands.ChatCommands.Add(new Command("buy", Buy, "buy")); Commands.ChatCommands.Add(new Command("serverbuy", Servershop, "servershop")); Commands.ChatCommands.Add(new Command("serverbuy", Servershop, "ss")); Commands.ChatCommands.Add(new Command("setshop", Setshop, "setshop")); Commands.ChatCommands.Add(new Command("buyrate", BuyRate, "buyrate")); SQLEditor = new SqlTableEditor(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); var table = new SqlTable("ServerShopCatalogue", new SqlColumn("ID", MySqlDbType.Int32) { Primary = true }, new SqlColumn("Name", MySqlDbType.String, 255) { Unique = true }, new SqlColumn("Price", MySqlDbType.Int32), new SqlColumn("MaxStack", MySqlDbType.Int32), new SqlColumn("InStock", MySqlDbType.Int32), new SqlColumn("ShopName", MySqlDbType.String, 255), new SqlColumn("Hidden", MySqlDbType.Int32), new SqlColumn("Permission", MySqlDbType.String, 255) ); SQLWriter.EnsureExists(table); string alpha = "abcdefghijklmnopqrstuvwkyz"; if (SQLEditor.ReadColumn("ServerShopCatalogue", "ID", new List<SqlValue>()).Count < 1) { Console.WriteLine("Creating Item Price List..."); foreach (char letter in alpha) //for (Int32 i = 1; i < 364; i++ ) { string firstletter = "" + letter + ""; for (int k = 0; k < TShockAPI.TShock.Utils.GetItemByName(firstletter).Count; k++) //for (Int32 k = 0; k < TShockAPI.TShock.Utils.GetItemByIdOrName(i.ToString()).Count; k++) { Item item = TShockAPI.TShock.Utils.GetItemByName(firstletter)[k]; int price = item.value / 5; int i = item.type; string space = " "; string itemID = i.ToString(); string itemname = item.name; string apostrophe = "'"; char[] apostrophetochar = apostrophe.ToCharArray(); itemname = itemname.Replace(apostrophetochar[0], ' '); int itemmaxstack = item.maxStack; List<SqlValue> list = new List<SqlValue>(); list.Add(new SqlValue("ID", i)); list.Add(new SqlValue("Name", "'" + itemname + "'")); list.Add(new SqlValue("Price", price)); list.Add(new SqlValue("MaxStack", itemmaxstack)); list.Add(new SqlValue("InStock", 1)); list.Add(new SqlValue("ShopName", "'" + space + "'")); list.Add(new SqlValue("Hidden", 0)); try { SQLEditor.InsertValues("ServerShopCatalogue", list); } catch (Exception) { } } } } if (SQLEditor.ReadColumn("ServerShopCatalogue", "ID", new List<SqlValue>()).Count > 0) { Console.WriteLine("Loading Item Price List..."); for (int i = 0; i < SQLEditor.ReadColumn("ServerShopCatalogue", "ID", new List<SqlValue>()).Count; i++) { int id = Int32.Parse(SQLEditor.ReadColumn("ServerShopCatalogue", "ID", new List<SqlValue>())[i].ToString()); List<SqlValue> where = new List<SqlValue>(); where.Add(new SqlValue("ID", id)); string name = SQLEditor.ReadColumn("ServerShopCatalogue", "Name", where)[0].ToString(); int price = Int32.Parse(SQLEditor.ReadColumn("ServerShopCatalogue", "Price", where)[0].ToString()); bool instock = Int32.Parse(SQLEditor.ReadColumn("ServerShopCatalogue", "InStock", where)[0].ToString()) == 0 ? false : true; string shopname = SQLEditor.ReadColumn("ServerShopCatalogue", "ShopName", where)[0].ToString(); bool hidden = Int32.Parse(SQLEditor.ReadColumn("ServerShopCatalogue", "Hidden", where)[0].ToString()) == 0 ? false : true; string permission; try { permission = SQLEditor.ReadColumn("ServerShopCatalogue", "Permission", where)[0].ToString(); } catch (NullReferenceException) { permission = null; } SSCatalogue.Add(new ServerShopCatalogueItem(id, name, price, instock, shopname, permission, hidden)); if (!ShopList.Contains(shopname)) ShopList.Add(shopname); } for (int i = 0; i < ShopList.Count; i++ ) { if (ShopList[i] == " ") ShopList.RemoveAt(i); } } SSCatalogueInStock = GetItemsInStock(); }
public void OnInitialize() { Main.buffName[1] = "Obsidian Skin"; Main.buffName[2] = "Regeneration"; Main.buffName[3] = "Swiftness"; Main.buffName[4] = "Gills"; Main.buffName[5] = "Ironskin"; Main.buffName[6] = "Mana Regeneration"; Main.buffName[7] = "Magic Power"; Main.buffName[8] = "Featherfall"; Main.buffName[9] = "Spelunker"; Main.buffName[10] = "Invisibility"; Main.buffName[11] = "Shine"; Main.buffName[12] = "Night Owl"; Main.buffName[13] = "Battle"; Main.buffName[14] = "Thorns"; Main.buffName[15] = "Water Walking"; Main.buffName[0x10] = "Archery"; Main.buffName[0x11] = "Hunter"; Main.buffName[0x12] = "Gravitation"; Main.buffName[0x13] = "Orb of Light"; Main.buffName[20] = "Poisoned"; Main.buffName[0x15] = "Potion Sickness"; Main.buffName[0x16] = "Darkness"; Main.buffName[0x17] = "Cursed"; Main.buffName[0x18] = "On Fire!"; Main.buffName[0x19] = "Tipsy"; Main.buffName[0x1a] = "Well Fed"; SQLEditor = new SqlTableEditor(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); var table = new SqlTable("regionMow", new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("Mow", MySqlDbType.Int32)); SQLWriter.EnsureExists(table); var table2 = new SqlTable("muteList", new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("IP", MySqlDbType.Text)); SQLWriter.EnsureExists(table2); var readTableName = SQLEditor.ReadColumn("regionMow", "Name", new List<SqlValue>()); var readTableBool = SQLEditor.ReadColumn("regionMow", "Mow", new List<SqlValue>()); for (int i = 0; i < readTableName.Count; i++) { try { regionMow.Add(readTableName[i].ToString(), Convert.ToBoolean(readTableBool[i])); } catch (Exception) { } } reload(); List<string> permlist = new List<string>(); permlist.Add("ghostmode"); permlist.Add("fly"); permlist.Add("flymisc"); permlist.Add("mute"); permlist.Add("reloadmore"); permlist.Add("permabuff"); TShock.Groups.AddPermissions("trustedadmin", permlist); for (int i = 0; i < 256; i++) { isGhost[i] = false; isHeal[i] = false; flyMode[i] = false; upPressed[i] = false; carpetPoints.Add(new List<Vector2>()); buffsUsed.Add(new List<int>()); muted[i] = false; muteTime[i] = -1; muteAllFree[i] = false; viewAll[i] = false; accessRed[i] = (redPass == ""); accessBlue[i] = (bluePass == ""); accessGreen[i] = (greenPass == ""); accessYellow[i] = (yellowPass == ""); autoKill[i] = false; tpOff[i] = false; } Commands.ChatCommands.Add(new Command("ghostmode", Ghost, "ghost")); Commands.ChatCommands.Add(new Command("time", FreezeTime, "freezetime")); Commands.ChatCommands.Add(new Command("spawnmob", SpawnMobPlayer, "spawnmobplayer")); Commands.ChatCommands.Add(new Command("spawnmob", SpawnAll, "spawnall")); Commands.ChatCommands.Add(new Command("spawnmob", SpawnGroup, "spawngroup")); Commands.ChatCommands.Add(new Command("autoheal", AutoHeal, "autoheal")); Commands.ChatCommands.Add(new Command("fly", Fly, "fly")); Commands.ChatCommands.Add(new Command("flymisc", Fetch, "fetch")); //Commands.ChatCommands.Add(new Command("flymisc", CarpetBody, "carpetbody")); //Commands.ChatCommands.Add(new Command("flymisc", CarpetSides, "carpetsides")); Commands.ChatCommands.Add(new Command("editspawn", Mow, "mow")); Commands.ChatCommands.Add(new Command("permabuff", permaBuff, "permabuff")); Commands.ChatCommands.Add(new Command("permabuff", permaBuffAll, "permabuffall")); Commands.ChatCommands.Add(new Command("permabuff", permaBuffGroup, "permabuffgroup")); Commands.ChatCommands.Add(new Command("item", ForceGive, "forcegive")); Commands.ChatCommands.Add(new Command("killall", KillAll, "killall")); Commands.ChatCommands.Add(new Command("mute", Mute, "mute")); Commands.ChatCommands.Add(new Command("mute", PermaMute, "permamute")); Commands.ChatCommands.Add(new Command("muteall", MuteAll, "muteall")); Commands.ChatCommands.Add(new Command("butcher", ButcherAll, "butcherall")); Commands.ChatCommands.Add(new Command("butcher", ButcherFriendly, "butcherfriendly")); Commands.ChatCommands.Add(new Command("butcher", ButcherNPC, "butchernpc")); Commands.ChatCommands.Add(new Command("butcher", ButcherNear, "butchernear")); Commands.ChatCommands.Add(new Command("spawnmob", SpawnByMe, "spawnbyme")); //Commands.ChatCommands.Add(new Command("clearitems", ClearItems, "clearitems")); Commands.ChatCommands.Add(new Command("reloadmore", ReloadMore, "reloadmore")); Commands.ChatCommands.Add(new Command("viewall", ViewAll, "viewall")); Commands.ChatCommands.Add(new Command(null, TeamUnlock, "teamunlock")); Commands.ChatCommands.Add(new Command("autokill", AutoKill, "autokill")); Commands.ChatCommands.Add(new Command("forcepvp", ForcePvP, "forcepvp")); Commands.ChatCommands.Add(new Command("forcepvp", CanOffPvP, "canoffpvp")); Commands.ChatCommands.Add(new Command("antitp", TPOff, "tpoff")); Commands.ChatCommands.Add(new Command("moonphase", MoonPhase, "moonphase")); }
internal void OnInitialize(EventArgs args) { if (C3Config.TeamColor1 < 1 || C3Config.TeamColor1 > 4 || C3Config.TeamColor1 == C3Config.TeamColor2 || C3Config.TeamColor2 > 4 || C3Config.TeamColor2 < 1) throw new Exception("Team Colours are inccorectly set up. Check c3config.json"); SQLEditor = new SqlTableEditor(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); ApocalypseMonsters.AddNPCs(); int ArenaCount; #region TestPerms //Checks to see if permissions have been moved around bool vote = false; bool joinvote = false; bool setflags = false; bool setspawns = false; bool managec3settings = false; bool cvote = false; bool duel = false; foreach (Group group in TShock.Groups.groups) { if (group.Name != "superadmin") { if (group.HasPermission("vote")) vote = true; if (group.HasPermission("joinvote")) joinvote = true; if (group.HasPermission("setflags")) setflags = true; if (group.HasPermission("managec3settings")) managec3settings = true; if (group.HasPermission("cvote")) cvote = true; if (group.HasPermission("duel")) duel = true; if (group.HasPermission("setspawns")) setspawns = true; } } List<string> perm = new List<string>(); if (!vote) perm.Add("vote"); if (!joinvote) perm.Add("joinvote"); if (!duel) perm.Add("duel"); TShock.Groups.AddPermissions("default", perm); perm.Clear(); if (!setflags) perm.Add("setflags"); if (!setflags) perm.Add("setspawns"); if (!managec3settings) perm.Add("managec3settings"); if (!cvote) perm.Add("cvote"); if (!setspawns) perm.Add("setspawns"); TShock.Groups.AddPermissions("trustedadmin", perm); #endregion //Converted v2.2 #region AddCommands if (C3Mod.C3Config.TeamColor1 == 1) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Flag, "setctfredflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Spawn, "setctfredspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam1Spawn, "setoneflagredspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam1Spawn, "setduelredspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam1Spawn, "settdmredspawn")); } else if (C3Mod.C3Config.TeamColor1 == 2) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Flag, "setctfgreenflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Spawn, "setctfgreenspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam1Spawn, "setoneflaggreenspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam1Spawn, "setduelgreenspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam1Spawn, "settdmgreenspawn")); } else if (C3Mod.C3Config.TeamColor1 == 3) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Flag, "setctfblueflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Spawn, "setctfbluespawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam1Spawn, "setoneflagbluespawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam1Spawn, "setduelbluespawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam1Spawn, "settdmbluespawn")); } else if (C3Mod.C3Config.TeamColor1 == 4) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Flag, "setctfyellowflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam1Spawn, "setctfyellowspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam1Spawn, "setoneflagyellowspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam1Spawn, "setduelyellowspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam1Spawn, "settdmyellowspawn")); } if (C3Mod.C3Config.TeamColor2 == 1) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Flag, "setctfredflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Spawn, "setctfredspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam2Spawn, "setoneflagredspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam2Spawn, "setduelredspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam2Spawn, "settdmredspawn")); } else if (C3Mod.C3Config.TeamColor2 == 2) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Flag, "setctfgreenflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Spawn, "setctfgreenspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam2Spawn, "setoneflaggreenspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam2Spawn, "setduelgreenspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam2Spawn, "settdmgreenspawn")); } else if (C3Mod.C3Config.TeamColor2 == 3) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Flag, "setctfblueflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Spawn, "setctfbluespawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam2Spawn, "setoneflagbluespawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam2Spawn, "setduelbluespawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam2Spawn, "settdmbluespawn")); } else if (C3Mod.C3Config.TeamColor2 == 4) { Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Flag, "setctfyellowflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFTeam2Spawn, "setctfyellowspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagTeam2Spawn, "setoneflagyellowspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelTeam2Spawn, "setduelyellowspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMTeam2Spawn, "settdmyellowspawn")); } Commands.ChatCommands.Add(new Command("setflags", C3Commands.AddCTFArena, "addctfarena")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlag, "setoneflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.AddOneFlagArena, "addoneflagarena")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.AddDuelArena, "addduelarena")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.AddTDMArena, "addtdmarena")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetFFASpawn, "setffaspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.AddFFAArena, "addffaarena")); Commands.ChatCommands.Add(new Command("vote", C3Commands.StartVote, "vote")); Commands.ChatCommands.Add(new Command("joinvote", C3Commands.JoinVote, "join")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.Stop, "stop")); Commands.ChatCommands.Add(new Command(C3Commands.Quit, "quit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetCTFLimit, "setctflimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetOneFlagLimit, "setoneflaglimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetDuelLimit, "setduellimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetTDMLimit, "settdmlimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetFFALimit, "setffalimit")); Commands.ChatCommands.Add(new Command("cvote", C3Commands.CancelVote, "cvote")); Commands.ChatCommands.Add(new Command("duel", C3Commands.ChallengePlayer, "duel")); Commands.ChatCommands.Add(new Command(C3Commands.AcceptChallenge, "accept")); Commands.ChatCommands.Add(new Command(C3Commands.ListArenaID, "list")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetApocPlayerSpawn, "setapocplayerspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetApocMonsterSpawn, "setapocmonsterspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetApocSpectatorSpawn, "setapocspectatorspawn")); #endregion #region FlagPoints var table = new SqlTable("FlagPoints", new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("RedX", MySqlDbType.Int32), new SqlColumn("RedY", MySqlDbType.Int32), new SqlColumn("BlueX", MySqlDbType.Int32), new SqlColumn("BlueY", MySqlDbType.Int32), new SqlColumn("RedSpawnX", MySqlDbType.Int32), new SqlColumn("RedSpawnY", MySqlDbType.Int32), new SqlColumn("BlueSpawnX", MySqlDbType.Int32), new SqlColumn("BlueSpawnY", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); if ((ArenaCount = SQLEditor.ReadColumn("FlagPoints", "Name", new List<SqlValue>()).Count) != 0) { for (int i = 0; i < ArenaCount; i++) { string name = SQLEditor.ReadColumn("FlagPoints", "Name", new List<SqlValue>())[i].ToString(); int redx = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "RedX", new List<SqlValue>())[i].ToString()); int redy = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "RedY", new List<SqlValue>())[i].ToString()); int bluex = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "BlueX", new List<SqlValue>())[i].ToString()); int bluey = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "BlueY", new List<SqlValue>())[i].ToString()); int redspawnx = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "RedSpawnX", new List<SqlValue>())[i].ToString()); int redspawny = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "RedSpawnY", new List<SqlValue>())[i].ToString()); int bluespawnx = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "BlueSpawnX", new List<SqlValue>())[i].ToString()); int bluespawny = Int32.Parse(SQLEditor.ReadColumn("FlagPoints", "BlueSpawnY", new List<SqlValue>())[i].ToString()); CTF.Arenas.Add(new CTFArena(new Vector2(redx, redy), new Vector2(bluex, bluey), new Vector2(redspawnx, redspawny), new Vector2(bluespawnx, bluespawny), name)); } } #endregion #region DuelSpawns table = new SqlTable("DuelSpawns", new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("RedSpawnX", MySqlDbType.Int32), new SqlColumn("RedSpawnY", MySqlDbType.Int32), new SqlColumn("BlueSpawnX", MySqlDbType.Int32), new SqlColumn("BlueSpawnY", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); if ((ArenaCount = SQLEditor.ReadColumn("DuelSpawns", "Name", new List<SqlValue>()).Count) != 0) { for (int i = 0; i < ArenaCount; i++) { string name = SQLEditor.ReadColumn("DuelSpawns", "Name", new List<SqlValue>())[0].ToString(); int redx = Int32.Parse(SQLEditor.ReadColumn("DuelSpawns", "RedSpawnX", new List<SqlValue>())[0].ToString()); int redy = Int32.Parse(SQLEditor.ReadColumn("DuelSpawns", "RedSpawnY", new List<SqlValue>())[0].ToString()); int bluex = Int32.Parse(SQLEditor.ReadColumn("DuelSpawns", "BlueSpawnX", new List<SqlValue>())[0].ToString()); int bluey = Int32.Parse(SQLEditor.ReadColumn("DuelSpawns", "BlueSpawnY", new List<SqlValue>())[0].ToString()); Duel.Arenas.Add(new DuelArena(new Vector2(redx, redy), new Vector2(bluex, bluey), name)); } } #endregion #region OneFlagPoints table = new SqlTable("OneFlagPoints", new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("FlagX", MySqlDbType.Int32), new SqlColumn("FlagY", MySqlDbType.Int32), new SqlColumn("RedSpawnX", MySqlDbType.Int32), new SqlColumn("RedSpawnY", MySqlDbType.Int32), new SqlColumn("BlueSpawnX", MySqlDbType.Int32), new SqlColumn("BlueSpawnY", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); if ((ArenaCount = SQLEditor.ReadColumn("OneFlagPoints", "Name", new List<SqlValue>()).Count) != 0) { for (int i = 0; i < ArenaCount; i++) { string name = SQLEditor.ReadColumn("OneFlagPoints", "Name", new List<SqlValue>())[i].ToString(); int flagx = Int32.Parse(SQLEditor.ReadColumn("OneFlagPoints", "FlagX", new List<SqlValue>())[i].ToString()); int flagy = Int32.Parse(SQLEditor.ReadColumn("OneFlagPoints", "FlagY", new List<SqlValue>())[i].ToString()); int redspawnx = Int32.Parse(SQLEditor.ReadColumn("OneFlagPoints", "RedSpawnX", new List<SqlValue>())[i].ToString()); int redspawny = Int32.Parse(SQLEditor.ReadColumn("OneFlagPoints", "RedSpawnY", new List<SqlValue>())[i].ToString()); int bluespawnx = Int32.Parse(SQLEditor.ReadColumn("OneFlagPoints", "BlueSpawnX", new List<SqlValue>())[i].ToString()); int bluespawny = Int32.Parse(SQLEditor.ReadColumn("OneFlagPoints", "BlueSpawnY", new List<SqlValue>())[i].ToString()); OneFlagCTF.Arenas.Add(new OneFlagArena(new Vector2(flagx, flagy), new Vector2(redspawnx, redspawny), new Vector2(bluespawnx, bluespawny), name)); } } #endregion #region TDMSpawns table = new SqlTable("TDMSpawns", new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("RedSpawnX", MySqlDbType.Int32), new SqlColumn("RedSpawnY", MySqlDbType.Int32), new SqlColumn("BlueSpawnX", MySqlDbType.Int32), new SqlColumn("BlueSpawnY", MySqlDbType.Int32) ); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter.EnsureExists(table); if ((ArenaCount = SQLEditor.ReadColumn("TDMSpawns", "Name", new List<SqlValue>()).Count) != 0) { for (int i = 0; i < ArenaCount; i++) { string name = SQLEditor.ReadColumn("TDMSpawns", "Name", new List<SqlValue>())[i].ToString(); int redx = Int32.Parse(SQLEditor.ReadColumn("TDMSpawns", "RedSpawnX", new List<SqlValue>())[i].ToString()); int redy = Int32.Parse(SQLEditor.ReadColumn("TDMSpawns", "RedSpawnY", new List<SqlValue>())[i].ToString()); int bluex = Int32.Parse(SQLEditor.ReadColumn("TDMSpawns", "BlueSpawnX", new List<SqlValue>())[i].ToString()); int bluey = Int32.Parse(SQLEditor.ReadColumn("TDMSpawns", "BlueSpawnY", new List<SqlValue>())[i].ToString()); TDM.Arenas.Add(new TDMArena(new Vector2(redx, redy), new Vector2(bluex, bluey), name)); } } #endregion #region FFASpawns table = new SqlTable("FFASpawns", new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("SpawnX", MySqlDbType.Int32), new SqlColumn("SpawnY", MySqlDbType.Int32) ); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter.EnsureExists(table); if ((ArenaCount = SQLEditor.ReadColumn("FFASpawns", "Name", new List<SqlValue>()).Count) != 0) { for (int i = 0; i < ArenaCount; i++) { string name = SQLEditor.ReadColumn("FFASpawns", "Name", new List<SqlValue>())[i].ToString(); int x = Int32.Parse(SQLEditor.ReadColumn("FFASpawns", "SpawnX", new List<SqlValue>())[i].ToString()); int y = Int32.Parse(SQLEditor.ReadColumn("FFASpawns", "SpawnY", new List<SqlValue>())[i].ToString()); FFA.Arenas.Add(new FFAArena(new Vector2(x, y), name)); } } #endregion #region Apocalypse table = new SqlTable("Apocalypse", new SqlColumn("SpawnX", MySqlDbType.Int32), new SqlColumn("SpawnY", MySqlDbType.Int32), new SqlColumn("MonsterSpawnX", MySqlDbType.Int32), new SqlColumn("MonsterSpawnY", MySqlDbType.Int32), new SqlColumn("SpectatorSpawnX", MySqlDbType.Int32), new SqlColumn("SpectatorSpawnY", MySqlDbType.Int32) ); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter.EnsureExists(table); if (SQLEditor.ReadColumn("Apocalypse", "SpawnX", new List<SqlValue>()).Count == 0) { List<SqlValue> list = new List<SqlValue>(); list.Add(new SqlValue("SpawnX", 0)); list.Add(new SqlValue("SpawnY", 0)); list.Add(new SqlValue("MonsterSpawnX", 0)); list.Add(new SqlValue("MonsterSpawnY", 0)); list.Add(new SqlValue("SpectatorSpawnX", 0)); list.Add(new SqlValue("SpectatorSpawnY", 0)); SQLEditor.InsertValues("Apocalypse", list); } else { Apocalypse.PlayerSpawn.X = Int32.Parse(SQLEditor.ReadColumn("Apocalypse", "SpawnX", new List<SqlValue>())[0].ToString()); Apocalypse.PlayerSpawn.Y = Int32.Parse(SQLEditor.ReadColumn("Apocalypse", "SpawnY", new List<SqlValue>())[0].ToString()); Apocalypse.MonsterSpawn.X = Int32.Parse(SQLEditor.ReadColumn("Apocalypse", "MonsterSpawnX", new List<SqlValue>())[0].ToString()); Apocalypse.MonsterSpawn.Y = Int32.Parse(SQLEditor.ReadColumn("Apocalypse", "MonsterSpawnY", new List<SqlValue>())[0].ToString()); Apocalypse.SpectatorArea.X = Int32.Parse(SQLEditor.ReadColumn("Apocalypse", "SpectatorSpawnX", new List<SqlValue>())[0].ToString()); Apocalypse.SpectatorArea.Y = Int32.Parse(SQLEditor.ReadColumn("Apocalypse", "SpectatorSpawnY", new List<SqlValue>())[0].ToString()); } #endregion }
public void OnInitialize() { SQLEditor = new SqlTableEditor(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); #region Setup bool sethouse = false; bool edithouse = false; bool enterlocked = false; foreach (Group group in TShock.Groups.groups) { if (group.Name != "superadmin") { if (group.HasPermission("sethouse")) sethouse = true; if (group.HasPermission("edithouse")) edithouse = true; if (group.HasPermission("enterlocked")) enterlocked = true; } } List<string> perm = new List<string>(); if (!sethouse) perm.Add("sethouse"); if (!edithouse) perm.Add("edithouse"); if (!enterlocked) perm.Add("enterlocked"); TShock.Groups.AddPermissions("trustedadmin", perm); var table = new SqlTable("HousingDistrict", new SqlColumn("ID", MySqlDbType.Int32) { Primary = true, AutoIncrement = true }, new SqlColumn("Name", MySqlDbType.Text) { Unique = true }, new SqlColumn("TopX", MySqlDbType.Int32), new SqlColumn("TopY", MySqlDbType.Int32), new SqlColumn("BottomX", MySqlDbType.Int32), new SqlColumn("BottomY", MySqlDbType.Int32), new SqlColumn("Owners", MySqlDbType.Text), new SqlColumn("WorldID", MySqlDbType.Text), new SqlColumn("Locked", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); for (int i = 0; i < SQLEditor.ReadColumn("HousingDistrict", "ID", new List<SqlValue>()).Count; i++) { string[] list = SQLEditor.ReadColumn("HousingDistrict", "Owners", new List<SqlValue>())[i].ToString().Split(','); List<string> items = new List<string>(); foreach (string item in list) { items.Add(item); } int locked = 0; if (SQLEditor.ReadColumn("HousingDistrict", "Locked", new List<SqlValue>())[i] != null) { locked = (int)SQLEditor.ReadColumn("HousingDistrict", "Locked", new List<SqlValue>())[i]; } Houses.Add(new House( new Rectangle( (int)SQLEditor.ReadColumn("HousingDistrict", "TopX", new List<SqlValue>())[i], (int)SQLEditor.ReadColumn("HousingDistrict", "TopY", new List<SqlValue>())[i], (int)SQLEditor.ReadColumn("HousingDistrict", "BottomX", new List<SqlValue>())[i], (int)SQLEditor.ReadColumn("HousingDistrict", "BottomY", new List<SqlValue>())[i]), items, (int)SQLEditor.ReadColumn("HousingDistrict", "ID", new List<SqlValue>())[i], (string)SQLEditor.ReadColumn("HousingDistrict", "Name", new List<SqlValue>())[i], (string)SQLEditor.ReadColumn("HousingDistrict", "WorldID", new List<SqlValue>())[i], locked)); } #endregion #region Commands Commands.ChatCommands.Add(new Command("sethouse", HCommands.House, "house")); Commands.ChatCommands.Add(new Command("superadmin", HCommands.Convert, "converthouse")); Commands.ChatCommands.Add(new Command(HCommands.ChangeLock, "changelock")); Commands.ChatCommands.Add(new Command(HCommands.TellAll, "all")); #endregion }
public void OnInitialize() { SQLEditor = new SqlTableEditor(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); bool setcost = false; bool freewarp = false; bool freetp = false; bool freeheal = false; bool freebuff = false; bool checkcommandcost = false; foreach (Group group in TShock.Groups.groups) { if (group.Name != "superadmin") { if (group.HasPermission("setcost")) setcost = true; if (group.HasPermission("freewarp")) freewarp = true; if (group.HasPermission("freetp")) freetp = true; if (group.HasPermission("freeheal")) freeheal = true; if (group.HasPermission("freebuff")) setcost = true; if (group.HasPermission("checkcommandcost")) checkcommandcost = true; } } List<string> permlist = new List<string>(); if (!setcost) permlist.Add("setcost"); if (!freewarp) permlist.Add("freewarp"); if (!freetp) permlist.Add("freetp"); if (!freeheal) permlist.Add("freeheal"); if (!freebuff) permlist.Add("freebuff"); if (!checkcommandcost) permlist.Add("checkcommandcost"); TShock.Groups.AddPermissions("trustedadmin", permlist); Commands.ChatCommands.Add(new Command("setcost", SetCost, "setcost")); Commands.ChatCommands.Add(new Command("setcost", SetWarpCost, "setwarpcost")); Commands.ChatCommands.Add(new Command("checkcommandcost", CheckCommandCost, "checkcommandcost")); Commands.ChatCommands.Add(new Command("checkcommandcost", CheckWarpCost, "checkwarpcost")); var table = new SqlTable("CommandCosts", new SqlColumn("Command", MySqlDbType.String, 255) { Unique = true }, new SqlColumn("Cost", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); if (SQLEditor.ReadColumn("CommandCosts", "Command", new List<SqlValue>()).Count == 0) { List<SqlValue> tp = new List<SqlValue>(); tp.Add(new SqlValue("Command", "'" + "tp" + "'")); tp.Add(new SqlValue("Cost", 100)); SQLEditor.InsertValues("CommandCosts", tp); List<SqlValue> heal = new List<SqlValue>(); heal.Add(new SqlValue("Command", "'" + "heal" + "'")); heal.Add(new SqlValue("Cost", 100)); SQLEditor.InsertValues("CommandCosts", heal); List<SqlValue> buff = new List<SqlValue>(); buff.Add(new SqlValue("Command", "'" + "buff" + "'")); buff.Add(new SqlValue("Cost", 100)); SQLEditor.InsertValues("CommandCosts", buff); List<SqlValue> warp = new List<SqlValue>(); warp.Add(new SqlValue("Command", "'" + "warp" + "'")); warp.Add(new SqlValue("Cost", 100)); SQLEditor.InsertValues("CommandCosts", warp); } List<SqlValue> where1 = new List<SqlValue>(); where1.Add(new SqlValue("Command", "'" + "warp" + "'")); warpcost = Int32.Parse(SQLEditor.ReadColumn("CommandCosts", "Cost", where1)[0].ToString()); List<SqlValue> where2 = new List<SqlValue>(); where2.Add(new SqlValue("Command", "'" + "tp" + "'")); tpcost = Int32.Parse(SQLEditor.ReadColumn("CommandCosts", "Cost", where1)[0].ToString()); List<SqlValue> where3 = new List<SqlValue>(); where3.Add(new SqlValue("Command", "'" + "heal" + "'")); healcost = Int32.Parse(SQLEditor.ReadColumn("CommandCosts", "Cost", where1)[0].ToString()); List<SqlValue> where4 = new List<SqlValue>(); where4.Add(new SqlValue("Command", "'" + "buff" + "'")); buffcost = Int32.Parse(SQLEditor.ReadColumn("CommandCosts", "Cost", where1)[0].ToString()); }
public void OnInitialize() { SQLEditor = new SqlTableEditor(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); ApocalypseMonsters.AddNPCs(); #region TestPerms //Checks to see if permissions have been moved around bool vote = false; bool joinvote = false; bool setflags = false; bool setspawns = false; bool managec3settings = false; bool cvote = false; bool duel = false; foreach (Group group in TShock.Groups.groups) { if (group.Name != "superadmin") { if (group.HasPermission("vote")) vote = true; if (group.HasPermission("joinvote")) joinvote = true; if (group.HasPermission("setflags")) setflags = true; if (group.HasPermission("managec3settings")) managec3settings = true; if (group.HasPermission("cvote")) cvote = true; if (group.HasPermission("duel")) duel = true; if (group.HasPermission("setspawns")) setspawns = true; } } List<string> perm = new List<string>(); if (!vote) perm.Add("vote"); if (!joinvote) perm.Add("joinvote"); if (!duel) perm.Add("duel"); TShock.Groups.AddPermissions("default", perm); perm.Clear(); if (!setflags) perm.Add("setflags"); if (!setflags) perm.Add("setspawns"); if (!managec3settings) perm.Add("managec3settings"); if (!cvote) perm.Add("cvote"); if (!setspawns) perm.Add("setspawns"); TShock.Groups.AddPermissions("trustedadmin", perm); #endregion #region AddCommands //Adds C3Commands Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFRedFlag, "setctfredflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetCTFBlueFlag, "setctfblueflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlag, "setoneflag")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagRedSpawn, "setoneflagredspawn")); Commands.ChatCommands.Add(new Command("setflags", C3Commands.SetOneFlagBlueSpawn, "setoneflagbluespawn")); Commands.ChatCommands.Add(new Command("vote", C3Commands.StartVote, "vote")); Commands.ChatCommands.Add(new Command("joinvote", C3Commands.JoinVote, "join")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetCTFLimit, "setctflimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetOneFlagLimit, "setoneflaglimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetDuelLimit, "setduellimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.SetTDMLimit, "settdmlimit")); Commands.ChatCommands.Add(new Command("managec3settings", C3Commands.Stop, "stop")); Commands.ChatCommands.Add(new Command("cvote", C3Commands.CancelVote, "cvote")); Commands.ChatCommands.Add(new Command("duel", C3Commands.ChallengePlayer, "duel")); Commands.ChatCommands.Add(new Command(C3Commands.AcceptChallenge, "accept")); Commands.ChatCommands.Add(new Command(C3Commands.Quit, "quit")); Commands.ChatCommands.Add(new Command(C3Commands.Teams, "teams")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelBlueSpawn, "setduelbluespawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetDuelRedSpawn, "setduelredspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMBlueSpawn, "settdmbluespawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetTDMRedSpawn, "settdmredspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetApocPlayerSpawn, "setapocplayerspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetApocMonsterSpawn, "setapocmonsterspawn")); Commands.ChatCommands.Add(new Command("setspawns", C3Commands.SetApocSpectatorSpawn, "setapocspectatorspawn")); #endregion #region FlagPoints var table = new SqlTable("FlagPoints", new SqlColumn("RedX", MySqlDbType.Int32), new SqlColumn("RedY", MySqlDbType.Int32), new SqlColumn("BlueX", MySqlDbType.Int32), new SqlColumn("BlueY", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); if (SQLEditor.ReadColumn("FlagPoints", "RedX", new List<SqlValue>()).Count == 0) { List<SqlValue> list = new List<SqlValue>(); list.Add(new SqlValue("RedX", 0)); list.Add(new SqlValue("RedY", 0)); list.Add(new SqlValue("BlueX", 0)); list.Add(new SqlValue("BlueY", 0)); SQLEditor.InsertValues("FlagPoints", list); } else { CTF.flagPoints[0].X = float.Parse(SQLEditor.ReadColumn("FlagPoints", "RedX", new List<SqlValue>())[0].ToString()); CTF.flagPoints[0].Y = float.Parse(SQLEditor.ReadColumn("FlagPoints", "RedY", new List<SqlValue>())[0].ToString()); CTF.flagPoints[1].X = float.Parse(SQLEditor.ReadColumn("FlagPoints", "BlueX", new List<SqlValue>())[0].ToString()); CTF.flagPoints[1].Y = float.Parse(SQLEditor.ReadColumn("FlagPoints", "BlueY", new List<SqlValue>())[0].ToString()); } #endregion #region DuelSpawns table = new SqlTable("DuelSpawns", new SqlColumn("RedSpawnX", MySqlDbType.Int32), new SqlColumn("RedSpawnY", MySqlDbType.Int32), new SqlColumn("BlueSpawnX", MySqlDbType.Int32), new SqlColumn("BlueSpawnY", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); if (SQLEditor.ReadColumn("DuelSpawns", "RedSpawnX", new List<SqlValue>()).Count == 0) { List<SqlValue> list = new List<SqlValue>(); list.Add(new SqlValue("RedSpawnX", 0)); list.Add(new SqlValue("RedSpawnY", 0)); list.Add(new SqlValue("BlueSpawnX", 0)); list.Add(new SqlValue("BlueSpawnY", 0)); SQLEditor.InsertValues("DuelSpawns", list); } else { Duel.DuelSpawns[0].X = float.Parse(SQLEditor.ReadColumn("DuelSpawns", "RedSpawnX", new List<SqlValue>())[0].ToString()); Duel.DuelSpawns[0].Y = float.Parse(SQLEditor.ReadColumn("DuelSpawns", "RedSpawnY", new List<SqlValue>())[0].ToString()); Duel.DuelSpawns[1].X = float.Parse(SQLEditor.ReadColumn("DuelSpawns", "BlueSpawnX", new List<SqlValue>())[0].ToString()); Duel.DuelSpawns[1].Y = float.Parse(SQLEditor.ReadColumn("DuelSpawns", "BlueSpawnY", new List<SqlValue>())[0].ToString()); } #endregion #region OneFlagPoints table = new SqlTable("OneFlagPoints", new SqlColumn("FlagX", MySqlDbType.Int32), new SqlColumn("FlagY", MySqlDbType.Int32), new SqlColumn("RedSpawnX", MySqlDbType.Int32), new SqlColumn("RedSpawnY", MySqlDbType.Int32), new SqlColumn("BlueSpawnX", MySqlDbType.Int32), new SqlColumn("BlueSpawnY", MySqlDbType.Int32) ); SQLWriter.EnsureExists(table); if (SQLEditor.ReadColumn("OneFlagPoints", "RedSpawnX", new List<SqlValue>()).Count == 0) { List<SqlValue> list = new List<SqlValue>(); list.Add(new SqlValue("FlagX", 0)); list.Add(new SqlValue("FlagY", 0)); list.Add(new SqlValue("RedSpawnX",0)); list.Add(new SqlValue("RedSpawnY", 0)); list.Add(new SqlValue("BlueSpawnX", 0)); list.Add(new SqlValue("BlueSpawnY", 0)); SQLEditor.InsertValues("OneFlagPoints", list); } else { OneFlagCTF.FlagPoint.X = float.Parse(SQLEditor.ReadColumn("OneFlagPoints", "FlagX", new List<SqlValue>())[0].ToString()); OneFlagCTF.FlagPoint.Y = float.Parse(SQLEditor.ReadColumn("OneFlagPoints", "FlagY", new List<SqlValue>())[0].ToString()); OneFlagCTF.SpawnPoint[0].X = float.Parse(SQLEditor.ReadColumn("OneFlagPoints", "RedSpawnX", new List<SqlValue>())[0].ToString()); OneFlagCTF.SpawnPoint[0].Y = float.Parse(SQLEditor.ReadColumn("OneFlagPoints", "RedSpawnY", new List<SqlValue>())[0].ToString()); OneFlagCTF.SpawnPoint[1].X = float.Parse(SQLEditor.ReadColumn("OneFlagPoints", "BlueSpawnX", new List<SqlValue>())[0].ToString()); OneFlagCTF.SpawnPoint[1].Y = float.Parse(SQLEditor.ReadColumn("OneFlagPoints", "BlueSpawnY", new List<SqlValue>())[0].ToString()); } #endregion #region TDMSpawns table = new SqlTable("TDMSpawns", new SqlColumn("RedSpawnX", MySqlDbType.Int32), new SqlColumn("RedSpawnY", MySqlDbType.Int32), new SqlColumn("BlueSpawnX", MySqlDbType.Int32), new SqlColumn("BlueSpawnY", MySqlDbType.Int32) ); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter.EnsureExists(table); if (SQLEditor.ReadColumn("TDMSpawns", "RedSpawnX", new List<SqlValue>()).Count == 0) { List<SqlValue> list = new List<SqlValue>(); list.Add(new SqlValue("RedSpawnX",0)); list.Add(new SqlValue("RedSpawnY", 0)); list.Add(new SqlValue("BlueSpawnX", 0)); list.Add(new SqlValue("BlueSpawnY", 0)); SQLEditor.InsertValues("TDMSpawns", list); } else { TDM.TDMSpawns[0].X = float.Parse(SQLEditor.ReadColumn("TDMSpawns", "RedSpawnX", new List<SqlValue>())[0].ToString()); TDM.TDMSpawns[0].Y = float.Parse(SQLEditor.ReadColumn("TDMSpawns", "RedSpawnY", new List<SqlValue>())[0].ToString()); TDM.TDMSpawns[1].X = float.Parse(SQLEditor.ReadColumn("TDMSpawns", "BlueSpawnX", new List<SqlValue>())[0].ToString()); TDM.TDMSpawns[1].Y = float.Parse(SQLEditor.ReadColumn("TDMSpawns", "BlueSpawnY", new List<SqlValue>())[0].ToString()); } #endregion #region Apocalypse table = new SqlTable("Apocalypse", new SqlColumn("SpawnX", MySqlDbType.Int32), new SqlColumn("SpawnY", MySqlDbType.Int32), new SqlColumn("MonsterSpawnX", MySqlDbType.Int32), new SqlColumn("MonsterSpawnY", MySqlDbType.Int32), new SqlColumn("SpectatorSpawnX", MySqlDbType.Int32), new SqlColumn("SpectatorSpawnY", MySqlDbType.Int32) ); SQLWriter = new SqlTableCreator(TShock.DB, TShock.DB.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator()); SQLWriter.EnsureExists(table); if (SQLEditor.ReadColumn("Apocalypse", "SpawnX", new List<SqlValue>()).Count == 0) { List<SqlValue> list = new List<SqlValue>(); list.Add(new SqlValue("SpawnX", 0)); list.Add(new SqlValue("SpawnY", 0)); list.Add(new SqlValue("MonsterSpawnX", 0)); list.Add(new SqlValue("MonsterSpawnY", 0)); list.Add(new SqlValue("SpectatorSpawnX", 0)); list.Add(new SqlValue("SpectatorSpawnY", 0)); SQLEditor.InsertValues("Apocalypse", list); } else { Apocalypse.PlayerSpawn.X = float.Parse(SQLEditor.ReadColumn("Apocalypse", "SpawnX", new List<SqlValue>())[0].ToString()); Apocalypse.PlayerSpawn.Y = float.Parse(SQLEditor.ReadColumn("Apocalypse", "SpawnY", new List<SqlValue>())[0].ToString()); Apocalypse.MonsterSpawn.X = float.Parse(SQLEditor.ReadColumn("Apocalypse", "MonsterSpawnX", new List<SqlValue>())[0].ToString()); Apocalypse.MonsterSpawn.Y = float.Parse(SQLEditor.ReadColumn("Apocalypse", "MonsterSpawnY", new List<SqlValue>())[0].ToString()); Apocalypse.SpectatorArea.X = float.Parse(SQLEditor.ReadColumn("Apocalypse", "SpectatorSpawnX", new List<SqlValue>())[0].ToString()); Apocalypse.SpectatorArea.Y = float.Parse(SQLEditor.ReadColumn("Apocalypse", "SpectatorSpawnY", new List<SqlValue>())[0].ToString()); } #endregion }