diff options
| author | Gecko32 <gecko32@trinity.contrib> | 2012-04-19 10:38:14 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-04-19 10:38:14 +0200 |
| commit | 584161bc6db7fd150f857eddefad54cd2c4ad9f2 (patch) | |
| tree | 3fea6a6da835de168318940d561d26a594915ea9 | |
| parent | ccb211374e10d2506d6af24a05378823ac240032 (diff) | |
DB/Loot: Add missing loot templates for some creatures in naxx25
remove scraps from naxx10
Closes # 2776
| -rw-r--r-- | sql/updates/world/2012_04_19_00_world_creature_template.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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); |