public void ReadStats(Account acc)
{
MySqlCommand cmd = CreateQuery();
cmd.CommandText = "SELECT fame, totalFame, credits FROM stats WHERE accId=@accId;";
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.HasRows)
{
rdr.Read();
acc.Credits = rdr.GetInt32("credits");
acc.Stats = new Stats
{
Fame = rdr.GetInt32("fame"),
TotalFame = rdr.GetInt32("totalFame")
};
}
else
{
acc.Credits = 0;
acc.Stats = new Stats
{
Fame = 0,
TotalFame = 0,
BestCharFame = 0,
ClassStates = new List<ClassStats>()
};
}
}
acc.Stats.ClassStates = ReadClassStates(acc);
if (acc.Stats.ClassStates.Count > 0)
acc.Stats.BestCharFame = acc.Stats.ClassStates.Max(_ => _.BestFame);
acc.Vault = ReadVault(acc);
}