Advertisement
Rushor

Untitled

Aug 10th, 2014
234
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. DELETE FROM `creature_loot_template` WHERE `entry` IN (NPCID1, NPCID2, NPCID3..., NPCID_LAST) AND `item`=12698;
  2. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  3. (NPCID1, 12698, 0.02, 1, 0, 1, 1),
  4. (NPCID2, 12698, 0.02, 1, 0, 1, 1),
  5. (NPCID3, 12698, 0.02, 1, 0, 1, 1),
  6. .
  7. .
  8. .
  9. (NPCID_LAST, 12698, 0.02, 1, 0, 1, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement