using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;

namespace Blizzard
{
    class Updater
    {
        public static List<string> SQLStoExecute;
        public static bool IsClosed = true;
        public static void InitUpdater()
        {
            IsClosed = false;
            SQLStoExecute = new List<string>();

            while (true)
            {
                if (SQLStoExecute.Count > 0)
                {
                    foreach (string SQL in SQLStoExecute)
                    {
                        BlizzardSystem.MySQL.ExecuteNonQuery(SQL);
                    }
                    SQLStoExecute.Clear();
                    BlizzardSystem.WriteLine("Blizzard static system updated");
                }
                Thread.Sleep(100000);

                if (IsClosed)
                    break;
            }
        }

        public static void EndUpdater()
        {
            if (!IsClosed)
            {
                IsClosed = true;
                foreach (string SQL in SQLStoExecute)
                {
                    BlizzardSystem.MySQL.ExecuteNonQuery(SQL);
                }
                SQLStoExecute.Clear();
                BlizzardSystem.WriteLine("Blizzard static system ended");
            }
        }
    }
}