API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
45
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.53 KB | None | 0 0
raw download clone embed print report
  1. SET @ENTRY34797LOOT10N :=34797;
  2.  
  3. DELETE FROM `creature_loot_template`
  4. WHERE `entry` LIKE @ENTRY34797LOOT10N;
  5.  
  6. insert into `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
  7. values
  8. (@ENTRY34797LOOT10N,'47850','10','1','0','1','1'),
  9. (@ENTRY34797LOOT10N,'47855','10','1','0','1','1'),
  10. (@ENTRY34797LOOT10N,'47852','9','1','0','1','1'),
  11. (@ENTRY34797LOOT10N,'47858','9','1','0','1','1'),
  12. (@ENTRY34797LOOT10N,'47857','9','1','0','1','1'),
  13. (@ENTRY34797LOOT10N,'47860','9','1','0','1','1'),
  14. (@ENTRY34797LOOT10N,'47856','9','1','0','1','1'),
  15. (@ENTRY34797LOOT10N,'47853','9','1','0','1','1'),
  16. (@ENTRY34797LOOT10N,'47859','9','1','0','1','1'),
  17. (@ENTRY34797LOOT10N,'47854','9','1','0','1','1'),
  18. (@ENTRY34797LOOT10N,'47608','8','1','0','1','1'),
  19. (@ENTRY34797LOOT10N,'47615','8','1','0','1','1'),
  20. (@ENTRY34797LOOT10N,'47578','8','1','0','1','1'),
  21. (@ENTRY34797LOOT10N,'47849','8','1','0','1','1'),
  22. (@ENTRY34797LOOT10N,'47851','8','1','0','1','1'),
  23. (@ENTRY34797LOOT10N,'47612','8','1','0','1','1'),
  24. (@ENTRY34797LOOT10N,'47607','7','1','0','1','1'),
  25. (@ENTRY34797LOOT10N,'47611','7','1','0','1','1'),
  26. (@ENTRY34797LOOT10N,'47609','7','1','0','1','1'),
  27. (@ENTRY34797LOOT10N,'47614','7','1','0','1','1'),
  28. (@ENTRY34797LOOT10N,'47617','7','1','0','1','1'),
  29. (@ENTRY34797LOOT10N,'47616','7','1','0','1','1'),
  30. (@ENTRY34797LOOT10N,'47613','7','1','0','1','1'),
  31. (@ENTRY34797LOOT10N,'47610','6','1','0','1','1');
  32.  
  33.  
  34.  
  35. SET @ENTRY35447LOOT25N :=35447;
  36.  
  37. DELETE FROM `creature_loot_template`
  38. WHERE `entry` LIKE @ENTRY35447LOOT25N;
  39.  
  40. insert into `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
  41. values
  42. (@ENTRY35447LOOT25N,'47242','97','1','0','1','1'),
  43. (@ENTRY35447LOOT25N,'47556','47','1','0','1','1'),
  44. (@ENTRY35447LOOT25N,'47258','11','1','0','1','1'),
  45. (@ENTRY35447LOOT25N,'47262','11','1','0','1','1'),
  46. (@ENTRY35447LOOT25N,'47257','11','1','0','1','1'),
  47. (@ENTRY35447LOOT25N,'47261','10','1','0','1','1'),
  48. (@ENTRY35447LOOT25N,'47265','10','1','0','1','1'),
  49. (@ENTRY35447LOOT25N,'47253','10','1','0','1','1'),
  50. (@ENTRY35447LOOT25N,'47256','10','1','0','1','1'),
  51. (@ENTRY35447LOOT25N,'47264','10','1','0','1','1'),
  52. (@ENTRY35447LOOT25N,'47260','10','1','0','1','1'),
  53. (@ENTRY35447LOOT25N,'47254','10','1','0','1','1'),
  54. (@ENTRY35447LOOT25N,'47252','10','1','0','1','1'),
  55. (@ENTRY35447LOOT25N,'47263','10','1','0','1','1'),
  56. (@ENTRY35447LOOT25N,'47255','10','1','0','1','1'),
  57. (@ENTRY35447LOOT25N,'46990','9','1','0','1','1'),
  58. (@ENTRY35447LOOT25N,'46961','9','1','0','1','1'),
  59. (@ENTRY35447LOOT25N,'46985','9','1','0','1','1'),
  60. (@ENTRY35447LOOT25N,'46963','9','1','0','1','1'),
  61. (@ENTRY35447LOOT25N,'47251','9','1','0','1','1'),
  62. (@ENTRY35447LOOT25N,'46974','9','1','0','1','1'),
  63. (@ENTRY35447LOOT25N,'47259','9','1','0','1','1'),
  64. (@ENTRY35447LOOT25N,'46988','8','1','0','1','1'),
  65. (@ENTRY35447LOOT25N,'46959','8','1','0','1','1'),
  66. (@ENTRY35447LOOT25N,'46979','8','1','0','1','1'),
  67. (@ENTRY35447LOOT25N,'46960','8','1','0','1','1'),
  68. (@ENTRY35447LOOT25N,'46962','8','1','0','1','1'),
  69. (@ENTRY35447LOOT25N,'46972','8','1','0','1','1'),
  70. (@ENTRY35447LOOT25N,'46970','8','1','0','1','1'),
  71. (@ENTRY35447LOOT25N,'46992','8','1','0','1','1'),
  72. (@ENTRY35447LOOT25N,'46976','8','1','0','1','1'),
  73. (@ENTRY35447LOOT25N,'46958','8','1','0','1','1'),
  74. (@ENTRY35447LOOT25N,'47646','2','1','0','1','1'),
  75. (@ENTRY35447LOOT25N,'47633','1.9','1','0','1','1'),
  76. (@ENTRY35447LOOT25N,'47648','1.7','1','0','1','1'),
  77. (@ENTRY35447LOOT25N,'47641','1.7','1','0','1','1'),
  78. (@ENTRY35447LOOT25N,'47649','1.7','1','0','1','1'),
  79. (@ENTRY35447LOOT25N,'47642','1.7','1','0','1','1'),
  80. (@ENTRY35447LOOT25N,'47651','1.6','1','0','1','1'),
  81. (@ENTRY35447LOOT25N,'47647','1.5','1','0','1','1'),
  82. (@ENTRY35447LOOT25N,'47636','1.5','1','0','1','1'),
  83. (@ENTRY35447LOOT25N,'47652','1.5','1','0','1','1'),
  84. (@ENTRY35447LOOT25N,'47625','1.5','1','0','1','1'),
  85. (@ENTRY35447LOOT25N,'47650','1.5','1','0','1','1'),
  86. (@ENTRY35447LOOT25N,'47653','1.4','1','0','1','1'),
  87. (@ENTRY35447LOOT25N,'47645','1.4','1','0','1','1'),
  88. (@ENTRY35447LOOT25N,'47635','1.4','1','0','1','1'),
  89. (@ENTRY35447LOOT25N,'47640','1.4','1','0','1','1'),
  90. (@ENTRY35447LOOT25N,'47655','1.4','1','0','1','1'),
  91. (@ENTRY35447LOOT25N,'47644','1.3','1','0','1','1'),
  92. (@ENTRY35447LOOT25N,'47638','1.3','1','0','1','1'),
  93. (@ENTRY35447LOOT25N,'47643','1.3','1','0','1','1'),
  94. (@ENTRY35447LOOT25N,'47657','1.3','1','0','1','1'),
  95. (@ENTRY35447LOOT25N,'47626','1.3','1','0','1','1'),
  96. (@ENTRY35447LOOT25N,'47656','1.3','1','0','1','1'),
  97. (@ENTRY35447LOOT25N,'47630','1.2','1','0','1','1'),
  98. (@ENTRY35447LOOT25N,'47631','1.2','1','0','1','1'),
  99. (@ENTRY35447LOOT25N,'47634','1.2','1','0','1','1'),
  100. (@ENTRY35447LOOT25N,'47637','1.2','1','0','1','1'),
  101. (@ENTRY35447LOOT25N,'47654','1.2','1','0','1','1'),
  102. (@ENTRY35447LOOT25N,'47627','1.2','1','0','1','1'),
  103. (@ENTRY35447LOOT25N,'47639','1.2','1','0','1','1'),
  104. (@ENTRY35447LOOT25N,'47628','1.1','1','0','1','1'),
  105. (@ENTRY35447LOOT25N,'47632','1.1','1','0','1','1'),
  106. (@ENTRY35447LOOT25N,'47629','1.1','1','0','1','1'),
  107. (@ENTRY35447LOOT25N,'47623','1.1','1','0','1','1'),
  108. (@ENTRY35447LOOT25N,'47624','1','1','0','1','1'),
  109. (@ENTRY35447LOOT25N,'47622','1','1','0','1','1');
  110.  
  111.  
  112. SET @ENTRY35448LOOT10H :=35448;
  113.  
  114. DELETE FROM `creature_loot_template`
  115. WHERE `entry` LIKE @ENTRY35448LOOT10H;
  116.  
  117. insert into `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
  118. values
  119. (@ENTRY35448LOOT10H,'47556','46','1','0','1','1'),
  120. (@ENTRY35448LOOT10H,'47998','10','1','0','1','1'),
  121. (@ENTRY35448LOOT10H,'47988','10','1','0','1','1'),
  122. (@ENTRY35448LOOT10H,'47999','10','1','0','1','1'),
  123. (@ENTRY35448LOOT10H,'47990','9','1','0','1','1'),
  124. (@ENTRY35448LOOT10H,'47993','9','1','0','1','1'),
  125. (@ENTRY35448LOOT10H,'47996','9','1','0','1','1'),
  126. (@ENTRY35448LOOT10H,'47991','9','1','0','1','1'),
  127. (@ENTRY35448LOOT10H,'47997','9','1','0','1','1'),
  128. (@ENTRY35448LOOT10H,'47994','9','1','0','1','1'),
  129. (@ENTRY35448LOOT10H,'47922','9','1','0','1','1'),
  130. (@ENTRY35448LOOT10H,'47992','8','1','0','1','1'),
  131. (@ENTRY35448LOOT10H,'47917','8','1','0','1','1'),
  132. (@ENTRY35448LOOT10H,'47995','8','1','0','1','1'),
  133. (@ENTRY35448LOOT10H,'47926','8','1','0','1','1'),
  134. (@ENTRY35448LOOT10H,'47919','7','1','0','1','1'),
  135. (@ENTRY35448LOOT10H,'47924','7','1','0','1','1'),
  136. (@ENTRY35448LOOT10H,'47989','7','1','0','1','1'),
  137. (@ENTRY35448LOOT10H,'47920','7','1','0','1','1'),
  138. (@ENTRY35448LOOT10H,'47916','7','1','0','1','1'),
  139. (@ENTRY35448LOOT10H,'47915','7','1','0','1','1'),
  140. (@ENTRY35448LOOT10H,'47918','7','1','0','1','1'),
  141. (@ENTRY35448LOOT10H,'47925','7','1','0','1','1'),
  142. (@ENTRY35448LOOT10H,'47921','7','1','0','1','1'),
  143. (@ENTRY35448LOOT10H,'47923','6','1','0','1','1'),
  144. (@ENTRY35448LOOT10H,'47644','3','1','0','1','1'),
  145. (@ENTRY35448LOOT10H,'47633','2','1','0','1','1'),
  146. (@ENTRY35448LOOT10H,'47647','2','1','0','1','1'),
  147. (@ENTRY35448LOOT10H,'47648','1.7','1','0','1','1'),
  148. (@ENTRY35448LOOT10H,'47646','1.6','1','0','1','1'),
  149. (@ENTRY35448LOOT10H,'47641','1.5','1','0','1','1'),
  150. (@ENTRY35448LOOT10H,'47636','1.5','1','0','1','1'),
  151. (@ENTRY35448LOOT10H,'47653','1.5','1','0','1','1'),
  152. (@ENTRY35448LOOT10H,'47639','1.5','1','0','1','1'),
  153. (@ENTRY35448LOOT10H,'47649','1.4','1','0','1','1'),
  154. (@ENTRY35448LOOT10H,'47652','1.4','1','0','1','1'),
  155. (@ENTRY35448LOOT10H,'47630','1.4','1','0','1','1'),
  156. (@ENTRY35448LOOT10H,'47651','1.3','1','0','1','1'),
  157. (@ENTRY35448LOOT10H,'47625','1.3','1','0','1','1'),
  158. (@ENTRY35448LOOT10H,'47638','1.3','1','0','1','1'),
  159. (@ENTRY35448LOOT10H,'47643','1.3','1','0','1','1'),
  160. (@ENTRY35448LOOT10H,'47631','1.3','1','0','1','1'),
  161. (@ENTRY35448LOOT10H,'47634','1.3','1','0','1','1'),
  162. (@ENTRY35448LOOT10H,'47645','1.2','1','0','1','1'),
  163. (@ENTRY35448LOOT10H,'47657','1.2','1','0','1','1'),
  164. (@ENTRY35448LOOT10H,'47637','1.2','1','0','1','1'),
  165. (@ENTRY35448LOOT10H,'47628','1.2','1','0','1','1'),
  166. (@ENTRY35448LOOT10H,'47642','1.1','1','0','1','1'),
  167. (@ENTRY35448LOOT10H,'47635','1.1','1','0','1','1'),
  168. (@ENTRY35448LOOT10H,'47626','1.1','1','0','1','1'),
  169. (@ENTRY35448LOOT10H,'47632','1.1','1','0','1','1'),
  170. (@ENTRY35448LOOT10H,'47624','1.1','1','0','1','1'),
  171. (@ENTRY35448LOOT10H,'47650','1','1','0','1','1'),
  172. (@ENTRY35448LOOT10H,'47640','1','1','0','1','1'),
  173. (@ENTRY35448LOOT10H,'47654','1','1','0','1','1'),
  174. (@ENTRY35448LOOT10H,'47629','1','1','0','1','1'),
  175. (@ENTRY35448LOOT10H,'47622','1','1','0','1','1'),
  176. (@ENTRY35448LOOT10H,'47655','0.9','1','0','1','1'),
  177. (@ENTRY35448LOOT10H,'47627','0.9','1','0','1','1'),
  178. (@ENTRY35448LOOT10H,'47656','0.8','1','0','1','1'),
  179. (@ENTRY35448LOOT10H,'47623','0.7','1','0','1','1');
  180.  
  181.  
  182. SET @ENTRY35449LOOT25H :=35449;
  183.  
  184. DELETE FROM `creature_loot_template`
  185. WHERE `entry` LIKE @ENTRY35449LOOT25H;
  186.  
  187. insert into `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
  188. values
  189. (@ENTRY35449LOOT25H,'47242','98','1','0','1','1'),
  190. (@ENTRY35449LOOT25H,'47556','92','1','0','1','1'),
  191. (@ENTRY35449LOOT25H,'46975','17','1','0','1','1'),
  192. (@ENTRY35449LOOT25H,'46967','16','1','0','1','1'),
  193. (@ENTRY35449LOOT25H,'46989','16','1','0','1','1'),
  194. (@ENTRY35449LOOT25H,'47414','12','1','0','1','1'),
  195. (@ENTRY35449LOOT25H,'47632','11','1','0','1','1'),
  196. (@ENTRY35449LOOT25H,'47422','11','1','0','1','1'),
  197. (@ENTRY35449LOOT25H,'47419','11','1','0','1','1'),
  198. (@ENTRY35449LOOT25H,'47418','11','1','0','1','1'),
  199. (@ENTRY35449LOOT25H,'47417','11','1','0','1','1'),
  200. (@ENTRY35449LOOT25H,'47424','11','1','0','1','1'),
  201. (@ENTRY35449LOOT25H,'47416','11','1','0','1','1'),
  202. (@ENTRY35449LOOT25H,'47423','10','1','0','1','1'),
  203. (@ENTRY35449LOOT25H,'47412','10','1','0','1','1'),
  204. (@ENTRY35449LOOT25H,'47425','10','1','0','1','1'),
  205. (@ENTRY35449LOOT25H,'47420','9','1','0','1','1'),
  206. (@ENTRY35449LOOT25H,'47426','9','1','0','1','1'),
  207. (@ENTRY35449LOOT25H,'47415','9','1','0','1','1'),
  208. (@ENTRY35449LOOT25H,'47413','9','1','0','1','1'),
  209. (@ENTRY35449LOOT25H,'47421','8','1','0','1','1'),
  210. (@ENTRY35449LOOT25H,'46991','8','1','0','1','1'),
  211. (@ENTRY35449LOOT25H,'46986','8','1','0','1','1'),
  212. (@ENTRY35449LOOT25H,'46971','7','1','0','1','1'),
  213. (@ENTRY35449LOOT25H,'46966','7','1','0','1','1'),
  214. (@ENTRY35449LOOT25H,'46980','7','1','0','1','1'),
  215. (@ENTRY35449LOOT25H,'46965','7','1','0','1','1'),
  216. (@ENTRY35449LOOT25H,'46964','7','1','0','1','1'),
  217. (@ENTRY35449LOOT25H,'46969','7','1','0','1','1'),
  218. (@ENTRY35449LOOT25H,'46968','7','1','0','1','1'),
  219. (@ENTRY35449LOOT25H,'46973','7','1','0','1','1'),
  220. (@ENTRY35449LOOT25H,'46993','6','1','0','1','1'),
  221. (@ENTRY35449LOOT25H,'46977','6','1','0','1','1'),
  222. (@ENTRY35449LOOT25H,'47647','1.6','1','0','1','1'),
  223. (@ENTRY35449LOOT25H,'47653','1.6','1','0','1','1'),
  224. (@ENTRY35449LOOT25H,'47645','1.6','1','0','1','1'),
  225. (@ENTRY35449LOOT25H,'47637','1.6','1','0','1','1'),
  226. (@ENTRY35449LOOT25H,'47636','1.4','1','0','1','1'),
  227. (@ENTRY35449LOOT25H,'47649','1.4','1','0','1','1'),
  228. (@ENTRY35449LOOT25H,'47642','1.4','1','0','1','1'),
  229. (@ENTRY35449LOOT25H,'47643','1.3','1','0','1','1'),
  230. (@ENTRY35449LOOT25H,'47640','1.3','1','0','1','1'),
  231. (@ENTRY35449LOOT25H,'47644','1.2','1','0','1','1'),
  232. (@ENTRY35449LOOT25H,'47639','1.2','1','0','1','1'),
  233. (@ENTRY35449LOOT25H,'47652','1.2','1','0','1','1'),
  234. (@ENTRY35449LOOT25H,'47630','1.2','1','0','1','1'),
  235. (@ENTRY35449LOOT25H,'47651','1.2','1','0','1','1'),
  236. (@ENTRY35449LOOT25H,'47638','1.2','1','0','1','1'),
  237. (@ENTRY35449LOOT25H,'47628','1.2','1','0','1','1'),
  238. (@ENTRY35449LOOT25H,'47624','1.2','1','0','1','1'),
  239. (@ENTRY35449LOOT25H,'47654','1.2','1','0','1','1'),
  240. (@ENTRY35449LOOT25H,'47648','1.1','1','0','1','1'),
  241. (@ENTRY35449LOOT25H,'47650','1.1','1','0','1','1'),
  242. (@ENTRY35449LOOT25H,'47629','1.1','1','0','1','1'),
  243. (@ENTRY35449LOOT25H,'47631','1','1','0','1','1'),
  244. (@ENTRY35449LOOT25H,'47627','1','1','0','1','1'),
  245. (@ENTRY35449LOOT25H,'47646','0.9','1','0','1','1'),
  246. (@ENTRY35449LOOT25H,'47625','0.9','1','0','1','1'),
  247. (@ENTRY35449LOOT25H,'47655','0.9','1','0','1','1'),
  248. (@ENTRY35449LOOT25H,'47623','0.9','1','0','1','1'),
  249. (@ENTRY35449LOOT25H,'47633','0.8','1','0','1','1'),
  250. (@ENTRY35449LOOT25H,'47641','0.8','1','0','1','1'),
  251. (@ENTRY35449LOOT25H,'47657','0.7','1','0','1','1'),
  252. (@ENTRY35449LOOT25H,'47635','0.7','1','0','1','1'),
  253. (@ENTRY35449LOOT25H,'47626','0.7','1','0','1','1'),
  254. (@ENTRY35449LOOT25H,'47622','0.4','1','0','1','1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!