From 7d49ee81583fc19b073d388b1665ff039f47bebb Mon Sep 17 00:00:00 2001 From: offl Date: Sat, 2 May 2020 17:49:25 +0200 Subject: DB/Loot: Remove more incorrect/weird items from loot Closes #24537 (cherry picked from commit fa2f42b596f9903139782205543588ec6cb2f1b1) --- .../world/master/2022_01_01_47_world_2020_05_02_03_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/master/2022_01_01_47_world_2020_05_02_03_world.sql (limited to 'sql') 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); -- cgit v1.2.3