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);
}
}
