From dc5e9c80fca8a7e17c8d54dd9e7a150c71a7c810 Mon Sep 17 00:00:00 2001 From: Zaphod Date: Fri, 1 Feb 2013 05:08:11 +0000 Subject: DB/Loot: Fix Prismatic Black Diamond --- .../world/2013_02_01_01_world_spell_loot_template.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2013_02_01_01_world_spell_loot_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_02_01_01_world_spell_loot_template.sql b/sql/updates/world/2013_02_01_01_world_spell_loot_template.sql new file mode 100644 index 00000000000..0185f464412 --- /dev/null +++ b/sql/updates/world/2013_02_01_01_world_spell_loot_template.sql @@ -0,0 +1,12 @@ +-- loot for Prismatic Black Diamond +DELETE FROM `spell_loot_template` WHERE `entry`=62941; +INSERT INTO `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES +(62941, 23094, 0, 1, 1, 1, 1), +(62941, 23095, 0, 1, 1, 1, 1), +(62941, 28595, 0, 1, 1, 1, 1), +(62941, 23116, 0, 1, 1, 1, 1), +(62941, 23118, 0, 1, 1, 1, 1), +(62941, 23119, 0, 1, 1, 1, 1), +(62941, 23120, 0, 1, 1, 1, 1), +(62941, 23114, 0, 1, 1, 1, 1), +(62941, 23115, 0, 1, 1, 1, 1); -- cgit v1.2.3