API tools faq
paste
image

S8 - Gadg

image
Dec 17th, 2011
241
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 15.96 KB | None | 0 0
raw download clone embed print report
  1. -- SEASON 8 VENDORS
  2. -- SPAWN
  3. DELETE FROM `creature` WHERE `id` IN ('33934', '33935', '33939', '34093');
  4. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  5. VALUES
  6. ('33934', '1', '1', '1', '0', '0', '-7120.75', '-3774.16', '9.0363', '0.767945', '600', '0', '0', '6986', '0', '0', '0'),
  7. ('33935', '1', '1', '1', '0', '915', '-7121.21', '-3772.24', '9.10584', '0.417131', '600', '0', '0', '6986', '0', '0', '0'),
  8. ('33939', '1', '1', '1', '0', '0', '-7117.46', '-3779.66', '8.68703', '0.205764', '600', '0', '0', '7000', '0', '0', '0'),
  9. ('34093', '1', '1', '1', '0', '0', '-7126.62', '-3761.68', '9.40626', '0.547374', '600', '0', '0', '6986', '0', '0', '0');
  10.  
  11. -- TEMPLATE UP
  12. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "4224", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33934;
  13. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33935;
  14. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `equipment_id` = "1417", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33939;
  15. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `equipment_id` = "1936", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=34093;
  16.  
  17.  
  18. -- VENDOR PART
  19. -- [33934] - Ecton Brasstumbler
  20. DELETE FROM `npc_vendor` WHERE `entry`='33934';
  21. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  22. VALUES
  23. ('33934', '40787', '0', '0', '2959'),
  24. ('33934', '40788', '0', '0', '2959'),
  25. ('33934', '40789', '0', '0', '2959'),
  26. ('33934', '40807', '0', '0', '2960'),
  27. ('33934', '40808', '0', '0', '2960'),
  28. ('33934', '40809', '0', '0', '2960'),
  29. ('33934', '40826', '0', '0', '2959'),
  30. ('33934', '40827', '0', '0', '2959'),
  31. ('33934', '40828', '0', '0', '2959'),
  32. ('33934', '40847', '0', '0', '2958'),
  33. ('33934', '40848', '0', '0', '2958'),
  34. ('33934', '40849', '0', '0', '2958'),
  35. ('33934', '40866', '0', '0', '2958'),
  36. ('33934', '40868', '0', '0', '2958'),
  37. ('33934', '40869', '0', '0', '2958'),
  38. ('33934', '40907', '0', '0', '2959'),
  39. ('33934', '40927', '0', '0', '2960'),
  40. ('33934', '40933', '0', '0', '2959'),
  41. ('33934', '40939', '0', '0', '2958'),
  42. ('33934', '40963', '0', '0', '2958'),
  43. ('33934', '40992', '0', '0', '2959'),
  44. ('33934', '40993', '0', '0', '2959'),
  45. ('33934', '41001', '0', '0', '2960'),
  46. ('33934', '41007', '0', '0', '2960'),
  47. ('33934', '41013', '0', '0', '2959'),
  48. ('33934', '41019', '0', '0', '2959'),
  49. ('33934', '41027', '0', '0', '2958'),
  50. ('33934', '41033', '0', '0', '2958'),
  51. ('33934', '41038', '0', '0', '2958'),
  52. ('33934', '41044', '0', '0', '2958'),
  53. ('33934', '41081', '0', '0', '2959'),
  54. ('33934', '41087', '0', '0', '2959'),
  55. ('33934', '41137', '0', '0', '2960'),
  56. ('33934', '41143', '0', '0', '2960'),
  57. ('33934', '41151', '0', '0', '2959'),
  58. ('33934', '41157', '0', '0', '2959'),
  59. ('33934', '41199', '0', '0', '2958'),
  60. ('33934', '41205', '0', '0', '2958'),
  61. ('33934', '41211', '0', '0', '2958'),
  62. ('33934', '41217', '0', '0', '2958'),
  63. ('33934', '41275', '0', '0', '2958'),
  64. ('33934', '41281', '0', '0', '2958'),
  65. ('33934', '41287', '0', '0', '2960'),
  66. ('33934', '41293', '0', '0', '2960'),
  67. ('33934', '41298', '0', '0', '2958'),
  68. ('33934', '41304', '0', '0', '2958'),
  69. ('33934', '41310', '0', '0', '2959'),
  70. ('33934', '41316', '0', '0', '2959'),
  71. ('33934', '41321', '0', '0', '2959'),
  72. ('33934', '41327', '0', '0', '2959'),
  73. ('33934', '41650', '0', '0', '2959'),
  74. ('33934', '41655', '0', '0', '2958'),
  75. ('33934', '41661', '0', '0', '2959'),
  76. ('33934', '41667', '0', '0', '2958'),
  77. ('33934', '41672', '0', '0', '2959'),
  78. ('33934', '41678', '0', '0', '2959'),
  79. ('33934', '41683', '0', '0', '2958'),
  80. ('33934', '41715', '0', '0', '2958'),
  81. ('33934', '41767', '0', '0', '2960'),
  82. ('33934', '41773', '0', '0', '2960'),
  83. ('33934', '41854', '0', '0', '2959'),
  84. ('33934', '41859', '0', '0', '2959'),
  85. ('33934', '41864', '0', '0', '2958'),
  86. ('33934', '41869', '0', '0', '2958'),
  87. ('33934', '41874', '0', '0', '2960'),
  88. ('33934', '41915', '0', '0', '2959'),
  89. ('33934', '41921', '0', '0', '2959'),
  90. ('33934', '41927', '0', '0', '2958'),
  91. ('33934', '41934', '0', '0', '2958'),
  92. ('33934', '41940', '0', '0', '2960'),
  93. ('33934', '41946', '0', '0', '2959'),
  94. ('33934', '41953', '0', '0', '2959'),
  95. ('33934', '41959', '0', '0', '2958'),
  96. ('33934', '41965', '0', '0', '2958'),
  97. ('33934', '41971', '0', '0', '2960'),
  98. ('33934', '41993', '0', '0', '2959'),
  99. ('33934', '41998', '0', '0', '2959'),
  100. ('33934', '42005', '0', '0', '2958'),
  101. ('33934', '42011', '0', '0', '2958'),
  102. ('33934', '42017', '0', '0', '2960'),
  103. ('33934', '42579', '0', '0', '2969'),
  104. ('33934', '42584', '0', '0', '2969'),
  105. ('33934', '42589', '0', '0', '2969'),
  106. ('33934', '42598', '0', '0', '2969'),
  107. ('33934', '42603', '0', '0', '2969'),
  108. ('33934', '42608', '0', '0', '2969'),
  109. ('33934', '42615', '0', '0', '2969'),
  110. ('33934', '42621', '0', '0', '2969'),
  111. ('33934', '42853', '0', '0', '2969'),
  112. ('33934', '45706', '0', '0', '2596');
  113.  
  114.  
  115. -- [33935] - Evee Copperspring
  116. DELETE FROM `npc_vendor` WHERE `entry`='33935';
  117. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  118. VALUES
  119. ('33935', '40790', '0', '0', '2956'),
  120. ('33935', '40791', '0', '0', '2956'),
  121. ('33935', '40792', '0', '0', '2956'),
  122. ('33935', '40810', '0', '0', '2957'),
  123. ('33935', '40811', '0', '0', '2957'),
  124. ('33935', '40812', '0', '0', '2957'),
  125. ('33935', '40829', '0', '0', '2956'),
  126. ('33935', '40830', '0', '0', '2956'),
  127. ('33935', '40831', '0', '0', '2956'),
  128. ('33935', '40850', '0', '0', '2956'),
  129. ('33935', '40851', '0', '0', '2956'),
  130. ('33935', '40852', '0', '0', '2956'),
  131. ('33935', '40870', '0', '0', '2955'),
  132. ('33935', '40871', '0', '0', '2955'),
  133. ('33935', '40872', '0', '0', '2955'),
  134. ('33935', '40910', '0', '0', '2956'),
  135. ('33935', '40928', '0', '0', '2957'),
  136. ('33935', '40934', '0', '0', '2956'),
  137. ('33935', '40940', '0', '0', '2956'),
  138. ('33935', '40964', '0', '0', '2955'),
  139. ('33935', '40994', '0', '0', '2956'),
  140. ('33935', '40995', '0', '0', '2956'),
  141. ('33935', '41002', '0', '0', '2957'),
  142. ('33935', '41008', '0', '0', '2957'),
  143. ('33935', '41014', '0', '0', '2956'),
  144. ('33935', '41020', '0', '0', '2956'),
  145. ('33935', '41028', '0', '0', '2956'),
  146. ('33935', '41034', '0', '0', '2956'),
  147. ('33935', '41039', '0', '0', '2955'),
  148. ('33935', '41045', '0', '0', '2955'),
  149. ('33935', '41082', '0', '0', '2956'),
  150. ('33935', '41088', '0', '0', '2956'),
  151. ('33935', '41138', '0', '0', '2957'),
  152. ('33935', '41144', '0', '0', '2957'),
  153. ('33935', '41152', '0', '0', '2956'),
  154. ('33935', '41158', '0', '0', '2956'),
  155. ('33935', '41200', '0', '0', '2956'),
  156. ('33935', '41206', '0', '0', '2956'),
  157. ('33935', '41212', '0', '0', '2955'),
  158. ('33935', '41218', '0', '0', '2955'),
  159. ('33935', '41276', '0', '0', '2955'),
  160. ('33935', '41282', '0', '0', '2955'),
  161. ('33935', '41288', '0', '0', '2957'),
  162. ('33935', '41294', '0', '0', '2957'),
  163. ('33935', '41299', '0', '0', '2956'),
  164. ('33935', '41305', '0', '0', '2956'),
  165. ('33935', '41311', '0', '0', '2956'),
  166. ('33935', '41317', '0', '0', '2956'),
  167. ('33935', '41322', '0', '0', '2956'),
  168. ('33935', '41328', '0', '0', '2956'),
  169. ('33935', '41651', '0', '0', '2956'),
  170. ('33935', '41656', '0', '0', '2956'),
  171. ('33935', '41662', '0', '0', '2956'),
  172. ('33935', '41668', '0', '0', '2956'),
  173. ('33935', '41673', '0', '0', '2956'),
  174. ('33935', '41679', '0', '0', '2956'),
  175. ('33935', '41684', '0', '0', '2955'),
  176. ('33935', '41716', '0', '0', '2955'),
  177. ('33935', '41768', '0', '0', '2957'),
  178. ('33935', '41774', '0', '0', '2957'),
  179. ('33935', '41855', '0', '0', '2956'),
  180. ('33935', '41860', '0', '0', '2956'),
  181. ('33935', '41865', '0', '0', '2956'),
  182. ('33935', '41870', '0', '0', '2955'),
  183. ('33935', '41875', '0', '0', '2957'),
  184. ('33935', '41916', '0', '0', '2956'),
  185. ('33935', '41922', '0', '0', '2956'),
  186. ('33935', '41928', '0', '0', '2956'),
  187. ('33935', '41935', '0', '0', '2955'),
  188. ('33935', '41941', '0', '0', '2957'),
  189. ('33935', '41947', '0', '0', '2956'),
  190. ('33935', '41954', '0', '0', '2956'),
  191. ('33935', '41960', '0', '0', '2956'),
  192. ('33935', '41966', '0', '0', '2955'),
  193. ('33935', '41972', '0', '0', '2957'),
  194. ('33935', '41994', '0', '0', '2956'),
  195. ('33935', '41999', '0', '0', '2956'),
  196. ('33935', '42006', '0', '0', '2956'),
  197. ('33935', '42012', '0', '0', '2955'),
  198. ('33935', '42018', '0', '0', '2957'),
  199. ('33935', '42580', '0', '0', '2608'),
  200. ('33935', '42585', '0', '0', '2608'),
  201. ('33935', '42591', '0', '0', '2608'),
  202. ('33935', '42599', '0', '0', '2608'),
  203. ('33935', '42604', '0', '0', '2608'),
  204. ('33935', '42609', '0', '0', '2608'),
  205. ('33935', '42616', '0', '0', '2608'),
  206. ('33935', '42622', '0', '0', '2608'),
  207. ('33935', '42854', '0', '0', '2608'),
  208. ('33935', '45706', '0', '0', '2596');
  209.  
  210.  
  211. -- [33939] - Argex Irongut
  212. DELETE FROM `npc_vendor` WHERE `entry`='33939';
  213. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  214. VALUES
  215. ('33939', '51388', '0', '0', '2936'),
  216. ('33939', '51390', '0', '0', '2936'),
  217. ('33939', '51392', '0', '0', '2936'),
  218. ('33939', '51394', '0', '0', '2936'),
  219. ('33939', '51396', '0', '0', '2950'),
  220. ('33939', '51397', '0', '0', '2943'),
  221. ('33939', '51400', '0', '0', '2936'),
  222. ('33939', '51402', '0', '0', '2936'),
  223. ('33939', '51404', '0', '0', '2936'),
  224. ('33939', '51406', '0', '0', '2943'),
  225. ('33939', '51407', '0', '0', '2950'),
  226. ('33939', '51408', '0', '0', '2950'),
  227. ('33939', '51409', '0', '0', '2950'),
  228. ('33939', '51410', '0', '0', '2951'),
  229. ('33939', '51411', '0', '0', '2936'),
  230. ('33939', '51413', '0', '0', '2952'),
  231. ('33939', '51414', '0', '0', '2954'),
  232. ('33939', '51415', '0', '0', '2949'),
  233. ('33939', '51416', '0', '0', '2953'),
  234. ('33939', '51417', '0', '0', '2951'),
  235. ('33939', '51418', '0', '0', '2948'),
  236. ('33939', '51419', '0', '0', '2952'),
  237. ('33939', '51420', '0', '0', '2954'),
  238. ('33939', '51421', '0', '0', '2949'),
  239. ('33939', '51422', '0', '0', '2953'),
  240. ('33939', '51423', '0', '0', '2951'),
  241. ('33939', '51424', '0', '0', '2948'),
  242. ('33939', '51425', '0', '0', '2952'),
  243. ('33939', '51426', '0', '0', '2954'),
  244. ('33939', '51427', '0', '0', '2949'),
  245. ('33939', '51428', '0', '0', '2953'),
  246. ('33939', '51429', '0', '0', '2951'),
  247. ('33939', '51430', '0', '0', '2948'),
  248. ('33939', '51431', '0', '0', '2936'),
  249. ('33939', '51433', '0', '0', '2952'),
  250. ('33939', '51434', '0', '0', '2954'),
  251. ('33939', '51435', '0', '0', '2949'),
  252. ('33939', '51436', '0', '0', '2953'),
  253. ('33939', '51437', '0', '0', '2951'),
  254. ('33939', '51438', '0', '0', '2948'),
  255. ('33939', '51439', '0', '0', '2946'),
  256. ('33939', '51441', '0', '0', '2946'),
  257. ('33939', '51443', '0', '0', '2946'),
  258. ('33939', '51445', '0', '0', '2946'),
  259. ('33939', '51447', '0', '0', '2946'),
  260. ('33939', '51449', '0', '0', '2936'),
  261. ('33939', '51451', '0', '0', '2951'),
  262. ('33939', '51452', '0', '0', '2950'),
  263. ('33939', '51453', '0', '0', '2943'),
  264. ('33939', '51455', '0', '0', '2950'),
  265. ('33939', '51456', '0', '0', '2936'),
  266. ('33939', '51458', '0', '0', '2952'),
  267. ('33939', '51459', '0', '0', '2954'),
  268. ('33939', '51460', '0', '0', '2949'),
  269. ('33939', '51461', '0', '0', '2953'),
  270. ('33939', '51462', '0', '0', '2948'),
  271. ('33939', '51463', '0', '0', '2952'),
  272. ('33939', '51464', '0', '0', '2954'),
  273. ('33939', '51465', '0', '0', '2949'),
  274. ('33939', '51466', '0', '0', '2953'),
  275. ('33939', '51467', '0', '0', '2948'),
  276. ('33939', '51468', '0', '0', '2952'),
  277. ('33939', '51469', '0', '0', '2954'),
  278. ('33939', '51470', '0', '0', '2949'),
  279. ('33939', '51471', '0', '0', '2953'),
  280. ('33939', '51472', '0', '0', '2951'),
  281. ('33939', '51473', '0', '0', '2948'),
  282. ('33939', '51474', '0', '0', '2952'),
  283. ('33939', '51475', '0', '0', '2954'),
  284. ('33939', '51476', '0', '0', '2949'),
  285. ('33939', '51477', '0', '0', '2953'),
  286. ('33939', '51478', '0', '0', '2951'),
  287. ('33939', '51479', '0', '0', '2948'),
  288. ('33939', '51480', '0', '0', '2936'),
  289. ('33939', '51482', '0', '0', '2952'),
  290. ('33939', '51483', '0', '0', '2954'),
  291. ('33939', '51484', '0', '0', '2949'),
  292. ('33939', '51485', '0', '0', '2953'),
  293. ('33939', '51486', '0', '0', '2948'),
  294. ('33939', '51487', '0', '0', '2952'),
  295. ('33939', '51488', '0', '0', '2954'),
  296. ('33939', '51489', '0', '0', '2949'),
  297. ('33939', '51490', '0', '0', '2953'),
  298. ('33939', '51491', '0', '0', '2948'),
  299. ('33939', '51492', '0', '0', '2952'),
  300. ('33939', '51493', '0', '0', '2954'),
  301. ('33939', '51494', '0', '0', '2949'),
  302. ('33939', '51495', '0', '0', '2953'),
  303. ('33939', '51496', '0', '0', '2948'),
  304. ('33939', '51497', '0', '0', '2952'),
  305. ('33939', '51498', '0', '0', '2954'),
  306. ('33939', '51499', '0', '0', '2949'),
  307. ('33939', '51500', '0', '0', '2953'),
  308. ('33939', '51501', '0', '0', '2951'),
  309. ('33939', '51502', '0', '0', '2948'),
  310. ('33939', '51503', '0', '0', '2952'),
  311. ('33939', '51504', '0', '0', '2954'),
  312. ('33939', '51505', '0', '0', '2949'),
  313. ('33939', '51506', '0', '0', '2953'),
  314. ('33939', '51507', '0', '0', '2951'),
  315. ('33939', '51508', '0', '0', '2948'),
  316. ('33939', '51509', '0', '0', '2952'),
  317. ('33939', '51510', '0', '0', '2954'),
  318. ('33939', '51511', '0', '0', '2949'),
  319. ('33939', '51512', '0', '0', '2953'),
  320. ('33939', '51513', '0', '0', '2951'),
  321. ('33939', '51514', '0', '0', '2948'),
  322. ('33939', '51515', '0', '0', '2945'),
  323. ('33939', '51517', '0', '0', '2945'),
  324. ('33939', '51519', '0', '0', '2945'),
  325. ('33939', '51521', '0', '0', '2945'),
  326. ('33939', '51523', '0', '0', '2945'),
  327. ('33939', '51525', '0', '0', '2946'),
  328. ('33939', '51527', '0', '0', '2946'),
  329. ('33939', '51530', '0', '0', '2946'),
  330. ('33939', '51531', '0', '0', '2951'),
  331. ('33939', '51532', '0', '0', '2951'),
  332. ('33939', '51533', '0', '0', '2950'),
  333. ('33939', '51535', '0', '0', '2951'),
  334. ('33939', '51536', '0', '0', '2952'),
  335. ('33939', '51537', '0', '0', '2954'),
  336. ('33939', '51538', '0', '0', '2949'),
  337. ('33939', '51539', '0', '0', '2953'),
  338. ('33939', '51540', '0', '0', '2948'),
  339. ('33939', '51541', '0', '0', '2952'),
  340. ('33939', '51542', '0', '0', '2954'),
  341. ('33939', '51543', '0', '0', '2949'),
  342. ('33939', '51544', '0', '0', '2953'),
  343. ('33939', '51545', '0', '0', '2948');
  344.  
  345.  
  346. -- [34093] - Blazzek the Biter
  347. DELETE FROM `npc_vendor` WHERE `entry`='34093';
  348. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  349. VALUES
  350. ('34093', '51389', '0', '0', '2939'),
  351. ('34093', '51391', '0', '0', '2939'),
  352. ('34093', '51393', '0', '0', '2939'),
  353. ('34093', '51395', '0', '0', '2939'),
  354. ('34093', '51398', '0', '0', '2940'),
  355. ('34093', '51399', '0', '0', '2940'),
  356. ('34093', '51401', '0', '0', '2939'),
  357. ('34093', '51403', '0', '0', '2939'),
  358. ('34093', '51405', '0', '0', '2939'),
  359. ('34093', '51412', '0', '0', '2939'),
  360. ('34093', '51432', '0', '0', '2939'),
  361. ('34093', '51440', '0', '0', '2947'),
  362. ('34093', '51442', '0', '0', '2947'),
  363. ('34093', '51444', '0', '0', '2947'),
  364. ('34093', '51446', '0', '0', '2947'),
  365. ('34093', '51448', '0', '0', '2947'),
  366. ('34093', '51450', '0', '0', '2939'),
  367. ('34093', '51454', '0', '0', '2940'),
  368. ('34093', '51457', '0', '0', '2939'),
  369. ('34093', '51481', '0', '0', '2939'),
  370. ('34093', '51516', '0', '0', '2944'),
  371. ('34093', '51518', '0', '0', '2944'),
  372. ('34093', '51520', '0', '0', '2944'),
  373. ('34093', '51522', '0', '0', '2944'),
  374. ('34093', '51524', '0', '0', '2944'),
  375. ('34093', '51526', '0', '0', '2947'),
  376. ('34093', '51528', '0', '0', '2947'),
  377. ('34093', '51529', '0', '0', '2947'),
  378. ('34093', '51534', '0', '0', '2937');
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!