From 2e99388d5081f5f29387d1637c14aa5021fd969d Mon Sep 17 00:00:00 2001 From: Rushor Date: Tue, 20 Oct 2015 11:47:44 +0200 Subject: DB/Creature: Thistle Boar - Skinning Loot * closes #15744 (cherry picked from commit 54341dc8ab77d48c0c0c245648e6fd51bed3e0eb) --- sql/updates/world/2015_11_06_14_world_2015_10_20_03.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2015_11_06_14_world_2015_10_20_03.sql (limited to 'sql') diff --git a/sql/updates/world/2015_11_06_14_world_2015_10_20_03.sql b/sql/updates/world/2015_11_06_14_world_2015_10_20_03.sql new file mode 100644 index 00000000000..23f7ba806c1 --- /dev/null +++ b/sql/updates/world/2015_11_06_14_world_2015_10_20_03.sql @@ -0,0 +1,6 @@ +-- Thistle Boar - Skinning Loot +UPDATE `creature_template` SET `skinloot`=1985 WHERE `entry`=1985; +DELETE FROM `skinning_loot_template` WHERE `Entry`=1985; +INSERT INTO `skinning_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(1985, 2934, 0, 88, 0, 1, 1, 1, 1, NULL), +(1985, 2318, 0, 10, 0, 1, 1, 1, 1, NULL); -- cgit v1.2.3