/// <summary> /// Removes the card from the db, returns true if successful. /// </summary> /// <param name="card"></param> /// <returns></returns> public bool DeleteCard(Card card) { using (var conn = this.Connection) using (var mc = new MySqlCommand("DELETE FROM `cards` WHERE `cardId` = @cardId", conn)) { mc.Parameters.AddWithValue("@cardId", card.Id); return (mc.ExecuteNonQuery() > 0); } }
/// <summary> /// Returns all pet and partner cards present for this account. /// </summary> /// <param name="accountId"></param> /// <returns></returns> public List<Card> GetPetCards(string accountId) { using (var conn = this.Connection) using (var mc = new MySqlCommand("SELECT `cardId`, `type`, `race` FROM `cards` WHERE `accountId` = @accountId AND race > 0 AND !`isGift`", conn)) { mc.Parameters.AddWithValue("@accountId", accountId); var result = new List<Card>(); using (var reader = mc.ExecuteReader()) { while (reader.Read()) { var card = new Card(); card.Id = reader.GetInt64("cardId"); card.Type = reader.GetInt32("type"); card.Race = reader.GetInt32("race"); result.Add(card); } } return result; } }
/// <summary> /// Deletes pet card from account. /// </summary> /// <param name="card"></param> public bool DeletePetCard(Card card) { if (!LoginServer.Instance.Database.DeleteCard(card)) return false; this.PetCards.Remove(card); return true; }
// Cards // ------------------------------------------------------------------ /// <summary> /// Returns all character cards present for this account. /// </summary> /// <param name="accountName"></param> /// <returns></returns> public List<Card> GetCharacterCards(string accountName) { using (var conn = MabiDb.Instance.GetConnection()) { var mc = new MySqlCommand("SELECT `cardId`, `type` FROM `cards` WHERE `accountId` = @id AND race = 0 AND !`isGift`", conn); mc.Parameters.AddWithValue("@id", accountName); var result = new List<Card>(); using (var reader = mc.ExecuteReader()) { while (reader.Read()) { var card = new Card(); card.Id = reader.GetUInt32("cardId"); card.Type = reader.GetUInt32("type"); result.Add(card); } } return result; } }
/// <summary> /// Deletes character card from account. /// </summary> /// <param name="cardId"></param> public bool DeleteCharacterCard(Card card) { if (!LoginDb.Instance.DeleteCard(card)) return false; this.CharacterCards.Remove(card); return true; }