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(); } } }