diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_04_02_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_04_02_world.sql b/sql/updates/world/3.3.5/2020_05_04_02_world.sql new file mode 100644 index 00000000000..40ac58ec25e --- /dev/null +++ b/sql/updates/world/3.3.5/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); |