Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void Update()
- {
- if (DatabaseSettings.AccountUpdatePollingEnabled)
- {
- int Difference = DateTime.Compare(DateTime.Now, LastUpdate.AddSeconds(DatabaseSettings.AccountsPollingDelay));
- if (Difference > 0)
- {
- using (sql_con = new SQLiteConnection(connString))
- {
- LastUpdate = DateTime.Now;
- sql_con.Open();
- SQLiteCommand AcctCmd = new SQLiteCommand("SELECT * FROM Accounts LIMIT @Start,@End", sql_con);
- AcctCmd.Parameters.Add("@Start", System.Data.DbType.Int32).Value = CurrentQuery;
- AcctCmd.Parameters.Add("@End", System.Data.DbType.Int32).Value = DatabaseSettings.AccountUpdatesPerQuery;
- int count = 0;
- using (SQLiteDataReader dr = AcctCmd.ExecuteReader())
- {
- while (dr.Read())
- {
- string Username = (string)dr.GetValue(0);
- if (AccountReferences.ContainsKey(Username))
- {
- // AccountReferences[account.Username].Username = (string)dr.GetValue(0);
- // AccountReferences[account.Username].Password = (string)dr.GetValue(1);
- // AccountReferences[account.Username].Email = (string)dr.GetValue(2);
- AccountReferences[Username].IsGM = (bool)dr.GetValue(3);
- AccountReferences[Username].IsBanned = (bool)dr.GetValue(4);
- count++;
- }
- else
- {
- // Todo: Add account here.
- }
- }
- }
- CurrentQuery += DatabaseSettings.AccountUpdatesPerQuery;
- if (count < DatabaseSettings.AccountUpdatesPerQuery)
- {
- CurrentQuery = 0;
- }
- }
- }
- //int GCDifference = DateTime.Compare(DateTime.Now, GarbageRun.AddSeconds(GarbageRunDelay));
- //if (GCDifference > 0)
- //{
- // GC.Collect();
- // RCScript.Log("Garbage collected");
- // GarbageRun = DateTime.Now;
- //}
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement