diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_08_02_world.sql | 263 |
1 files changed, 263 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_08_02_world.sql b/sql/updates/world/3.3.5/2020_05_08_02_world.sql new file mode 100644 index 00000000000..1fbaa9a2de8 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_05_08_02_world.sql @@ -0,0 +1,263 @@ +-- +-- Storm Fury & Ashtongue Feral Spirit shouldn't have loot table +DELETE FROM `creature_loot_template` WHERE `Entry` IN (22848,22849); +UPDATE `creature_template` SET `lootid` = 0 WHERE `Entry` IN (22848,22849); + +-- Aqueous Spawn shouldn't drop epic items +DELETE FROM `creature_loot_template` WHERE `Entry` = 22883 AND `Reference` = 14099; + +-- Epic Items (with Aqueous Surger (22881), 22963 may have lower chance to drop them) +-- Already used but lacks of content +SET @ENTRY := 14099; +DELETE FROM `reference_loot_template` WHERE `Entry` = @ENTRY AND `Item` IN (32526,32589,32590,32591,32592,32609); +INSERT INTO `reference_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES +(@ENTRY,32526,0,0,0,1,1,1,1), +(@ENTRY,32589,0,0,0,1,1,1,1), +(@ENTRY,32590,0,0,0,1,1,1,1), +(@ENTRY,32591,0,0,0,1,1,1,1), +(@ENTRY,32592,0,0,0,1,1,1,1), +(@ENTRY,32609,0,0,0,1,1,1,1); + +DELETE FROM `creature_loot_template` WHERE `Entry` IN (22844,22845,22846,22847,22853,22855,22869,22873,22874,22875,22876,22877,22878,22879,22880,22881,22882,22884,22885,22939,22945,22946,22953,22954,22955,22956,22957,22959,22960,22962,22963,22964,22965,23018,23028,23030,23047,23049,23147,23172,23196,23222,23223,23232,23235,23236,23237,23239,23330,23337,23339,23374,23394,23397,23400,23402,23403) AND ((`Item` IN (32526,32527,32528,32589,32590,32591,32592,32593,32606,32608,32609,32943,34011,34012) AND `Reference` = 0) OR `Reference` = @ENTRY); +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(22844,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22845,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22846,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22847,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22853,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22855,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22869,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22873,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22874,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22875,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22876,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22877,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22878,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22879,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22880,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22881,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22882,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22884,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22885,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22939,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22945,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22946,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22953,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22954,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22955,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22956,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22957,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22959,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22960,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22962,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22963,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22964,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(22965,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23018,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23028,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23030,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23047,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23049,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23147,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23172,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23196,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23222,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23223,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23232,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23235,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23236,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23237,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23239,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23330,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23337,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23339,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23374,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23394,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23397,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23400,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23402,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"), +(23403,@ENTRY,@ENTRY,2,0,1,0,1,1,"Epic Items (Black Temple)"); + +-- Cards and books (without Aqueous Surger (22881)) +DELETE FROM `creature_loot_template` WHERE `Entry` IN (22844,22845,22846,22847,22853,22855,22869,22873,22874,22875,22876,22877,22878,22879,22880,22882,22884,22885,22939,22945,22946,22953,22954,22955,22956,22957,22959,22960,22962,22963,22964,22965,23018,23028,23030,23047,23049,23147,23172,23196,23222,23223,23232,23235,23236,23237,23239,23330,23337,23339,23374,23394,23397,23400,23402,23403) AND ((`Item` IN (31883,31884,31886,31887,31893,31894,31896,31898,31902,31903,31905,31906,31911,31912,31915,31916,22146,22153,29549,29550,31501,31837) AND `Reference` = 0) OR `Reference` IN (34118,34119)); +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(22844,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22845,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22846,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22847,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22853,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22855,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22869,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22873,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22874,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22875,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22876,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22877,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22878,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22879,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22880,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22882,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22884,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22885,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22939,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22945,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22946,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22953,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22954,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22955,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22956,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22957,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22959,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22960,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22962,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22963,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22964,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22965,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23018,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23028,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23030,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23047,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23049,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23147,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23172,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23196,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23222,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23223,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23232,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23235,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23236,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23237,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23239,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23330,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23337,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23339,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23374,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23394,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23397,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23400,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23402,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(23403,34118,34118,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"), +(22844,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22845,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22846,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22847,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22853,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22855,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22869,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22873,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22874,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22875,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22876,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22877,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22878,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22879,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22880,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22882,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22884,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22885,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22939,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22945,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22946,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22953,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22954,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22955,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22956,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22957,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22959,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22960,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22962,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22963,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22964,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(22965,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23018,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23028,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23030,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23047,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23049,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23147,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23172,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23196,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23222,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23223,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23232,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23235,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23236,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23237,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23239,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23330,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23337,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23339,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23374,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23394,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23397,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23400,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23402,34119,34119,0.5,0,1,0,1,1,"Books Level 70"), +(23403,34119,34119,0.5,0,1,0,1,1,"Books Level 70"); + +-- Aqueous Spawn special case +DELETE FROM `creature_loot_template` WHERE `Entry` = 22883 AND ((`Item` IN (22146,22153,29549,29550,31501,31837) AND `Reference` = 0) OR `Reference` = 34119); +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(22883,34119,34119,0.5,0,1,0,1,1,"Books Level 70"); + +-- Epic Gems (with Aqueous Surger (22881) but without Dragonmaw Wyrmcaller (22960)) +DELETE FROM `creature_loot_template` WHERE `Entry` IN (22844,22845,22846,22847,22853,22855,22869,22873,22874,22875,22876,22877,22878,22879,22880,22881,22882,22884,22885,22939,22945,22946,22953,22954,22955,22956,22957,22959,22962,22963,22964,22965,23018,23028,23030,23047,23049,23147,23172,23196,23222,23223,23232,23235,23236,23237,23239,23330,23337,23339,23374,23394,23397,23400,23402,23403) AND ((`Item` IN (32227,32228,32229,32230,32231,32249) AND `Reference` = 0) OR `Reference` = 34093); +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(22844,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22845,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22846,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22847,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22853,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22855,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22869,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22873,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22874,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22875,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22876,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22877,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22878,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22879,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22880,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22881,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22882,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22884,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22885,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22939,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22945,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22946,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22953,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22954,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22955,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22956,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22957,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22959,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22962,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22963,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22964,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(22965,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23018,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23028,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23030,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23047,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23049,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23147,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23172,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23196,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23222,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23223,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23232,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23235,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23236,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23237,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23239,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23330,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23337,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23339,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23374,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23394,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23397,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23400,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23402,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"), +(23403,34093,34093,3,0,1,0,1,1,"Epic Gems Level 70"); + +-- Fix db errors +UPDATE `creature_template` SET `lootid` = 0 WHERE `entry` IN (11373,11521); |