diff options
| author | zxbiohazardzx <zxbiohazardzx@gmail.com> | 2011-11-14 00:31:14 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-11-14 00:31:14 +0100 |
| commit | 2fb6f35c34f7ccff7cb610d26156058ff540e802 (patch) | |
| tree | 262a6b5dba8fa36ce83ed7922404fb2120d48bef | |
| parent | 96ba9ced9da09573754ed66e7f6058748b1caec9 (diff) | |
DB/Loot: Add missing items to the Hallows End Treatbag
fixes #3556
| -rw-r--r-- | sql/updates/world/2011_11_13_06_world_reference_loot_template.sql | 9 |
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 |