From 2773adbb3804c6f383e67a08fa9d0e8dc0d9aaeb Mon Sep 17 00:00:00 2001 From: Kandera Date: Fri, 14 Sep 2012 09:58:42 -0400 Subject: DB/Loot: Sister svalna is supposed to also drop one emblem of frost --- sql/updates/world/2012_09_14_01_world_creature_loot_template.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2012_09_14_01_world_creature_loot_template.sql (limited to 'sql') diff --git a/sql/updates/world/2012_09_14_01_world_creature_loot_template.sql b/sql/updates/world/2012_09_14_01_world_creature_loot_template.sql new file mode 100644 index 00000000000..02b9ad761bd --- /dev/null +++ b/sql/updates/world/2012_09_14_01_world_creature_loot_template.sql @@ -0,0 +1,4 @@ +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(37126, 49426, 100, 1, 0, 0, 1, 1), +(37126, 1, 100, 1, 0, 0, -100002, 1); +UPDATE `creature_template` SET `lootid` = 37126 WHERE `entry` IN (37126,38258); -- cgit v1.2.3