private int CallProcRecordBannerProbabilities(
MySqlConnection connection,
MySqlTransaction transaction,
DataGachaSeriesItemDetails itemDetails,
uint SeriesID,
bool isJP)
{
Decimal num1 = !itemDetails.ProbabilityByRarity.OneStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.OneStar.Value;
Decimal num2 = !itemDetails.ProbabilityByRarity.TwoStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.TwoStar.Value;
Decimal num3 = !itemDetails.ProbabilityByRarity.ThreeStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.ThreeStar.Value;
Decimal num4 = !itemDetails.ProbabilityByRarity.FourStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.FourStar.Value;
Decimal num5 = !itemDetails.ProbabilityByRarity.FiveStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.FiveStar.Value;
Decimal num6 = !itemDetails.ProbabilityByRarity.SixStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.SixStar.Value;
Decimal num7 = !itemDetails.ProbabilityByRarity.SevenStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.SevenStar.Value;
using (MySqlCommand mySqlCommand = new MySqlCommand("record_banner_probabilities", connection, transaction))
{
mySqlCommand.CommandType = CommandType.StoredProcedure;
mySqlCommand.Parameters.AddWithValue("@bid", (object)SeriesID);
mySqlCommand.Parameters.AddWithValue("@isjp", (object)isJP);
mySqlCommand.Parameters.AddWithValue("@r1", (object)num1);
mySqlCommand.Parameters.AddWithValue("@r2", (object)num2);
mySqlCommand.Parameters.AddWithValue("@r3", (object)num3);
mySqlCommand.Parameters.AddWithValue("@r4", (object)num4);
mySqlCommand.Parameters.AddWithValue("@r5", (object)num5);
mySqlCommand.Parameters.AddWithValue("@r6", (object)num6);
mySqlCommand.Parameters.AddWithValue("@r7", (object)num7);
mySqlCommand.Parameters.AddWithValue("@assuredrarity", (object)itemDetails.AssuredRarity);
mySqlCommand.Parameters.AddWithValue("@boostrate", (object)itemDetails.BoostRateAssured);
mySqlCommand.Parameters.AddWithValue("@equalprob", (object)itemDetails.EqualProbInRarity);
return(mySqlCommand.ExecuteNonQuery());
}
}
public DbOpRecordGachaProbabilities(
DataGachaSeriesItemDetails itemDetails,
uint seriesID,
ulong serverTime)
{
this.mItemDetails = itemDetails;
this.mSeriesID = seriesID;
this.serverTime = serverTime;
}
