public void Execute(MySqlConnection connection, MySqlTransaction transaction) { using (MySqlCommand mySqlCommand = new MySqlCommand(string.Format("SELECT * FROM banner_featured_items WHERE bannerid = {0} AND isJapanese = {1}", (object)this.myBannerID, (object)(this.myIsJP ? 1 : 0)), connection, transaction)) { using (MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader()) { while (mySqlDataReader.Read()) { BasicFeaturedItemInfo featuredItemInfo = new BasicFeaturedItemInfo(); featuredItemInfo.BannerID = (uint)mySqlDataReader["bannerid"]; byte b = (byte)mySqlDataReader["isJapanese"]; featuredItemInfo.IsJP = b == (byte)1; featuredItemInfo.ItemID = (uint)mySqlDataReader["itemid"]; int key = this.HashValues(featuredItemInfo.BannerID, b, featuredItemInfo.ItemID); featuredItemInfo.DisplayOrder = (int)mySqlDataReader["disp_order"]; featuredItemInfo.ItemImagePath = (string)mySqlDataReader["image_path"]; featuredItemInfo.CharacterID = (uint)mySqlDataReader["character_id"]; featuredItemInfo.HasSB = (byte)mySqlDataReader["has_sb"] == (byte)1; featuredItemInfo.HasCharacterSB = (byte)mySqlDataReader["has_character_sb"] == (byte)1; featuredItemInfo.LMID = (uint)mySqlDataReader["legend_materia_id"]; featuredItemInfo.SBCategoryID = (int)mySqlDataReader["sb_category_id"]; featuredItemInfo.Rate = this.ParseDecimal(mySqlDataReader["rate"]); featuredItemInfo.SBImagePath = (string)mySqlDataReader["sb_image_path"]; featuredItemInfo.Description = (string)mySqlDataReader["sb_description"]; this.myItems.Add(key, featuredItemInfo); } } } }
private void ConsolidateRelicDrawList(Dictionary <long, BasicRelicDropInfo> draws) { this.myMiscInfo = new FFRKViewGacha2.MiscDropInfo(); bool flag1 = true; if (this.comboBoxPullTypeFilter.SelectedIndex == 1) { flag1 = false; } bool flag2 = true; if (this.comboBoxPullTypeFilter.SelectedIndex == 0) { flag2 = false; } Dictionary <uint, FilteredRelicDropInfo> dictionary1 = new Dictionary <uint, FilteredRelicDropInfo>(); Dictionary <long, bool> dictionary2 = new Dictionary <long, bool>(); foreach (BasicRelicDropInfo basicRelicDropInfo in draws.Values) { BasicRelicDropInfo dropInfo = basicRelicDropInfo; if ((dropInfo.ItemTotal != (ushort)11 || flag1) && (dropInfo.ItemTotal == (ushort)11 || flag2)) { long key = this.HashTimeAndUser(dropInfo.ServerTime, dropInfo.UserHash); if (!dictionary2.ContainsKey(key)) { this.myMiscInfo.totalPulls += (int)dropInfo.ItemTotal; dictionary2.Add(key, true); } switch (dropInfo.Rarity) { case 1: this.myMiscInfo.count1 += (int)dropInfo.DropNum; break; case 2: this.myMiscInfo.count2 += (int)dropInfo.DropNum; break; case 3: this.myMiscInfo.count3 += (int)dropInfo.DropNum; break; case 4: this.myMiscInfo.count4 += (int)dropInfo.DropNum; break; case 5: this.myMiscInfo.count5 += (int)dropInfo.DropNum; break; case 6: this.myMiscInfo.count6 += (int)dropInfo.DropNum; break; case 7: this.myMiscInfo.count7 += (int)dropInfo.DropNum; break; } if (dropInfo.Rarity > (byte)4) { if (dictionary1.ContainsKey(dropInfo.ItemID)) { dictionary1[dropInfo.ItemID].DropNum += dropInfo.DropNum; } else if (this.myFeaturedItems.Values.ToList <BasicFeaturedItemInfo>().Exists((Predicate <BasicFeaturedItemInfo>)(x => (int)x.ItemID == (int)dropInfo.ItemID))) { FilteredRelicDropInfo filteredRelicDropInfo = new FilteredRelicDropInfo(); filteredRelicDropInfo.DropNum = dropInfo.DropNum; filteredRelicDropInfo.ItemID = dropInfo.ItemID; filteredRelicDropInfo.ItemName = dropInfo.ItemName; filteredRelicDropInfo.Rarity = dropInfo.Rarity; BasicFeaturedItemInfo featuredItemInfo = this.myFeaturedItems.Values.First <BasicFeaturedItemInfo>((Func <BasicFeaturedItemInfo, bool>)(x => (int)x.ItemID == (int)dropInfo.ItemID)); filteredRelicDropInfo.DisplayOrder = featuredItemInfo.DisplayOrder; filteredRelicDropInfo.AssumedRate = featuredItemInfo.Rate; dictionary1.Add(dropInfo.ItemID, filteredRelicDropInfo); } else { switch (dropInfo.Rarity) { case 5: this.myMiscInfo.offBanner5count += (int)dropInfo.DropNum; break; case 6: this.myMiscInfo.offBanner6count += (int)dropInfo.DropNum; break; case 7: this.myMiscInfo.offBanner7count += (int)dropInfo.DropNum; break; } } } } } FiddlerApplication.Log.LogString(dictionary1.Values.Count.ToString()); this.myConsolidatedRelicDrops = dictionary1; }