public List<ClassStats> ReadClassStates(Account acc)
{
MySqlCommand cmd = CreateQuery();
cmd.CommandText = "SELECT objType, bestLv, bestFame FROM classstats WHERE accId=@accId;";
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
var ret = new List<ClassStats>();
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
ret.Add(new ClassStats
{
ObjectType = rdr.GetInt32("objType"),
BestFame = rdr.GetInt32("bestFame"),
BestLevel = rdr.GetInt32("bestLv")
});
}
return ret;
}