public bool SaveUser(CTFUser user) { try { db.Query("UPDATE ctfusers SET Coins = @0, Kills = @1, Deaths = @2, " + "Assists = @3, Wins = @4, Loses = @5, Draws = @6, Classes = @7 WHERE ID = @8", user.Coins, user.Kills, user.Deaths, user.Assists, user.Wins, user.Loses, user.Draws, ClassesToString(user.Classes), user.ID); return(true); } catch (Exception ex) { TShock.Log.Error(ex.ToString()); } return(false); }
public CTFUser GetUser(int id) { try { using (var reader = db.QueryReader("SELECT * FROM ctfusers WHERE ID = @0", id)) { if (reader.Read()) { return(new CTFUser() { ID = reader.Get <int>("ID"), Coins = reader.Get <int>("Coins"), Kills = reader.Get <int>("Kills"), Deaths = reader.Get <int>("Deaths"), Assists = reader.Get <int>("Assists"), Wins = reader.Get <int>("Wins"), Loses = reader.Get <int>("Loses"), Draws = reader.Get <int>("Draws"), Classes = ParseClasses(reader.Get <string>("Classes")) }); } else { var ret = new CTFUser(); ret.ID = id; if (db.Query("INSERT INTO ctfusers (ID, Coins, Kills, " + "Deaths, Assists, Wins, Loses, Draws, Classes) " + "VALUES (@0, @1, @2, @3, @4, @5, @6, @7, @8)", ret.ID, ret.Coins, ret.Kills, ret.Deaths, ret.Assists, ret.Wins, ret.Loses, ret.Draws, ClassesToString(ret.Classes)) != 0) { return(ret); } } } } catch (Exception ex) { TShock.Log.Error(ex.ToString()); } return(null); }