From 06411e9f6190fc4dfe9fb6e960e9dbc06ab800e2 Mon Sep 17 00:00:00 2001 From: Rushor Date: Sun, 7 Feb 2016 01:36:44 +0100 Subject: DB/Creature: Remove skinning_loot_template 100008 from non-skinnable beasts * by tkrokli * closes #15917 --- sql/updates/world/2016_02_07_07_world_335.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2016_02_07_07_world_335.sql (limited to 'sql') 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); -- cgit v1.2.3