using System;
using MySql.Data.MySqlClient;
using System.Collections.Generic;
using System.IO;

namespace MySqlTableCompare
{
    public class fTable
    {
        public UInt32 ID;
        public UInt32[] KillCredit;
        public UInt32[] ModelID;
        public string IconName;
        public UInt32 Rank;
        public UInt32 Family;
        public UInt32 Type;
        public UInt32 TypeFlag;
        public UInt32 MovementID;
        public UInt32 HealthMod; //need convert to Float or double
        public UInt32 ManaMod;    //need convert to Float or double
        public UInt32 RacialLider;
        public UInt32[] QuestItem;

        public fTable()
        {
            KillCredit = new UInt32[2];
            ModelID = new UInt32[4];
            QuestItem = new UInt32[6];
        }

        /*public string[] ToArray()
        {
            return new[]
            {
                ID.ToString(),
                KillCredit[0].ToString(),
                KillCredit[1].ToString(),
                ModelID[0].ToString(),
                ModelID[1].ToString(),
                ModelID[2].ToString(),
                ModelID[3].ToString(),
                IconName.ToString(),
                Rank.ToString(),
                Family.ToString(),
                Type.ToString(),
                TypeFlag.ToString(),
                MovementID.ToString(),
                HealthMod.ToString,
                ManaMod.ToString,
                RacialLider.ToString,
                QuestItem[0].ToString,
                QuestItem[1].ToString,
                QuestItem[2].ToString,
                QuestItem[3].ToString,
                QuestItem[4].ToString,
                QuestItem[5]
            };
        }*/
    };

    public class sTable
    {
        public UInt32 ID;
        public UInt32[] KillCredit;
        public UInt32[] ModelID;
        public string IconName;
        public UInt32 Rank;
        public UInt32 Family;
        public UInt32 Type;
        public UInt32 TypeFlag;
        public UInt32 MovementID;
        public UInt32 HealthMod; //need convert to Float or double
        public UInt32 ManaMod;    //need convert to Float or double
        public UInt32 RacialLider;
        public UInt32[] QuestItem;

        public sTable()
        {
            KillCredit = new UInt32[2];
            ModelID = new UInt32[4];
            QuestItem = new UInt32[6];
        }

        /*public string[] ToArray()
        {
            return new[]
            {
                ID.ToString(),
                KillCredit[0].ToString(),
                KillCredit[1].ToString(),
                ModelID[0].ToString(),
                ModelID[1].ToString(),
                ModelID[2].ToString(),
                ModelID[3].ToString(),
                IconName.ToString(),
                Rank.ToString(),
                Family.ToString(),
                Type.ToString(),
                TypeFlag.ToString(),
                MovementID.ToString(),
                HealthMod.ToString,
                ManaMod.ToString,
                RacialLider.ToString,
                QuestItem[0].ToString,
                QuestItem[1].ToString,
                QuestItem[2].ToString,
                QuestItem[3].ToString,
                QuestItem[4].ToString,
                QuestItem[5]
            };
        }*/
    };

    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 MySqlConnection connect = new MySqlConnection(connectionInfo);

        public static List<fTable> fTables = new List<fTable>();
        public static List<sTable> sTables = new List<sTable>();

