diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-02 17:49:25 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-05-02 17:49:25 +0200 |
| commit | fa2f42b596f9903139782205543588ec6cb2f1b1 (patch) | |
| tree | 3b8d6e225fbf69a6ef114ac8bd090930b352d88a | |
| parent | 9f5bafa7c662d39d891126f9c09de6cd654a0342 (diff) | |
DB/Loot: Remove more incorrect/weird items from loot
Closes #24537
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_02_03_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_02_03_world.sql b/sql/updates/world/3.3.5/2020_05_02_03_world.sql new file mode 100644 index 00000000000..81d71593ca3 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |