class DatabaseCore
    {
        private static Timer PulseTimer;
        public static News_ News;
        public static Server_ Server;
        public static User_ User;

        public static void SetPulseTime(int iTime)
        {
            PulseTimer = new Timer();
            PulseTimer.Interval = iTime;
        }

        public static void Start()
        {
            PulseTimer.Elapsed += new ElapsedEventHandler(Pulse);
            News = new News_();
            Server = new Server_();
            User = new User_();
            PulseTimer.Start();
            Pulse(null,null);
        }

        private static void Pulse(object sender, EventArgs e)
        {
            Console.WriteLine("Pulsing...");
            News.Pulse();
            Server.Pulse();
            User.Pulse();
        }

        public class News_
        {
            public int NumberOfNews = 0;
            public string[] Head = new string[0];
            public string[] Text = new string[0];
            public byte[] Day = new byte[0];
            public byte[] Month = new byte[0];


            public void Pulse()
            {
                NumberOfNews = Database.GetRowsCount("SELECT * FROM News");
                Head = new string[NumberOfNews];
                Text = new string[NumberOfNews];
                Day = new byte[NumberOfNews];
                Month = new byte[NumberOfNews];

                for (int i = 0; i < NumberOfNews; i++)
                {
                    Head[i] = Database.GetString("SELECT * FROM News WHERE id='" + i + "'", "head");
                    Text[i] = Database.GetString("SELECT * FROM News WHERE id='" + i + "'", "text");
                    Day[i] = Database.GetByte("SELECT * FROM News WHERE id='" + i + "'", "day");
                    Month[i] = Database.GetByte("SELECT * FROM News WHERE id='" + i + "'", "month");
                }
            }
        }

        public class Server_
        {
            public  int NumberOfServer = 0;
            public  string[] ServerName = new string[0];
            public  ushort[] ServerId = new ushort[0];
            public  ushort[] CurUser = new ushort[0];
            public  ushort[] MaxUser = new ushort[0];
            public  byte[] ServerState = new byte[0];


            public  void Pulse()
            {
                NumberOfServer = Database.GetRowsCount("SELECT * FROM server");
                ServerName = new string[NumberOfServer];
                ServerId = new ushort[NumberOfServer];
                CurUser = new ushort[NumberOfServer];
                MaxUser = new ushort[NumberOfServer];
                ServerState = new byte[NumberOfServer];

                for (int i = 1; i < NumberOfServer; i++)
                {
                    ServerId[i] = Database.GetUShort("SELECT * FROM server WHERE id='" + i + "'", "id");
                    ServerName[i] = Database.GetString("SELECT * FROM server WHERE id='" + i + "'", "name");
                    CurUser[i] = Database.GetUShort("SELECT * FROM server WHERE id='" + i + "'", "users_current");
                    MaxUser[i] = Database.GetUShort("SELECT * FROM server WHERE id='" + i + "'", "users_max");
                    ServerState[i] = Database.GetByte("SELECT * FROM server WHERE id='" + i + "'", "state");
                }
            }
        }

        public class User_
        {
            public struct UserData
            {
                public string User;
                public string Password;
                public byte FailedLogins;
                public bool Online;
                public bool Banned;
            }

            public UserData[] Users = new UserData[0];

            public  void Pulse()
            {
                Users = new UserData[Database.GetRowsCount("SELECT * FROM user")];
                for (int i = 0; i < Users.Length; i++)
                {
                    Users[i].User = Database.GetString(string.Format("SELECT * FROM user WHERE id='{0}'",i), "name");
                    Users[i].Password = Database.GetString(string.Format("SELECT * FROM user WHERE id='{0}'", i), "password");
                    Users[i].FailedLogins = Database.GetByte(string.Format("SELECT * FROM user WHERE id='{0}'", i), "failed_logins");
                    Users[i].Online = Database.GetBool(string.Format("SELECT * FROM user WHERE id='{0}'", i), "online");
                    Users[i].Banned = Database.GetBool(string.Format("SELECT * FROM user WHERE id='{0}'", i), "banned");
                }
            }
        }