API tools faq
paste
frenado05

Untitled

frenado05
Jun 29th, 2025 (edited)
17
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.42 KB | None | 0 0
raw download clone embed print report
  1. -- https://tracker.legionbugs.com/view.php?id=33314
  2. DELETE FROM `gameobject` WHERE `guid` = 63944;
  3.  
  4. -- https://tracker.legionbugs.com/view.php?id=33325
  5. DELETE FROM `reference_loot_template` WHERE `entry` = 22388; -- фиолки
  6. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `MaxExpansion`, `MinExpansion`) VALUES
  7. (22388, 809, 0, 1, 0, 1, 1, 0, 2),
  8. (22388, 810, 0, 1, 0, 1, 1, 0, 2),
  9. (22388, 812, 0, 1, 0, 1, 1, 0, 2),
  10. (22388, 871, 0, 1, 0, 1, 1, 0, 2),
  11. (22388, 940, 0, 1, 0, 1, 1, 0, 2),
  12. (22388, 942, 0, 1, 0, 1, 1, 0, 2),
  13. (22388, 943, 0, 1, 0, 1, 1, 0, 2),
  14. (22388, 1169, 0, 1, 0, 1, 1, 0, 2),
  15. (22388, 1315, 0, 1, 0, 1, 1, 0, 2),
  16. (22388, 1447, 0, 1, 0, 1, 1, 0, 2),
  17. (22388, 1979, 0, 1, 0, 1, 1, 0, 2),
  18. (22388, 2100, 0, 1, 0, 1, 1, 0, 2),
  19. (22388, 2163, 0, 1, 0, 1, 1, 0, 2),
  20. (22388, 2291, 0, 1, 0, 1, 1, 0, 2),
  21. (22388, 2824, 0, 1, 0, 1, 1, 0, 2),
  22. (22388, 2915, 0, 1, 0, 1, 1, 0, 2),
  23. (22388, 3075, 0, 1, 0, 1, 1, 0, 2),
  24. (22388, 14551, 0, 1, 0, 1, 1, 0, 2),
  25. (22388, 14552, 0, 1, 0, 1, 1, 0, 2),
  26. (22388, 17007, 0, 1, 0, 1, 1, 0, 2),
  27. (22388, 22388, 0, 1, 0, 1, 1, 0, 2);
  28.  
  29.  
  30. DELETE FROM `reference_loot_template` WHERE `entry` = 13144; -- синька
  31. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `MaxExpansion`, `MinExpansion`) VALUES
  32. (13144, 754, 0, 1, 0, 1, 1, 0, 2),
  33. (13144, 1203, 0, 1, 0, 1, 1, 0, 2),
  34. (13144, 1607, 0, 1, 0, 1, 1, 0, 2),
  35. (13144, 1720, 0, 1, 0, 1, 1, 0, 2),
  36. (13144, 1721, 0, 1, 0, 1, 1, 0, 2),
  37. (13144, 2564, 0, 1, 0, 1, 1, 0, 2),
  38. (13144, 4090, 0, 1, 0, 1, 1, 0, 2),
  39. (13144, 4091, 0, 1, 0, 1, 1, 0, 2),
  40. (13144, 5266, 0, 1, 0, 1, 1, 0, 2),
  41. (13144, 6660, 0, 1, 0, 1, 1, 0, 2),
  42. (13144, 7734, 0, 1, 0, 1, 1, 0, 2),
  43. (13144, 7991, 0, 1, 0, 1, 1, 0, 2),
  44. (13144, 8190, 0, 1, 0, 1, 1, 0, 2),
  45. (13144, 9433, 0, 1, 0, 1, 1, 0, 2),
  46. (13144, 11302, 0, 1, 0, 1, 1, 0, 2),
  47. (13144, 13008, 0, 1, 0, 1, 1, 0, 2),
  48. (13144, 13009, 0, 1, 0, 1, 1, 0, 2),
  49. (13144, 13014, 0, 1, 0, 1, 1, 0, 2),
  50. (13144, 13018, 0, 1, 0, 1, 1, 0, 2),
  51. (13144, 13021, 0, 1, 0, 1, 1, 0, 2),
  52. (13144, 13022, 0, 1, 0, 1, 1, 0, 2),
  53. (13144, 13027, 0, 1, 0, 1, 1, 0, 2),
  54. (13144, 13030, 0, 1, 0, 1, 1, 0, 2),
  55. (13144, 13035, 0, 1, 0, 1, 1, 0, 2),
  56. (13144, 13039, 0, 1, 0, 1, 1, 0, 2),
  57. (13144, 13043, 0, 1, 0, 1, 1, 0, 2),
  58. (13144, 13046, 0, 1, 0, 1, 1, 0, 2),
  59. (13144, 13052, 0, 1, 0, 1, 1, 0, 2),
  60. (13144, 13055, 0, 1, 0, 1, 1, 0, 2),
  61. (13144, 13059, 0, 1, 0, 1, 1, 0, 2),
  62. (13144, 13065, 0, 1, 0, 1, 1, 0, 2),
  63. (13144, 13066, 0, 1, 0, 1, 1, 0, 2),
  64. (13144, 13067, 0, 1, 0, 1, 1, 0, 2),
  65. (13144, 13073, 0, 1, 0, 1, 1, 0, 2),
  66. (13144, 13074, 0, 1, 0, 1, 1, 0, 2),
  67. (13144, 13076, 0, 1, 0, 1, 1, 0, 2),
  68. (13144, 13082, 0, 1, 0, 1, 1, 0, 2),
  69. (13144, 13085, 0, 1, 0, 1, 1, 0, 2),
  70. (13144, 13089, 0, 1, 0, 1, 1, 0, 2),
  71. (13144, 13102, 0, 1, 0, 1, 1, 0, 2),
  72. (13144, 13109, 0, 1, 0, 1, 1, 0, 2),
  73. (13144, 13111, 0, 1, 0, 1, 1, 0, 2),
  74. (13144, 13112, 0, 1, 0, 1, 1, 0, 2),
  75. (13144, 13120, 0, 1, 0, 1, 1, 0, 2),
  76. (13144, 13122, 0, 1, 0, 1, 1, 0, 2),
  77. (13144, 13125, 0, 1, 0, 1, 1, 0, 2),
  78. (13144, 13126, 0, 1, 0, 1, 1, 0, 2),
  79. (13144, 13128, 0, 1, 0, 1, 1, 0, 2),
  80. (13144, 13134, 0, 1, 0, 1, 1, 0, 2),
  81. (13144, 13139, 0, 1, 0, 1, 1, 0, 2),
  82. (13144, 13144, 0, 1, 0, 1, 1, 0, 2),
  83. (13144, 17050, 0, 1, 0, 1, 1, 0, 2);
  84.  
  85.  
  86. DELETE FROM `reference_loot_template` WHERE `entry` = 21949; -- зелёнка
  87. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `MaxExpansion`, `MinExpansion`) VALUES
  88. (21949, 1608, 0, 1, 0, 1, 1, 0, 2),
  89. (21949, 1639, 0, 1, 0, 1, 1, 0, 2),
  90. (21949, 1685, 0, 1, 0, 1, 1, 0, 2),
  91. (21949, 1994, 0, 1, 0, 1, 1, 0, 2),
  92. (21949, 3208, 0, 1, 0, 1, 1, 0, 2),
  93. (21949, 3395, 0, 1, 0, 1, 1, 0, 2),
  94. (21949, 3914, 0, 1, 0, 1, 1, 0, 2),
  95. (21949, 4069, 0, 1, 0, 1, 1, 0, 2),
  96. (21949, 4088, 0, 1, 0, 1, 1, 0, 2),
  97. (21949, 4089, 0, 1, 0, 1, 1, 0, 2),
  98. (21949, 4500, 0, 1, 0, 1, 1, 0, 2),
  99. (21949, 4733, 0, 1, 0, 1, 1, 0, 2),
  100. (21949, 6427, 0, 1, 0, 1, 1, 0, 2),
  101. (21949, 7113, 0, 1, 0, 1, 1, 0, 2),
  102. (21949, 7517, 0, 1, 0, 1, 1, 0, 2),
  103. (21949, 7518, 0, 1, 0, 1, 1, 0, 2),
  104. (21949, 7519, 0, 1, 0, 1, 1, 0, 2),
  105. (21949, 7520, 0, 1, 0, 1, 1, 0, 2),
  106. (21949, 7521, 0, 1, 0, 1, 1, 0, 2),
  107. (21949, 7523, 0, 1, 0, 1, 1, 0, 2),
  108. (21949, 7526, 0, 1, 0, 1, 1, 0, 2),
  109. (21949, 7527, 0, 1, 0, 1, 1, 0, 2),
  110. (21949, 7528, 0, 1, 0, 1, 1, 0, 2),
  111. (21949, 7529, 0, 1, 0, 1, 1, 0, 2),
  112. (21949, 7530, 0, 1, 0, 1, 1, 0, 2),
  113. (21949, 7531, 0, 1, 0, 1, 1, 0, 2),
  114. (21949, 7535, 0, 1, 0, 1, 1, 0, 2),
  115. (21949, 7536, 0, 1, 0, 1, 1, 0, 2),
  116. (21949, 7538, 0, 1, 0, 1, 1, 0, 2),
  117. (21949, 7541, 0, 1, 0, 1, 1, 0, 2),
  118. (21949, 7543, 0, 1, 0, 1, 1, 0, 2),
  119. (21949, 7546, 0, 1, 0, 1, 1, 0, 2),
  120. (21949, 7553, 0, 1, 0, 1, 1, 0, 2),
  121. (21949, 7611, 0, 1, 0, 1, 1, 0, 2),
  122. (21949, 7909, 0, 1, 0, 1, 1, 0, 2),
  123. (21949, 7910, 0, 1, 0, 1, 1, 0, 2),
  124. (21949, 7989, 0, 1, 0, 1, 1, 0, 2),
  125. (21949, 8107, 0, 1, 0, 1, 1, 0, 2),
  126. (21949, 8108, 0, 1, 0, 1, 1, 0, 2),
  127. (21949, 8110, 0, 1, 0, 1, 1, 0, 2),
  128. (21949, 8111, 0, 1, 0, 1, 1, 0, 2),
  129. (21949, 8112, 0, 1, 0, 1, 1, 0, 2),
  130. (21949, 8113, 0, 1, 0, 1, 1, 0, 2),
  131. (21949, 8114, 0, 1, 0, 1, 1, 0, 2),
  132. (21949, 8118, 0, 1, 0, 1, 1, 0, 2),
  133. (21949, 8119, 0, 1, 0, 1, 1, 0, 2),
  134. (21949, 8121, 0, 1, 0, 1, 1, 0, 2),
  135. (21949, 8123, 0, 1, 0, 1, 1, 0, 2),
  136. (21949, 8124, 0, 1, 0, 1, 1, 0, 2),
  137. (21949, 8125, 0, 1, 0, 1, 1, 0, 2),
  138. (21949, 8126, 0, 1, 0, 1, 1, 0, 2),
  139. (21949, 8127, 0, 1, 0, 1, 1, 0, 2),
  140. (21949, 8128, 0, 1, 0, 1, 1, 0, 2),
  141. (21949, 8129, 0, 1, 0, 1, 1, 0, 2),
  142. (21949, 8130, 0, 1, 0, 1, 1, 0, 2),
  143. (21949, 8131, 0, 1, 0, 1, 1, 0, 2),
  144. (21949, 8132, 0, 1, 0, 1, 1, 0, 2),
  145. (21949, 8134, 0, 1, 0, 1, 1, 0, 2),
  146. (21949, 8199, 0, 1, 0, 1, 1, 0, 2),
  147. (21949, 8246, 0, 1, 0, 1, 1, 0, 2),
  148. (21949, 8247, 0, 1, 0, 1, 1, 0, 2),
  149. (21949, 8248, 0, 1, 0, 1, 1, 0, 2),
  150. (21949, 8249, 0, 1, 0, 1, 1, 0, 2),
  151. (21949, 8250, 0, 1, 0, 1, 1, 0, 2),
  152. (21949, 8251, 0, 1, 0, 1, 1, 0, 2),
  153. (21949, 8253, 0, 1, 0, 1, 1, 0, 2),
  154. (21949, 8254, 0, 1, 0, 1, 1, 0, 2),
  155. (21949, 8256, 0, 1, 0, 1, 1, 0, 2),
  156. (21949, 8259, 0, 1, 0, 1, 1, 0, 2),
  157. (21949, 8260, 0, 1, 0, 1, 1, 0, 2),
  158. (21949, 8261, 0, 1, 0, 1, 1, 0, 2),
  159. (21949, 8263, 0, 1, 0, 1, 1, 0, 2),
  160. (21949, 8270, 0, 1, 0, 1, 1, 0, 2),
  161. (21949, 8272, 0, 1, 0, 1, 1, 0, 2),
  162. (21949, 8274, 0, 1, 0, 1, 1, 0, 2),
  163. (21949, 8276, 0, 1, 0, 1, 1, 0, 2),
  164. (21949, 8277, 0, 1, 0, 1, 1, 0, 2),
  165. (21949, 8278, 0, 1, 0, 1, 1, 0, 2),
  166. (21949, 8279, 0, 1, 0, 1, 1, 0, 2),
  167. (21949, 8281, 0, 1, 0, 1, 1, 0, 2),
  168. (21949, 8282, 0, 1, 0, 1, 1, 0, 2),
  169. (21949, 8286, 0, 1, 0, 1, 1, 0, 2),
  170. (21949, 8297, 0, 1, 0, 1, 1, 0, 2),
  171. (21949, 8316, 0, 1, 0, 1, 1, 0, 2),
  172. (21949, 8319, 0, 1, 0, 1, 1, 0, 2),
  173. (21949, 8385, 0, 1, 0, 1, 1, 0, 2),
  174. (21949, 8387, 0, 1, 0, 1, 1, 0, 2),
  175. (21949, 8389, 0, 1, 0, 1, 1, 0, 2),
  176. (21949, 9298, 0, 1, 0, 1, 1, 0, 2),
  177. (21949, 9905, 0, 1, 0, 1, 1, 0, 2),
  178. (21949, 9911, 0, 1, 0, 1, 1, 0, 2),
  179. (21949, 9922, 0, 1, 0, 1, 1, 0, 2),
  180. (21949, 9936, 0, 1, 0, 1, 1, 0, 2),
  181. (21949, 9940, 0, 1, 0, 1, 1, 0, 2),
  182. (21949, 9941, 0, 1, 0, 1, 1, 0, 2),
  183. (21949, 9942, 0, 1, 0, 1, 1, 0, 2),
  184. (21949, 9943, 0, 1, 0, 1, 1, 0, 2),
  185. (21949, 9944, 0, 1, 0, 1, 1, 0, 2),
  186. (21949, 9945, 0, 1, 0, 1, 1, 0, 2),
  187. (21949, 9946, 0, 1, 0, 1, 1, 0, 2),
  188. (21949, 9947, 0, 1, 0, 1, 1, 0, 2),
  189. (21949, 9951, 0, 1, 0, 1, 1, 0, 2),
  190. (21949, 9952, 0, 1, 0, 1, 1, 0, 2),
  191. (21949, 9953, 0, 1, 0, 1, 1, 0, 2),
  192. (21949, 9955, 0, 1, 0, 1, 1, 0, 2),
  193. (21949, 9957, 0, 1, 0, 1, 1, 0, 2),
  194. (21949, 9962, 0, 1, 0, 1, 1, 0, 2),
  195. (21949, 9965, 0, 1, 0, 1, 1, 0, 2),
  196. (21949, 9974, 0, 1, 0, 1, 1, 0, 2),
  197. (21949, 10058, 0, 1, 0, 1, 1, 0, 2),
  198. (21949, 10059, 0, 1, 0, 1, 1, 0, 2),
  199. (21949, 10060, 0, 1, 0, 1, 1, 0, 2),
  200. (21949, 10062, 0, 1, 0, 1, 1, 0, 2),
  201. (21949, 10063, 0, 1, 0, 1, 1, 0, 2),
  202. (21949, 10064, 0, 1, 0, 1, 1, 0, 2),
  203. (21949, 10066, 0, 1, 0, 1, 1, 0, 2),
  204. (21949, 10067, 0, 1, 0, 1, 1, 0, 2),
  205. (21949, 10068, 0, 1, 0, 1, 1, 0, 2),
  206. (21949, 10069, 0, 1, 0, 1, 1, 0, 2),
  207. (21949, 10070, 0, 1, 0, 1, 1, 0, 2),
  208. (21949, 10072, 0, 1, 0, 1, 1, 0, 2),
  209. (21949, 10073, 0, 1, 0, 1, 1, 0, 2),
  210. (21949, 10074, 0, 1, 0, 1, 1, 0, 2),
  211. (21949, 10076, 0, 1, 0, 1, 1, 0, 2),
  212. (21949, 10082, 0, 1, 0, 1, 1, 0, 2),
  213. (21949, 10084, 0, 1, 0, 1, 1, 0, 2),
  214. (21949, 10085, 0, 1, 0, 1, 1, 0, 2),
  215. (21949, 10087, 0, 1, 0, 1, 1, 0, 2),
  216. (21949, 10090, 0, 1, 0, 1, 1, 0, 2),
  217. (21949, 10091, 0, 1, 0, 1, 1, 0, 2),
  218. (21949, 10093, 0, 1, 0, 1, 1, 0, 2),
  219. (21949, 10098, 0, 1, 0, 1, 1, 0, 2),
  220. (21949, 10099, 0, 1, 0, 1, 1, 0, 2),
  221. (21949, 10103, 0, 1, 0, 1, 1, 0, 2),
  222. (21949, 10107, 0, 1, 0, 1, 1, 0, 2),
  223. (21949, 10109, 0, 1, 0, 1, 1, 0, 2),
  224. (21949, 10120, 0, 1, 0, 1, 1, 0, 2),
  225. (21949, 10127, 0, 1, 0, 1, 1, 0, 2),
  226. (21949, 10128, 0, 1, 0, 1, 1, 0, 2),
  227. (21949, 10133, 0, 1, 0, 1, 1, 0, 2),
  228. (21949, 10134, 0, 1, 0, 1, 1, 0, 2),
  229. (21949, 10165, 0, 1, 0, 1, 1, 0, 2),
  230. (21949, 10166, 0, 1, 0, 1, 1, 0, 2),
  231. (21949, 10171, 0, 1, 0, 1, 1, 0, 2),
  232. (21949, 10172, 0, 1, 0, 1, 1, 0, 2),
  233. (21949, 10173, 0, 1, 0, 1, 1, 0, 2),
  234. (21949, 10174, 0, 1, 0, 1, 1, 0, 2),
  235. (21949, 10175, 0, 1, 0, 1, 1, 0, 2),
  236. (21949, 10176, 0, 1, 0, 1, 1, 0, 2),
  237. (21949, 10179, 0, 1, 0, 1, 1, 0, 2),
  238. (21949, 10180, 0, 1, 0, 1, 1, 0, 2),
  239. (21949, 10185, 0, 1, 0, 1, 1, 0, 2),
  240. (21949, 10186, 0, 1, 0, 1, 1, 0, 2),
  241. (21949, 10187, 0, 1, 0, 1, 1, 0, 2),
  242. (21949, 10189, 0, 1, 0, 1, 1, 0, 2),
  243. (21949, 10193, 0, 1, 0, 1, 1, 0, 2),
  244. (21949, 10198, 0, 1, 0, 1, 1, 0, 2),
  245. (21949, 10201, 0, 1, 0, 1, 1, 0, 2),
  246. (21949, 10202, 0, 1, 0, 1, 1, 0, 2),
  247. (21949, 10205, 0, 1, 0, 1, 1, 0, 2),
  248. (21949, 10231, 0, 1, 0, 1, 1, 0, 2),
  249. (21949, 10244, 0, 1, 0, 1, 1, 0, 2),
  250. (21949, 10245, 0, 1, 0, 1, 1, 0, 2),
  251. (21949, 10315, 0, 1, 0, 1, 1, 0, 2),
  252. (21949, 11208, 0, 1, 0, 1, 1, 0, 2),
  253. (21949, 11974, 0, 1, 0, 1, 1, 0, 2),
  254. (21949, 11989, 0, 1, 0, 1, 1, 0, 2),
  255. (21949, 11999, 0, 1, 0, 1, 1, 0, 2),
  256. (21949, 12001, 0, 1, 0, 1, 1, 0, 2),
  257. (21949, 12002, 0, 1, 0, 1, 1, 0, 2),
  258. (21949, 12014, 0, 1, 0, 1, 1, 0, 2),
  259. (21949, 12024, 0, 1, 0, 1, 1, 0, 2),
  260. (21949, 12034, 0, 1, 0, 1, 1, 0, 2),
  261. (21949, 12682, 0, 1, 0, 1, 1, 0, 2),
  262. (21949, 12683, 0, 1, 0, 1, 1, 0, 2),
  263. (21949, 12684, 0, 1, 0, 1, 1, 0, 2),
  264. (21949, 12689, 0, 1, 0, 1, 1, 0, 2),
  265. (21949, 14467, 0, 1, 0, 1, 1, 0, 2),
  266. (21949, 15216, 0, 1, 0, 1, 1, 0, 2),
  267. (21949, 15217, 0, 1, 0, 1, 1, 0, 2),
  268. (21949, 15227, 0, 1, 0, 1, 1, 0, 2),
  269. (21949, 15228, 0, 1, 0, 1, 1, 0, 2),
  270. (21949, 15229, 0, 1, 0, 1, 1, 0, 2),
  271. (21949, 15235, 0, 1, 0, 1, 1, 0, 2),
  272. (21949, 15236, 0, 1, 0, 1, 1, 0, 2),
  273. (21949, 15237, 0, 1, 0, 1, 1, 0, 2),
  274. (21949, 15245, 0, 1, 0, 1, 1, 0, 2),
  275. (21949, 15252, 0, 1, 0, 1, 1, 0, 2),
  276. (21949, 15253, 0, 1, 0, 1, 1, 0, 2),
  277. (21949, 15254, 0, 1, 0, 1, 1, 0, 2),
  278. (21949, 15262, 0, 1, 0, 1, 1, 0, 2),
  279. (21949, 15263, 0, 1, 0, 1, 1, 0, 2),
  280. (21949, 15270, 0, 1, 0, 1, 1, 0, 2),
  281. (21949, 15274, 0, 1, 0, 1, 1, 0, 2),
  282. (21949, 15275, 0, 1, 0, 1, 1, 0, 2),
  283. (21949, 15279, 0, 1, 0, 1, 1, 0, 2),
  284. (21949, 15280, 0, 1, 0, 1, 1, 0, 2),
  285. (21949, 15291, 0, 1, 0, 1, 1, 0, 2),
  286. (21949, 15294, 0, 1, 0, 1, 1, 0, 2),
  287. (21949, 15295, 0, 1, 0, 1, 1, 0, 2),
  288. (21949, 15323, 0, 1, 0, 1, 1, 0, 2),
  289. (21949, 15737, 0, 1, 0, 1, 1, 0, 2),
  290. (21949, 16215, 0, 1, 0, 1, 1, 0, 2),
  291. (21949, 21947, 0, 1, 0, 1, 1, 0, 2),
  292. (21949, 21949, 0, 1, 0, 1, 1, 0, 2);
  293.  
  294.  
  295. DELETE FROM `item_loot_template` WHERE `entry` = 10752;
  296. INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `MaxExpansion`, `MinExpansion`) VALUES
  297. (10752, 13144, 100, 1, 0, -13144, 1, 0, 2),
  298. (10752, 21949, 30, 1, 0, -21949, 1, 0, 2),
  299. (10752, 22388, 1, 1, 0, -22388, 1, 0, 2);
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!