Advertisement
gecko32

treat bag

Oct 17th, 2011
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.94 KB | None | 0 0
  1. SET @REF= 10020;
  2. DELETE FROM `reference_loot_template` WHERE `entry`=@REF AND `item`=34000;
  3. DELETE FROM `reference_loot_template` WHERE `entry`=@REF AND `item`=34001;
  4. DELETE FROM `reference_loot_template` WHERE `entry`=@REF AND `item`=34002;
  5. DELETE FROM `reference_loot_template` WHERE `entry`=@REF AND `item`=34003;
  6. DELETE FROM `reference_loot_template` WHERE `entry`=@REF AND `item`=33292;
  7. DELETE FROM `reference_loot_template` WHERE `entry`=@REF AND `item`=37606;
  8. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  9. (@REF, 34002, 0.8, 1, 0, 1, 1), -- Flimsy Male Blood Elf Mask
  10. (@REF, 34001, 0.8, 1, 0, 1, 1), -- Flimsy Female Draenei Mask
  11. (@REF, 34003, 0.8, 1, 0, 1, 1), -- Flimsy Male Draenei Mask
  12. (@REF, 34000, 0.8, 1, 0, 1, 1), -- Flimsy Female Blood Elf Mask
  13. (@REF, 34000, 11, 1, 0, 1, 1), -- Penny Pouch
  14. (@REF, 34000, 2, 1, 0, 1, 1); -- Hallowed Helm
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement