From 5db7bf9cc33ee30b5201ab46a2fc788bbad2ab35 Mon Sep 17 00:00:00 2001 From: gecko32 Date: Tue, 4 Oct 2011 10:14:55 +0200 Subject: DB/Loot: Twin Val'kyr should drop 2 items and not 1 fixes #2553 --- .../world/2011_10_04_00_world_creature_loot_template.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2011_10_04_00_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_10_04_00_world_creature_loot_template.sql b/sql/updates/world/2011_10_04_00_world_creature_loot_template.sql new file mode 100644 index 00000000000..0a6cfc1073f --- /dev/null +++ b/sql/updates/world/2011_10_04_00_world_creature_loot_template.sql @@ -0,0 +1,13 @@ +-- Make Fjola drop two items from her loot table +-- 10 Normal +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=34497 AND `item`=2; +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=34497 AND `item`=1; +-- 25 Normal +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=35350 AND `item`=2; +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=35350 AND `item`=1; +-- 10 Heroic +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=35351 AND `item`=2; +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=35351 AND `item`=1; +-- 25 Herioc +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=35352 AND `item`=2; +UPDATE `creature_loot_template` SET `maxcount`=2 WHERE `entry`=35352 AND `item`=1; -- cgit v1.2.3