public void SaveBackpacks(Char chr, Account acc)
{
if (chr.Backpacks.Count > 0)
{
foreach (var i in chr.Backpacks)
{
MySqlCommand cmd = CreateQuery();
cmd.CommandText = @"INSERT INTO backpacks(accId, charId, num, items)
VALUES(@accId, @charId, @num, @items)
ON DUPLICATE KEY UPDATE
items = @items;";
cmd.Parameters.AddWithValue("@charId", chr.CharacterId);
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
cmd.Parameters.AddWithValue("@num", i.Key);
cmd.Parameters.AddWithValue("@items", Utils.GetCommaSepString(i.Value));
cmd.ExecuteNonQuery();
}
}
}