Example #1
0
        public static void LoadCache()
        {
            Cache = new List<Models.ServersModel>();

            DatabaseProvider.CheckConnection();

            lock (DatabaseProvider.Locker)
            {
                var sqlText = "SELECT * FROM gameservers";
                var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection);

                var sqlReader = sqlCommand.ExecuteReader();

                while (sqlReader.Read())
                {
                    var server = new Models.ServersModel()
                    {
                        ID = sqlReader.GetInt16("Id"),
                        IP = sqlReader.GetString("Ip"),
                        Port = sqlReader.GetInt16("Port"),
                        PassKey = sqlReader.GetString("PassKey"),
                    };

                    lock (Cache)
                        Cache.Add(server);
                }

                sqlReader.Close();
            }
        }
Example #2
0
        public static void LoadCache()
        {
            _servers = new List<Models.ServersModel>();

            DatabaseProvider.CheckConnection();

            lock (DatabaseProvider.ConnectionLocker)
            {
                var sqlText = "SELECT * FROM dyn_servers";
                var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection);

                var sqlReader = sqlCommand.ExecuteReader();

                while (sqlReader.Read())
                {
                    var server = new Models.ServersModel();
                    {
                        server.ID = sqlReader.GetInt16("Id");
                        server.IP = sqlReader.GetString("Ip");
                        server.Port = sqlReader.GetInt16("Port");
                    }

                    lock (_servers)
                        _servers.Add(server);
                }

                sqlReader.Close();
            }
        }