From 3cc54cb6e8df57954a02bfe5514f7a5f4b1996a5 Mon Sep 17 00:00:00 2001 From: zxbiohazardzx Date: Mon, 14 Nov 2011 01:01:32 +0100 Subject: DB/Loot: Orders of Kael'thas only drop from 3 creatures, at 80% chance if on quest fixes #3028 --- sql/updates/world/2011_11_13_11_world_creature_loot_template.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2011_11_13_11_world_creature_loot_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_13_11_world_creature_loot_template.sql b/sql/updates/world/2011_11_13_11_world_creature_loot_template.sql new file mode 100644 index 00000000000..9f753577844 --- /dev/null +++ b/sql/updates/world/2011_11_13_11_world_creature_loot_template.sql @@ -0,0 +1,6 @@ +-- Add Orders From Kael'thas to the following creatures +DELETE FROM `creature_loot_template` WHERE `item`=29797; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(18860,29797,-80,1,0,1,1), -- Daughter of Destiny +(20285,29797,-80,1,0,1,1), -- Gan'arg Warp-Tinker +(20326,29797,-80,1,0,1,1); -- Mo'arg Warp-Master -- cgit v1.2.3