Advertisement
Guest User

Untitled

a guest
Jun 19th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. UPDATE `creature_template` SET `LootID`= 31205 WHERE `entry` = 31205;
  2. DELETE FROM `creature_loot_template` WHERE `entry` = 31205;
  3. INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES
  4. (31205, 36912, 42, 0, 2, 6, 0, 0, 0),
  5. (31205, 37703, 24, 0, 1, 3, 0, 0, 0),
  6. (31205, 43610, -20, 0, 1, 1, 0, 0, 0),
  7. (31205, 37701, 15, 0, 1, 6, 0, 0, 0),
  8. (31205, 36933, 12, 0, 1, 1, 0, 0, 0),
  9. (31205, 43616, -10, 0, 1, 1, 0, 0, 0),
  10. (31205, 37704, 8, 0, 1, 3, 0, 0, 0),
  11. (31205, 36906, 8, 0, 2, 3, 0, 0, 0),
  12. (31205, 36905, 5, 0, 2, 3, 0, 0, 0),
  13. (31205, 37705, 3, 0, 3, 6, 0, 0, 0),
  14. (31205, 37700, 2, 0, 3, 3, 0, 0, 0),
  15. (31205, 43016, 1, 0, 1, 1, 0, 0, 0),
  16. (31205, 36908, 1, 0, 1, 1, 0, 0, 0),
  17. (31205, 36910, 1, 0, 3, 3, 0, 0, 0),
  18. (31205, 44228, 1, 0, 3, 3, 0, 0, 0),
  19. (31205, 33470, 1, 0, 20, 20, 0, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement