diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-02 17:49:25 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-02 00:20:41 +0100 |
| commit | 7d49ee81583fc19b073d388b1665ff039f47bebb (patch) | |
| tree | c2930988c8d275030bc08004fcecae644ac43be3 /sql | |
| parent | 3be5ade1241eac65089e4a2458603c46a46dbb82 (diff) | |
DB/Loot: Remove more incorrect/weird items from loot
Closes #24537
(cherry picked from commit fa2f42b596f9903139782205543588ec6cb2f1b1)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_01_47_world_2020_05_02_03_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_47_world_2020_05_02_03_world.sql b/sql/updates/world/master/2022_01_01_47_world_2020_05_02_03_world.sql new file mode 100644 index 00000000000..81d71593ca3 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_47_world_2020_05_02_03_world.sql @@ -0,0 +1,10 @@ +-- Incorrect/weird or drops from gameobjects or items +DELETE FROM `creature_loot_template` WHERE `Item` IN (6712,16747,16748,12533,22649,22650,21749); +-- Incorrect/weird +DELETE FROM `creature_loot_template` WHERE `Entry` = 23051 AND `Item` != 33838; +DELETE FROM `creature_loot_template` WHERE `Entry` = 14467 AND `Item` != 18625; +DELETE FROM `creature_loot_template` WHERE `Entry` = 11876 AND `Item` != 13542; +DELETE FROM `creature_loot_template` WHERE `Entry` = 868 AND `Item` = 19279; +-- These NPCs shouldn't have loot table +UPDATE `creature_template` SET `lootid` = 0 WHERE `entry` IN (10387,10388,10389,17070,17462,20595); +DELETE FROM `creature_loot_template` WHERE `Entry` IN (10387,10388,10389,17070); |