public VaultData ReadVault(Account acc)
{
MySqlCommand cmd = CreateQuery();
cmd.CommandText = "SELECT chestId, items FROM vaults WHERE accId=@accId;";
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.HasRows)
{
var ret = new VaultData { Chests = new List<VaultChest>() };
while (rdr.Read())
{
ret.Chests.Add(new VaultChest
{
ChestId = rdr.GetInt32("chestId"),
_Items = rdr.GetString("items")
});
}
return ret;
}
return new VaultData
{
Chests = new List<VaultChest>()
};
}
}