diff options
| author | zxbiohazardzx <zxbiohazardzx@gmail.com> | 2011-11-14 01:01:32 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-11-14 01:01:32 +0100 |
| commit | 3cc54cb6e8df57954a02bfe5514f7a5f4b1996a5 (patch) | |
| tree | 2161e355ff1e35e3d1e326efe8ade62f628014c3 | |
| parent | 38349a63e45e9148e61ae5366dd1cfbf50470582 (diff) | |
DB/Loot: Orders of Kael'thas only drop from 3 creatures, at 80% chance if on quest
fixes #3028
| -rw-r--r-- | sql/updates/world/2011_11_13_11_world_creature_loot_template.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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 |