API tools faq
paste
image

S8 - A52

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