From cf76345d6b52a50928ca25313ea40b79d8e9a3a4 Mon Sep 17 00:00:00 2001 From: Valcorb Date: Sun, 22 Jul 2012 02:13:02 +0100 Subject: DB/NPCs: Add a missing item to Nefarion's loot table Closes #7100 Signed-off-by: Nay --- sql/updates/world/2012_07_22_02_world_creature_loot_template.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2012_07_22_02_world_creature_loot_template.sql (limited to 'sql') diff --git a/sql/updates/world/2012_07_22_02_world_creature_loot_template.sql b/sql/updates/world/2012_07_22_02_world_creature_loot_template.sql new file mode 100644 index 00000000000..e4bc61b6fa4 --- /dev/null +++ b/sql/updates/world/2012_07_22_02_world_creature_loot_template.sql @@ -0,0 +1,5 @@ +-- Item was added to the wrong NPC +-- Source: http://old.wowhead.com/item=19364 +DELETE FROM `creature_loot_template` WHERE `entry` IN (1853, 11583) AND `item`=19364; +INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES +(11583, 19364, 10, 1, 0, 1, 1); -- cgit v1.2.3