public Dictionary<int, short[]> GetBackpacks(Char chr, Account acc)
{
MySqlCommand cmd = CreateQuery();
cmd.CommandText = "SELECT * FROM backpacks WHERE charId=@charId AND accId=@accId";
cmd.Parameters.AddWithValue("@charId", chr.CharacterId);
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
var ret = new Dictionary<int, short[]>();
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
if (!rdr.HasRows)
return new Dictionary<int, short[]> { { 1, new short[] { -1, -1, -1, -1, -1, -1, -1, -1 } } };
while (rdr.Read())
ret.Add(rdr.GetInt32("num"), Utils.FromCommaSepString16(rdr.GetString("items")));
return ret;
}
}