diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-05 00:37:05 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-02 13:45:49 +0100 |
| commit | f466bf8b6a3fdd84b5f81814b7b8ccd3e913dca7 (patch) | |
| tree | 7a89af15034dc028e5e50fa66b1f6c53c3597e8d /sql | |
| parent | 06963c5797995bb4c7d0acec0864552b86a66a90 (diff) | |
DB/Loot: Remove excess references from some creatures
Closes #24557
(cherry picked from commit ec17750fe9ea9f198315bb0803d9b8e022c67769)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_02_02_world_2020_05_04_02_world.sql | 14 |
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); |