Advertisement
Guest User

Grelda the Hag

a guest
Jan 21st, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.66 KB | None | 0 0
  1. DELETE FROM `creature_loot_template` WHERE `entry`=95123;
  2. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
  3. VALUES
  4. (95123, 136785, -54, 1, 0, 1, 1,),
  5. (95123, 130122, 39, 1, 0, 1, 1,),
  6. (95123, 138839, 10, 1, 0, 1, 1,),
  7. (95123, 139528, 0.12, 1, 0, 1, 1,),
  8. (95123, 139526, 0.1, 1, 0, 1, 1,),
  9. (95123, 138009, 0.03, 1, 0, 1, 1,),
  10. (95123, 139527, 0.01, 1, 0, 1, 1,),
  11. (95123, 124437, 17, 1, 0, 1, 3,),
  12. (95123, 138781, 0.7, 1, 0, 1, 1,),
  13. (95123, 140222, 0.4, 1, 0, 1, 1,),
  14. (95123, 121215, 0.3, 1, 0, 1, 1,),
  15. (95123, 121335, 0.3, 1, 0, 1, 1,),
  16. (95123, 121332, 0.3, 1, 0, 1, 1,),
  17. (95123, 121342, 0.3, 1, 0, 1, 1,),
  18. (95123, 121354, 0.3, 1, 0, 1, 1,),
  19. (95123, 121356, 0.3, 1, 0, 1, 1,),
  20. (95123, 121358, 0.3, 1, 0, 1, 1,),
  21. (95123, 121213, 0.2, 1, 0, 1, 1,),
  22. (95123, 121211, 0.2, 1, 0, 1, 1,),
  23. (95123, 141290, 0.2, 1, 0, 1, 1,),
  24. (95123, 121337, 0.2, 1, 0, 1, 1,),
  25. (95123, 121350, 0.2, 1, 0, 1, 1,),
  26. (95123, 121371, 0.2, 1, 0, 1, 1,),
  27. (95123, 121344, 0.2, 1, 0, 1, 1,),
  28. (95123, 121359, 0.2, 1, 0, 1, 1,),
  29. (95123, 121184, 0.18, 1, 0, 1, 1,),
  30. (95123, 121334, 0.18, 1, 0, 1, 1,),
  31. (95123, 121339, 0.17, 1, 0, 1, 1,),
  32. (95123, 121365, 0.17, 1, 0, 1, 1,),
  33. (95123, 121370, 0.17, 1, 0, 1, 1,),
  34. (95123, 140221, 0.16, 1, 0, 1, 1,),
  35. (95123, 140226, 0.16, 1, 0, 1, 1,),
  36. (95123, 121363, 0.16, 1, 0, 1, 1,),
  37. (95123, 121345, 0.16, 1, 0, 1, 1,),
  38. (95123, 121362, 0.16, 1, 0, 1, 1,),
  39. (95123, 140224, 0.15, 1, 0, 1, 1,),
  40. (95123, 121208, 0.15, 1, 0, 1, 1,),
  41. (95123, 121210, 0.13, 1, 0, 1, 1,),
  42. (95123, 121366, 0.13, 1, 0, 1, 1,),
  43. (95123, 121368, 0.13, 1, 0, 1, 1,),
  44. (95123, 121349, 0.13, 1, 0, 1, 1,),
  45. (95123, 121218, 0.12, 1, 0, 1, 1,),
  46. (95123, 121205, 0.12, 1, 0, 1, 1,),
  47. (95123, 121361, 0.12, 1, 0, 1, 1,),
  48. (95123, 121369, 0.12, 1, 0, 1, 1,),
  49. (95123, 121214, 0.11, 1, 0, 1, 1,),
  50. (95123, 121168, 0.11, 1, 0, 1, 1,),
  51. (95123, 121193, 0.11, 1, 0, 1, 1,),
  52. (95123, 121341, 0.11, 1, 0, 1, 1,),
  53. (95123, 121346, 0.11, 1, 0, 1, 1,),
  54. (95123, 140227, 0.1, 1, 0, 1, 1,),
  55. (95123, 121206, 0.1, 1, 0, 1, 1,),
  56. (95123, 121169, 0.1, 1, 0, 1, 1,),
  57. (95123, 140225, 0.1, 1, 0, 1, 1,),
  58. (95123, 121189, 0.1, 1, 0, 1, 1,),
  59. (95123, 121177, 0.1, 1, 0, 1, 1,),
  60. (95123, 121373, 0.1, 1, 0, 1, 1,),
  61. (95123, 121355, 0.1, 1, 0, 1, 1,),
  62. (95123, 121212, 0.09, 1, 0, 1, 1,),
  63. (95123, 121405, 0.09, 1, 0, 1, 1,),
  64. (95123, 121352, 0.09, 1, 0, 1, 1,),
  65. (95123, 121172, 0.08, 1, 0, 1, 1,),
  66. (95123, 121181, 0.08, 1, 0, 1, 1,),
  67. (95123, 121179, 0.08, 1, 0, 1, 1,),
  68. (95123, 121173, 0.07, 1, 0, 1, 1,),
  69. (95123, 140220, 0.07, 1, 0, 1, 1,),
  70. (95123, 121360, 0.07, 1, 0, 1, 1,),
  71. (95123, 121209, 0.06, 1, 0, 1, 1,),
  72. (95123, 121188, 0.06, 1, 0, 1, 1,),
  73. (95123, 121219, 0.05, 1, 0, 1, 1,),
  74. (95123, 121207, 0.05, 1, 0, 1, 1,),
  75. (95123, 121166, 0.05, 1, 0, 1, 1,),
  76. (95123, 121187, 0.05, 1, 0, 1, 1,),
  77. (95123, 121364, 0.05, 1, 0, 1, 1,),
  78. (95123, 121372, 0.05, 1, 0, 1, 1,),
  79. (95123, 121217, 0.04, 1, 0, 1, 1,),
  80. (95123, 121180, 0.04, 1, 0, 1, 1,),
  81. (95123, 121338, 0.04, 1, 0, 1, 1,),
  82. (95123, 121402, 0.04, 1, 0, 1, 1,),
  83. (95123, 121367, 0.04, 1, 0, 1, 1,),
  84. (95123, 121216, 0.03, 1, 0, 1, 1,),
  85. (95123, 121167, 0.03, 1, 0, 1, 1,),
  86. (95123, 141291, 0.03, 1, 0, 1, 1,),
  87. (95123, 121410, 0.03, 1, 0, 1, 1,),
  88. (95123, 121384, 0.03, 1, 0, 1, 1,),
  89. (95123, 121392, 0.03, 1, 0, 1, 1,),
  90. (95123, 121348, 0.03, 1, 0, 1, 1,),
  91. (95123, 121393, 0.03, 1, 0, 1, 1,),
  92. (95123, 121183, 0.02, 1, 0, 1, 1,),
  93. (95123, 121333, 0.02, 1, 0, 1, 1,),
  94. (95123, 121170, 0.01, 1, 0, 1, 1,),
  95. (95123, 121186, 0.01, 1, 0, 1, 1,),
  96. (95123, 121385, 0.01, 1, 0, 1, 1,),
  97. (95123, 121406, 0.01, 1, 0, 1, 1,),
  98. (95123, 121409, 0.01, 1, 0, 1, 1,);
  99. UPDATE `creature_template` SET `lootid`='95123' WHERE `entry`='95123';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement