From 5bd486712bb35083541bb8a82bdc3ef4f56f73dd Mon Sep 17 00:00:00 2001 From: kandera Date: Fri, 14 Sep 2012 11:41:27 -0300 Subject: DB/Loot: fix error from previous commit --- sql/updates/world/2012_09_14_01_world_creature_loot_template.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'sql/updates') 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 index 02b9ad761bd..570cc87f849 100644 --- 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 @@ -1,4 +1,5 @@ +DELET FROM `creature_loot_template` WHERE `entry` = 37126; 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); +(37126, 49426, 100, 1, 0, 1, 1), +(37126, 1, 100, 1, 0, -100002, 1); UPDATE `creature_template` SET `lootid` = 37126 WHERE `entry` IN (37126,38258); -- cgit v1.2.3