DB/Loot: Add some references for Black Temple

Closes #24585

(cherry picked from commit 2ada2cfaea96c535d2996aad50ea14af50db25a7)

1 files changed, 263 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_02_14_world_2020_05_08_02_world.sql b/sql/updates/world/master/2022_01_02_14_world_2020_05_08_02_world.sql
new file mode 100644
index 00000000000..1fbaa9a2de8
--- /dev/null
+++ b/sql/updates/world/master/2022_01_02_14_world_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);