Code:
public void CreateCharacter(ulong accID, uint slot, uint avatar)
{
using (var con = GetConnection())
{
using (var cmd = BuildQuery(con, "INSERT INTO account_characters(AccountID, Slot, Avatar) VALUES(@AccountID, @Slot, @Avatar)", "@AccountID", accID, "@Slot", slot, "@Avatar", avatar))
{
cmd.ExecuteNonQuery();
}
using (var cmd = BuildQuery(con,
"INSERT INTO account_inventory(AccountID, Category, SubCategory, ItemID, ProductID, EffectID, PurchaseTime, ExpireTime, Energy) VALUES(@AccountID, @Category, @SubCategory, @ItemID, @ProductID, @EffectID, @PurchaseTime, @ExpireTime, @Energy); SHOW TABLE STATUS LIKE 'account_inventory';",
"@AccountID", accID, "@Category", 3, "@SubCategory", 10, "@ItemID", 1, "@ProductID", 3, "@EffectID", 0, "@PurchaseTime", 1398784884, "@ExpireTime", -1, "@Energy", 2400))
{
cmd.ExecuteNonQuery();
}
using (var cmd = BuildQuery(con,
"INSERT INTO account_inventory(AccountID, Category, SubCategory, ItemID, ProductID, EffectID, PurchaseTime, ExpireTime, Energy) VALUES(@AccountID, @Category, @SubCategory, @ItemID, @ProductID, @EffectID, @PurchaseTime, @ExpireTime, @Energy); SHOW TABLE STATUS LIKE 'account_inventory';",
"@AccountID", accID, "@Category", 2, "@SubCategory", 0, "@ItemID", 1, "@ProductID", 2, "@EffectID", 0, "@PurchaseTime", 1398785050, "@ExpireTime", -1, "@Energy",2400))
{
cmd.ExecuteNonQuery();
}
}
}






