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