/// <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;
}
