public static Response UpdateClientOnServerRequestHandler(UpdateClientOnServerRequest arg) { //string command = $"UPDATE users SET galacticcredits={arg.user.galacticCredits} WHERE username='******'"; //using var cmd = new SQLiteCommand(command, StarDatabaseCode.sqlite_conn); //cmd.ExecuteNonQuery(); DatabaseFiles.DatabaseHandler.db.Query <User>($"UPDATE users SET galacticcredits={arg.user.galacticCredits} WHERE username='******'"); //command = $"UPDATE users SET diplomaticweight={arg.user.diplomaticWeight} WHERE username='******'"; //using var cmdd = new SQLiteCommand(command, StarDatabaseCode.sqlite_conn); //cmdd.ExecuteNonQuery(); DatabaseFiles.DatabaseHandler.db.Query <User>($"UPDATE users SET diplomaticweight={arg.user.diplomaticWeight} WHERE username='******'"); //command = $"UPDATE users SET sysid={arg.user.positionID} WHERE username='******'"; //using var cmddd = new SQLiteCommand(command, StarDatabaseCode.sqlite_conn); //cmddd.ExecuteNonQuery(); DatabaseFiles.DatabaseHandler.db.Query <User>($"UPDATE users SET positionID={arg.user.positionID} WHERE username='******'"); bool x = liveUsers.Keys.First() == arg.user.seshID; ServerProgram.liveUsers[arg.user.seshID] = arg.user; Console.WriteLine(arg.user.username + "'s data has been updated - " + DateTime.Now.ToString("G")); foreach (User user in liveUsers.Values) { Console.WriteLine(user.seshID + " : " + user.username); } Console.WriteLine(liveUsers.Count + " users are live"); return(Response.From(ServerProgram.liveUsers[arg.user.seshID])); }
private void SendUpdateToServer() { lock (client) { UpdateClientOnServerRequest createReq = new UpdateClientOnServerRequest(currUser); currUser = client.SendRequest <User>(createReq); } }