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