From 584161bc6db7fd150f857eddefad54cd2c4ad9f2 Mon Sep 17 00:00:00 2001 From: Gecko32 Date: Thu, 19 Apr 2012 10:38:14 +0200 Subject: DB/Loot: Add missing loot templates for some creatures in naxx25 remove scraps from naxx10 Closes # 2776 --- sql/updates/world/2012_04_19_00_world_creature_template.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2012_04_19_00_world_creature_template.sql (limited to 'sql') diff --git a/sql/updates/world/2012_04_19_00_world_creature_template.sql b/sql/updates/world/2012_04_19_00_world_creature_template.sql new file mode 100644 index 00000000000..e9abd40095e --- /dev/null +++ b/sql/updates/world/2012_04_19_00_world_creature_template.sql @@ -0,0 +1,7 @@ +-- update Plague Slime & Marauding Geist to naxx25 trash lootid +UPDATE `creature_template` SET `lootid`=100005 WHERE `entry` IN(29575,30424); +-- update Plague Slime & Marauding Geist to naxx10 trash lootid +UPDATE `creature_template` SET `lootid`=100003 WHERE `entry` IN(16243,30083); +DELETE FROM `creature_loot_template` WHERE `entry` IN(30424,29575,16243,30083); +-- Remove scraps for naxx10 from creature creature_loot_template +DELETE FROM `creature_loot_template` WHERE `item` IN (22373,22374,22375,22376); -- cgit v1.2.3