diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-05 00:37:05 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-05-05 00:37:05 +0200 |
| commit | ec17750fe9ea9f198315bb0803d9b8e022c67769 (patch) | |
| tree | 42828b0b76dccb9208b33896d9ec6d81e4d8cd60 | |
| parent | 7c1cf76e280005b4aaa774aeb20129c6c55edb7a (diff) | |
DB/Loot: Remove excess references from some creatures
Closes #24557
| -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); |