aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorValcorb <valcorb@hotmail.com>2012-07-22 02:13:02 +0100
committerNay <dnpd.dd@gmail.com>2012-07-22 02:13:02 +0100
commitcf76345d6b52a50928ca25313ea40b79d8e9a3a4 (patch)
treebacdbb3f19376dcc363654f055db32099e153f5e
parentda866ac132b6db17dee4a27111d2434be187ca57 (diff)
DB/NPCs: Add a missing item to Nefarion's loot table
Closes #7100 Signed-off-by: Nay <dnpd.dd@gmail.com>
-rw-r--r--sql/updates/world/2012_07_22_02_world_creature_loot_template.sql5
1 files changed, 5 insertions, 0 deletions
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);