aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2022_01_02_02_world_2020_05_04_02_world.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_02_02_world_2020_05_04_02_world.sql b/sql/updates/world/master/2022_01_02_02_world_2020_05_04_02_world.sql
new file mode 100644
index 00000000000..40ac58ec25e
--- /dev/null
+++ b/sql/updates/world/master/2022_01_02_02_world_2020_05_04_02_world.sql
@@ -0,0 +1,14 @@
+--
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24016 AND `Entry` IN (2850,6466,18258,7370,12378,12377,12379,12380);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24017 AND `Entry` IN (2561,7370,12378,12377,12379,12380);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24018 AND `Entry` IN (19306,7370,12378,12377,12379,12380);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24019 AND `Entry` IN (7370,12378,12377,12379,12380);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24020 AND `Entry` IN (19996);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24021 AND `Entry` IN (12377);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24024 AND `Entry` IN (7370,12378,12377,12379,12380,22342);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24029 AND `Entry` IN (12377);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24031 AND `Entry` IN (6466,7370,12377);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24032 AND `Entry` IN (12378,12380);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24033 AND `Entry` IN (7370,12378,12377,12379,12380);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24034 AND `Entry` IN (7370,12378,12377,12379,12380);
+DELETE FROM `creature_loot_template` WHERE `Reference` = 24036 AND `Entry` IN (232);