diff options
| author | Rushor <PBienati@web.de> | 2016-02-07 01:36:44 +0100 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2016-02-07 01:36:44 +0100 |
| commit | 06411e9f6190fc4dfe9fb6e960e9dbc06ab800e2 (patch) | |
| tree | cd34cec851d66556ce600aa66f1d3e446da36d2e | |
| parent | fb445f8a4b8a267c45d1d7d73aaa6136859b7bd9 (diff) | |
DB/Creature: Remove skinning_loot_template 100008 from non-skinnable beasts
* by tkrokli
* closes #15917
| -rw-r--r-- | sql/updates/world/2016_02_07_07_world_335.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_07_07_world_335.sql b/sql/updates/world/2016_02_07_07_world_335.sql new file mode 100644 index 00000000000..af323a47bda --- /dev/null +++ b/sql/updates/world/2016_02_07_07_world_335.sql @@ -0,0 +1,6 @@ +-- +-- Remove skinning_loot_template 100008 from non-skinnable beasts: +UPDATE `creature_template` SET `skinloot`= 0 WHERE `skinloot`= 100008 AND `entry` NOT IN (1042,1043,1069); + +UPDATE `skinning_loot_template` SET `Comment`='Light Leather' WHERE `Item`= 2318 AND `Entry` IN (3098,3124); +UPDATE `skinning_loot_template` SET `Comment`='Ruined Leather Scraps' WHERE `Item`= 2934 AND `Entry` IN (3098,3124); |