From 9674be8bcd0fba52d5b8662a6c330b6de0001d7a Mon Sep 17 00:00:00 2001 From: Nay Date: Thu, 24 Mar 2011 12:09:34 +0000 Subject: SQL: Fix some errors in previous commits. --- .../world/2011_03_23_10_world_loot_template.sql | 382 --------------------- .../world/2011_03_24_0_world_creature_template.sql | 5 +- .../world/2011_03_24_1_world_loot_template.sql | 382 +++++++++++++++++++++ 3 files changed, 384 insertions(+), 385 deletions(-) delete mode 100644 sql/updates/world/2011_03_23_10_world_loot_template.sql create mode 100644 sql/updates/world/2011_03_24_1_world_loot_template.sql (limited to 'sql') diff --git a/sql/updates/world/2011_03_23_10_world_loot_template.sql b/sql/updates/world/2011_03_23_10_world_loot_template.sql deleted file mode 100644 index a039b5d1933..00000000000 --- a/sql/updates/world/2011_03_23_10_world_loot_template.sql +++ /dev/null @@ -1,382 +0,0 @@ --- Trashloot for ICC/FoS/PoS/HoR --- Generic -SET @ICC_TrashGenericGrey := 35063; -- Set by TDB (need x) -SET @ICC_TrashGenericWhite := @ICC_TrashGenericGrey+1; -SET @ICC_TrashGenericScroll := @ICC_TrashGenericGrey+2; -SET @ICC_TrashGenericGreen := @ICC_TrashGenericGrey+3; -SET @ICC_TrashGenericBlue := @ICC_TrashGenericGrey+4; -SET @ICC_TrashGenericPurpleICC := @ICC_TrashGenericGrey+5; -SET @ICC_TrashCitadelFinal := @ICC_TrashGenericGrey+6; -SET @ICC_TrashGenericPurpleDUNN := @ICC_TrashGenericGrey+7; -SET @ICC_TrashDungeonNFinal := @ICC_TrashGenericGrey+8; -SET @ICC_TrashGenericPurpleDUNH := @ICC_TrashGenericGrey+9; -SET @ICC_TrashDungeonHFinal := @ICC_TrashGenericGrey+10; -SET @ICC_TrashGenericPurple := @ICC_TrashGenericGrey+11; - -DELETE FROM `reference_loot_template` WHERE `entry` BETWEEN @ICC_TrashGenericGrey AND @ICC_TrashGenericGrey+11; -DELETE FROM `reference_loot_template` WHERE `entry` BETWEEN 35063 AND 35076; -- cleanup OLD loot -INSERT INTO reference_loot_template (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES --- grey items (45) -(@ICC_TrashGenericGrey,33430,0,1,1,1,1), -- Abandoned Greatsword -(@ICC_TrashGenericGrey,33426,0,1,1,1,1), -- Chipped Timber Axe -(@ICC_TrashGenericGrey,33424,0,1,1,1,1), -- Cracked Iron Staff -(@ICC_TrashGenericGrey,33428,0,1,1,1,1), -- Dulled SHiv -(@ICC_TrashGenericGrey,33397,0,1,1,1,1), -- Frigid Mail Armor -(@ICC_TrashGenericGrey,33398,0,1,1,1,1), -- Frigid Mail Belt -(@ICC_TrashGenericGrey,33399,0,1,1,1,1), -- Frigid Mail Boots -(@ICC_TrashGenericGrey,33400,0,1,1,1,1), -- Frigid Mail Bracers -(@ICC_TrashGenericGrey,33433,0,1,1,1,1), -- Frigid Mail Circlet -(@ICC_TrashGenericGrey,33401,0,1,1,1,1), -- Frigid Mail Gloves -(@ICC_TrashGenericGrey,33402,0,1,1,1,1), -- Frigid Mail Pants -(@ICC_TrashGenericGrey,33403,0,1,1,1,1), -- Frigid Mail Shoulderpads -(@ICC_TrashGenericGrey,33427,0,1,1,1,1), -- Frost-Encrusted Rifle -(@ICC_TrashGenericGrey,33365,0,1,1,1,1), -- Frost-Rimed Cloth Belt -(@ICC_TrashGenericGrey,33366,0,1,1,1,1), -- Frost-Rimed Cloth Boots -(@ICC_TrashGenericGrey,33367,0,1,1,1,1), -- Frost-Rimed Cloth Bracers -(@ICC_TrashGenericGrey,33368,0,1,1,1,1), -- Frost-Rimed Cloth Gloves -(@ICC_TrashGenericGrey,33346,0,1,1,1,1), -- Frost-Rimed Cloth Hat -(@ICC_TrashGenericGrey,33369,0,1,1,1,1), -- Frost-Rimed Cloth Pants -(@ICC_TrashGenericGrey,33370,0,1,1,1,1), -- Frost-Rimed Cloth Shoulderpads -(@ICC_TrashGenericGrey,33371,0,1,1,1,1), -- Frost-Rimed Cloth Vest -(@ICC_TrashGenericGrey,33412,0,1,1,1,1), -- Frost-Worn Plate Belt -(@ICC_TrashGenericGrey,33413,0,1,1,1,1), -- Frost-Worn Plate Boots -(@ICC_TrashGenericGrey,33414,0,1,1,1,1), -- Frost-Worn Plate Bracers -(@ICC_TrashGenericGrey,33415,0,1,1,1,1), -- Frost-Worn Plate Chestpiece -(@ICC_TrashGenericGrey,33416,0,1,1,1,1), -- Frost-Worn Plate Gloves -(@ICC_TrashGenericGrey,33435,0,1,1,1,1), -- Frost-Worn Plate Helmet -(@ICC_TrashGenericGrey,33417,0,1,1,1,1), -- Frost-Worn Plate Pants -(@ICC_TrashGenericGrey,33419,0,1,1,1,1), -- Frost-Worn Plate Shoulderpads -(@ICC_TrashGenericGrey,33379,0,1,1,1,1), -- Frozen Armor -(@ICC_TrashGenericGrey,33380,0,1,1,1,1), -- Frozen Belt -(@ICC_TrashGenericGrey,33381,0,1,1,1,1), -- Frozen Boots -(@ICC_TrashGenericGrey,33382,0,1,1,1,1), -- Frozen Bracers -(@ICC_TrashGenericGrey,33383,0,1,1,1,1), -- Frozen Gloves -(@ICC_TrashGenericGrey,33434,0,1,1,1,1), -- Frozen Leather Helmet -(@ICC_TrashGenericGrey,33384,0,1,1,1,1), -- Frozen Pants -(@ICC_TrashGenericGrey,33385,0,1,1,1,1), -- Frozen Shoulderpads -(@ICC_TrashGenericGrey,33429,0,1,1,1,1), -- Ice Cleaver -(@ICC_TrashGenericGrey,33425,0,1,1,1,1), -- Ice-Pitted Blade -(@ICC_TrashGenericGrey,33431,0,1,1,1,1), -- Icesmashing Mace -(@ICC_TrashGenericGrey,33423,0,1,1,1,1), -- Rime-Covered Mace -(@ICC_TrashGenericGrey,33422,0,1,1,1,1), -- Shattered Bow -(@ICC_TrashGenericGrey,43852,70,1,1,1,1), -- Thick Fur Clothing Scraps (drops more often) --- white items -(@ICC_TrashGenericWhite,33470,0,1,1,2,7), -- Frostweave Cloth -(@ICC_TrashGenericWhite,33445,0,1,1,1,1), -- Honeymint Tea -(@ICC_TrashGenericWhite,33454,0,1,1,1,1), -- Salted Venison -(@ICC_TrashGenericWhite,35947,0,1,1,1,1), -- Sparkling Frostcap -(@ICC_TrashGenericWhite,33447,0,1,1,1,1), -- Runic Healing Potion -(@ICC_TrashGenericWhite,33448,0,1,1,1,1), -- Runic Mana Potion --- Scroll items -(@ICC_TrashGenericScroll,43463,0,1,1,1,1), -- Scroll of Agility VII -(@ICC_TrashGenericScroll,37091,0,1,1,1,1), -- Scroll of Intellect VII -(@ICC_TrashGenericScroll,37093,0,1,1,1,1), -- Scroll of Stamina VII -(@ICC_TrashGenericScroll,43465,0,1,1,1,1), -- Scroll of Strength VII -(@ICC_TrashGenericScroll,37097,0,1,1,1,1), -- Scroll of Spirit VII -(@ICC_TrashGenericScroll,43464,0,1,1,1,1), -- Scroll of Agility VIII -(@ICC_TrashGenericScroll,37092,0,1,1,1,1), -- Scroll of Intellect VIII -(@ICC_TrashGenericScroll,37094,0,1,1,1,1), -- Scroll of Stamina VIII -(@ICC_TrashGenericScroll,43466,0,1,1,1,1), -- Scroll of Strength VIII -(@ICC_TrashGenericScroll,37098,0,1,1,1,1), -- Scroll of Spirit VIII --- green items (166) -(@ICC_TrashGenericGreen,36609,0,1,1,1,1), -- Abandoned Spear -(@ICC_TrashGenericGreen,36497,0,1,1,1,1), -- Adamant Mallet -(@ICC_TrashGenericGreen,36511,0,1,1,1,1), -- Artic War Hammer -(@ICC_TrashGenericGreen,36694,0,1,1,1,1), -- Beatific Mace -(@ICC_TrashGenericGreen,36527,0,1,1,1,1), -- Blackened Blade -(@ICC_TrashGenericGreen,36611,0,1,1,1,1), -- Black Scythe -(@ICC_TrashGenericGreen,36638,0,1,1,1,1), -- Bloody Crossbow -(@ICC_TrashGenericGreen,36428,0,1,1,1,1), -- Bouquet Ring -(@ICC_TrashGenericGreen,36639,0,1,1,1,1), -- Brutal Ballista -(@ICC_TrashGenericGreen,36707,0,1,1,1,1), -- Cascading Water Staff -(@ICC_TrashGenericGreen,36539,0,1,1,1,1), -- Chilled Warblade -(@ICC_TrashGenericGreen,36723,0,1,1,1,1), -- Clawed Shuriken -(@ICC_TrashGenericGreen,36035,0,1,1,1,1), -- Condor Belt -(@ICC_TrashGenericGreen,36042,0,1,1,1,1), -- Condor Bindings -(@ICC_TrashGenericGreen,36038,0,1,1,1,1), -- Condor Gloves -(@ICC_TrashGenericGreen,36039,0,1,1,1,1), -- Condor Headpiece -(@ICC_TrashGenericGreen,36040,0,1,1,1,1), -- Condor Pants -(@ICC_TrashGenericGreen,36037,0,1,1,1,1), -- Condor Robe -(@ICC_TrashGenericGreen,36036,0,1,1,1,1), -- Condor Sandals -(@ICC_TrashGenericGreen,36041,0,1,1,1,1), -- Condor Shoulderpads -(@ICC_TrashGenericGreen,36266,0,1,1,1,1), -- Cormorant Bracelets -(@ICC_TrashGenericGreen,36261,0,1,1,1,1), -- Cormorant Chain Vest -(@ICC_TrashGenericGreen,36260,0,1,1,1,1), -- Cormorant Footwraps -(@ICC_TrashGenericGreen,36262,0,1,1,1,1), -- Cormorant Gloves -(@ICC_TrashGenericGreen,36263,0,1,1,1,1), -- Cormorant Helm -(@ICC_TrashGenericGreen,36264,0,1,1,1,1), -- Cormorant Leggings -(@ICC_TrashGenericGreen,36265,0,1,1,1,1), -- Cormorant Mantle -(@ICC_TrashGenericGreen,36259,0,1,1,1,1), -- Cormorant Waistband -(@ICC_TrashGenericGreen,36525,0,1,1,1,1), -- Craggy Machete -(@ICC_TrashGenericGreen,36709,0,1,1,1,1), -- Crystal Woodstaff -(@ICC_TrashGenericGreen,36050,0,1,1,1,1), -- Crystalsong Bracelets -(@ICC_TrashGenericGreen,36047,0,1,1,1,1), -- Crystalsong Crown -(@ICC_TrashGenericGreen,36046,0,1,1,1,1), -- Crystalsong Gloves -(@ICC_TrashGenericGreen,36048,0,1,1,1,1), -- Crystalsong Leggings -(@ICC_TrashGenericGreen,36049,0,1,1,1,1), -- Crystalsong Mantle -(@ICC_TrashGenericGreen,36045,0,1,1,1,1), -- Crystalsong Robe -(@ICC_TrashGenericGreen,36043,0,1,1,1,1), -- Crystalsong Sash -(@ICC_TrashGenericGreen,36044,0,1,1,1,1), -- Crystalsong Slippers -(@ICC_TrashGenericGreen,36554,0,1,1,1,1), -- Cursed Staff -(@ICC_TrashGenericGreen,43297,0,1,1,1,1), -- Damaged Necklace -(@ICC_TrashGenericGreen,36553,0,1,1,1,1), -- Desecrated Staff -(@ICC_TrashGenericGreen,36695,0,1,1,1,1), -- Dogmatic Scepter -(@ICC_TrashGenericGreen,36721,0,1,1,1,1), -- Dragon's Teeth -(@ICC_TrashGenericGreen,36413,0,1,1,1,1), -- Dyed Taffeta Cape -(@ICC_TrashGenericGreen,36427,0,1,1,1,1), -- Engraved Ring -(@ICC_TrashGenericGreen,36484,0,1,1,1,1), -- Etched Dagger -(@ICC_TrashGenericGreen,36499,0,1,1,1,1), -- Frigid War-Mace -(@ICC_TrashGenericGreen,36470,0,1,1,1,1), -- Gilded Scepter -(@ICC_TrashGenericGreen,36381,0,1,1,1,1), -- Golem Breastplate -(@ICC_TrashGenericGreen,36382,0,1,1,1,1), -- Golem Gauntlets -(@ICC_TrashGenericGreen,36379,0,1,1,1,1), -- Golem Girdle -(@ICC_TrashGenericGreen,36383,0,1,1,1,1), -- Golem Helmet -(@ICC_TrashGenericGreen,36384,0,1,1,1,1), -- Golem Legplates -(@ICC_TrashGenericGreen,36385,0,1,1,1,1), -- Golem Pauldrons -(@ICC_TrashGenericGreen,36380,0,1,1,1,1), -- Golem Sabatons -(@ICC_TrashGenericGreen,36386,0,1,1,1,1), -- Golem Vambraces -(@ICC_TrashGenericGreen,36623,0,1,1,1,1), -- Harnessed Longbow -(@ICC_TrashGenericGreen,36568,0,1,1,1,1), -- Hollowed Bone Knuckles -(@ICC_TrashGenericGreen,36637,0,1,1,1,1), -- Horrific Crossbow -(@ICC_TrashGenericGreen,36471,0,1,1,1,1), -- Ice Crystal -(@ICC_TrashGenericGreen,36582,0,1,1,1,1), -- Ice Pick -(@ICC_TrashGenericGreen,36597,0,1,1,1,1), -- Ice-Splintering Axe -(@ICC_TrashGenericGreen,36456,0,1,1,1,1), -- Ice Kite Shield -(@ICC_TrashGenericGreen,36457,0,1,1,1,1), -- Ivory Shield -(@ICC_TrashGenericGreen,36373,0,1,1,1,1), -- Kraken Breastplate -(@ICC_TrashGenericGreen,36377,0,1,1,1,1), -- Kraken Epaulets -(@ICC_TrashGenericGreen,36374,0,1,1,1,1), -- Kraken Gauntlets -(@ICC_TrashGenericGreen,36371,0,1,1,1,1), -- Kraken Girdle -(@ICC_TrashGenericGreen,36372,0,1,1,1,1), -- Kraken Greaves -(@ICC_TrashGenericGreen,36375,0,1,1,1,1), -- Kraken Helm -(@ICC_TrashGenericGreen,36376,0,1,1,1,1), -- Kraken Legplates -(@ICC_TrashGenericGreen,36378,0,1,1,1,1), -- Kraken Vambraces -(@ICC_TrashGenericGreen,36469,0,1,1,1,1), -- Lidless Orb -(@ICC_TrashGenericGreen,36513,0,1,1,1,1), -- Lode-Headed Hammer -(@ICC_TrashGenericGreen,36414,0,1,1,1,1), -- Mammoth Fur Cloack -(@ICC_TrashGenericGreen,36483,0,1,1,1,1), -- Mandible Edge -(@ICC_TrashGenericGreen,36625,0,1,1,1,1), -- Massive Recurved Bow -(@ICC_TrashGenericGreen,36555,0,1,1,1,1), -- Minion Staff -(@ICC_TrashGenericGreen,36651,0,1,1,1,1), -- Muzzled Musket -(@ICC_TrashGenericGreen,36680,0,1,1,1,1), -- Mystic Fang -(@ICC_TrashGenericGreen,36498,0,1,1,1,1), -- Nerubian Mace -(@ICC_TrashGenericGreen,36512,0,1,1,1,1), -- Onerous Mallet -(@ICC_TrashGenericGreen,36441,0,1,1,1,1), -- Pearl Woven Choker -(@ICC_TrashGenericGreen,36540,0,1,1,1,1), -- Petrified Sword -(@ICC_TrashGenericGreen,36610,0,1,1,1,1), -- Plagued Pike -(@ICC_TrashGenericGreen,36595,0,1,1,1,1), -- Planate Broadaxe -(@ICC_TrashGenericGreen,36455,0,1,1,1,1), -- Plated Bulwark -(@ICC_TrashGenericGreen,36443,0,1,1,1,1), -- Platinum Medallion -(@ICC_TrashGenericGreen,36666,0,1,1,1,1), -- Polar Wand -(@ICC_TrashGenericGreen,36653,0,1,1,1,1), -- Precipice Longrifle -(@ICC_TrashGenericGreen,36147,0,1,1,1,1), -- Pygmy Belt -(@ICC_TrashGenericGreen,36154,0,1,1,1,1), -- Pygmy Bindings -(@ICC_TrashGenericGreen,36148,0,1,1,1,1), -- Pygmy Boots -(@ICC_TrashGenericGreen,36150,0,1,1,1,1), -- Pygmy Gloves -(@ICC_TrashGenericGreen,36151,0,1,1,1,1), -- Pygmy Helmet -(@ICC_TrashGenericGreen,36152,0,1,1,1,1), -- Pygmy Pants -(@ICC_TrashGenericGreen,36153,0,1,1,1,1), -- Pygmy Shoulders -(@ICC_TrashGenericGreen,36149,0,1,1,1,1), -- Pygmy Tunic -(@ICC_TrashGenericGreen,36722,0,1,1,1,1), -- Pyramid Throwing Star -(@ICC_TrashGenericGreen,36389,0,1,1,1,1), -- Revenant Armor -(@ICC_TrashGenericGreen,36387,0,1,1,1,1), -- Revenant Belt -(@ICC_TrashGenericGreen,36394,0,1,1,1,1), -- Revenant Bracers -(@ICC_TrashGenericGreen,36393,0,1,1,1,1), -- Revenant Epaulets -(@ICC_TrashGenericGreen,36390,0,1,1,1,1), -- Revenant Gauntlets -(@ICC_TrashGenericGreen,36388,0,1,1,1,1), -- Revenant Greaves -(@ICC_TrashGenericGreen,36391,0,1,1,1,1), -- Revenant Helmet -(@ICC_TrashGenericGreen,36392,0,1,1,1,1), -- Revenant Legguards -(@ICC_TrashGenericGreen,36596,0,1,1,1,1), -- Rupturing Axe -(@ICC_TrashGenericGreen,36569,0,1,1,1,1), -- Savage Talons -(@ICC_TrashGenericGreen,36693,0,1,1,1,1), -- Serene Hammer -(@ICC_TrashGenericGreen,36624,0,1,1,1,1), -- Shrieking Bow -(@ICC_TrashGenericGreen,36442,0,1,1,1,1), -- Silken Cord Amulet -(@ICC_TrashGenericGreen,36679,0,1,1,1,1), -- Singing Dagger -(@ICC_TrashGenericGreen,36485,0,1,1,1,1), -- Sinuous Keris -(@ICC_TrashGenericGreen,36567,0,1,1,1,1), -- Six-Fingered Claws -(@ICC_TrashGenericGreen,36583,0,1,1,1,1), -- Skeletal Hacker -(@ICC_TrashGenericGreen,36526,0,1,1,1,1), -- SLeeted Longsword -(@ICC_TrashGenericGreen,36708,0,1,1,1,1), -- Snow Blossom Staff -(@ICC_TrashGenericGreen,36667,0,1,1,1,1), -- Solid Ice Wand -(@ICC_TrashGenericGreen,36275,0,1,1,1,1), -- Spiderlord Belt -(@ICC_TrashGenericGreen,36276,0,1,1,1,1), -- Spiderlord Boots -(@ICC_TrashGenericGreen,36282,0,1,1,1,1), -- Spiderlord Bracers -(@ICC_TrashGenericGreen,36277,0,1,1,1,1), -- Spiderlord Chestpiece -(@ICC_TrashGenericGreen,36278,0,1,1,1,1), -- Spiderlord Gauntlets -(@ICC_TrashGenericGreen,36279,0,1,1,1,1), -- Spiderlord Helm -(@ICC_TrashGenericGreen,36280,0,1,1,1,1), -- Spiderlord Legguards -(@ICC_TrashGenericGreen,36281,0,1,1,1,1), -- Spiderlord Spaulders -(@ICC_TrashGenericGreen,36429,0,1,1,1,1), -- Spur Ring -(@ICC_TrashGenericGreen,36652,0,1,1,1,1), -- Stocky Shotgun -(@ICC_TrashGenericGreen,36274,0,1,1,1,1), -- Ulduar Bracers -(@ICC_TrashGenericGreen,36269,0,1,1,1,1), -- Ulduar Breastplate -(@ICC_TrashGenericGreen,36270,0,1,1,1,1), -- Ulduar Gauntlets -(@ICC_TrashGenericGreen,36267,0,1,1,1,1), -- Ulduar Girdle -(@ICC_TrashGenericGreen,36268,0,1,1,1,1), -- Ulduar Greaves -(@ICC_TrashGenericGreen,36271,0,1,1,1,1), -- Ulduar Helm -(@ICC_TrashGenericGreen,36272,0,1,1,1,1), -- Ulduar Legguards -(@ICC_TrashGenericGreen,36273,0,1,1,1,1), -- Ulduar Shoulderguards -(@ICC_TrashGenericGreen,36415,0,1,1,1,1), -- Vintage Satin Cloak -(@ICC_TrashGenericGreen,36058,0,1,1,1,1), -- Vizier Bracelets -(@ICC_TrashGenericGreen,36054,0,1,1,1,1), -- Vizier Gloves -(@ICC_TrashGenericGreen,36055,0,1,1,1,1), -- Vizier Hood -(@ICC_TrashGenericGreen,36056,0,1,1,1,1), -- Vizier Leggings -(@ICC_TrashGenericGreen,36057,0,1,1,1,1), -- Vizier Mantle -(@ICC_TrashGenericGreen,36053,0,1,1,1,1), -- Vizier Robe -(@ICC_TrashGenericGreen,36051,0,1,1,1,1), -- Vizier Sash -(@ICC_TrashGenericGreen,36052,0,1,1,1,1), -- Vizier SLippers -(@ICC_TrashGenericGreen,36665,0,1,1,1,1), -- Wasteland Wand -(@ICC_TrashGenericGreen,36170,0,1,1,1,1), -- Webspinner Bindings -(@ICC_TrashGenericGreen,36164,0,1,1,1,1), -- Webspinner Boots -(@ICC_TrashGenericGreen,36163,0,1,1,1,1), -- Webspinner Cord -(@ICC_TrashGenericGreen,36166,0,1,1,1,1), -- Webspinner Gloves -(@ICC_TrashGenericGreen,36167,0,1,1,1,1), -- Webspinner Hood -(@ICC_TrashGenericGreen,36168,0,1,1,1,1), -- Webspinner Leggings -(@ICC_TrashGenericGreen,36169,0,1,1,1,1), -- Webspinner Shoulderguards -(@ICC_TrashGenericGreen,36165,0,1,1,1,1), -- Webspinner Vest -(@ICC_TrashGenericGreen,36162,0,1,1,1,1), -- Wendigo Bands -(@ICC_TrashGenericGreen,36156,0,1,1,1,1), -- Wendigo Boots -(@ICC_TrashGenericGreen,36157,0,1,1,1,1), -- Wendigo Chestpiece -(@ICC_TrashGenericGreen,36155,0,1,1,1,1), -- Wendigo Girdle -(@ICC_TrashGenericGreen,36158,0,1,1,1,1), -- Wendigo Gloves -(@ICC_TrashGenericGreen,36159,0,1,1,1,1), -- Wendigo Hood -(@ICC_TrashGenericGreen,36160,0,1,1,1,1), -- Wendigo Legguards -(@ICC_TrashGenericGreen,36161,0,1,1,1,1), -- Wendigo Pauldrons -(@ICC_TrashGenericGreen,36541,0,1,1,1,1), -- Wintry Claymore -(@ICC_TrashGenericGreen,36681,0,1,1,1,1), -- Wisdom Carver -(@ICC_TrashGenericGreen,36581,0,1,1,1,1), -- Wolvar Handaxe --- blue items -(@ICC_TrashGenericBlue,37792,0,1,1,1,1), -- Agin's Crushing Carapace -(@ICC_TrashGenericBlue,37770,0,1,1,1,1), -- Bulge-Concealing Breastplate -(@ICC_TrashGenericBlue,37780,0,1,1,1,1), -- Condor-Bone Chestguard -(@ICC_TrashGenericBlue,37760,0,1,1,1,1), -- Cracklefire Wristguards -(@ICC_TrashGenericBlue,37781,0,1,1,1,1), -- Grips of the Warming Heart -(@ICC_TrashGenericBlue,37824,0,1,1,1,1), -- Gwyneth's Runed Dragonwand -(@ICC_TrashGenericBlue,37761,0,1,1,1,1), -- Shimmerthread Girdle -(@ICC_TrashGenericBlue,37793,0,1,1,1,1), -- Skullcage of Eternal Terror -(@ICC_TrashGenericBlue,37794,0,1,1,1,1), -- Torta's Oversized Choker -(@ICC_TrashGenericBlue,37822,0,1,1,1,1), -- Twisted Puzzle-Ring -(@ICC_TrashGenericBlue,37771,0,1,1,1,1), -- Wristguard of Verdant Recovery --- Designs -(@ICC_TrashGenericBlue,41788,0,1,1,1,1), -- Design: Beaming Earthsiege Diamond -(@ICC_TrashGenericBlue,41780,0,1,1,1,1), -- Design: Champion's Monarch Topaz -(@ICC_TrashGenericBlue,41786,0,1,1,1,1), -- Design: Destructive Skyflare Diamond -(@ICC_TrashGenericBlue,41777,0,1,1,1,1), -- Design: Etched Monarch Topaz -(@ICC_TrashGenericBlue,41789,0,1,1,1,1), -- Design: Inscribed Monarch Topaz -(@ICC_TrashGenericBlue,41781,0,1,1,1,1), -- Design: Misty Forest Emerald -(@ICC_TrashGenericBlue,41783,0,1,1,1,1), -- Design: Purified Twilight Opal -(@ICC_TrashGenericBlue,41778,0,1,1,1,1), -- Design: Resolute MOnarch Topaz -(@ICC_TrashGenericBlue,41782,0,1,1,1,1), -- Design: Shining Forest Emerald -(@ICC_TrashGenericBlue,41784,0,1,1,1,1), -- Design: Sovereign Twilight Opal -(@ICC_TrashGenericBlue,41779,0,1,1,1,1), -- Design: Stalwart Monarch Topaz -(@ICC_TrashGenericBlue,41785,0,1,1,1,1), -- Design: Tenuous Twilight Opal -(@ICC_TrashGenericBlue,41787,0,1,1,1,1), -- Design: Thundering Skyflare Diamond --- tailoring -(@ICC_TrashGenericBlue,43876,0,1,1,1,1), -- A Guide to Northern Cloth Scavenging --- purple items icc (7) -(@ICC_TrashGenericPurpleICC,50444,0,1,1,1,1), -- Rowan's Rifle of Silver Bullets -(@ICC_TrashGenericPurpleICC,50451,0,1,1,1,1), -- Belt of the Lonely Noble -(@ICC_TrashGenericPurpleICC,50450,0,1,1,1,1), -- Leggings of Dubious Charms -(@ICC_TrashGenericPurpleICC,50449,0,1,1,1,1), -- Stiffened Corpse Shoulderpads -(@ICC_TrashGenericPurpleICC,50453,0,1,1,1,1), -- Ring of Rotting Sinew -(@ICC_TrashGenericPurpleICC,50447,0,1,1,1,1), -- Harbinger's Bone Band -(@ICC_TrashGenericPurpleICC,50452,0,1,1,1,1), -- Wodin's Lucky Necklace --- Generic World Epics -(@ICC_TrashGenericPurple,44311,0,1,1,1,1), -- Avool's Sword of Jin -(@ICC_TrashGenericPurple,37835,0,1,1,1,1), -- Je'Tze's Bell -(@ICC_TrashGenericPurple,44310,0,1,1,1,1), -- Namlak's Supernumerary Sticker -(@ICC_TrashGenericPurple,44309,0,1,1,1,1), -- Sash of Jordan -(@ICC_TrashGenericPurple,44308,0,1,1,1,1), -- Signet of Edward the Odd -(@ICC_TrashGenericPurple,37254,0,1,1,1,1), -- Super Simian Sphere -(@ICC_TrashGenericPurple,44312,0,1,1,1,1), -- Wapach's Spaulders of Solidarity -(@ICC_TrashGenericPurple,44313,0,1,1,1,1), -- Zom's Crackling Bulwark --- purple items dungeon_N (4) -(@ICC_TrashGenericPurpleDUNN,49852,0,1,1,1,1), -- Coffin Nail -(@ICC_TrashGenericPurpleDUNN,49855,0,1,1,1,1), -- Plated Grips of Korth'azz -(@ICC_TrashGenericPurpleDUNN,49853,0,1,1,1,1), -- Titanium Links of Lore -(@ICC_TrashGenericPurpleDUNN,49854,0,1,1,1,1), -- Mantle of Tattered Feathers --- purple items dungeon_H (3) -(@ICC_TrashGenericPurpleDUNH,50319,0,1,1,1,1), -- Unsharpened Ice Razor -(@ICC_TrashGenericPurpleDUNH,50315,0,1,1,1,1), -- Seven-Fingered Claws -(@ICC_TrashGenericPurpleDUNH,50318,0,1,1,1,1), -- Ghostly Wristwraps --- final output icc -(@ICC_TrashCitadelFinal,1,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) -(@ICC_TrashCitadelFinal,2,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) -(@ICC_TrashCitadelFinal,3,20,1,0,-@ICC_TrashGenericWhite,1), -- 1 white loot (20%) -(@ICC_TrashCitadelFinal,4,7,1,0,-@ICC_TrashGenericScroll,1), -- 1 scroll loot (7%) -(@ICC_TrashCitadelFinal,5,10,1,0,-@ICC_TrashGenericGreen,1), -- 1 green loot (10%) -(@ICC_TrashCitadelFinal,6,3,1,0,-@ICC_TrashGenericBlue,1), -- 1 blue loot (3%) -(@ICC_TrashCitadelFinal,7,2,1,0,-@ICC_TrashGenericPurpleICC,1), -- 1 purple icc loot (2%) -(@ICC_TrashCitadelFinal,8,1,1,0,-@ICC_TrashGenericPurple,1), -- 1 purple world loot (1%) --- final output dungeon_n -(@ICC_TrashDungeonNFinal,1,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) -(@ICC_TrashDungeonNFinal,2,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) -(@ICC_TrashDungeonNFinal,3,20,1,0,-@ICC_TrashGenericWhite,1), -- 1 white loot (20%) -(@ICC_TrashDungeonNFinal,4,7,1,0,-@ICC_TrashGenericScroll,1), -- 1 scroll loot (7%) -(@ICC_TrashDungeonNFinal,5,10,1,0,-@ICC_TrashGenericGreen,1), -- 1 green loot (10%) -(@ICC_TrashDungeonNFinal,6,3,1,0,-@ICC_TrashGenericBlue,1), -- 1 blue loot (3%) -(@ICC_TrashDungeonNFinal,7,2,1,0,-@ICC_TrashGenericPurpleDUNN,1), -- 1 purple dungeon loot (2%) -(@ICC_TrashDungeonNFinal,8,1,1,0,-@ICC_TrashGenericPurple,1), -- 1 purple world loot (1%) --- final output dungeon_h -(@ICC_TrashDungeonHFinal,1,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) -(@ICC_TrashDungeonHFinal,2,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) -(@ICC_TrashDungeonHFinal,3,20,1,0,-@ICC_TrashGenericWhite,1), -- 1 white loot (20%) -(@ICC_TrashDungeonHFinal,4,7,1,0,-@ICC_TrashGenericScroll,1), -- 1 scroll loot (7%) -(@ICC_TrashDungeonHFinal,5,10,1,0,-@ICC_TrashGenericGreen,1), -- 1 green loot (10%) -(@ICC_TrashDungeonHFinal,6,3,1,0,-@ICC_TrashGenericBlue,1), -- 1 blue loot (3%) -(@ICC_TrashDungeonHFinal,7,2,1,0,-@ICC_TrashGenericPurpleDUNH,1), -- 1 purple heroicdungeon loot (1%) -(@ICC_TrashDungeonHFinal,8,1,1,0,-@ICC_TrashGenericPurple,1); -- 1 purple world loot (1%) - - --- -------------------------------- --- -- Apply Trash Loot Dungeon_N -- --- -------------------------------- -SET @LootDUNGEON_N := 100000; -- needs official entry designated -UPDATE `creature_template` SET `lootid`=@LootDUNGEON_N WHERE `entry` IN (36522,36620,36516,36564,36499,36478,36666); -- FoS -UPDATE `creature_template` SET `lootid`=@LootDUNGEON_N WHERE `entry` IN (36896,36842,36830,36879,37711,36788,37712,37713); -- PoS -UPDATE `creature_template` SET `lootid`=@LootDUNGEON_N WHERE `entry` IN (38176,38177,38173,38172,38175,36723); -- HoR -DELETE FROM `creature_loot_template` WHERE `entry` IN (36522,36620,36516,36564,36499,36478,36666,36896,36842,36830,36879,37711,36788,37712,37713,38176,38177,38173,38172,38175,36723,@LootDUNGEON_N); -INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES -(@LootDUNGEON_N,1,100,1,0,-@ICC_TrashDungeonNFinal,2); -- 2 selection from reference - --- -------------------------------- --- -- Apply Trash Loot Dungeon_H -- --- -------------------------------- -SET @LootDUNGEON_H := 100001; -- needs official entry designated -UPDATE `creature_template` SET `lootid`=@LootDUNGEON_H WHERE `entry` IN (37569,37568,37567,37565,38193,37566,37563); -- FoS -UPDATE `creature_template` SET `lootid`=@LootDUNGEON_H WHERE `entry` IN (37609,37638,37637,37635,37636,38249,38025,38026); -- PoS -UPDATE `creature_template` SET `lootid`=@LootDUNGEON_H WHERE `entry` IN (37720,38524,38525,38563,38544,38564); -- HoR -DELETE FROM `creature_loot_template` WHERE `entry` IN (37569,37568,37567,37565,38193,37566,37563,37609,37638,37637,37635,37636,38249,38025,38026,37720,38524,38525,38563,38544,38564,@LootDUNGEON_H); -INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES -(@LootDUNGEON_H,1,100,1,0,-@ICC_TrashDungeonHFinal,2); -- 2 selection from reference - --- -------------------------- --- -- Apply Trash Loot ICC -- --- -------------------------- -SET @LootRAID := 100002; -- needs official entry designated -UPDATE `creature_template` SET `lootid`=@LootRAID WHERE `entry` IN(37012,37022,37571,37664,37595,37662,37665,37663,37666,37007,36811,36807,36829,36805,36808,36880,37546,37531,37229,37228,36725,37501,37502,37023,10404,38494,38490,36724,37126,37544,37545,37098,37038); -DELETE FROM `creature_loot_template` WHERE `entry` IN(37012,37022,37571,37664,37595,37662,37665,37663,37666,37007,36811,36807,36829,36805,36808,36880,37546,37531,37229,37228,36725,37501,37502,37023,10404,38494,38490,36724,37126,37544,37545,37098,37038,@LootRAID); -INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES -(@LootRAID,1,100,1,0,-@ICC_TrashCitadelFinal,2); -- 2 selection from reference - --- -------------------- --- -- Special Cases: -- --- -------------------- --- Specialids -CALL `sp_set_npc_lootid_bylist` ('37217,37025,37230,37532,36891',NULL); --- Loot -DELETE FROM `creature_loot_template` WHERE `entry` IN (37217,37025,37230,37532,36891); -INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES --- Precious -(37217,1,100,1,0,-@ICC_TrashCitadelFinal,2), -- 2 selection from reference -(37217,52019,30,1,0,1,1), -- Precious Ribbon --- Stinky -(37025,1,100,1,0,-@ICC_TrashCitadelFinal,2), -- 2 selection from reference --- Dragons (Spire Frostwyrm) -(37230,1,100,1,0,-@ICC_TrashCitadelFinal,2), -- 2 selection from reference -(37230,33631,65,1,1,2,3), -- Frosted Claw -(37230,33632,35,1,1,2,3), -- Icicle Fang -(37532,33631,65,1,1,2,3), -- Frosted Claw -(37532,33632,35,1,1,2,3), -- Icicle Fang -(36891,33631,65,1,1,2,3), -- Frosted Claw -(36891,33632,35,1,1,2,3); -- Icicle Fang diff --git a/sql/updates/world/2011_03_24_0_world_creature_template.sql b/sql/updates/world/2011_03_24_0_world_creature_template.sql index 4f35a668ea8..d1dd1653f33 100644 --- a/sql/updates/world/2011_03_24_0_world_creature_template.sql +++ b/sql/updates/world/2011_03_24_0_world_creature_template.sql @@ -64,7 +64,6 @@ UPDATE `creature_template` SET `difficulty_entry_1`=0,`difficulty_entry_2`=0,`di UPDATE `creature_template` SET `difficulty_entry_1`=0,`difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=38456; -- Frozen Orb -- Delete all the fake/temp diffentry templates -DELETE FROM `creature_template` WHERE `entry` > 100000 ; +DELETE FROM `creature_template` WHERE `entry` BETWEEN 3460602 AND 3845601 OR `entry` IN (1040402,1040403); DELETE FROM `creature_loot_template` WHERE `entry` IN (3672402,3672403,3672502,3672503,3680502,3680503,3680702,3680703,3680802,3680803,3681102,3681103,3682902,3682903,3688002,3688003,3699802,3699803,3700302,3700303,3700402,3700403,3700702,3700703,3701102,3701103,3701202,3701203,3701602,3701603,3701702,3701703,3702102,3702103,3702202,3702203,3702302,3702303,3702502,3702503,3702702,3702703,3703002,3703003,3703102,3703103,3703202,3703203,3703302,3703303,3703402,3703403,3703502,3703503,3703802,3703803,3709802,3709803,3714402,3714403,3714602,3714603,3714802,3714803,3714902,3714903,3721702,3721703,3723002,3723003,3750102,3750103,3750202,3750203,3754402,3754403,3754502,3754503,3754602,3754603,3757102,3757103,3759502,3759503,3766202,3766203,3766302,3766303,3766402,3766403,3766502,3766503,3766602,3766603); -DELETE FROM `creature_onkill_reputation` WHERE `creature_id`>100000; - +DELETE FROM `creature_onkill_reputation` WHERE `creature_id` BETWEEN 3460602 AND 3845601 OR `creature_id` IN (1040402,1040403); diff --git a/sql/updates/world/2011_03_24_1_world_loot_template.sql b/sql/updates/world/2011_03_24_1_world_loot_template.sql new file mode 100644 index 00000000000..a039b5d1933 --- /dev/null +++ b/sql/updates/world/2011_03_24_1_world_loot_template.sql @@ -0,0 +1,382 @@ +-- Trashloot for ICC/FoS/PoS/HoR +-- Generic +SET @ICC_TrashGenericGrey := 35063; -- Set by TDB (need x) +SET @ICC_TrashGenericWhite := @ICC_TrashGenericGrey+1; +SET @ICC_TrashGenericScroll := @ICC_TrashGenericGrey+2; +SET @ICC_TrashGenericGreen := @ICC_TrashGenericGrey+3; +SET @ICC_TrashGenericBlue := @ICC_TrashGenericGrey+4; +SET @ICC_TrashGenericPurpleICC := @ICC_TrashGenericGrey+5; +SET @ICC_TrashCitadelFinal := @ICC_TrashGenericGrey+6; +SET @ICC_TrashGenericPurpleDUNN := @ICC_TrashGenericGrey+7; +SET @ICC_TrashDungeonNFinal := @ICC_TrashGenericGrey+8; +SET @ICC_TrashGenericPurpleDUNH := @ICC_TrashGenericGrey+9; +SET @ICC_TrashDungeonHFinal := @ICC_TrashGenericGrey+10; +SET @ICC_TrashGenericPurple := @ICC_TrashGenericGrey+11; + +DELETE FROM `reference_loot_template` WHERE `entry` BETWEEN @ICC_TrashGenericGrey AND @ICC_TrashGenericGrey+11; +DELETE FROM `reference_loot_template` WHERE `entry` BETWEEN 35063 AND 35076; -- cleanup OLD loot +INSERT INTO reference_loot_template (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +-- grey items (45) +(@ICC_TrashGenericGrey,33430,0,1,1,1,1), -- Abandoned Greatsword +(@ICC_TrashGenericGrey,33426,0,1,1,1,1), -- Chipped Timber Axe +(@ICC_TrashGenericGrey,33424,0,1,1,1,1), -- Cracked Iron Staff +(@ICC_TrashGenericGrey,33428,0,1,1,1,1), -- Dulled SHiv +(@ICC_TrashGenericGrey,33397,0,1,1,1,1), -- Frigid Mail Armor +(@ICC_TrashGenericGrey,33398,0,1,1,1,1), -- Frigid Mail Belt +(@ICC_TrashGenericGrey,33399,0,1,1,1,1), -- Frigid Mail Boots +(@ICC_TrashGenericGrey,33400,0,1,1,1,1), -- Frigid Mail Bracers +(@ICC_TrashGenericGrey,33433,0,1,1,1,1), -- Frigid Mail Circlet +(@ICC_TrashGenericGrey,33401,0,1,1,1,1), -- Frigid Mail Gloves +(@ICC_TrashGenericGrey,33402,0,1,1,1,1), -- Frigid Mail Pants +(@ICC_TrashGenericGrey,33403,0,1,1,1,1), -- Frigid Mail Shoulderpads +(@ICC_TrashGenericGrey,33427,0,1,1,1,1), -- Frost-Encrusted Rifle +(@ICC_TrashGenericGrey,33365,0,1,1,1,1), -- Frost-Rimed Cloth Belt +(@ICC_TrashGenericGrey,33366,0,1,1,1,1), -- Frost-Rimed Cloth Boots +(@ICC_TrashGenericGrey,33367,0,1,1,1,1), -- Frost-Rimed Cloth Bracers +(@ICC_TrashGenericGrey,33368,0,1,1,1,1), -- Frost-Rimed Cloth Gloves +(@ICC_TrashGenericGrey,33346,0,1,1,1,1), -- Frost-Rimed Cloth Hat +(@ICC_TrashGenericGrey,33369,0,1,1,1,1), -- Frost-Rimed Cloth Pants +(@ICC_TrashGenericGrey,33370,0,1,1,1,1), -- Frost-Rimed Cloth Shoulderpads +(@ICC_TrashGenericGrey,33371,0,1,1,1,1), -- Frost-Rimed Cloth Vest +(@ICC_TrashGenericGrey,33412,0,1,1,1,1), -- Frost-Worn Plate Belt +(@ICC_TrashGenericGrey,33413,0,1,1,1,1), -- Frost-Worn Plate Boots +(@ICC_TrashGenericGrey,33414,0,1,1,1,1), -- Frost-Worn Plate Bracers +(@ICC_TrashGenericGrey,33415,0,1,1,1,1), -- Frost-Worn Plate Chestpiece +(@ICC_TrashGenericGrey,33416,0,1,1,1,1), -- Frost-Worn Plate Gloves +(@ICC_TrashGenericGrey,33435,0,1,1,1,1), -- Frost-Worn Plate Helmet +(@ICC_TrashGenericGrey,33417,0,1,1,1,1), -- Frost-Worn Plate Pants +(@ICC_TrashGenericGrey,33419,0,1,1,1,1), -- Frost-Worn Plate Shoulderpads +(@ICC_TrashGenericGrey,33379,0,1,1,1,1), -- Frozen Armor +(@ICC_TrashGenericGrey,33380,0,1,1,1,1), -- Frozen Belt +(@ICC_TrashGenericGrey,33381,0,1,1,1,1), -- Frozen Boots +(@ICC_TrashGenericGrey,33382,0,1,1,1,1), -- Frozen Bracers +(@ICC_TrashGenericGrey,33383,0,1,1,1,1), -- Frozen Gloves +(@ICC_TrashGenericGrey,33434,0,1,1,1,1), -- Frozen Leather Helmet +(@ICC_TrashGenericGrey,33384,0,1,1,1,1), -- Frozen Pants +(@ICC_TrashGenericGrey,33385,0,1,1,1,1), -- Frozen Shoulderpads +(@ICC_TrashGenericGrey,33429,0,1,1,1,1), -- Ice Cleaver +(@ICC_TrashGenericGrey,33425,0,1,1,1,1), -- Ice-Pitted Blade +(@ICC_TrashGenericGrey,33431,0,1,1,1,1), -- Icesmashing Mace +(@ICC_TrashGenericGrey,33423,0,1,1,1,1), -- Rime-Covered Mace +(@ICC_TrashGenericGrey,33422,0,1,1,1,1), -- Shattered Bow +(@ICC_TrashGenericGrey,43852,70,1,1,1,1), -- Thick Fur Clothing Scraps (drops more often) +-- white items +(@ICC_TrashGenericWhite,33470,0,1,1,2,7), -- Frostweave Cloth +(@ICC_TrashGenericWhite,33445,0,1,1,1,1), -- Honeymint Tea +(@ICC_TrashGenericWhite,33454,0,1,1,1,1), -- Salted Venison +(@ICC_TrashGenericWhite,35947,0,1,1,1,1), -- Sparkling Frostcap +(@ICC_TrashGenericWhite,33447,0,1,1,1,1), -- Runic Healing Potion +(@ICC_TrashGenericWhite,33448,0,1,1,1,1), -- Runic Mana Potion +-- Scroll items +(@ICC_TrashGenericScroll,43463,0,1,1,1,1), -- Scroll of Agility VII +(@ICC_TrashGenericScroll,37091,0,1,1,1,1), -- Scroll of Intellect VII +(@ICC_TrashGenericScroll,37093,0,1,1,1,1), -- Scroll of Stamina VII +(@ICC_TrashGenericScroll,43465,0,1,1,1,1), -- Scroll of Strength VII +(@ICC_TrashGenericScroll,37097,0,1,1,1,1), -- Scroll of Spirit VII +(@ICC_TrashGenericScroll,43464,0,1,1,1,1), -- Scroll of Agility VIII +(@ICC_TrashGenericScroll,37092,0,1,1,1,1), -- Scroll of Intellect VIII +(@ICC_TrashGenericScroll,37094,0,1,1,1,1), -- Scroll of Stamina VIII +(@ICC_TrashGenericScroll,43466,0,1,1,1,1), -- Scroll of Strength VIII +(@ICC_TrashGenericScroll,37098,0,1,1,1,1), -- Scroll of Spirit VIII +-- green items (166) +(@ICC_TrashGenericGreen,36609,0,1,1,1,1), -- Abandoned Spear +(@ICC_TrashGenericGreen,36497,0,1,1,1,1), -- Adamant Mallet +(@ICC_TrashGenericGreen,36511,0,1,1,1,1), -- Artic War Hammer +(@ICC_TrashGenericGreen,36694,0,1,1,1,1), -- Beatific Mace +(@ICC_TrashGenericGreen,36527,0,1,1,1,1), -- Blackened Blade +(@ICC_TrashGenericGreen,36611,0,1,1,1,1), -- Black Scythe +(@ICC_TrashGenericGreen,36638,0,1,1,1,1), -- Bloody Crossbow +(@ICC_TrashGenericGreen,36428,0,1,1,1,1), -- Bouquet Ring +(@ICC_TrashGenericGreen,36639,0,1,1,1,1), -- Brutal Ballista +(@ICC_TrashGenericGreen,36707,0,1,1,1,1), -- Cascading Water Staff +(@ICC_TrashGenericGreen,36539,0,1,1,1,1), -- Chilled Warblade +(@ICC_TrashGenericGreen,36723,0,1,1,1,1), -- Clawed Shuriken +(@ICC_TrashGenericGreen,36035,0,1,1,1,1), -- Condor Belt +(@ICC_TrashGenericGreen,36042,0,1,1,1,1), -- Condor Bindings +(@ICC_TrashGenericGreen,36038,0,1,1,1,1), -- Condor Gloves +(@ICC_TrashGenericGreen,36039,0,1,1,1,1), -- Condor Headpiece +(@ICC_TrashGenericGreen,36040,0,1,1,1,1), -- Condor Pants +(@ICC_TrashGenericGreen,36037,0,1,1,1,1), -- Condor Robe +(@ICC_TrashGenericGreen,36036,0,1,1,1,1), -- Condor Sandals +(@ICC_TrashGenericGreen,36041,0,1,1,1,1), -- Condor Shoulderpads +(@ICC_TrashGenericGreen,36266,0,1,1,1,1), -- Cormorant Bracelets +(@ICC_TrashGenericGreen,36261,0,1,1,1,1), -- Cormorant Chain Vest +(@ICC_TrashGenericGreen,36260,0,1,1,1,1), -- Cormorant Footwraps +(@ICC_TrashGenericGreen,36262,0,1,1,1,1), -- Cormorant Gloves +(@ICC_TrashGenericGreen,36263,0,1,1,1,1), -- Cormorant Helm +(@ICC_TrashGenericGreen,36264,0,1,1,1,1), -- Cormorant Leggings +(@ICC_TrashGenericGreen,36265,0,1,1,1,1), -- Cormorant Mantle +(@ICC_TrashGenericGreen,36259,0,1,1,1,1), -- Cormorant Waistband +(@ICC_TrashGenericGreen,36525,0,1,1,1,1), -- Craggy Machete +(@ICC_TrashGenericGreen,36709,0,1,1,1,1), -- Crystal Woodstaff +(@ICC_TrashGenericGreen,36050,0,1,1,1,1), -- Crystalsong Bracelets +(@ICC_TrashGenericGreen,36047,0,1,1,1,1), -- Crystalsong Crown +(@ICC_TrashGenericGreen,36046,0,1,1,1,1), -- Crystalsong Gloves +(@ICC_TrashGenericGreen,36048,0,1,1,1,1), -- Crystalsong Leggings +(@ICC_TrashGenericGreen,36049,0,1,1,1,1), -- Crystalsong Mantle +(@ICC_TrashGenericGreen,36045,0,1,1,1,1), -- Crystalsong Robe +(@ICC_TrashGenericGreen,36043,0,1,1,1,1), -- Crystalsong Sash +(@ICC_TrashGenericGreen,36044,0,1,1,1,1), -- Crystalsong Slippers +(@ICC_TrashGenericGreen,36554,0,1,1,1,1), -- Cursed Staff +(@ICC_TrashGenericGreen,43297,0,1,1,1,1), -- Damaged Necklace +(@ICC_TrashGenericGreen,36553,0,1,1,1,1), -- Desecrated Staff +(@ICC_TrashGenericGreen,36695,0,1,1,1,1), -- Dogmatic Scepter +(@ICC_TrashGenericGreen,36721,0,1,1,1,1), -- Dragon's Teeth +(@ICC_TrashGenericGreen,36413,0,1,1,1,1), -- Dyed Taffeta Cape +(@ICC_TrashGenericGreen,36427,0,1,1,1,1), -- Engraved Ring +(@ICC_TrashGenericGreen,36484,0,1,1,1,1), -- Etched Dagger +(@ICC_TrashGenericGreen,36499,0,1,1,1,1), -- Frigid War-Mace +(@ICC_TrashGenericGreen,36470,0,1,1,1,1), -- Gilded Scepter +(@ICC_TrashGenericGreen,36381,0,1,1,1,1), -- Golem Breastplate +(@ICC_TrashGenericGreen,36382,0,1,1,1,1), -- Golem Gauntlets +(@ICC_TrashGenericGreen,36379,0,1,1,1,1), -- Golem Girdle +(@ICC_TrashGenericGreen,36383,0,1,1,1,1), -- Golem Helmet +(@ICC_TrashGenericGreen,36384,0,1,1,1,1), -- Golem Legplates +(@ICC_TrashGenericGreen,36385,0,1,1,1,1), -- Golem Pauldrons +(@ICC_TrashGenericGreen,36380,0,1,1,1,1), -- Golem Sabatons +(@ICC_TrashGenericGreen,36386,0,1,1,1,1), -- Golem Vambraces +(@ICC_TrashGenericGreen,36623,0,1,1,1,1), -- Harnessed Longbow +(@ICC_TrashGenericGreen,36568,0,1,1,1,1), -- Hollowed Bone Knuckles +(@ICC_TrashGenericGreen,36637,0,1,1,1,1), -- Horrific Crossbow +(@ICC_TrashGenericGreen,36471,0,1,1,1,1), -- Ice Crystal +(@ICC_TrashGenericGreen,36582,0,1,1,1,1), -- Ice Pick +(@ICC_TrashGenericGreen,36597,0,1,1,1,1), -- Ice-Splintering Axe +(@ICC_TrashGenericGreen,36456,0,1,1,1,1), -- Ice Kite Shield +(@ICC_TrashGenericGreen,36457,0,1,1,1,1), -- Ivory Shield +(@ICC_TrashGenericGreen,36373,0,1,1,1,1), -- Kraken Breastplate +(@ICC_TrashGenericGreen,36377,0,1,1,1,1), -- Kraken Epaulets +(@ICC_TrashGenericGreen,36374,0,1,1,1,1), -- Kraken Gauntlets +(@ICC_TrashGenericGreen,36371,0,1,1,1,1), -- Kraken Girdle +(@ICC_TrashGenericGreen,36372,0,1,1,1,1), -- Kraken Greaves +(@ICC_TrashGenericGreen,36375,0,1,1,1,1), -- Kraken Helm +(@ICC_TrashGenericGreen,36376,0,1,1,1,1), -- Kraken Legplates +(@ICC_TrashGenericGreen,36378,0,1,1,1,1), -- Kraken Vambraces +(@ICC_TrashGenericGreen,36469,0,1,1,1,1), -- Lidless Orb +(@ICC_TrashGenericGreen,36513,0,1,1,1,1), -- Lode-Headed Hammer +(@ICC_TrashGenericGreen,36414,0,1,1,1,1), -- Mammoth Fur Cloack +(@ICC_TrashGenericGreen,36483,0,1,1,1,1), -- Mandible Edge +(@ICC_TrashGenericGreen,36625,0,1,1,1,1), -- Massive Recurved Bow +(@ICC_TrashGenericGreen,36555,0,1,1,1,1), -- Minion Staff +(@ICC_TrashGenericGreen,36651,0,1,1,1,1), -- Muzzled Musket +(@ICC_TrashGenericGreen,36680,0,1,1,1,1), -- Mystic Fang +(@ICC_TrashGenericGreen,36498,0,1,1,1,1), -- Nerubian Mace +(@ICC_TrashGenericGreen,36512,0,1,1,1,1), -- Onerous Mallet +(@ICC_TrashGenericGreen,36441,0,1,1,1,1), -- Pearl Woven Choker +(@ICC_TrashGenericGreen,36540,0,1,1,1,1), -- Petrified Sword +(@ICC_TrashGenericGreen,36610,0,1,1,1,1), -- Plagued Pike +(@ICC_TrashGenericGreen,36595,0,1,1,1,1), -- Planate Broadaxe +(@ICC_TrashGenericGreen,36455,0,1,1,1,1), -- Plated Bulwark +(@ICC_TrashGenericGreen,36443,0,1,1,1,1), -- Platinum Medallion +(@ICC_TrashGenericGreen,36666,0,1,1,1,1), -- Polar Wand +(@ICC_TrashGenericGreen,36653,0,1,1,1,1), -- Precipice Longrifle +(@ICC_TrashGenericGreen,36147,0,1,1,1,1), -- Pygmy Belt +(@ICC_TrashGenericGreen,36154,0,1,1,1,1), -- Pygmy Bindings +(@ICC_TrashGenericGreen,36148,0,1,1,1,1), -- Pygmy Boots +(@ICC_TrashGenericGreen,36150,0,1,1,1,1), -- Pygmy Gloves +(@ICC_TrashGenericGreen,36151,0,1,1,1,1), -- Pygmy Helmet +(@ICC_TrashGenericGreen,36152,0,1,1,1,1), -- Pygmy Pants +(@ICC_TrashGenericGreen,36153,0,1,1,1,1), -- Pygmy Shoulders +(@ICC_TrashGenericGreen,36149,0,1,1,1,1), -- Pygmy Tunic +(@ICC_TrashGenericGreen,36722,0,1,1,1,1), -- Pyramid Throwing Star +(@ICC_TrashGenericGreen,36389,0,1,1,1,1), -- Revenant Armor +(@ICC_TrashGenericGreen,36387,0,1,1,1,1), -- Revenant Belt +(@ICC_TrashGenericGreen,36394,0,1,1,1,1), -- Revenant Bracers +(@ICC_TrashGenericGreen,36393,0,1,1,1,1), -- Revenant Epaulets +(@ICC_TrashGenericGreen,36390,0,1,1,1,1), -- Revenant Gauntlets +(@ICC_TrashGenericGreen,36388,0,1,1,1,1), -- Revenant Greaves +(@ICC_TrashGenericGreen,36391,0,1,1,1,1), -- Revenant Helmet +(@ICC_TrashGenericGreen,36392,0,1,1,1,1), -- Revenant Legguards +(@ICC_TrashGenericGreen,36596,0,1,1,1,1), -- Rupturing Axe +(@ICC_TrashGenericGreen,36569,0,1,1,1,1), -- Savage Talons +(@ICC_TrashGenericGreen,36693,0,1,1,1,1), -- Serene Hammer +(@ICC_TrashGenericGreen,36624,0,1,1,1,1), -- Shrieking Bow +(@ICC_TrashGenericGreen,36442,0,1,1,1,1), -- Silken Cord Amulet +(@ICC_TrashGenericGreen,36679,0,1,1,1,1), -- Singing Dagger +(@ICC_TrashGenericGreen,36485,0,1,1,1,1), -- Sinuous Keris +(@ICC_TrashGenericGreen,36567,0,1,1,1,1), -- Six-Fingered Claws +(@ICC_TrashGenericGreen,36583,0,1,1,1,1), -- Skeletal Hacker +(@ICC_TrashGenericGreen,36526,0,1,1,1,1), -- SLeeted Longsword +(@ICC_TrashGenericGreen,36708,0,1,1,1,1), -- Snow Blossom Staff +(@ICC_TrashGenericGreen,36667,0,1,1,1,1), -- Solid Ice Wand +(@ICC_TrashGenericGreen,36275,0,1,1,1,1), -- Spiderlord Belt +(@ICC_TrashGenericGreen,36276,0,1,1,1,1), -- Spiderlord Boots +(@ICC_TrashGenericGreen,36282,0,1,1,1,1), -- Spiderlord Bracers +(@ICC_TrashGenericGreen,36277,0,1,1,1,1), -- Spiderlord Chestpiece +(@ICC_TrashGenericGreen,36278,0,1,1,1,1), -- Spiderlord Gauntlets +(@ICC_TrashGenericGreen,36279,0,1,1,1,1), -- Spiderlord Helm +(@ICC_TrashGenericGreen,36280,0,1,1,1,1), -- Spiderlord Legguards +(@ICC_TrashGenericGreen,36281,0,1,1,1,1), -- Spiderlord Spaulders +(@ICC_TrashGenericGreen,36429,0,1,1,1,1), -- Spur Ring +(@ICC_TrashGenericGreen,36652,0,1,1,1,1), -- Stocky Shotgun +(@ICC_TrashGenericGreen,36274,0,1,1,1,1), -- Ulduar Bracers +(@ICC_TrashGenericGreen,36269,0,1,1,1,1), -- Ulduar Breastplate +(@ICC_TrashGenericGreen,36270,0,1,1,1,1), -- Ulduar Gauntlets +(@ICC_TrashGenericGreen,36267,0,1,1,1,1), -- Ulduar Girdle +(@ICC_TrashGenericGreen,36268,0,1,1,1,1), -- Ulduar Greaves +(@ICC_TrashGenericGreen,36271,0,1,1,1,1), -- Ulduar Helm +(@ICC_TrashGenericGreen,36272,0,1,1,1,1), -- Ulduar Legguards +(@ICC_TrashGenericGreen,36273,0,1,1,1,1), -- Ulduar Shoulderguards +(@ICC_TrashGenericGreen,36415,0,1,1,1,1), -- Vintage Satin Cloak +(@ICC_TrashGenericGreen,36058,0,1,1,1,1), -- Vizier Bracelets +(@ICC_TrashGenericGreen,36054,0,1,1,1,1), -- Vizier Gloves +(@ICC_TrashGenericGreen,36055,0,1,1,1,1), -- Vizier Hood +(@ICC_TrashGenericGreen,36056,0,1,1,1,1), -- Vizier Leggings +(@ICC_TrashGenericGreen,36057,0,1,1,1,1), -- Vizier Mantle +(@ICC_TrashGenericGreen,36053,0,1,1,1,1), -- Vizier Robe +(@ICC_TrashGenericGreen,36051,0,1,1,1,1), -- Vizier Sash +(@ICC_TrashGenericGreen,36052,0,1,1,1,1), -- Vizier SLippers +(@ICC_TrashGenericGreen,36665,0,1,1,1,1), -- Wasteland Wand +(@ICC_TrashGenericGreen,36170,0,1,1,1,1), -- Webspinner Bindings +(@ICC_TrashGenericGreen,36164,0,1,1,1,1), -- Webspinner Boots +(@ICC_TrashGenericGreen,36163,0,1,1,1,1), -- Webspinner Cord +(@ICC_TrashGenericGreen,36166,0,1,1,1,1), -- Webspinner Gloves +(@ICC_TrashGenericGreen,36167,0,1,1,1,1), -- Webspinner Hood +(@ICC_TrashGenericGreen,36168,0,1,1,1,1), -- Webspinner Leggings +(@ICC_TrashGenericGreen,36169,0,1,1,1,1), -- Webspinner Shoulderguards +(@ICC_TrashGenericGreen,36165,0,1,1,1,1), -- Webspinner Vest +(@ICC_TrashGenericGreen,36162,0,1,1,1,1), -- Wendigo Bands +(@ICC_TrashGenericGreen,36156,0,1,1,1,1), -- Wendigo Boots +(@ICC_TrashGenericGreen,36157,0,1,1,1,1), -- Wendigo Chestpiece +(@ICC_TrashGenericGreen,36155,0,1,1,1,1), -- Wendigo Girdle +(@ICC_TrashGenericGreen,36158,0,1,1,1,1), -- Wendigo Gloves +(@ICC_TrashGenericGreen,36159,0,1,1,1,1), -- Wendigo Hood +(@ICC_TrashGenericGreen,36160,0,1,1,1,1), -- Wendigo Legguards +(@ICC_TrashGenericGreen,36161,0,1,1,1,1), -- Wendigo Pauldrons +(@ICC_TrashGenericGreen,36541,0,1,1,1,1), -- Wintry Claymore +(@ICC_TrashGenericGreen,36681,0,1,1,1,1), -- Wisdom Carver +(@ICC_TrashGenericGreen,36581,0,1,1,1,1), -- Wolvar Handaxe +-- blue items +(@ICC_TrashGenericBlue,37792,0,1,1,1,1), -- Agin's Crushing Carapace +(@ICC_TrashGenericBlue,37770,0,1,1,1,1), -- Bulge-Concealing Breastplate +(@ICC_TrashGenericBlue,37780,0,1,1,1,1), -- Condor-Bone Chestguard +(@ICC_TrashGenericBlue,37760,0,1,1,1,1), -- Cracklefire Wristguards +(@ICC_TrashGenericBlue,37781,0,1,1,1,1), -- Grips of the Warming Heart +(@ICC_TrashGenericBlue,37824,0,1,1,1,1), -- Gwyneth's Runed Dragonwand +(@ICC_TrashGenericBlue,37761,0,1,1,1,1), -- Shimmerthread Girdle +(@ICC_TrashGenericBlue,37793,0,1,1,1,1), -- Skullcage of Eternal Terror +(@ICC_TrashGenericBlue,37794,0,1,1,1,1), -- Torta's Oversized Choker +(@ICC_TrashGenericBlue,37822,0,1,1,1,1), -- Twisted Puzzle-Ring +(@ICC_TrashGenericBlue,37771,0,1,1,1,1), -- Wristguard of Verdant Recovery +-- Designs +(@ICC_TrashGenericBlue,41788,0,1,1,1,1), -- Design: Beaming Earthsiege Diamond +(@ICC_TrashGenericBlue,41780,0,1,1,1,1), -- Design: Champion's Monarch Topaz +(@ICC_TrashGenericBlue,41786,0,1,1,1,1), -- Design: Destructive Skyflare Diamond +(@ICC_TrashGenericBlue,41777,0,1,1,1,1), -- Design: Etched Monarch Topaz +(@ICC_TrashGenericBlue,41789,0,1,1,1,1), -- Design: Inscribed Monarch Topaz +(@ICC_TrashGenericBlue,41781,0,1,1,1,1), -- Design: Misty Forest Emerald +(@ICC_TrashGenericBlue,41783,0,1,1,1,1), -- Design: Purified Twilight Opal +(@ICC_TrashGenericBlue,41778,0,1,1,1,1), -- Design: Resolute MOnarch Topaz +(@ICC_TrashGenericBlue,41782,0,1,1,1,1), -- Design: Shining Forest Emerald +(@ICC_TrashGenericBlue,41784,0,1,1,1,1), -- Design: Sovereign Twilight Opal +(@ICC_TrashGenericBlue,41779,0,1,1,1,1), -- Design: Stalwart Monarch Topaz +(@ICC_TrashGenericBlue,41785,0,1,1,1,1), -- Design: Tenuous Twilight Opal +(@ICC_TrashGenericBlue,41787,0,1,1,1,1), -- Design: Thundering Skyflare Diamond +-- tailoring +(@ICC_TrashGenericBlue,43876,0,1,1,1,1), -- A Guide to Northern Cloth Scavenging +-- purple items icc (7) +(@ICC_TrashGenericPurpleICC,50444,0,1,1,1,1), -- Rowan's Rifle of Silver Bullets +(@ICC_TrashGenericPurpleICC,50451,0,1,1,1,1), -- Belt of the Lonely Noble +(@ICC_TrashGenericPurpleICC,50450,0,1,1,1,1), -- Leggings of Dubious Charms +(@ICC_TrashGenericPurpleICC,50449,0,1,1,1,1), -- Stiffened Corpse Shoulderpads +(@ICC_TrashGenericPurpleICC,50453,0,1,1,1,1), -- Ring of Rotting Sinew +(@ICC_TrashGenericPurpleICC,50447,0,1,1,1,1), -- Harbinger's Bone Band +(@ICC_TrashGenericPurpleICC,50452,0,1,1,1,1), -- Wodin's Lucky Necklace +-- Generic World Epics +(@ICC_TrashGenericPurple,44311,0,1,1,1,1), -- Avool's Sword of Jin +(@ICC_TrashGenericPurple,37835,0,1,1,1,1), -- Je'Tze's Bell +(@ICC_TrashGenericPurple,44310,0,1,1,1,1), -- Namlak's Supernumerary Sticker +(@ICC_TrashGenericPurple,44309,0,1,1,1,1), -- Sash of Jordan +(@ICC_TrashGenericPurple,44308,0,1,1,1,1), -- Signet of Edward the Odd +(@ICC_TrashGenericPurple,37254,0,1,1,1,1), -- Super Simian Sphere +(@ICC_TrashGenericPurple,44312,0,1,1,1,1), -- Wapach's Spaulders of Solidarity +(@ICC_TrashGenericPurple,44313,0,1,1,1,1), -- Zom's Crackling Bulwark +-- purple items dungeon_N (4) +(@ICC_TrashGenericPurpleDUNN,49852,0,1,1,1,1), -- Coffin Nail +(@ICC_TrashGenericPurpleDUNN,49855,0,1,1,1,1), -- Plated Grips of Korth'azz +(@ICC_TrashGenericPurpleDUNN,49853,0,1,1,1,1), -- Titanium Links of Lore +(@ICC_TrashGenericPurpleDUNN,49854,0,1,1,1,1), -- Mantle of Tattered Feathers +-- purple items dungeon_H (3) +(@ICC_TrashGenericPurpleDUNH,50319,0,1,1,1,1), -- Unsharpened Ice Razor +(@ICC_TrashGenericPurpleDUNH,50315,0,1,1,1,1), -- Seven-Fingered Claws +(@ICC_TrashGenericPurpleDUNH,50318,0,1,1,1,1), -- Ghostly Wristwraps +-- final output icc +(@ICC_TrashCitadelFinal,1,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) +(@ICC_TrashCitadelFinal,2,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) +(@ICC_TrashCitadelFinal,3,20,1,0,-@ICC_TrashGenericWhite,1), -- 1 white loot (20%) +(@ICC_TrashCitadelFinal,4,7,1,0,-@ICC_TrashGenericScroll,1), -- 1 scroll loot (7%) +(@ICC_TrashCitadelFinal,5,10,1,0,-@ICC_TrashGenericGreen,1), -- 1 green loot (10%) +(@ICC_TrashCitadelFinal,6,3,1,0,-@ICC_TrashGenericBlue,1), -- 1 blue loot (3%) +(@ICC_TrashCitadelFinal,7,2,1,0,-@ICC_TrashGenericPurpleICC,1), -- 1 purple icc loot (2%) +(@ICC_TrashCitadelFinal,8,1,1,0,-@ICC_TrashGenericPurple,1), -- 1 purple world loot (1%) +-- final output dungeon_n +(@ICC_TrashDungeonNFinal,1,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) +(@ICC_TrashDungeonNFinal,2,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) +(@ICC_TrashDungeonNFinal,3,20,1,0,-@ICC_TrashGenericWhite,1), -- 1 white loot (20%) +(@ICC_TrashDungeonNFinal,4,7,1,0,-@ICC_TrashGenericScroll,1), -- 1 scroll loot (7%) +(@ICC_TrashDungeonNFinal,5,10,1,0,-@ICC_TrashGenericGreen,1), -- 1 green loot (10%) +(@ICC_TrashDungeonNFinal,6,3,1,0,-@ICC_TrashGenericBlue,1), -- 1 blue loot (3%) +(@ICC_TrashDungeonNFinal,7,2,1,0,-@ICC_TrashGenericPurpleDUNN,1), -- 1 purple dungeon loot (2%) +(@ICC_TrashDungeonNFinal,8,1,1,0,-@ICC_TrashGenericPurple,1), -- 1 purple world loot (1%) +-- final output dungeon_h +(@ICC_TrashDungeonHFinal,1,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) +(@ICC_TrashDungeonHFinal,2,40,1,0,-@ICC_TrashGenericGrey,1), -- 1 grey loot (40%) +(@ICC_TrashDungeonHFinal,3,20,1,0,-@ICC_TrashGenericWhite,1), -- 1 white loot (20%) +(@ICC_TrashDungeonHFinal,4,7,1,0,-@ICC_TrashGenericScroll,1), -- 1 scroll loot (7%) +(@ICC_TrashDungeonHFinal,5,10,1,0,-@ICC_TrashGenericGreen,1), -- 1 green loot (10%) +(@ICC_TrashDungeonHFinal,6,3,1,0,-@ICC_TrashGenericBlue,1), -- 1 blue loot (3%) +(@ICC_TrashDungeonHFinal,7,2,1,0,-@ICC_TrashGenericPurpleDUNH,1), -- 1 purple heroicdungeon loot (1%) +(@ICC_TrashDungeonHFinal,8,1,1,0,-@ICC_TrashGenericPurple,1); -- 1 purple world loot (1%) + + +-- -------------------------------- +-- -- Apply Trash Loot Dungeon_N -- +-- -------------------------------- +SET @LootDUNGEON_N := 100000; -- needs official entry designated +UPDATE `creature_template` SET `lootid`=@LootDUNGEON_N WHERE `entry` IN (36522,36620,36516,36564,36499,36478,36666); -- FoS +UPDATE `creature_template` SET `lootid`=@LootDUNGEON_N WHERE `entry` IN (36896,36842,36830,36879,37711,36788,37712,37713); -- PoS +UPDATE `creature_template` SET `lootid`=@LootDUNGEON_N WHERE `entry` IN (38176,38177,38173,38172,38175,36723); -- HoR +DELETE FROM `creature_loot_template` WHERE `entry` IN (36522,36620,36516,36564,36499,36478,36666,36896,36842,36830,36879,37711,36788,37712,37713,38176,38177,38173,38172,38175,36723,@LootDUNGEON_N); +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@LootDUNGEON_N,1,100,1,0,-@ICC_TrashDungeonNFinal,2); -- 2 selection from reference + +-- -------------------------------- +-- -- Apply Trash Loot Dungeon_H -- +-- -------------------------------- +SET @LootDUNGEON_H := 100001; -- needs official entry designated +UPDATE `creature_template` SET `lootid`=@LootDUNGEON_H WHERE `entry` IN (37569,37568,37567,37565,38193,37566,37563); -- FoS +UPDATE `creature_template` SET `lootid`=@LootDUNGEON_H WHERE `entry` IN (37609,37638,37637,37635,37636,38249,38025,38026); -- PoS +UPDATE `creature_template` SET `lootid`=@LootDUNGEON_H WHERE `entry` IN (37720,38524,38525,38563,38544,38564); -- HoR +DELETE FROM `creature_loot_template` WHERE `entry` IN (37569,37568,37567,37565,38193,37566,37563,37609,37638,37637,37635,37636,38249,38025,38026,37720,38524,38525,38563,38544,38564,@LootDUNGEON_H); +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@LootDUNGEON_H,1,100,1,0,-@ICC_TrashDungeonHFinal,2); -- 2 selection from reference + +-- -------------------------- +-- -- Apply Trash Loot ICC -- +-- -------------------------- +SET @LootRAID := 100002; -- needs official entry designated +UPDATE `creature_template` SET `lootid`=@LootRAID WHERE `entry` IN(37012,37022,37571,37664,37595,37662,37665,37663,37666,37007,36811,36807,36829,36805,36808,36880,37546,37531,37229,37228,36725,37501,37502,37023,10404,38494,38490,36724,37126,37544,37545,37098,37038); +DELETE FROM `creature_loot_template` WHERE `entry` IN(37012,37022,37571,37664,37595,37662,37665,37663,37666,37007,36811,36807,36829,36805,36808,36880,37546,37531,37229,37228,36725,37501,37502,37023,10404,38494,38490,36724,37126,37544,37545,37098,37038,@LootRAID); +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@LootRAID,1,100,1,0,-@ICC_TrashCitadelFinal,2); -- 2 selection from reference + +-- -------------------- +-- -- Special Cases: -- +-- -------------------- +-- Specialids +CALL `sp_set_npc_lootid_bylist` ('37217,37025,37230,37532,36891',NULL); +-- Loot +DELETE FROM `creature_loot_template` WHERE `entry` IN (37217,37025,37230,37532,36891); +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +-- Precious +(37217,1,100,1,0,-@ICC_TrashCitadelFinal,2), -- 2 selection from reference +(37217,52019,30,1,0,1,1), -- Precious Ribbon +-- Stinky +(37025,1,100,1,0,-@ICC_TrashCitadelFinal,2), -- 2 selection from reference +-- Dragons (Spire Frostwyrm) +(37230,1,100,1,0,-@ICC_TrashCitadelFinal,2), -- 2 selection from reference +(37230,33631,65,1,1,2,3), -- Frosted Claw +(37230,33632,35,1,1,2,3), -- Icicle Fang +(37532,33631,65,1,1,2,3), -- Frosted Claw +(37532,33632,35,1,1,2,3), -- Icicle Fang +(36891,33631,65,1,1,2,3), -- Frosted Claw +(36891,33632,35,1,1,2,3); -- Icicle Fang -- cgit v1.2.3