Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //using System;
- using MySql.Data.MySqlClient;
- using System.Collections.Generic;
- using System.IO;
- namespace MySqlTableCompare
- {
- public static class Program
- {
- const string connectionInfo = ("host=127.0.0.1;" + "port = '3306';" + "database='world';" + "UserName='root';" + "Password='mangos'");
- public static StreamWriter Log = new StreamWriter("sql_log.txt", true);
- public static MySqlCommand fcommand;
- public static MySqlCommand scommand;
- public static int error_count = 0;
- public static int index = 0;
- public static string table = "table not exist";
- public static MySqlConnection connect = new MySqlConnection(connectionInfo);
- public static List<CreatureTemplate1> CreatureTemplates1 = new List<CreatureTemplate1>();
- public static List<CreatureTemplate2> CreatureTemplates2 = new List<CreatureTemplate2>();
- public static List<GameobjectTemplate1> GameobjectTemplates1 = new List<GameobjectTemplate1>();
- public static List<GameobjectTemplate2> GameobjectTemplates2 = new List<GameobjectTemplate2>();
- static void Main(string[] args)
- {
- Console.Title = "Table compare";
- Console.ForegroundColor = ConsoleColor.Yellow;
- Console.WriteLine(DateTime.Now.ToString("[HH:mm:ss]") + "Programm is open!");
- ToLog("Programm is open!");
- if (!TryCon())
- return;
- Console.ForegroundColor = ConsoleColor.Cyan;
- Console.WriteLine("Choose variante:");
- Console.WriteLine("---" + "1 - Get creature_template structure and compare it");
- Console.WriteLine("---" + "2 - Get gameobject_template structure and compare it");
- Console.WriteLine("---" + "3 - Get item_template structure and compare it");
- Console.WriteLine("---" + "4 - Get quest_template structure and compare it");
- string variant = Console.ReadLine();
- Console.ForegroundColor = ConsoleColor.Green;
- switch (variant)
- {
- case "1":
- table = "creature";
- //Clear();
- Console.WriteLine("Get creature_template struct...");
- ToLog("Get creature_template struct...");
- CreatureTemplateStructur();
- Console.WriteLine("Compare...");
- ToLog("Compare...");
- CompareCreatureTemplate();
- break;
- case "2":
- table = "gameobject";
- //Clear();
- Console.WriteLine("Get gameobject_template struct...");
- ToLog("Get gameobject_template struct...");
- GameObjectStructure();
- Console.WriteLine("Compare...");
- ToLog("Compare...");
- CompareGameobjectTemplate();
- break;
- case "3":
- case "4":
- Console.WriteLine("Not finished yet!");
- ToLog("Not finished yet");
- break;
- }
- Console.Read();
- }
- public static void ToLog(string text)
- {
- Log.WriteLine(DateTime.Now.ToString("[HH:mm:ss]") + text); Log.Flush();
- }
- public static uint ToUInt32(this object val)
- {
- uint num;
- uint.TryParse(val.ToString(), out num);
- return num;
- }
- public static float ToFloat(this object val)
- {
- float num;
- float.TryParse(val.ToString(), out num);
- return num;
- }
- public static void Clear()
- {
- CreatureTemplates1.Clear();
- CreatureTemplates2.Clear();
- GameobjectTemplates1.Clear();
- GameobjectTemplates2.Clear();
- }
- public static void CreatureTemplateStructur()
- {
- connect.Close();
- connect.Open();
- string fSelect = "SELECT * FROM world.creature_template WHERE entry IN(SELECT entry FROM world.creature_template1) ORDER BY entry ASC";
- string sSelect = "SELECT * FROM world.creature_template1 SORT ORDER BY entry ASC"; //верное
- fcommand = new MySqlCommand(fSelect, connect);
- scommand = new MySqlCommand(sSelect, connect);
- using (var fDBstructur = fcommand.ExecuteReader()) //creature_template
- {
- while(fDBstructur.Read())
- {
- CreatureTemplate1 CreatureTemplate = new CreatureTemplate1();
- CreatureTemplate.ID = fDBstructur[0].ToUInt32();
- CreatureTemplate.KillCredit[0] = fDBstructur[4].ToUInt32(); //kill credit 1,2
- CreatureTemplate.KillCredit[1] = fDBstructur[5].ToUInt32();
- CreatureTemplate.ModelID[0] = fDBstructur[6].ToUInt32(); //modelid1 id 1-4
- CreatureTemplate.ModelID[1] = fDBstructur[7].ToUInt32();
- CreatureTemplate.ModelID[2] = fDBstructur[8].ToUInt32();
- CreatureTemplate.ModelID[3] = fDBstructur[9].ToUInt32();
- CreatureTemplate.IconName = fDBstructur[12].ToString();
- CreatureTemplate.Rank = fDBstructur[23].ToUInt32(); //rank
- CreatureTemplate.Family = fDBstructur[34].ToUInt32(); //family
- CreatureTemplate.Type = fDBstructur[42].ToUInt32(); //type
- CreatureTemplate.TypeFlag = fDBstructur[43].ToUInt32();//type flag
- CreatureTemplate.HealthMod = fDBstructur[68].ToFloat(); //health mod
- CreatureTemplate.ManaMod = fDBstructur[69].ToFloat(); //power(mana) mod
- CreatureTemplate.RacialLeader = fDBstructur[71].ToUInt32(); //racial leader
- CreatureTemplate.QuestItem[0] = fDBstructur[72].ToUInt32(); //quest item 1-6
- CreatureTemplate.QuestItem[1] = fDBstructur[73].ToUInt32();
- CreatureTemplate.QuestItem[2] = fDBstructur[74].ToUInt32();
- CreatureTemplate.QuestItem[3] = fDBstructur[75].ToUInt32();
- CreatureTemplate.QuestItem[4] = fDBstructur[76].ToUInt32();
- CreatureTemplate.QuestItem[5] = fDBstructur[77].ToUInt32();
- CreatureTemplate.MovementID = fDBstructur[78].ToUInt32();
- CreatureTemplates1.Add(CreatureTemplate);
- }
- }
- using (var sDBstructur = scommand.ExecuteReader()) //cache_creature_template
- {
- while(sDBstructur.Read())
- {
- CreatureTemplate2 CreatureCacheTemplate = new CreatureTemplate2();
- CreatureCacheTemplate.ID = sDBstructur[1].ToUInt32();
- //CreatureCacheTemplate.Name[0] = sDBstructur[3].ToString(); //For future locale compare
- //CreatureCacheTemplate.Name[1] = sDBstructur[4].ToString();
- //CreatureCacheTemplate.Name[2] = sDBstructur[5].ToString();
- //CreatureCacheTemplate.Name[3] = sDBstructur[6].ToString();
- //CreatureCacheTemplate.SubName = sDBstructur[7].ToString(); //For future locale compare
- CreatureCacheTemplate.IconName = sDBstructur[8].ToString();
- CreatureCacheTemplate.TypeFlag = sDBstructur[9].ToUInt32();//type flag
- CreatureCacheTemplate.Type = sDBstructur[10].ToUInt32(); //type
- CreatureCacheTemplate.Family = sDBstructur[11].ToUInt32(); //family
- CreatureCacheTemplate.Rank = sDBstructur[12].ToUInt32(); //rank
- CreatureCacheTemplate.KillCredit[0] = sDBstructur[13].ToUInt32(); //kill credit 1,2
- CreatureCacheTemplate.KillCredit[1] = sDBstructur[14].ToUInt32();
- CreatureCacheTemplate.ModelID[0] = sDBstructur[15].ToUInt32(); //A
- CreatureCacheTemplate.ModelID[1] = sDBstructur[16].ToUInt32(); //A2
- CreatureCacheTemplate.ModelID[2] = sDBstructur[17].ToUInt32(); //H
- CreatureCacheTemplate.ModelID[3] = sDBstructur[18].ToUInt32(); //H2
- CreatureCacheTemplate.HealthMod = sDBstructur[19].ToFloat(); //health mod
- CreatureCacheTemplate.ManaMod = sDBstructur[20].ToFloat(); //power(mana) mod
- CreatureCacheTemplate.RacialLeader = sDBstructur[21].ToUInt32(); //racial leader
- CreatureCacheTemplate.QuestItem[0] = sDBstructur[22].ToUInt32(); //quest item 1-6
- CreatureCacheTemplate.QuestItem[1] = sDBstructur[23].ToUInt32();
- CreatureCacheTemplate.QuestItem[2] = sDBstructur[24].ToUInt32();
- CreatureCacheTemplate.QuestItem[3] = sDBstructur[25].ToUInt32();
- CreatureCacheTemplate.QuestItem[4] = sDBstructur[26].ToUInt32();
- CreatureCacheTemplate.QuestItem[5] = sDBstructur[27].ToUInt32();
- CreatureCacheTemplate.MovementID = sDBstructur[28].ToUInt32(); //movement id
- CreatureTemplates2.Add(CreatureCacheTemplate);
- }
- }
- }
- public static void GameObjectStructure()
- {
- connect.Close();
- connect.Open();
- string fSelect = "SELECT * FROM world.gameobject_template WHERE entry IN(SELECT entry FROM world.gameobject_template1) ORDER BY entry ASC";
- string sSelect = "SELECT * FROM world.gameobject_template1 SORT ORDER BY entry ASC"; //верное
- fcommand = new MySqlCommand(fSelect, connect);
- scommand = new MySqlCommand(sSelect, connect);
- using (var fDBstructur = fcommand.ExecuteReader()) //gameobject_template
- {
- while (fDBstructur.Read())
- {
- GameobjectTemplate1 GameobjectTemplate = new GameobjectTemplate1();
- GameobjectTemplate.ID = fDBstructur[0].ToUInt32();
- GameobjectTemplate.Type = fDBstructur[1].ToUInt32();
- GameobjectTemplate.DisplayId = fDBstructur[2].ToUInt32();
- //GameobjectTemplate.Name = fDBstructur[3].ToString(); //For future locale compare
- GameobjectTemplate.IconName = fDBstructur[4].ToString();
- GameobjectTemplate.CastBar = fDBstructur[5].ToString();
- GameobjectTemplate.Size = fDBstructur[9].ToFloat();
- GameobjectTemplate.QuestItem[0] = fDBstructur[10].ToUInt32();
- GameobjectTemplate.QuestItem[1] = fDBstructur[11].ToUInt32();
- GameobjectTemplate.QuestItem[2] = fDBstructur[12].ToUInt32();
- GameobjectTemplate.QuestItem[3] = fDBstructur[13].ToUInt32();
- GameobjectTemplate.QuestItem[4] = fDBstructur[14].ToUInt32();
- GameobjectTemplate.QuestItem[5] = fDBstructur[15].ToUInt32();
- GameobjectTemplate.Data[0] = fDBstructur[16].ToUInt32();
- GameobjectTemplate.Data[1] = fDBstructur[17].ToUInt32();
- GameobjectTemplate.Data[2] = fDBstructur[18].ToUInt32();
- GameobjectTemplate.Data[3] = fDBstructur[19].ToUInt32();
- GameobjectTemplate.Data[4] = fDBstructur[20].ToUInt32();
- GameobjectTemplate.Data[5] = fDBstructur[21].ToUInt32();
- GameobjectTemplate.Data[6] = fDBstructur[22].ToUInt32();
- GameobjectTemplate.Data[7] = fDBstructur[23].ToUInt32();
- GameobjectTemplate.Data[8] = fDBstructur[24].ToUInt32();
- GameobjectTemplate.Data[9] = fDBstructur[25].ToUInt32();
- GameobjectTemplate.Data[10] = fDBstructur[26].ToUInt32();
- GameobjectTemplate.Data[11] = fDBstructur[27].ToUInt32();
- GameobjectTemplate.Data[12] = fDBstructur[28].ToUInt32();
- GameobjectTemplate.Data[13] = fDBstructur[29].ToUInt32();
- GameobjectTemplate.Data[14] = fDBstructur[30].ToUInt32();
- GameobjectTemplate.Data[15] = fDBstructur[31].ToUInt32();
- GameobjectTemplate.Data[16] = fDBstructur[32].ToUInt32();
- GameobjectTemplate.Data[17] = fDBstructur[33].ToUInt32();
- GameobjectTemplate.Data[18] = fDBstructur[34].ToUInt32();
- GameobjectTemplate.Data[19] = fDBstructur[35].ToUInt32();
- GameobjectTemplate.Data[20] = fDBstructur[36].ToUInt32();
- GameobjectTemplate.Data[21] = fDBstructur[37].ToUInt32();
- GameobjectTemplate.Data[22] = fDBstructur[38].ToUInt32();
- GameobjectTemplate.Data[23] = fDBstructur[39].ToUInt32();
- GameobjectTemplates1.Add(GameobjectTemplate);
- }
- }
- using (var sDBstructur = scommand.ExecuteReader()) //cache_gameobject_template
- {
- while (sDBstructur.Read())
- {
- GameobjectTemplate2 GameobjectCacheTemplate = new GameobjectTemplate2();
- GameobjectCacheTemplate.ID = sDBstructur[1].ToUInt32();
- GameobjectCacheTemplate.Type = sDBstructur[3].ToUInt32();
- GameobjectCacheTemplate.DisplayId = sDBstructur[4].ToUInt32();
- //GameobjectCacheTemplate.Name[0] = sDBstructur[5].ToString(); //For future locale compare
- //GameobjectCacheTemplate.Name[1] = sDBstructur[6].ToString();
- //GameobjectCacheTemplate.Name[2] = sDBstructur[7].ToString();
- //GameobjectCacheTemplate.Name[3] = sDBstructur[8].ToString();
- GameobjectCacheTemplate.IconName = sDBstructur[9].ToString();
- GameobjectCacheTemplate.CastBar = sDBstructur[10].ToString();
- //GameobjectCacheTemplate.Name[4] = sDBstructur[11].ToString();
- GameobjectCacheTemplate.Data[0] = sDBstructur[12].ToUInt32();
- GameobjectCacheTemplate.Data[1] = sDBstructur[13].ToUInt32();
- GameobjectCacheTemplate.Data[2] = sDBstructur[14].ToUInt32();
- GameobjectCacheTemplate.Data[3] = sDBstructur[15].ToUInt32();
- GameobjectCacheTemplate.Data[4] = sDBstructur[16].ToUInt32();
- GameobjectCacheTemplate.Data[5] = sDBstructur[17].ToUInt32();
- GameobjectCacheTemplate.Data[6] = sDBstructur[18].ToUInt32();
- GameobjectCacheTemplate.Data[7] = sDBstructur[19].ToUInt32();
- GameobjectCacheTemplate.Data[8] = sDBstructur[20].ToUInt32();
- GameobjectCacheTemplate.Data[9] = sDBstructur[21].ToUInt32();
- GameobjectCacheTemplate.Data[10] = sDBstructur[22].ToUInt32();
- GameobjectCacheTemplate.Data[11] = sDBstructur[23].ToUInt32();
- GameobjectCacheTemplate.Data[12] = sDBstructur[24].ToUInt32();
- GameobjectCacheTemplate.Data[13] = sDBstructur[25].ToUInt32();
- GameobjectCacheTemplate.Data[14] = sDBstructur[26].ToUInt32();
- GameobjectCacheTemplate.Data[15] = sDBstructur[27].ToUInt32();
- GameobjectCacheTemplate.Data[16] = sDBstructur[28].ToUInt32();
- GameobjectCacheTemplate.Data[17] = sDBstructur[29].ToUInt32();
- GameobjectCacheTemplate.Data[18] = sDBstructur[30].ToUInt32();
- GameobjectCacheTemplate.Data[19] = sDBstructur[31].ToUInt32();
- GameobjectCacheTemplate.Data[20] = sDBstructur[32].ToUInt32();
- GameobjectCacheTemplate.Data[21] = sDBstructur[33].ToUInt32();
- GameobjectCacheTemplate.Data[22] = sDBstructur[34].ToUInt32();
- GameobjectCacheTemplate.Data[23] = sDBstructur[35].ToUInt32();
- GameobjectCacheTemplate.Size = sDBstructur[36].ToFloat();
- GameobjectCacheTemplate.QuestItem[0] = sDBstructur[37].ToUInt32();
- GameobjectCacheTemplate.QuestItem[1] = sDBstructur[38].ToUInt32();
- GameobjectCacheTemplate.QuestItem[2] = sDBstructur[39].ToUInt32();
- GameobjectCacheTemplate.QuestItem[3] = sDBstructur[40].ToUInt32();
- GameobjectCacheTemplate.QuestItem[4] = sDBstructur[41].ToUInt32();
- GameobjectCacheTemplate.QuestItem[5] = sDBstructur[42].ToUInt32();
- GameobjectTemplates2.Add(GameobjectCacheTemplate);
- }
- }
- }
- public static void CompareCreatureTemplate()
- {
- int m = 0;
- int q = 0;
- index = CreatureTemplates1.Count;
- for (int i = 0; i < index; ++i)
- {
- if(!Equals(CreatureTemplates1[i].IconName, CreatureTemplates2[i].IconName))
- sSqlLog("IconName", CreatureTemplates2[i].IconName, CreatureTemplates2[i].ID);
- if (!Equals(CreatureTemplates1[i].TypeFlag, CreatureTemplates2[i].TypeFlag))
- SqlLog("type_flag", CreatureTemplates2[i].TypeFlag, CreatureTemplates2[i].ID);
- if (!Equals(CreatureTemplates1[i].Type, CreatureTemplates2[i].Type))
- SqlLog("type", CreatureTemplates2[i].Type, CreatureTemplates2[i].ID);
- if (!Equals(CreatureTemplates1[i].Family, CreatureTemplates2[i].Family))
- SqlLog("family", CreatureTemplates2[i].Family, CreatureTemplates2[i].ID);
- if (!Equals(CreatureTemplates1[i].Rank, CreatureTemplates2[i].Rank))
- SqlLog("rank", CreatureTemplates2[i].Rank, CreatureTemplates2[i].ID);
- if (!Equals(CreatureTemplates1[i].KillCredit[0], CreatureTemplates2[i].KillCredit[0]))
- SqlLog("KillCredit1", CreatureTemplates2[i].KillCredit[0], CreatureTemplates2[i].ID);
- if (!Equals(CreatureTemplates1[i].KillCredit[1], CreatureTemplates2[i].KillCredit[1]))
- SqlLog("KillCredit2", CreatureTemplates2[i].KillCredit[1], CreatureTemplates2[i].ID);
- for (m = 0; m < 3; ++m)
- {
- string ModelID = "modelid1";
- switch (m)
- {
- case 0: ModelID = "modelid1"; break;
- case 1: ModelID = "modelid2"; break;
- case 2: ModelID = "modelid3"; break;
- }
- if (!Equals(CreatureTemplates1[i].ModelID[m], CreatureTemplates2[i].ModelID[m]))
- SqlLog(ModelID, CreatureTemplates2[i].ModelID[m], CreatureTemplates2[i].ID);
- }
- if (!Equals(CreatureTemplates1[i].HealthMod, CreatureTemplates2[i].HealthMod))
- SqlLog("Health_Mod", CreatureTemplates2[i].HealthMod, CreatureTemplates2[i].ID);
- if(!Equals(CreatureTemplates1[i].ManaMod, CreatureTemplates2[i].ManaMod))
- SqlLog("Mana_mod", CreatureTemplates2[i].ManaMod, CreatureTemplates2[i].ID);
- if (CreatureTemplates1[i].RacialLeader != CreatureTemplates2[i].RacialLeader)
- SqlLog("RacialLeader", CreatureTemplates2[i].RacialLeader, CreatureTemplates2[i].ID);
- for (q = 0; q < 6; q++)
- {
- string QuestItem = "questItem1";
- switch (q)
- {
- case 0: QuestItem = "questItem1"; break;
- case 1: QuestItem = "questItem2"; break;
- case 2: QuestItem = "questItem3"; break;
- case 3: QuestItem = "questItem4"; break;
- case 4: QuestItem = "questItem5"; break;
- case 5: QuestItem = "questItem6"; break;
- }
- if (!Equals(CreatureTemplates1[i].QuestItem[q], CreatureTemplates2[i].QuestItem[q]))
- SqlLog(QuestItem, CreatureTemplates2[i].QuestItem[q], CreatureTemplates2[i].ID);
- }
- if (!Equals(CreatureTemplates1[i].MovementID, CreatureTemplates2[i].MovementID))
- SqlLog("MovementID", CreatureTemplates2[i].MovementID, CreatureTemplates2[i].ID);
- if (i == index - 1)
- Statistics();
- }
- }
- public static void CompareGameobjectTemplate()
- {
- int q = 0;
- int d = 0;
- index = GameobjectTemplates1.Count;
- for (int i = 0; i < index; ++i)
- {
- if (!Equals(GameobjectTemplates1[i].Type, GameobjectTemplates2[i].Type))
- SqlLog("Type", GameobjectTemplates2[i].Type, GameobjectTemplates2[i].ID);
- if (!Equals(GameobjectTemplates1[i].DisplayId, GameobjectTemplates2[i].DisplayId))
- SqlLog("DisplayId", GameobjectTemplates2[i].DisplayId, GameobjectTemplates2[i].ID);
- if (!Equals(GameobjectTemplates1[i].IconName, GameobjectTemplates2[i].IconName))
- sSqlLog("IconName", GameobjectTemplates2[i].IconName, GameobjectTemplates2[i].ID);
- if (!Equals(GameobjectTemplates1[i].CastBar, GameobjectTemplates2[i].CastBar))
- sSqlLog("castbarcaption", GameobjectTemplates2[i].CastBar, GameobjectTemplates2[i].ID);
- if (!Equals(GameobjectTemplates1[i].Size, GameobjectTemplates2[i].Size))
- SqlLog("Size", GameobjectTemplates2[i].Size, GameobjectTemplates2[i].ID);
- for (q = 0; q < 6; ++q)
- {
- string QuestItem = "questItem1";
- switch (q)
- {
- case 0: QuestItem = "questItem1"; break;
- case 1: QuestItem = "questItem2"; break;
- case 2: QuestItem = "questItem3"; break;
- case 3: QuestItem = "questItem4"; break;
- case 4: QuestItem = "questItem5"; break;
- case 5: QuestItem = "questItem6"; break;
- }
- if (!Equals(GameobjectTemplates1[i].QuestItem[q], GameobjectTemplates2[i].QuestItem[q]))
- SqlLog(QuestItem, GameobjectTemplates2[i].QuestItem[q], GameobjectTemplates2[i].ID);
- }
- for (d = 0; d < 24; ++d)
- {
- string tData = "data0";
- switch (d)
- {
- case 0: tData = "data0"; break;
- case 1: tData = "data1"; break;
- case 2: tData = "data2"; break;
- case 3: tData = "data3"; break;
- case 4: tData = "data4"; break;
- case 5: tData = "data5"; break;
- case 6: tData = "data6"; break;
- case 7: tData = "data7"; break;
- case 8: tData = "data8"; break;
- case 9: tData = "data9"; break;
- case 10: tData = "data10"; break;
- case 11: tData = "data11"; break;
- case 12: tData = "data12"; break;
- case 13: tData = "data13"; break;
- case 14: tData = "data14"; break;
- case 15: tData = "data15"; break;
- case 16: tData = "data16"; break;
- case 17: tData = "data17"; break;
- case 18: tData = "data18"; break;
- case 19: tData = "data19"; break;
- case 20: tData = "data20"; break;
- case 21: tData = "data21"; break;
- case 22: tData = "data22"; break;
- case 23: tData = "data23"; break;
- }
- if (!Equals(GameobjectTemplates1[i].Data[d], GameobjectTemplates2[i].Data[d]))
- SqlLog(tData, GameobjectTemplates2[i].Data[d], GameobjectTemplates2[i].ID);
- }
- if (i == index - 1)
- Statistics();
- }
- }
- public static void Statistics()
- {
- Console.WriteLine("==========||=============================================||");
- Console.WriteLine("Statistics|| Templates || Bad templates ||table name ||");
- Console.WriteLine("==========||{0} | {1} | {2} ", index, error_count, table);
- Console.WriteLine("==========||=============================================||");
- Console.Read();
- }
- public static void SqlLog(string field_name, double value, uint entry)
- {
- switch (table)
- {
- case "creature":
- Console.WriteLine("UPDATE creature_template SET {0} = {1} WHERE entry = {2};", field_name, value, entry);
- Log.WriteLine("UPDATE creature_template SET {0} = {1} WHERE entry = {2};", field_name, value, entry); Log.Flush();
- ++error_count;
- break;
- case "gameobject":
- Console.WriteLine("UPDATE gameobject_template SET {0} = {1} WHERE entry = {2};", field_name, value, entry);
- Log.WriteLine("UPDATE gameobject_template SET {0} = {1} WHERE entry = {2};", field_name, value, entry); Log.Flush();
- ++error_count;
- break;
- }
- }
- public static void sSqlLog(string field_name, string value, uint entry)
- {
- switch (table)
- {
- case "creature":
- Console.WriteLine("UPDATE creature_template SET {0} = '{1}' WHERE entry = {2};", field_name, value, entry);
- Log.WriteLine("UPDATE creature_template SET {0} = '{1}' WHERE entry = {2};", field_name, value, entry); Log.Flush();
- ++error_count;
- break;
- case "gameobject":
- Console.WriteLine("UPDATE gameobject_template SET {0} = '{1}' WHERE entry = {2};", field_name, value, entry);
- Log.WriteLine("UPDATE gameobject_template SET {0} = '{1}' WHERE entry = {2};", field_name, value, entry); Log.Flush();
- ++error_count;
- break;
- }
- }
- public static bool TryCon()
- {
- try
- {
- MySqlConnection connect = new MySqlConnection(connectionInfo);
- connect.Open();
- connect.Close();
- return true;
- }
- catch
- {
- Console.ForegroundColor = ConsoleColor.Red;
- Console.WriteLine(DateTime.Now.ToString("[HH:mm:ss]") + "Check your MySQL server");
- ToLog("MySQL Server is not running");
- return false;
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement