From f3b50ffe11d3bc5f75df0db7062f106de205be69 Mon Sep 17 00:00:00 2001 From: nelegalno Date: Fri, 6 Jan 2012 13:38:26 +0100 Subject: Db/Loot: Fix items dropped in Narain's Special Kit --- sql/updates/world/2012_01_06_03_world_item_loot_template.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2012_01_06_03_world_item_loot_template.sql (limited to 'sql') diff --git a/sql/updates/world/2012_01_06_03_world_item_loot_template.sql b/sql/updates/world/2012_01_06_03_world_item_loot_template.sql new file mode 100644 index 00000000000..e1d6cd94525 --- /dev/null +++ b/sql/updates/world/2012_01_06_03_world_item_loot_template.sql @@ -0,0 +1,8 @@ +-- Fix Decoy! (8606) quest items drop chance from Narain's Special Kit (21042) +SET @Kit := 21042; +DELETE FROM `item_loot_template` WHERE `entry`= @Kit; +INSERT INTO `item_loot_template` VALUES +(@Kit, 21037, 100, 1, 0, 1, 1), -- Crude Map +(@Kit, 21039, 100, 1, 0, 1, 1), -- Narain's Turban +(@Kit, 21040, 100, 1, 0, 1, 1), -- Narain's Robe +(@Kit, 21041, 100, 1, 0, 1, 1); -- Bag of Gold -- cgit v1.2.3