        static void Main(string[] args)
        {
            Console.ForegroundColor = ConsoleColor.Yellow;
            Console.WriteLine(DateTime.Now.ToString("[HH:mm:ss]") + "Programm is open!");
            ToLog("Programm is open!");

            if (!TryCon())
                return;

            Console.WriteLine(DateTime.Now.ToString("[HH:mm:ss]") + "Get DB struct?");
            string variant = Console.ReadLine();
            if (variant == "y")
            {
                Console.WriteLine(">>Get DB struct...");
                ToLog(">>Get DB struct...");
                tGetStr();
                Console.WriteLine(">>Start compare...");
                ToLog(">>Start compare...");
                tCompare();
            }
            else if (variant == "n")
            {
                Console.WriteLine(DateTime.Now.ToString("[HH:mm:ss]") + "Press any key for exit");
                connect.Close();
            }
            else
                Console.WriteLine(DateTime.Now.ToString("[HH:mm:ss]") + "Neee press 'y' or 'n'");

            Console.ReadKey();
        }

        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 void tGetStr()
        {
            connect.Close();
            connect.Open();

            string fSelect = "SELECT * FROM world.creature_template";
            string sSelect = "SELECT * FROM world.creature_template1";
            fcommand = new MySqlCommand(fSelect, connect);
            scommand = new MySqlCommand(sSelect, connect);
            fTables.Clear();
            sTables.Clear();

            using (var fDBstructur = fcommand.ExecuteReader())
            {
                while(fDBstructur.Read())
                {
                    fTable table1 = new fTable();

                    table1.ID            = fDBstructur[0].ToUInt32();
                    table1.KillCredit[0] = fDBstructur[4].ToUInt32(); //kill credit 1,2
                    table1.KillCredit[1] = fDBstructur[5].ToUInt32();
                    table1.ModelID[0]    = fDBstructur[6].ToUInt32(); //modelid1 id 1-4
                    table1.ModelID[1]    = fDBstructur[7].ToUInt32();
                    table1.ModelID[2]    = fDBstructur[8].ToUInt32();
                    table1.ModelID[3]    = fDBstructur[9].ToUInt32();
                    table1.IconName      = fDBstructur[12].ToString();
                    table1.Rank          = fDBstructur[23].ToUInt32(); //rank
                    table1.Family        = fDBstructur[34].ToUInt32(); //family
                    table1.Type          = fDBstructur[42].ToUInt32(); //type
                    table1.TypeFlag      = fDBstructur[43].ToUInt32();//type flag
                    table1.MovementID    = fDBstructur[66].ToUInt32(); //movement id
                    table1.HealthMod     = fDBstructur[68].ToUInt32(); //health mod
                    table1.ManaMod       = fDBstructur[69].ToUInt32(); //power(mana) mod
                    table1.RacialLider   = fDBstructur[71].ToUInt32(); //racial leader
                    table1.QuestItem[0]  = fDBstructur[72].ToUInt32(); //quest item 1-6
                    table1.QuestItem[1]  = fDBstructur[73].ToUInt32();
                    table1.QuestItem[2]  = fDBstructur[74].ToUInt32();
                    table1.QuestItem[3]  = fDBstructur[75].ToUInt32();
                    table1.QuestItem[4]  = fDBstructur[76].ToUInt32();
                    table1.QuestItem[5]  = fDBstructur[77].ToUInt32();

                    fTables.Add(table1);
                }
            }
            using (var sDBstructur = scommand.ExecuteReader())
            {
                while(sDBstructur.Read())
                {
                    sTable table2 = new sTable();

                    table2.ID            = sDBstructur[0].ToUInt32();
                    table2.KillCredit[0] = sDBstructur[4].ToUInt32(); //kill credit 1,2
                    table2.KillCredit[1] = sDBstructur[5].ToUInt32();
                    table2.ModelID[0]    = sDBstructur[6].ToUInt32(); //modelid1 id 1-4
                    table2.ModelID[1]    = sDBstructur[7].ToUInt32();
                    table2.ModelID[2]    = sDBstructur[8].ToUInt32();
                    table2.ModelID[3]    = sDBstructur[9].ToUInt32();
                    table2.IconName      = sDBstructur[12].ToString();
                    table2.Rank          = sDBstructur[23].ToUInt32(); //rank
                    table2.Family        = sDBstructur[34].ToUInt32(); //family
                    table2.Type          = sDBstructur[42].ToUInt32(); //type
                    table2.TypeFlag      = sDBstructur[43].ToUInt32();//type flag
                    table2.MovementID    = sDBstructur[66].ToUInt32(); //movement id
                    table2.HealthMod     = sDBstructur[68].ToUInt32(); //health mod
                    table2.ManaMod       = sDBstructur[69].ToUInt32(); //power(mana) mod
                    table2.RacialLider   = sDBstructur[71].ToUInt32(); //racial leader
                    table2.QuestItem[0]  = sDBstructur[72].ToUInt32(); //quest item 1-6
                    table2.QuestItem[1]  = sDBstructur[73].ToUInt32();
                    table2.QuestItem[2]  = sDBstructur[74].ToUInt32();
                    table2.QuestItem[3]  = sDBstructur[75].ToUInt32();
                    table2.QuestItem[4]  = sDBstructur[76].ToUInt32();
                    table2.QuestItem[5]  = sDBstructur[77].ToUInt32();

                    sTables.Add(table2);
                }
            }
        }

        public static void tableSelectForCompare(Int64 i)
        {
            connect.Close();
            connect.Open();

            string fSelect = "SELECT * FROM world.creature_template WHERE entry = " + i + ";";
            string sSelect = "SELECT * FROM world.creature_template1 WHERE entry = " + i + ";";
            fcommand = new MySqlCommand(fSelect, connect);
            scommand = new MySqlCommand(sSelect, connect);
        }

        public static void tCompare()
        {
            Console.WriteLine("ID {0}", fTables[0].ID);
            /*for (Int64 entry = 1; entry <= 45000; ++entry)
            {
                tableSelectForCompare(entry);
                Column();
            }*/
        }

        public static void Column()
        {
            /*for (int c = 0; c < 20; ++c)
            {
                if (fField[c] == sField[c])
                    continue;
                else
                {
                    Console.WriteLine("Entry {2} {0} != {1}", fField[c], sField[c], fField[0]);
                    Log.WriteLine("Entry {2} {0} != {1}", fField[c], sField[c], fField[0]);
                    Log.WriteLine("UPDATE creature_template SET {0} = {1} WHERE entry = {2}", sField[c], fField[c], fField[0]);
                    continue;
                }
            }*/
        }

        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;
            }
        }
    }
}