private int CallProcEquipmentStatsEntry( MySqlConnection connection, MySqlTransaction transaction, DataGachaItem equip) { int num = equip.AccMax > 0 ? 1 : 2; using (MySqlCommand mySqlCommand = new MySqlCommand("insert_equipment_stats_entry", connection, transaction)) { mySqlCommand.CommandType = CommandType.StoredProcedure; mySqlCommand.Parameters.AddWithValue("@iid", (object)equip.ItemID); mySqlCommand.Parameters.AddWithValue("@iname", (object)equip.ItemName); mySqlCommand.Parameters.AddWithValue("@atkmin", (object)equip.AtkMin); mySqlCommand.Parameters.AddWithValue("@magmin", (object)equip.MagMin); mySqlCommand.Parameters.AddWithValue("@accmin", (object)equip.AccMin); mySqlCommand.Parameters.AddWithValue("@defmin", (object)equip.DefMin); mySqlCommand.Parameters.AddWithValue("@resmin", (object)equip.ResMin); mySqlCommand.Parameters.AddWithValue("@evamin", (object)equip.EvaMin); mySqlCommand.Parameters.AddWithValue("@mndmin", (object)equip.MndMin); mySqlCommand.Parameters.AddWithValue("@atkmax", (object)equip.AtkMax); mySqlCommand.Parameters.AddWithValue("@magmax", (object)equip.MagMax); mySqlCommand.Parameters.AddWithValue("@accmax", (object)equip.AccMax); mySqlCommand.Parameters.AddWithValue("@defmax", (object)equip.DefMax); mySqlCommand.Parameters.AddWithValue("@resmax", (object)equip.ResMax); mySqlCommand.Parameters.AddWithValue("@evamax", (object)equip.EvaMax); mySqlCommand.Parameters.AddWithValue("@mndmax", (object)equip.MndMax); mySqlCommand.Parameters.AddWithValue("@irarity", (object)equip.Rarity); mySqlCommand.Parameters.AddWithValue("@iseries", (object)equip.SeriesID); mySqlCommand.Parameters.AddWithValue("@isubtype", (object)equip.CategoryID); mySqlCommand.Parameters.AddWithValue("@itype", (object)num); return(mySqlCommand.ExecuteNonQuery()); } }
private int CallProcRecordItemProbability( MySqlConnection connection, MySqlTransaction transaction, DataGachaItem equip, uint SeriesID, bool isJP) { using (MySqlCommand mySqlCommand = new MySqlCommand("record_item_probability", connection, transaction)) { mySqlCommand.CommandType = CommandType.StoredProcedure; mySqlCommand.Parameters.AddWithValue("@bid", (object)SeriesID); mySqlCommand.Parameters.AddWithValue("@isjp", (object)isJP); mySqlCommand.Parameters.AddWithValue("@iid", (object)equip.ItemID); mySqlCommand.Parameters.AddWithValue("@irate", (object)equip.Probability); return(mySqlCommand.ExecuteNonQuery()); } }
private int CallProcItemEntry( MySqlConnection connection, MySqlTransaction transaction, DataGachaItem equip) { int num = equip.AccMax > 0 ? 1 : 2; using (MySqlCommand mySqlCommand = new MySqlCommand("insert_item_entry", connection, transaction)) { mySqlCommand.CommandType = CommandType.StoredProcedure; mySqlCommand.Parameters.AddWithValue("@iid", (object)equip.ItemID); mySqlCommand.Parameters.AddWithValue("@iname", (object)equip.ItemName); mySqlCommand.Parameters.AddWithValue("@irarity", (object)equip.Rarity); mySqlCommand.Parameters.AddWithValue("@iseries", (object)equip.SeriesID); mySqlCommand.Parameters.AddWithValue("@itype", (object)num); mySqlCommand.Parameters.AddWithValue("@isubtype", (object)equip.CategoryID); return(mySqlCommand.ExecuteNonQuery()); } }