aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2011_11_13_06_world_reference_loot_template.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_11_13_06_world_reference_loot_template.sql b/sql/updates/world/2011_11_13_06_world_reference_loot_template.sql
new file mode 100644
index 00000000000..efb2fec72f3
--- /dev/null
+++ b/sql/updates/world/2011_11_13_06_world_reference_loot_template.sql
@@ -0,0 +1,9 @@
+SET @Ref = 10020;
+DELETE FROM `reference_loot_template` WHERE `entry`=@Ref AND `item`IN (34000,34001,34002,34003,33292,37606);
+INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
+(@REF,34000,0.8,1,0,1,1), -- Flimsy Female Blood Elf Mask
+(@REF,34001,0.8,1,0,1,1), -- Flimsy Female Draenei Mask
+(@REF,34002,0.8,1,0,1,1), -- Flimsy Male Blood Elf Mask
+(@REF,34003,0.8,1,0,1,1), -- Flimsy Male Draenei Mask
+(@REF,37606,11,1,0,1,1), -- Penny Pouch
+(@REF,33292,2,1,0,1,1); -- Hallowed Helm