API tools faq
paste
image

S8 - Dala

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