From 02fa3684df308c1d2c6c5273e4011df9c464926e Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Sat, 14 Jul 2012 13:57:39 +0200 Subject: DB/Loot: Various Lootfixes for quest-related items Closes #6951,#6957,#6980 --- sql/updates/world/2012_07_14_00_world_creature_loot_template.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2012_07_14_00_world_creature_loot_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_07_14_00_world_creature_loot_template.sql b/sql/updates/world/2012_07_14_00_world_creature_loot_template.sql new file mode 100644 index 00000000000..f76e5519594 --- /dev/null +++ b/sql/updates/world/2012_07_14_00_world_creature_loot_template.sql @@ -0,0 +1,6 @@ +-- Gorilla Fang should always be able to drop (Exodius) +UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = ABS(`ChanceOrQuestChance`) WHERE `item`=2799; +-- Update "Count" Ungula's Mandible drop rate does not require quest to drop it starts one (gecko32) +UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = ABS(`ChanceOrQuestChance`) WHERE `item`=25459; +-- Tainted Hellboar Meat fix (ZxBiohazardZx) +UPDATE `quest_template` SET `RequiredSourceItemId1`=23270,`RequiredSourceItemCount1`=8 WHERE `Id`=9361; -- cgit v1.2.3