My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Feb 9th, 2010 | Syntax: MySQL | Size: 67.74 KB | Hits: 8 | Expires: Never
Download | Raw | Embed | Report abuse
This paste has a previous version, view the difference. Copy text to clipboard
  1. -- Spawned EoC Vendors
  2. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  3. ('33963','571','1','1','28986','0','5931.81','507.6','650.263','1.8675','300','0','0','10080','8814','0','0'),
  4. ('33964','571','1','1','28987','0','5761.387207','731.868042','653.664246','2.220321','300','0','0','10080','8814','0','0');
  5.  
  6. -- Moved EoV Vendors to new locations
  7. REPLACE INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  8. ('104241','31581','571','1','1','27560','0','5938.955078','510.302307','650.179443','2.630050','300','0','0','10080','8814','0','0'),
  9. ('104206','31579','571','1','1','27559','0','5765.986816','738.268799','653.664734','3.009398','300','0','0','10080','8814','0','0');
  10.  
  11. -- Added EoC Templates
  12. INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
  13. ('33963','45632','0','0','2620'),
  14. ('33963','45633','0','0','2620'),
  15. ('33963','45634','0','0','2620'),
  16. ('33963','45638','0','0','2620'),
  17. ('33963','45639','0','0','2620'),
  18. ('33963','45640','0','0','2620'),
  19. ('33963','45820','0','0','2606'),
  20. ('33963','45822','0','0','2606'),
  21. ('33963','45823','0','0','2606'),
  22. ('33963','45821','0','0','2606'),
  23. ('33963','45819','0','0','2606'),
  24. ('33963','45509','0','0','2606'),
  25. ('33963','45270','0','0','2606'),
  26. ('33963','46138','0','0','2606'),
  27. ('33963','45510','0','0','2606'),
  28. ('33963','45436','0','0','2606'),
  29. ('33963','45145','0','0','2606'),
  30. ('33963','45144','0','0','2606'),
  31. ('33963','45254','0','0','2606'),
  32. ('33963','45114','0','0','2606'),
  33. ('33963','45255','0','0','2606'),
  34. ('33963','45169','0','0','2606'),
  35. ('33963','45833','0','0','2607'),
  36. ('33963','45835','0','0','2607'),
  37. ('33963','45834','0','0','2607'),
  38. ('33963','45837','0','0','2607'),
  39. ('33963','45838','0','0','2607'),
  40. ('33963','45836','0','0','2607'),
  41. ('33963','45839','0','0','2607'),
  42. ('33963','45840','0','0','2607'),
  43. ('33963','45827','0','0','2607'),
  44. ('33963','45830','0','0','2607'),
  45. ('33963','45824','0','0','2607'),
  46. ('33963','45829','0','0','2607'),
  47. ('33963','45826','0','0','2607'),
  48. ('33963','45831','0','0','2607'),
  49. ('33963','45825','0','0','2607'),
  50. ('33963','45828','0','0','2607'),
  51. ('33963','45844','0','0','2630'),
  52. ('33963','45845','0','0','2630'),
  53. ('33963','45846','0','0','2630'),
  54. ('33963','45843','0','0','2630'),
  55. ('33963','45841','0','0','2630'),
  56. ('33963','45848','0','0','2630'),
  57. ('33963','45847','0','0','2630'),
  58. ('33963','45842','0','0','2630'),
  59. ('33963','41086','0','0','2620'),
  60. ('33963','41142','0','0','2631'),
  61. ('33963','41156','0','0','2620'),
  62. ('33963','41204','0','0','2620'),
  63. ('33963','41216','0','0','2631'),
  64. ('33963','41772','0','0','2631'),
  65. ('33963','41677','0','0','2620'),
  66. ('33963','41666','0','0','2620'),
  67. ('33963','41660','0','0','2620'),
  68. ('33963','41714','0','0','2631'),
  69. ('33963','40784','0','0','2620'),
  70. ('33963','40806','0','0','2631'),
  71. ('33963','40824','0','0','2620'),
  72. ('33963','40845','0','0','2620'),
  73. ('33963','40863','0','0','2631'),
  74. ('33963','42010','0','0','2631'),
  75. ('33963','41992','0','0','2620'),
  76. ('33963','42016','0','0','2631'),
  77. ('33963','41997','0','0','2620'),
  78. ('33963','42004','0','0','2620'),
  79. ('33963','41286','0','0','2631'),
  80. ('33963','41320','0','0','2620'),
  81. ('33963','41297','0','0','2620'),
  82. ('33963','41309','0','0','2620'),
  83. ('33963','41274','0','0','2631'),
  84. ('33963','41766','0','0','2631'),
  85. ('33963','41671','0','0','2620'),
  86. ('33963','41654','0','0','2620'),
  87. ('33963','41682','0','0','2631'),
  88. ('33963','41649','0','0','2620'),
  89. ('33963','41080','0','0','2620'),
  90. ('33963','41136','0','0','2631'),
  91. ('33963','41150','0','0','2620'),
  92. ('33963','41198','0','0','2620'),
  93. ('33963','41210','0','0','2631'),
  94. ('33963','40991','0','0','2620'),
  95. ('33963','41006','0','0','2631'),
  96. ('33963','41018','0','0','2620'),
  97. ('33963','41032','0','0','2620'),
  98. ('33963','41043','0','0','2631'),
  99. ('33963','41873','0','0','2631'),
  100. ('33963','41853','0','0','2620'),
  101. ('33963','41863','0','0','2620'),
  102. ('33963','41868','0','0','2631'),
  103. ('33963','41858','0','0','2620'),
  104. ('33963','40905','0','0','2620'),
  105. ('33963','40926','0','0','2631'),
  106. ('33963','40932','0','0','2620'),
  107. ('33963','40938','0','0','2620'),
  108. ('33963','40962','0','0','2631'),
  109. ('33963','40786','0','0','2620'),
  110. ('33963','40804','0','0','2631'),
  111. ('33963','40823','0','0','2620'),
  112. ('33963','40844','0','0','2620'),
  113. ('33963','40862','0','0','2631'),
  114. ('33963','40990','0','0','2620'),
  115. ('33963','41000','0','0','2631'),
  116. ('33963','41012','0','0','2620'),
  117. ('33963','41026','0','0','2620'),
  118. ('33963','41037','0','0','2631'),
  119. ('33963','41939','0','0','2631'),
  120. ('33963','41914','0','0','2620'),
  121. ('33963','41926','0','0','2620'),
  122. ('33963','41933','0','0','2631'),
  123. ('33963','41920','0','0','2620'),
  124. ('33963','40785','0','0','2620'),
  125. ('33963','40805','0','0','2631'),
  126. ('33963','40825','0','0','2620'),
  127. ('33963','40846','0','0','2620'),
  128. ('33963','40864','0','0','2631'),
  129. ('33963','41964','0','0','2631'),
  130. ('33963','41945','0','0','2620'),
  131. ('33963','41970','0','0','2631'),
  132. ('33963','41951','0','0','2620'),
  133. ('33963','41958','0','0','2620'),
  134. ('33963','41292','0','0','2631'),
  135. ('33963','41326','0','0','2620'),
  136. ('33963','41303','0','0','2620'),
  137. ('33963','41315','0','0','2620'),
  138. ('33963','41280','0','0','2631'),
  139. ('33963','40753','0','0','2637'),
  140. ('33963','45087','0','0','2604'),
  141. ('33964','45632','0','0','2620'),
  142. ('33964','45633','0','0','2620'),
  143. ('33964','45634','0','0','2620'),
  144. ('33964','45638','0','0','2620'),
  145. ('33964','45639','0','0','2620'),
  146. ('33964','45640','0','0','2620'),
  147. ('33964','45820','0','0','2606'),
  148. ('33964','45822','0','0','2606'),
  149. ('33964','45823','0','0','2606'),
  150. ('33964','45821','0','0','2606'),
  151. ('33964','45819','0','0','2606'),
  152. ('33964','45509','0','0','2606'),
  153. ('33964','45270','0','0','2606'),
  154. ('33964','46138','0','0','2606'),
  155. ('33964','45510','0','0','2606'),
  156. ('33964','45436','0','0','2606'),
  157. ('33964','45145','0','0','2606'),
  158. ('33964','45144','0','0','2606'),
  159. ('33964','45254','0','0','2606'),
  160. ('33964','45114','0','0','2606'),
  161. ('33964','45255','0','0','2606'),
  162. ('33964','45169','0','0','2606'),
  163. ('33964','45833','0','0','2607'),
  164. ('33964','45835','0','0','2607'),
  165. ('33964','45834','0','0','2607'),
  166. ('33964','45837','0','0','2607'),
  167. ('33964','45838','0','0','2607'),
  168. ('33964','45836','0','0','2607'),
  169. ('33964','45839','0','0','2607'),
  170. ('33964','45840','0','0','2607'),
  171. ('33964','45827','0','0','2607'),
  172. ('33964','45830','0','0','2607'),
  173. ('33964','45824','0','0','2607'),
  174. ('33964','45829','0','0','2607'),
  175. ('33964','45826','0','0','2607'),
  176. ('33964','45831','0','0','2607'),
  177. ('33964','45825','0','0','2607'),
  178. ('33964','45828','0','0','2607'),
  179. ('33964','45844','0','0','2630'),
  180. ('33964','45845','0','0','2630'),
  181. ('33964','45846','0','0','2630'),
  182. ('33964','45843','0','0','2630'),
  183. ('33964','45841','0','0','2630'),
  184. ('33964','45848','0','0','2630'),
  185. ('33964','45847','0','0','2630'),
  186. ('33964','45842','0','0','2630'),
  187. ('33964','41086','0','0','2620'),
  188. ('33964','41142','0','0','2631'),
  189. ('33964','41156','0','0','2620'),
  190. ('33964','41204','0','0','2620'),
  191. ('33964','41216','0','0','2631'),
  192. ('33964','41772','0','0','2631'),
  193. ('33964','41677','0','0','2620'),
  194. ('33964','41666','0','0','2620'),
  195. ('33964','41660','0','0','2620'),
  196. ('33964','41714','0','0','2631'),
  197. ('33964','40784','0','0','2620'),
  198. ('33964','40806','0','0','2631'),
  199. ('33964','40824','0','0','2620'),
  200. ('33964','40845','0','0','2620'),
  201. ('33964','40863','0','0','2631'),
  202. ('33964','42010','0','0','2631'),
  203. ('33964','41992','0','0','2620'),
  204. ('33964','42016','0','0','2631'),
  205. ('33964','41997','0','0','2620'),
  206. ('33964','42004','0','0','2620'),
  207. ('33964','41286','0','0','2631'),
  208. ('33964','41320','0','0','2620'),
  209. ('33964','41297','0','0','2620'),
  210. ('33964','41309','0','0','2620'),
  211. ('33964','41274','0','0','2631'),
  212. ('33964','41766','0','0','2631'),
  213. ('33964','41671','0','0','2620'),
  214. ('33964','41654','0','0','2620'),
  215. ('33964','41682','0','0','2631'),
  216. ('33964','41649','0','0','2620'),
  217. ('33964','41080','0','0','2620'),
  218. ('33964','41136','0','0','2631'),
  219. ('33964','41150','0','0','2620'),
  220. ('33964','41198','0','0','2620'),
  221. ('33964','41210','0','0','2631'),
  222. ('33964','40991','0','0','2620'),
  223. ('33964','41006','0','0','2631'),
  224. ('33964','41018','0','0','2620'),
  225. ('33964','41032','0','0','2620'),
  226. ('33964','41043','0','0','2631'),
  227. ('33964','41873','0','0','2631'),
  228. ('33964','41853','0','0','2620'),
  229. ('33964','41863','0','0','2620'),
  230. ('33964','41868','0','0','2631'),
  231. ('33964','41858','0','0','2620'),
  232. ('33964','40905','0','0','2620'),
  233. ('33964','40926','0','0','2631'),
  234. ('33964','40932','0','0','2620'),
  235. ('33964','40938','0','0','2620'),
  236. ('33964','40962','0','0','2631'),
  237. ('33964','40786','0','0','2620'),
  238. ('33964','40804','0','0','2631'),
  239. ('33964','40823','0','0','2620'),
  240. ('33964','40844','0','0','2620'),
  241. ('33964','40862','0','0','2631'),
  242. ('33964','40990','0','0','2620'),
  243. ('33964','41000','0','0','2631'),
  244. ('33964','41012','0','0','2620'),
  245. ('33964','41026','0','0','2620'),
  246. ('33964','41037','0','0','2631'),
  247. ('33964','41939','0','0','2631'),
  248. ('33964','41914','0','0','2620'),
  249. ('33964','41926','0','0','2620'),
  250. ('33964','41933','0','0','2631'),
  251. ('33964','41920','0','0','2620'),
  252. ('33964','40785','0','0','2620'),
  253. ('33964','40805','0','0','2631'),
  254. ('33964','40825','0','0','2620'),
  255. ('33964','40846','0','0','2620'),
  256. ('33964','40864','0','0','2631'),
  257. ('33964','41964','0','0','2631'),
  258. ('33964','41945','0','0','2620'),
  259. ('33964','41970','0','0','2631'),
  260. ('33964','41951','0','0','2620'),
  261. ('33964','41958','0','0','2620'),
  262. ('33964','41292','0','0','2631'),
  263. ('33964','41326','0','0','2620'),
  264. ('33964','41303','0','0','2620'),
  265. ('33964','41315','0','0','2620'),
  266. ('33964','41280','0','0','2631'),
  267. ('33964','40753','0','0','2637'),
  268. ('33964','45087','0','0','2604');
  269.  
  270. -- Added EoT Vendors
  271. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  272. ('35494','0','0','29832','0','29832','0','Arcanist Miluria','Emblem of Triumph Quartermaster','','80','80','10080','10080','8814','8814','7822','2027','2027','128','1','1','0','345','499','0','287','1','2000','0','8','768','0','0','0','0','0','0','315','468','69','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','2',''),
  273. ('35495','0','0','29831','0','29831','0','Magistrix Vesara','Emblem of Triumph Quartermaster','','80','80','10080','10080','8814','8814','7822','2123','2123','128','1','1','0','345','499','0','287','1','2000','0','8','768','0','0','0','0','0','0','315','468','69','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','2',''),
  274. ('35574','0','0','29851','0','29851','0','Magistrix Iruvia','Emblem of Triumph Quartermaster','','80','80','10080','10080','8814','8814','7822','2123','2123','128','1','1','0','345','499','0','287','1','2000','0','8','768','0','0','0','0','0','0','315','468','69','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','2',''),
  275. ('35573','0','0','29850','0','29850','0','Arcanist Asarina','Emblem of Triumph Quartermaster','','80','80','10080','10080','8814','8814','7822','2027','2027','128','1','1','0','345','499','0','287','1','2000','0','8','768','0','0','0','0','0','0','315','468','69','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','2','');
  276.  
  277. -- Spawned EoT Vendors
  278. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  279. ('35494','571','1','1','29832','0','5764.579590','734.262573','653.664795','2.510629','300','0','0','10080','8814','0','0'),
  280. ('35495','571','1','1','29831','0','5935.081543','507.298462','650.179993','2.170845','300','0','0','10080','8814','0','0'),
  281. ('35574','571','1','1','29851','0','8503.544922','724.593750','558.526733','6.134700','300','0','0','10080','8814','0','0'),
  282. ('35573','571','1','1','29850','0','8528.499023','724.725647','558.525513','3.005683','300','0','0','10080','8814','0','0');
  283.  
  284. -- Added EoT Templates
  285. INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
  286. ('35494','47671','0','0','2682'),
  287. ('35494','47670','0','0','2682'),
  288. ('35494','47668','0','0','2682'),
  289. ('35494','47664','0','0','2682'),
  290. ('35494','47661','0','0','2682'),
  291. ('35494','47662','0','0','2682'),
  292. ('35494','47672','0','0','2682'),
  293. ('35494','47673','0','0','2682'),
  294. ('35494','47665','0','0','2682'),
  295. ('35494','47666','0','0','2682'),
  296. ('35494','47667','0','0','2682'),
  297. ('35494','47660','0','0','2682'),
  298. ('35494','47659','0','0','2682'),
  299. ('35494','47658','0','0','2682'),
  300. ('35494','47732','0','0','2685'),
  301. ('35494','47729','0','0','2685'),
  302. ('35494','47731','0','0','2685'),
  303. ('35494','47730','0','0','2685'),
  304. ('35494','47733','0','0','2685'),
  305. ('35494','47713','0','0','2709'),
  306. ('35494','47715','0','0','2709'),
  307. ('35494','47708','0','0','2709'),
  308. ('35494','47712','0','0','2709'),
  309. ('35494','47704','0','0','2709'),
  310. ('35494','47707','0','0','2709'),
  311. ('35494','47697','0','0','2709'),
  312. ('35494','47702','0','0','2709'),
  313. ('35494','47698','0','0','2709'),
  314. ('35494','47735','0','0','2686'),
  315. ('35494','47734','0','0','2686'),
  316. ('35494','48722','0','0','2686'),
  317. ('35494','48724','0','0','2686'),
  318. ('35494','47694','0','0','2708'),
  319. ('35494','47693','0','0','2708'),
  320. ('35494','47690','0','0','2708'),
  321. ('35494','47689','0','0','2708'),
  322. ('35494','47686','0','0','2708'),
  323. ('35494','47685','0','0','2708'),
  324. ('35494','47677','0','0','2708'),
  325. ('35494','47681','0','0','2708'),
  326. ('35494','47674','0','0','2708'),
  327. ('35494','41087','0','0','2708'),
  328. ('35494','41143','0','0','2686'),
  329. ('35494','41157','0','0','2708'),
  330. ('35494','41205','0','0','2708'),
  331. ('35494','41217','0','0','2686'),
  332. ('35494','41773','0','0','2686'),
  333. ('35494','41678','0','0','2708'),
  334. ('35494','41667','0','0','2708'),
  335. ('35494','41661','0','0','2708'),
  336. ('35494','41715','0','0','2686'),
  337. ('35494','40787','0','0','2708'),
  338. ('35494','40809','0','0','2686'),
  339. ('35494','40827','0','0','2708'),
  340. ('35494','40848','0','0','2708'),
  341. ('35494','40868','0','0','2686'),
  342. ('35494','42011','0','0','2686'),
  343. ('35494','41993','0','0','2708'),
  344. ('35494','42017','0','0','2686'),
  345. ('35494','41998','0','0','2708'),
  346. ('35494','42005','0','0','2708'),
  347. ('35494','41287','0','0','2686'),
  348. ('35494','41321','0','0','2708'),
  349. ('35494','41298','0','0','2708'),
  350. ('35494','41310','0','0','2708'),
  351. ('35494','41275','0','0','2686'),
  352. ('35494','41767','0','0','2686'),
  353. ('35494','41672','0','0','2708'),
  354. ('35494','41655','0','0','2708'),
  355. ('35494','41683','0','0','2686'),
  356. ('35494','41650','0','0','2708'),
  357. ('35494','41081','0','0','2708'),
  358. ('35494','41137','0','0','2686'),
  359. ('35494','41151','0','0','2708'),
  360. ('35494','41199','0','0','2708'),
  361. ('35494','41211','0','0','2686'),
  362. ('35494','40993','0','0','2708'),
  363. ('35494','41007','0','0','2686'),
  364. ('35494','41019','0','0','2708'),
  365. ('35494','41033','0','0','2708'),
  366. ('35494','41044','0','0','2686'),
  367. ('35494','41874','0','0','2686'),
  368. ('35494','41854','0','0','2708'),
  369. ('35494','41864','0','0','2708'),
  370. ('35494','41869','0','0','2686'),
  371. ('35494','41859','0','0','2708'),
  372. ('35494','40907','0','0','2708'),
  373. ('35494','40927','0','0','2686'),
  374. ('35494','40933','0','0','2708'),
  375. ('35494','40939','0','0','2708'),
  376. ('35494','40963','0','0','2686'),
  377. ('35494','40789','0','0','2708'),
  378. ('35494','40807','0','0','2686'),
  379. ('35494','40826','0','0','2708'),
  380. ('35494','40847','0','0','2708'),
  381. ('35494','40866','0','0','2686'),
  382. ('35494','40992','0','0','2708'),
  383. ('35494','41001','0','0','2686'),
  384. ('35494','41013','0','0','2708'),
  385. ('35494','41027','0','0','2708'),
  386. ('35494','41038','0','0','2686'),
  387. ('35494','41940','0','0','2686'),
  388. ('35494','41915','0','0','2708'),
  389. ('35494','41927','0','0','2708'),
  390. ('35494','41934','0','0','2686'),
  391. ('35494','41921','0','0','2708'),
  392. ('35494','40788','0','0','2708'),
  393. ('35494','40808','0','0','2686'),
  394. ('35494','40828','0','0','2708'),
  395. ('35494','40849','0','0','2708'),
  396. ('35494','40869','0','0','2686'),
  397. ('35494','41965','0','0','2686'),
  398. ('35494','41946','0','0','2708'),
  399. ('35494','41971','0','0','2686'),
  400. ('35494','41953','0','0','2708'),
  401. ('35494','41959','0','0','2708'),
  402. ('35494','41293','0','0','2686'),
  403. ('35494','41327','0','0','2708'),
  404. ('35494','41304','0','0','2708'),
  405. ('35494','41316','0','0','2708'),
  406. ('35494','41281','0','0','2686'),
  407. ('35495','47671','0','0','2682'),
  408. ('35495','47670','0','0','2682'),
  409. ('35495','47668','0','0','2682'),
  410. ('35495','47664','0','0','2682'),
  411. ('35495','47661','0','0','2682'),
  412. ('35495','47662','0','0','2682'),
  413. ('35495','47672','0','0','2682'),
  414. ('35495','47673','0','0','2682'),
  415. ('35495','47665','0','0','2682'),
  416. ('35495','47666','0','0','2682'),
  417. ('35495','47667','0','0','2682'),
  418. ('35495','47660','0','0','2682'),
  419. ('35495','47659','0','0','2682'),
  420. ('35495','47658','0','0','2682'),
  421. ('35495','47732','0','0','2685'),
  422. ('35495','47729','0','0','2685'),
  423. ('35495','47731','0','0','2685'),
  424. ('35495','47730','0','0','2685'),
  425. ('35495','47733','0','0','2685'),
  426. ('35495','47713','0','0','2709'),
  427. ('35495','47715','0','0','2709'),
  428. ('35495','47708','0','0','2709'),
  429. ('35495','47712','0','0','2709'),
  430. ('35495','47704','0','0','2709'),
  431. ('35495','47707','0','0','2709'),
  432. ('35495','47697','0','0','2709'),
  433. ('35495','47702','0','0','2709'),
  434. ('35495','47698','0','0','2709'),
  435. ('35495','47735','0','0','2686'),
  436. ('35495','47734','0','0','2686'),
  437. ('35495','48722','0','0','2686'),
  438. ('35495','48724','0','0','2686'),
  439. ('35495','47694','0','0','2708'),
  440. ('35495','47693','0','0','2708'),
  441. ('35495','47690','0','0','2708'),
  442. ('35495','47689','0','0','2708'),
  443. ('35495','47686','0','0','2708'),
  444. ('35495','47685','0','0','2708'),
  445. ('35495','47677','0','0','2708'),
  446. ('35495','47681','0','0','2708'),
  447. ('35495','47674','0','0','2708'),
  448. ('35495','41087','0','0','2708'),
  449. ('35495','41143','0','0','2686'),
  450. ('35495','41157','0','0','2708'),
  451. ('35495','41205','0','0','2708'),
  452. ('35495','41217','0','0','2686'),
  453. ('35495','41773','0','0','2686'),
  454. ('35495','41678','0','0','2708'),
  455. ('35495','41667','0','0','2708'),
  456. ('35495','41661','0','0','2708'),
  457. ('35495','41715','0','0','2686'),
  458. ('35495','40787','0','0','2708'),
  459. ('35495','40809','0','0','2686'),
  460. ('35495','40827','0','0','2708'),
  461. ('35495','40848','0','0','2708'),
  462. ('35495','40868','0','0','2686'),
  463. ('35495','42011','0','0','2686'),
  464. ('35495','41993','0','0','2708'),
  465. ('35495','42017','0','0','2686'),
  466. ('35495','41998','0','0','2708'),
  467. ('35495','42005','0','0','2708'),
  468. ('35495','41287','0','0','2686'),
  469. ('35495','41321','0','0','2708'),
  470. ('35495','41298','0','0','2708'),
  471. ('35495','41310','0','0','2708'),
  472. ('35495','41275','0','0','2686'),
  473. ('35495','41767','0','0','2686'),
  474. ('35495','41672','0','0','2708'),
  475. ('35495','41655','0','0','2708'),
  476. ('35495','41683','0','0','2686'),
  477. ('35495','41650','0','0','2708'),
  478. ('35495','41081','0','0','2708'),
  479. ('35495','41137','0','0','2686'),
  480. ('35495','41151','0','0','2708'),
  481. ('35495','41199','0','0','2708'),
  482. ('35495','41211','0','0','2686'),
  483. ('35495','40993','0','0','2708'),
  484. ('35495','41007','0','0','2686'),
  485. ('35495','41019','0','0','2708'),
  486. ('35495','41033','0','0','2708'),
  487. ('35495','41044','0','0','2686'),
  488. ('35495','41874','0','0','2686'),
  489. ('35495','41854','0','0','2708'),
  490. ('35495','41864','0','0','2708'),
  491. ('35495','41869','0','0','2686'),
  492. ('35495','41859','0','0','2708'),
  493. ('35495','40907','0','0','2708'),
  494. ('35495','40927','0','0','2686'),
  495. ('35495','40933','0','0','2708'),
  496. ('35495','40939','0','0','2708'),
  497. ('35495','40963','0','0','2686'),
  498. ('35495','40789','0','0','2708'),
  499. ('35495','40807','0','0','2686'),
  500. ('35495','40826','0','0','2708'),
  501. ('35495','40847','0','0','2708'),
  502. ('35495','40866','0','0','2686'),
  503. ('35495','40992','0','0','2708'),
  504. ('35495','41001','0','0','2686'),
  505. ('35495','41013','0','0','2708'),
  506. ('35495','41027','0','0','2708'),
  507. ('35495','41038','0','0','2686'),
  508. ('35495','41940','0','0','2686'),
  509. ('35495','41915','0','0','2708'),
  510. ('35495','41927','0','0','2708'),
  511. ('35495','41934','0','0','2686'),
  512. ('35495','41921','0','0','2708'),
  513. ('35495','40788','0','0','2708'),
  514. ('35495','40808','0','0','2686'),
  515. ('35495','40828','0','0','2708'),
  516. ('35495','40849','0','0','2708'),
  517. ('35495','40869','0','0','2686'),
  518. ('35495','41965','0','0','2686'),
  519. ('35495','41946','0','0','2708'),
  520. ('35495','41971','0','0','2686'),
  521. ('35495','41953','0','0','2708'),
  522. ('35495','41959','0','0','2708'),
  523. ('35495','41293','0','0','2686'),
  524. ('35495','41327','0','0','2708'),
  525. ('35495','41304','0','0','2708'),
  526. ('35495','41316','0','0','2708'),
  527. ('35495','41281','0','0','2686'),
  528. ('35573','47671','0','0','2682'),
  529. ('35573','47670','0','0','2682'),
  530. ('35573','47668','0','0','2682'),
  531. ('35573','47664','0','0','2682'),
  532. ('35573','47661','0','0','2682'),
  533. ('35573','47662','0','0','2682'),
  534. ('35573','47672','0','0','2682'),
  535. ('35573','47673','0','0','2682'),
  536. ('35573','47665','0','0','2682'),
  537. ('35573','47666','0','0','2682'),
  538. ('35573','47667','0','0','2682'),
  539. ('35573','47660','0','0','2682'),
  540. ('35573','47659','0','0','2682'),
  541. ('35573','47658','0','0','2682'),
  542. ('35573','47732','0','0','2685'),
  543. ('35573','47729','0','0','2685'),
  544. ('35573','47731','0','0','2685'),
  545. ('35573','47730','0','0','2685'),
  546. ('35573','47733','0','0','2685'),
  547. ('35573','47713','0','0','2709'),
  548. ('35573','47715','0','0','2709'),
  549. ('35573','47708','0','0','2709'),
  550. ('35573','47712','0','0','2709'),
  551. ('35573','47704','0','0','2709'),
  552. ('35573','47707','0','0','2709'),
  553. ('35573','47697','0','0','2709'),
  554. ('35573','47702','0','0','2709'),
  555. ('35573','47698','0','0','2709'),
  556. ('35573','47735','0','0','2686'),
  557. ('35573','47734','0','0','2686'),
  558. ('35573','48722','0','0','2686'),
  559. ('35573','48724','0','0','2686'),
  560. ('35573','47694','0','0','2708'),
  561. ('35573','47693','0','0','2708'),
  562. ('35573','47690','0','0','2708'),
  563. ('35573','47689','0','0','2708'),
  564. ('35573','47686','0','0','2708'),
  565. ('35573','47685','0','0','2708'),
  566. ('35573','47677','0','0','2708'),
  567. ('35573','47681','0','0','2708'),
  568. ('35573','47674','0','0','2708'),
  569. ('35573','41087','0','0','2708'),
  570. ('35573','41143','0','0','2686'),
  571. ('35573','41157','0','0','2708'),
  572. ('35573','41205','0','0','2708'),
  573. ('35573','41217','0','0','2686'),
  574. ('35573','41773','0','0','2686'),
  575. ('35573','41678','0','0','2708'),
  576. ('35573','41667','0','0','2708'),
  577. ('35573','41661','0','0','2708'),
  578. ('35573','41715','0','0','2686'),
  579. ('35573','40787','0','0','2708'),
  580. ('35573','40809','0','0','2686'),
  581. ('35573','40827','0','0','2708'),
  582. ('35573','40848','0','0','2708'),
  583. ('35573','40868','0','0','2686'),
  584. ('35573','42011','0','0','2686'),
  585. ('35573','41993','0','0','2708'),
  586. ('35573','42017','0','0','2686'),
  587. ('35573','41998','0','0','2708'),
  588. ('35573','42005','0','0','2708'),
  589. ('35573','41287','0','0','2686'),
  590. ('35573','41321','0','0','2708'),
  591. ('35573','41298','0','0','2708'),
  592. ('35573','41310','0','0','2708'),
  593. ('35573','41275','0','0','2686'),
  594. ('35573','41767','0','0','2686'),
  595. ('35573','41672','0','0','2708'),
  596. ('35573','41655','0','0','2708'),
  597. ('35573','41683','0','0','2686'),
  598. ('35573','41650','0','0','2708'),
  599. ('35573','41081','0','0','2708'),
  600. ('35573','41137','0','0','2686'),
  601. ('35573','41151','0','0','2708'),
  602. ('35573','41199','0','0','2708'),
  603. ('35573','41211','0','0','2686'),
  604. ('35573','40993','0','0','2708'),
  605. ('35573','41007','0','0','2686'),
  606. ('35573','41019','0','0','2708'),
  607. ('35573','41033','0','0','2708'),
  608. ('35573','41044','0','0','2686'),
  609. ('35573','41874','0','0','2686'),
  610. ('35573','41854','0','0','2708'),
  611. ('35573','41864','0','0','2708'),
  612. ('35573','41869','0','0','2686'),
  613. ('35573','41859','0','0','2708'),
  614. ('35573','40907','0','0','2708'),
  615. ('35573','40927','0','0','2686'),
  616. ('35573','40933','0','0','2708'),
  617. ('35573','40939','0','0','2708'),
  618. ('35573','40963','0','0','2686'),
  619. ('35573','40789','0','0','2708'),
  620. ('35573','40807','0','0','2686'),
  621. ('35573','40826','0','0','2708'),
  622. ('35573','40847','0','0','2708'),
  623. ('35573','40866','0','0','2686'),
  624. ('35573','40992','0','0','2708'),
  625. ('35573','41001','0','0','2686'),
  626. ('35573','41013','0','0','2708'),
  627. ('35573','41027','0','0','2708'),
  628. ('35573','41038','0','0','2686'),
  629. ('35573','41940','0','0','2686'),
  630. ('35573','41915','0','0','2708'),
  631. ('35573','41927','0','0','2708'),
  632. ('35573','41934','0','0','2686'),
  633. ('35573','41921','0','0','2708'),
  634. ('35573','40788','0','0','2708'),
  635. ('35573','40808','0','0','2686'),
  636. ('35573','40828','0','0','2708'),
  637. ('35573','40849','0','0','2708'),
  638. ('35573','40869','0','0','2686'),
  639. ('35573','41965','0','0','2686'),
  640. ('35573','41946','0','0','2708'),
  641. ('35573','41971','0','0','2686'),
  642. ('35573','41953','0','0','2708'),
  643. ('35573','41959','0','0','2708'),
  644. ('35573','41293','0','0','2686'),
  645. ('35573','41327','0','0','2708'),
  646. ('35573','41304','0','0','2708'),
  647. ('35573','41316','0','0','2708'),
  648. ('35573','41281','0','0','2686'),
  649. ('35574','47671','0','0','2682'),
  650. ('35574','47670','0','0','2682'),
  651. ('35574','47668','0','0','2682'),
  652. ('35574','47664','0','0','2682'),
  653. ('35574','47661','0','0','2682'),
  654. ('35574','47662','0','0','2682'),
  655. ('35574','47672','0','0','2682'),
  656. ('35574','47673','0','0','2682'),
  657. ('35574','47665','0','0','2682'),
  658. ('35574','47666','0','0','2682'),
  659. ('35574','47667','0','0','2682'),
  660. ('35574','47660','0','0','2682'),
  661. ('35574','47659','0','0','2682'),
  662. ('35574','47658','0','0','2682'),
  663. ('35574','47732','0','0','2685'),
  664. ('35574','47729','0','0','2685'),
  665. ('35574','47731','0','0','2685'),
  666. ('35574','47730','0','0','2685'),
  667. ('35574','47733','0','0','2685'),
  668. ('35574','47713','0','0','2709'),
  669. ('35574','47715','0','0','2709'),
  670. ('35574','47708','0','0','2709'),
  671. ('35574','47712','0','0','2709'),
  672. ('35574','47704','0','0','2709'),
  673. ('35574','47707','0','0','2709'),
  674. ('35574','47697','0','0','2709'),
  675. ('35574','47702','0','0','2709'),
  676. ('35574','47698','0','0','2709'),
  677. ('35574','47735','0','0','2686'),
  678. ('35574','47734','0','0','2686'),
  679. ('35574','48722','0','0','2686'),
  680. ('35574','48724','0','0','2686'),
  681. ('35574','47694','0','0','2708'),
  682. ('35574','47693','0','0','2708'),
  683. ('35574','47690','0','0','2708'),
  684. ('35574','47689','0','0','2708'),
  685. ('35574','47686','0','0','2708'),
  686. ('35574','47685','0','0','2708'),
  687. ('35574','47677','0','0','2708'),
  688. ('35574','47681','0','0','2708'),
  689. ('35574','47674','0','0','2708'),
  690. ('35574','41087','0','0','2708'),
  691. ('35574','41143','0','0','2686'),
  692. ('35574','41157','0','0','2708'),
  693. ('35574','41205','0','0','2708'),
  694. ('35574','41217','0','0','2686'),
  695. ('35574','41773','0','0','2686'),
  696. ('35574','41678','0','0','2708'),
  697. ('35574','41667','0','0','2708'),
  698. ('35574','41661','0','0','2708'),
  699. ('35574','41715','0','0','2686'),
  700. ('35574','40787','0','0','2708'),
  701. ('35574','40809','0','0','2686'),
  702. ('35574','40827','0','0','2708'),
  703. ('35574','40848','0','0','2708'),
  704. ('35574','40868','0','0','2686'),
  705. ('35574','42011','0','0','2686'),
  706. ('35574','41993','0','0','2708'),
  707. ('35574','42017','0','0','2686'),
  708. ('35574','41998','0','0','2708'),
  709. ('35574','42005','0','0','2708'),
  710. ('35574','41287','0','0','2686'),
  711. ('35574','41321','0','0','2708'),
  712. ('35574','41298','0','0','2708'),
  713. ('35574','41310','0','0','2708'),
  714. ('35574','41275','0','0','2686'),
  715. ('35574','41767','0','0','2686'),
  716. ('35574','41672','0','0','2708'),
  717. ('35574','41655','0','0','2708'),
  718. ('35574','41683','0','0','2686'),
  719. ('35574','41650','0','0','2708'),
  720. ('35574','41081','0','0','2708'),
  721. ('35574','41137','0','0','2686'),
  722. ('35574','41151','0','0','2708'),
  723. ('35574','41199','0','0','2708'),
  724. ('35574','41211','0','0','2686'),
  725. ('35574','40993','0','0','2708'),
  726. ('35574','41007','0','0','2686'),
  727. ('35574','41019','0','0','2708'),
  728. ('35574','41033','0','0','2708'),
  729. ('35574','41044','0','0','2686'),
  730. ('35574','41874','0','0','2686'),
  731. ('35574','41854','0','0','2708'),
  732. ('35574','41864','0','0','2708'),
  733. ('35574','41869','0','0','2686'),
  734. ('35574','41859','0','0','2708'),
  735. ('35574','40907','0','0','2708'),
  736. ('35574','40927','0','0','2686'),
  737. ('35574','40933','0','0','2708'),
  738. ('35574','40939','0','0','2708'),
  739. ('35574','40963','0','0','2686'),
  740. ('35574','40789','0','0','2708'),
  741. ('35574','40807','0','0','2686'),
  742. ('35574','40826','0','0','2708'),
  743. ('35574','40847','0','0','2708'),
  744. ('35574','40866','0','0','2686'),
  745. ('35574','40992','0','0','2708'),
  746. ('35574','41001','0','0','2686'),
  747. ('35574','41013','0','0','2708'),
  748. ('35574','41027','0','0','2708'),
  749. ('35574','41038','0','0','2686'),
  750. ('35574','41940','0','0','2686'),
  751. ('35574','41915','0','0','2708'),
  752. ('35574','41927','0','0','2708'),
  753. ('35574','41934','0','0','2686'),
  754. ('35574','41921','0','0','2708'),
  755. ('35574','40788','0','0','2708'),
  756. ('35574','40808','0','0','2686'),
  757. ('35574','40828','0','0','2708'),
  758. ('35574','40849','0','0','2708'),
  759. ('35574','40869','0','0','2686'),
  760. ('35574','41965','0','0','2686'),
  761. ('35574','41946','0','0','2708'),
  762. ('35574','41971','0','0','2686'),
  763. ('35574','41953','0','0','2708'),
  764. ('35574','41959','0','0','2708'),
  765. ('35574','41293','0','0','2686'),
  766. ('35574','41327','0','0','2708'),
  767. ('35574','41304','0','0','2708'),
  768. ('35574','41316','0','0','2708'),
  769. ('35574','41281','0','0','2686');
  770.  
  771. -- Captain Dirgehammer
  772. UPDATE `creature` SET `id` = '34073' WHERE `id` = '32381';
  773. INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`extendedcost`) VALUES
  774. (34073,41908,0,0,2560),
  775. (34073,41892,0,0,2560),
  776. (34073,41639,0,0,2560),
  777. (34073,41624,0,0,2560),
  778. (34073,41839,0,0,2560),
  779. (34073,41064,0,0,2560),
  780. (34073,41059,0,0,2560),
  781. (34073,41224,0,0,2560),
  782. (34073,40982,0,0,2560),
  783. (34073,40888,0,0,2560),
  784. (34073,41897,0,0,2559),
  785. (34073,41880,0,0,2559),
  786. (34073,41629,0,0,2559),
  787. (34073,41616,0,0,2559),
  788. (34073,41831,0,0,2559),
  789. (34073,41069,0,0,2559),
  790. (34073,41048,0,0,2559),
  791. (34073,41234,0,0,2559),
  792. (34073,40974,0,0,2559),
  793. (34073,40879,0,0,2559),
  794. (34073,41902,0,0,2559),
  795. (34073,41884,0,0,2559),
  796. (34073,41634,0,0,2559),
  797. (34073,41620,0,0,2559),
  798. (34073,41835,0,0,2559),
  799. (34073,41074,0,0,2559),
  800. (34073,41054,0,0,2559),
  801. (34073,41229,0,0,2559),
  802. (34073,40975,0,0,2559),
  803. (34073,40880,0,0,2559),
  804. (34073,42064,0,0,2561),
  805. (34073,42066,0,0,2561),
  806. (34073,42062,0,0,2561),
  807. (34073,42065,0,0,2561),
  808. (34073,42063,0,0,2561),
  809. (34073,42067,0,0,2561),
  810. (34073,42068,0,0,2561),
  811. (34073,42030,0,0,2561),
  812. (34073,42032,0,0,2561),
  813. (34073,42029,0,0,2561),
  814. (34073,42033,0,0,2561),
  815. (34073,42031,0,0,2561),
  816. (34073,42027,0,0,2561),
  817. (34073,42028,0,0,2561),
  818. (34073,42110,0,0,2605),
  819. (34073,42112,0,0,2605),
  820. (34073,42114,0,0,2561),
  821. (34073,42115,0,0,2561),
  822. (34073,42129,0,0,2559),
  823. (34073,42130,0,0,2559),
  824. (34073,42132,0,0,2559),
  825. (34073,42131,0,0,2559),
  826. (34073,42128,0,0,2559),
  827. (34073,42123,0,0,2605);
  828.  
  829. -- Captain ONeal
  830. INSERT INTO npc_vendor (entry,item,maxcount,incrtime,extendedcost) VALUES
  831. (34079, 36921, 0, 0, 2588),
  832. (34079, 36933, 0, 0, 2588),
  833. (34079, 36930, 0, 0, 2588),
  834. (34079, 36918, 0, 0, 2588),
  835. (34079, 36924, 0, 0, 2588),
  836. (34079, 36927, 0, 0, 2588),
  837. (34079, 41569, 0, 0, 2426),
  838. (34079, 41571, 0, 0, 2426),
  839. (34079, 41572, 0, 0, 2426),
  840. (34079, 41575, 0, 0, 2426),
  841. (34079, 41564, 0, 0, 2426),
  842. (34079, 41570, 0, 0, 2426),
  843. (34079, 41573, 0, 0, 2426),
  844. (34079, 41559, 0, 0, 2426),
  845. (34079, 41560, 0, 0, 2426),
  846. (34079, 41563, 0, 0, 2426),
  847. (34079, 41565, 0, 0, 2426),
  848. (34079, 41566, 0, 0, 2426);
  849.  
  850. -- Lieutenant Tristia
  851. INSERT INTO npc_vendor (entry,item,maxcount,incrtime,extendedcost) VALUES
  852. (34076, 41909, 0, 0, 2614),
  853. (34076, 41893, 0, 0, 2614),
  854. (34076, 41640, 0, 0, 2614),
  855. (34076, 41625, 0, 0, 2614),
  856. (34076, 41840, 0, 0, 2614),
  857. (34076, 41065, 0, 0, 2614),
  858. (34076, 41060, 0, 0, 2614),
  859. (34076, 41225, 0, 0, 2614),
  860. (34076, 40983, 0, 0, 2614),
  861. (34076, 40889, 0, 0, 2614),
  862. (34076, 41898, 0, 0, 2615),
  863. (34076, 41881, 0, 0, 2615),
  864. (34076, 41630, 0, 0, 2615),
  865. (34076, 41617, 0, 0, 2615),
  866. (34076, 41832, 0, 0, 2615),
  867. (34076, 41070, 0, 0, 2615),
  868. (34076, 41051, 0, 0, 2615),
  869. (34076, 41235, 0, 0, 2615),
  870. (34076, 40976, 0, 0, 2615),
  871. (34076, 40881, 0, 0, 2615),
  872. (34076, 41903, 0, 0, 2616),
  873. (34076, 41885, 0, 0, 2616),
  874. (34076, 41635, 0, 0, 2616),
  875. (34076, 41621, 0, 0, 2616),
  876. (34076, 41836, 0, 0, 2616),
  877. (34076, 41075, 0, 0, 2616),
  878. (34076, 41055, 0, 0, 2616),
  879. (34076, 41230, 0, 0, 2616),
  880. (34076, 40977, 0, 0, 2616),
  881. (34076, 40882, 0, 0, 2616),
  882. (34076, 42071, 0, 0, 2619),
  883. (34076, 42073, 0, 0, 2619),
  884. (34076, 42069, 0, 0, 2619),
  885. (34076, 42072, 0, 0, 2619),
  886. (34076, 42070, 0, 0, 2619),
  887. (34076, 42074, 0, 0, 2619),
  888. (34076, 42075, 0, 0, 2619),
  889. (34076, 42037, 0, 0, 2617),
  890. (34076, 42039, 0, 0, 2617),
  891. (34076, 42036, 0, 0, 2617),
  892. (34076, 42040, 0, 0, 2617),
  893. (34076, 42038, 0, 0, 2617),
  894. (34076, 46373, 0, 0, 2617),
  895. (34076, 42034, 0, 0, 2617),
  896. (34076, 42035, 0, 0, 2617),
  897. (34076, 42116, 0, 0, 2618),
  898. (34076, 42117, 0, 0, 2618),
  899. (34076, 42124, 0, 0, 2568);
  900.  
  901. -- Lady Palanseer
  902. INSERT INTO npc_vendor (entry,item,maxcount,incrtime,extendedcost) VALUES
  903. (34039, 36921, 0, 0, 2588),
  904. (34039, 36933, 0, 0, 2588),
  905. (34039, 36930, 0, 0, 2588),
  906. (34039, 36918, 0, 0, 2588),
  907. (34039, 36924, 0, 0, 2588),
  908. (34039, 36927, 0, 0, 2588),
  909. (34039, 41569, 0, 0, 2426),
  910. (34039, 41571, 0, 0, 2426),
  911. (34039, 41572, 0, 0, 2426),
  912. (34039, 41575, 0, 0, 2426),
  913. (34039, 41564, 0, 0, 2426),
  914. (34039, 41570, 0, 0, 2426),
  915. (34039, 41573, 0, 0, 2426),
  916. (34039, 41559, 0, 0, 2426),
  917. (34039, 41560, 0, 0, 2426),
  918. (34039, 41563, 0, 0, 2426),
  919. (34039, 41565, 0, 0, 2426),
  920. (34039, 41566, 0, 0, 2426);
  921.  
  922. -- Sergeant Thunderhorn
  923. INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`extendedcost`) VALUES
  924. (34036,41908,0,0,2560),
  925. (34036,41892,0,0,2560),
  926. (34036,41639,0,0,2560),
  927. (34036,41624,0,0,2560),
  928. (34036,41839,0,0,2560),
  929. (34036,41064,0,0,2560),
  930. (34036,41059,0,0,2560),
  931. (34036,41224,0,0,2560),
  932. (34036,40982,0,0,2560),
  933. (34036,40888,0,0,2560),
  934. (34036,41897,0,0,2559),
  935. (34036,41880,0,0,2559),
  936. (34036,41629,0,0,2559),
  937. (34036,41616,0,0,2559),
  938. (34036,41831,0,0,2559),
  939. (34036,41069,0,0,2559),
  940. (34036,41048,0,0,2559),
  941. (34036,41234,0,0,2559),
  942. (34036,40974,0,0,2559),
  943. (34036,40879,0,0,2559),
  944. (34036,41902,0,0,2559),
  945. (34036,41884,0,0,2559),
  946. (34036,41634,0,0,2559),
  947. (34036,41620,0,0,2559),
  948. (34036,41835,0,0,2559),
  949. (34036,41074,0,0,2559),
  950. (34036,41054,0,0,2559),
  951. (34036,41229,0,0,2559),
  952. (34036,40975,0,0,2559),
  953. (34036,40880,0,0,2559),
  954. (34036,42064,0,0,2561),
  955. (34036,42066,0,0,2561),
  956. (34036,42062,0,0,2561),
  957. (34036,42065,0,0,2561),
  958. (34036,42063,0,0,2561),
  959. (34036,42067,0,0,2561),
  960. (34036,42068,0,0,2561),
  961. (34036,42030,0,0,2561),
  962. (34036,42032,0,0,2561),
  963. (34036,42029,0,0,2561),
  964. (34036,42033,0,0,2561),
  965. (34036,42031,0,0,2561),
  966. (34036,42027,0,0,2561),
  967. (34036,42028,0,0,2561),
  968. (34036,42110,0,0,2605),
  969. (34036,42112,0,0,2605),
  970. (34036,42114,0,0,2561),
  971. (34036,42115,0,0,2561),
  972. (34036,42129,0,0,2559),
  973. (34036,42130,0,0,2559),
  974. (34036,42132,0,0,2559),
  975. (34036,42131,0,0,2559),
  976. (34036,42128,0,0,2559),
  977. (34036,42122,0,0,2605);
  978.  
  979. -- Doris Volanthius
  980. INSERT INTO npc_vendor (entry,item,maxcount,incrtime,extendedcost) VALUES
  981. (34058, 41909, 0, 0, 2614),
  982. (34058, 41893, 0, 0, 2614),
  983. (34058, 41640, 0, 0, 2614),
  984. (34058, 41625, 0, 0, 2614),
  985. (34058, 41840, 0, 0, 2614),
  986. (34058, 41065, 0, 0, 2614),
  987. (34058, 41060, 0, 0, 2614),
  988. (34058, 41225, 0, 0, 2614),
  989. (34058, 40983, 0, 0, 2614),
  990. (34058, 40889, 0, 0, 2614),
  991. (34058, 41898, 0, 0, 2615),
  992. (34058, 41881, 0, 0, 2615),
  993. (34058, 41630, 0, 0, 2615),
  994. (34058, 41617, 0, 0, 2615),
  995. (34058, 41832, 0, 0, 2615),
  996. (34058, 41070, 0, 0, 2615),
  997. (34058, 41051, 0, 0, 2615),
  998. (34058, 41235, 0, 0, 2615),
  999. (34058, 40976, 0, 0, 2615),
  1000. (34058, 40881, 0, 0, 2615),
  1001. (34058, 41903, 0, 0, 2616),
  1002. (34058, 41885, 0, 0, 2616),
  1003. (34058, 41635, 0, 0, 2616),
  1004. (34058, 41621, 0, 0, 2616),
  1005. (34058, 41836, 0, 0, 2616),
  1006. (34058, 41075, 0, 0, 2616),
  1007. (34058, 41055, 0, 0, 2616),
  1008. (34058, 41230, 0, 0, 2616),
  1009. (34058, 40977, 0, 0, 2616),
  1010. (34058, 40882, 0, 0, 2616),
  1011. (34058, 42071, 0, 0, 2619),
  1012. (34058, 42073, 0, 0, 2619),
  1013. (34058, 42069, 0, 0, 2619),
  1014. (34058, 42072, 0, 0, 2619),
  1015. (34058, 42070, 0, 0, 2619),
  1016. (34058, 42074, 0, 0, 2619),
  1017. (34058, 42075, 0, 0, 2619),
  1018. (34058, 42037, 0, 0, 2617),
  1019. (34058, 42039, 0, 0, 2617),
  1020. (34058, 42036, 0, 0, 2617),
  1021. (34058, 42040, 0, 0, 2617),
  1022. (34058, 42038, 0, 0, 2617),
  1023. (34058, 46373, 0, 0, 2617),
  1024. (34058, 42034, 0, 0, 2617),
  1025. (34058, 42035, 0, 0, 2617),
  1026. (34058, 42116, 0, 0, 2618),
  1027. (34058, 42117, 0, 0, 2618),
  1028. (34058, 42126, 0, 0, 2568);
  1029.  
  1030. -- Argex Irongut
  1031. DELETE FROM `creature` WHERE `id` = '33915';
  1032. DELETE FROM `creature_template` WHERE `entry` = '33924';
  1033. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1034. ('33924','0','0','27953','0','27593','0','Argex Irongut','Veteran Arena Vendor','','70','70','6986','6986','0','0','7','35','35','128','1','1','0','2','2','0','24','1','2000','0','1','0','0','0','0','0','0','0','1','1','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1035. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES
  1036. (33924, 45706, 0, 0, 2596),
  1037. (33924, 42589, 0, 0, 2384),
  1038. (33924, 42584, 0, 0, 2384),
  1039. (33924, 42579, 0, 0, 2384),
  1040. (33924, 42853, 0, 0, 2384),
  1041. (33924, 42615, 0, 0, 2384),
  1042. (33924, 42621, 0, 0, 2384),
  1043. (33924, 42608, 0, 0, 2384),
  1044. (33924, 42603, 0, 0, 2384),
  1045. (33924, 42598, 0, 0, 2384),
  1046. (33924, 42233, 0, 0, 2626),
  1047. (33924, 42209, 0, 0, 2624),
  1048. (33924, 42228, 0, 0, 2626),
  1049. (33924, 42281, 0, 0, 2626),
  1050. (33924, 42353, 0, 0, 2624),
  1051. (33924, 42276, 0, 0, 2624),
  1052. (33924, 42291, 0, 0, 2626),
  1053. (33924, 42286, 0, 0, 2624),
  1054. (33924, 42256, 0, 0, 2626),
  1055. (33924, 42243, 0, 0, 2624),
  1056. (33924, 42249, 0, 0, 2626),
  1057. (33924, 42347, 0, 0, 2624),
  1058. (33924, 42266, 0, 0, 2626),
  1059. (33924, 42271, 0, 0, 2626),
  1060. (33924, 42261, 0, 0, 2624),
  1061. (33924, 42318, 0, 0, 2623),
  1062. (33924, 42323, 0, 0, 2623),
  1063. (33924, 42333, 0, 0, 2623),
  1064. (33924, 42364, 0, 0, 2623),
  1065. (33924, 42385, 0, 0, 2623),
  1066. (33924, 44422, 0, 0, 2623),
  1067. (33924, 44421, 0, 0, 2623),
  1068. (33924, 42391, 0, 0, 2623),
  1069. (33924, 42328, 0, 0, 2623),
  1070. (33924, 42491, 0, 0, 2623),
  1071. (33924, 42496, 0, 0, 2623),
  1072. (33924, 42486, 0, 0, 2623),
  1073. (33924, 42451, 0, 0, 2384),
  1074. (33924, 42514, 0, 0, 2384),
  1075. (33924, 42520, 0, 0, 2384),
  1076. (33924, 42503, 0, 0, 2384),
  1077. (33924, 42526, 0, 0, 2626),
  1078. (33924, 42538, 0, 0, 2626),
  1079. (33924, 42532, 0, 0, 2626),
  1080. (33924, 42565, 0, 0, 2628),
  1081. (33924, 42571, 0, 0, 2628),
  1082. (33924, 42560, 0, 0, 2628),
  1083. (33924, 40963, 0, 0, 2470),
  1084. (33924, 41993, 0, 0, 2629),
  1085. (33924, 41998, 0, 0, 2622),
  1086. (33924, 41304, 0, 0, 2340),
  1087. (33924, 42005, 0, 0, 2340),
  1088. (33924, 42011, 0, 0, 2470),
  1089. (33924, 40992, 0, 0, 2622),
  1090. (33924, 42017, 0, 0, 2621),
  1091. (33924, 40849, 0, 0, 2340),
  1092. (33924, 41001, 0, 0, 2621),
  1093. (33924, 41007, 0, 0, 2621),
  1094. (33924, 41013, 0, 0, 2629),
  1095. (33924, 41019, 0, 0, 2629),
  1096. (33924, 41027, 0, 0, 2340),
  1097. (33924, 41033, 0, 0, 2340),
  1098. (33924, 41038, 0, 0, 2470),
  1099. (33924, 41044, 0, 0, 2470),
  1100. (33924, 41081, 0, 0, 2622),
  1101. (33924, 41087, 0, 0, 2622),
  1102. (33924, 41655, 0, 0, 2340),
  1103. (33924, 41137, 0, 0, 2621),
  1104. (33924, 41650, 0, 0, 2622),
  1105. (33924, 41143, 0, 0, 2621),
  1106. (33924, 41661, 0, 0, 2622),
  1107. (33924, 41151, 0, 0, 2629),
  1108. (33924, 41667, 0, 0, 2340),
  1109. (33924, 41157, 0, 0, 2629),
  1110. (33924, 40993, 0, 0, 2622),
  1111. (33924, 41672, 0, 0, 2629),
  1112. (33924, 41678, 0, 0, 2629),
  1113. (33924, 41683, 0, 0, 2470),
  1114. (33924, 40828, 0, 0, 2629),
  1115. (33924, 41199, 0, 0, 2340),
  1116. (33924, 41715, 0, 0, 2470),
  1117. (33924, 41205, 0, 0, 2340),
  1118. (33924, 41211, 0, 0, 2470),
  1119. (33924, 41217, 0, 0, 2470),
  1120. (33924, 41767, 0, 0, 2621),
  1121. (33924, 41773, 0, 0, 2621),
  1122. (33924, 41275, 0, 0, 2470),
  1123. (33924, 41281, 0, 0, 2470),
  1124. (33924, 41287, 0, 0, 2621),
  1125. (33924, 41293, 0, 0, 2621),
  1126. (33924, 41298, 0, 0, 2340),
  1127. (33924, 40787, 0, 0, 2622),
  1128. (33924, 40788, 0, 0, 2622),
  1129. (33924, 40789, 0, 0, 2622),
  1130. (33924, 41310, 0, 0, 2622),
  1131. (33924, 41321, 0, 0, 2629),
  1132. (33924, 41316, 0, 0, 2622),
  1133. (33924, 40807, 0, 0, 2621),
  1134. (33924, 40808, 0, 0, 2621),
  1135. (33924, 40809, 0, 0, 2621),
  1136. (33924, 41327, 0, 0, 2629),
  1137. (33924, 40826, 0, 0, 2629),
  1138. (33924, 40827, 0, 0, 2629),
  1139. (33924, 41854, 0, 0, 2629),
  1140. (33924, 41859, 0, 0, 2622),
  1141. (33924, 41864, 0, 0, 2340),
  1142. (33924, 41869, 0, 0, 2470),
  1143. (33924, 40847, 0, 0, 2340),
  1144. (33924, 40848, 0, 0, 2340),
  1145. (33924, 41874, 0, 0, 2621),
  1146. (33924, 45983, 0, 0, 2636),
  1147. (33924, 40866, 0, 0, 2470),
  1148. (33924, 40868, 0, 0, 2470),
  1149. (33924, 40869, 0, 0, 2470),
  1150. (33924, 41971, 0, 0, 2621),
  1151. (33924, 41915, 0, 0, 2629),
  1152. (33924, 41921, 0, 0, 2622),
  1153. (33924, 41927, 0, 0, 2340),
  1154. (33924, 40907, 0, 0, 2622),
  1155. (33924, 41934, 0, 0, 2470),
  1156. (33924, 41940, 0, 0, 2621),
  1157. (33924, 41946, 0, 0, 2629),
  1158. (33924, 40927, 0, 0, 2621),
  1159. (33924, 41953, 0, 0, 2622),
  1160. (33924, 40933, 0, 0, 2629),
  1161. (33924, 41959, 0, 0, 2340),
  1162. (33924, 40939, 0, 0, 2340),
  1163. (33924, 41965, 0, 0, 2470);
  1164.  
  1165. -- Big Zokk Torquewrench
  1166. DELETE FROM `creature` WHERE `id` = '33916';
  1167. DELETE FROM `creature_template` WHERE `entry` = '33932';
  1168. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1169. ('33932','0','0','23768','0','23768','0','Big Zokk Torqewrench','Arena Vendor','','70','70','6986','6986','0','0','7','35','35','128','1','1','0','2','2','0','24','1','2000','0','1','0','0','0','0','0','0','0','1','1','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1170. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  1171. ('33932','530','1','1','23768','0','3073.99','3633.34','143.779','2.09012','120','0','0','6986','0','0','0');
  1172. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES (33932, 45706, 0, 0, 2596);
  1173.  
  1174. -- Kezzik the Striker
  1175. DELETE FROM `creature` WHERE `id` = '33918';
  1176. DELETE FROM `creature_template` WHERE `entry` = '33931';
  1177. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1178. ('33931','0','0','27942','0','27942','0','Kezzik the Striker','Veteran Arena Vendor','','70','70','6986','6986','0','0','7','35','35','128','1','1','0','2','2','0','24','1','2000','0','1','0','0','0','0','0','0','0','1','1','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1179. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES
  1180. (33931, 45706, 0, 0, 2596),
  1181. (33931, 42589, 0, 0, 2384),
  1182. (33931, 42584, 0, 0, 2384),
  1183. (33931, 42579, 0, 0, 2384),
  1184. (33931, 42853, 0, 0, 2384),
  1185. (33931, 42615, 0, 0, 2384),
  1186. (33931, 42621, 0, 0, 2384),
  1187. (33931, 42608, 0, 0, 2384),
  1188. (33931, 42603, 0, 0, 2384),
  1189. (33931, 42598, 0, 0, 2384),
  1190. (33931, 42233, 0, 0, 2626),
  1191. (33931, 42209, 0, 0, 2624),
  1192. (33931, 42228, 0, 0, 2626),
  1193. (33931, 42281, 0, 0, 2626),
  1194. (33931, 42353, 0, 0, 2624),
  1195. (33931, 42276, 0, 0, 2624),
  1196. (33931, 42291, 0, 0, 2626),
  1197. (33931, 42286, 0, 0, 2624),
  1198. (33931, 42256, 0, 0, 2626),
  1199. (33931, 42243, 0, 0, 2624),
  1200. (33931, 42249, 0, 0, 2626),
  1201. (33931, 42347, 0, 0, 2624),
  1202. (33931, 42266, 0, 0, 2626),
  1203. (33931, 42271, 0, 0, 2626),
  1204. (33931, 42261, 0, 0, 2624),
  1205. (33931, 42318, 0, 0, 2623),
  1206. (33931, 42323, 0, 0, 2623),
  1207. (33931, 42333, 0, 0, 2623),
  1208. (33931, 42364, 0, 0, 2623),
  1209. (33931, 42385, 0, 0, 2623),
  1210. (33931, 44422, 0, 0, 2623),
  1211. (33931, 44421, 0, 0, 2623),
  1212. (33931, 42391, 0, 0, 2623),
  1213. (33931, 42328, 0, 0, 2623),
  1214. (33931, 42491, 0, 0, 2623),
  1215. (33931, 42496, 0, 0, 2623),
  1216. (33931, 42486, 0, 0, 2623),
  1217. (33931, 42451, 0, 0, 2384),
  1218. (33931, 42514, 0, 0, 2384),
  1219. (33931, 42520, 0, 0, 2384),
  1220. (33931, 42503, 0, 0, 2384),
  1221. (33931, 42526, 0, 0, 2626),
  1222. (33931, 42538, 0, 0, 2626),
  1223. (33931, 42532, 0, 0, 2626),
  1224. (33931, 42565, 0, 0, 2628),
  1225. (33931, 42571, 0, 0, 2628),
  1226. (33931, 42560, 0, 0, 2628),
  1227. (33931, 40963, 0, 0, 2470),
  1228. (33931, 41993, 0, 0, 2629),
  1229. (33931, 41998, 0, 0, 2622),
  1230. (33931, 41304, 0, 0, 2340),
  1231. (33931, 42005, 0, 0, 2340),
  1232. (33931, 42011, 0, 0, 2470),
  1233. (33931, 40992, 0, 0, 2622),
  1234. (33931, 42017, 0, 0, 2621),
  1235. (33931, 40849, 0, 0, 2340),
  1236. (33931, 41001, 0, 0, 2621),
  1237. (33931, 41007, 0, 0, 2621),
  1238. (33931, 41013, 0, 0, 2629),
  1239. (33931, 41019, 0, 0, 2629),
  1240. (33931, 41027, 0, 0, 2340),
  1241. (33931, 41033, 0, 0, 2340),
  1242. (33931, 41038, 0, 0, 2470),
  1243. (33931, 41044, 0, 0, 2470),
  1244. (33931, 41081, 0, 0, 2622),
  1245. (33931, 41087, 0, 0, 2622),
  1246. (33931, 41655, 0, 0, 2340),
  1247. (33931, 41137, 0, 0, 2621),
  1248. (33931, 41650, 0, 0, 2622),
  1249. (33931, 41143, 0, 0, 2621),
  1250. (33931, 41661, 0, 0, 2622),
  1251. (33931, 41151, 0, 0, 2629),
  1252. (33931, 41667, 0, 0, 2340),
  1253. (33931, 41157, 0, 0, 2629),
  1254. (33931, 40993, 0, 0, 2622),
  1255. (33931, 41672, 0, 0, 2629),
  1256. (33931, 41678, 0, 0, 2629),
  1257. (33931, 41683, 0, 0, 2470),
  1258. (33931, 40828, 0, 0, 2629),
  1259. (33931, 41199, 0, 0, 2340),
  1260. (33931, 41715, 0, 0, 2470),
  1261. (33931, 41205, 0, 0, 2340),
  1262. (33931, 41211, 0, 0, 2470),
  1263. (33931, 41217, 0, 0, 2470),
  1264. (33931, 41767, 0, 0, 2621),
  1265. (33931, 41773, 0, 0, 2621),
  1266. (33931, 41275, 0, 0, 2470),
  1267. (33931, 41281, 0, 0, 2470),
  1268. (33931, 41287, 0, 0, 2621),
  1269. (33931, 41293, 0, 0, 2621),
  1270. (33931, 41298, 0, 0, 2340),
  1271. (33931, 40787, 0, 0, 2622),
  1272. (33931, 40788, 0, 0, 2622),
  1273. (33931, 40789, 0, 0, 2622),
  1274. (33931, 41310, 0, 0, 2622),
  1275. (33931, 41321, 0, 0, 2629),
  1276. (33931, 41316, 0, 0, 2622),
  1277. (33931, 40807, 0, 0, 2621),
  1278. (33931, 40808, 0, 0, 2621),
  1279. (33931, 40809, 0, 0, 2621),
  1280. (33931, 41327, 0, 0, 2629),
  1281. (33931, 40826, 0, 0, 2629),
  1282. (33931, 40827, 0, 0, 2629),
  1283. (33931, 41854, 0, 0, 2629),
  1284. (33931, 41859, 0, 0, 2622),
  1285. (33931, 41864, 0, 0, 2340),
  1286. (33931, 41869, 0, 0, 2470),
  1287. (33931, 40847, 0, 0, 2340),
  1288. (33931, 40848, 0, 0, 2340),
  1289. (33931, 41874, 0, 0, 2621),
  1290. (33931, 45983, 0, 0, 2636),
  1291. (33931, 40866, 0, 0, 2470),
  1292. (33931, 40868, 0, 0, 2470),
  1293. (33931, 40869, 0, 0, 2470),
  1294. (33931, 41971, 0, 0, 2621),
  1295. (33931, 41915, 0, 0, 2629),
  1296. (33931, 41921, 0, 0, 2622),
  1297. (33931, 41927, 0, 0, 2340),
  1298. (33931, 40907, 0, 0, 2622),
  1299. (33931, 41934, 0, 0, 2470),
  1300. (33931, 41940, 0, 0, 2621),
  1301. (33931, 41946, 0, 0, 2629),
  1302. (33931, 40927, 0, 0, 2621),
  1303. (33931, 41953, 0, 0, 2622),
  1304. (33931, 40933, 0, 0, 2629),
  1305. (33931, 41959, 0, 0, 2340),
  1306. (33931, 40939, 0, 0, 2340),
  1307. (33931, 41965, 0, 0, 2470);
  1308.  
  1309. -- Evee Copperspring
  1310. DELETE FROM `creature` WHERE `id` = '33920';
  1311. DELETE FROM `creature_template` WHERE `entry` = '33928';
  1312. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1313. ('33928','0','0','22438','0','22438','0','Evee Copperspring','Arena Vendor','','70','70','6986','6986','0','0','7','35','35','128','1','1','0','2','2','0','24','1','2000','0','1','0','0','0','0','0','0','0','1','1','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1314. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  1315. ('33928','1','1','1','22438','0','-7120.42','-3773.96','9.0225','0.418879','300','0','0','6986','0','0','0');
  1316. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES
  1317. (33928, 45706, 0, 0, 2596),
  1318. (33928, 42588, 0, 0, 2608),
  1319. (33928, 42583, 0, 0, 2608),
  1320. (33928, 42578, 0, 0, 2608),
  1321. (33928, 42852, 0, 0, 2608),
  1322. (33928, 42614, 0, 0, 2608),
  1323. (33928, 42620, 0, 0, 2608),
  1324. (33928, 42607, 0, 0, 2608),
  1325. (33928, 42602, 0, 0, 2608),
  1326. (33928, 42597, 0, 0, 2608);
  1327.  
  1328. -- Nargle Lashcord
  1329. DELETE FROM `creature` WHERE `id` = '33921';
  1330. DELETE FROM `creature_template` WHERE `entry` = '33927';
  1331. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1332. ('33927','0','0','26463','0','26463','0','Nargle Lashcord','Veteran Arena Vendor','','75','75','8025','8025','0','0','8219','35','35','4224','1','1','0','342','485','0','392','1','2000','0','1','512','0','0','0','0','0','0','295','438','68','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1333. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  1334. ('33927','571','1','1','26463','0','5751.82','583.454','615.052','6.14356','300','0','0','8025','0','0','0');
  1335. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES
  1336. (33927, 45706, 0, 0, 2596),
  1337. (33927, 42589, 0, 0, 2384),
  1338. (33927, 42584, 0, 0, 2384),
  1339. (33927, 42579, 0, 0, 2384),
  1340. (33927, 42853, 0, 0, 2384),
  1341. (33927, 42615, 0, 0, 2384),
  1342. (33927, 42621, 0, 0, 2384),
  1343. (33927, 42608, 0, 0, 2384),
  1344. (33927, 42603, 0, 0, 2384),
  1345. (33927, 42598, 0, 0, 2384),
  1346. (33927, 42233, 0, 0, 2626),
  1347. (33927, 42209, 0, 0, 2624),
  1348. (33927, 42228, 0, 0, 2626),
  1349. (33927, 42281, 0, 0, 2626),
  1350. (33927, 42353, 0, 0, 2624),
  1351. (33927, 42276, 0, 0, 2624),
  1352. (33927, 42291, 0, 0, 2626),
  1353. (33927, 42286, 0, 0, 2624),
  1354. (33927, 42256, 0, 0, 2626),
  1355. (33927, 42243, 0, 0, 2624),
  1356. (33927, 42249, 0, 0, 2626),
  1357. (33927, 42347, 0, 0, 2624),
  1358. (33927, 42266, 0, 0, 2626),
  1359. (33927, 42271, 0, 0, 2626),
  1360. (33927, 42261, 0, 0, 2624),
  1361. (33927, 42318, 0, 0, 2623),
  1362. (33927, 42323, 0, 0, 2623),
  1363. (33927, 42333, 0, 0, 2623),
  1364. (33927, 42364, 0, 0, 2623),
  1365. (33927, 42385, 0, 0, 2623),
  1366. (33927, 44422, 0, 0, 2623),
  1367. (33927, 44421, 0, 0, 2623),
  1368. (33927, 42391, 0, 0, 2623),
  1369. (33927, 42328, 0, 0, 2623),
  1370. (33927, 42491, 0, 0, 2623),
  1371. (33927, 42496, 0, 0, 2623),
  1372. (33927, 42486, 0, 0, 2623),
  1373. (33927, 42451, 0, 0, 2384),
  1374. (33927, 42514, 0, 0, 2384),
  1375. (33927, 42520, 0, 0, 2384),
  1376. (33927, 42503, 0, 0, 2384),
  1377. (33927, 42526, 0, 0, 2626),
  1378. (33927, 42538, 0, 0, 2626),
  1379. (33927, 42532, 0, 0, 2626),
  1380. (33927, 42565, 0, 0, 2628),
  1381. (33927, 42571, 0, 0, 2628),
  1382. (33927, 42560, 0, 0, 2628),
  1383. (33927, 40963, 0, 0, 2470),
  1384. (33927, 41993, 0, 0, 2629),
  1385. (33927, 41998, 0, 0, 2622),
  1386. (33927, 41304, 0, 0, 2340),
  1387. (33927, 42005, 0, 0, 2340),
  1388. (33927, 42011, 0, 0, 2470),
  1389. (33927, 40992, 0, 0, 2622),
  1390. (33927, 42017, 0, 0, 2621),
  1391. (33927, 40849, 0, 0, 2340),
  1392. (33927, 41001, 0, 0, 2621),
  1393. (33927, 41007, 0, 0, 2621),
  1394. (33927, 41013, 0, 0, 2629),
  1395. (33927, 41019, 0, 0, 2629),
  1396. (33927, 41027, 0, 0, 2340),
  1397. (33927, 41033, 0, 0, 2340),
  1398. (33927, 41038, 0, 0, 2470),
  1399. (33927, 41044, 0, 0, 2470),
  1400. (33927, 41081, 0, 0, 2622),
  1401. (33927, 41087, 0, 0, 2622),
  1402. (33927, 41655, 0, 0, 2340),
  1403. (33927, 41137, 0, 0, 2621),
  1404. (33927, 41650, 0, 0, 2622),
  1405. (33927, 41143, 0, 0, 2621),
  1406. (33927, 41661, 0, 0, 2622),
  1407. (33927, 41151, 0, 0, 2629),
  1408. (33927, 41667, 0, 0, 2340),
  1409. (33927, 41157, 0, 0, 2629),
  1410. (33927, 40993, 0, 0, 2622),
  1411. (33927, 41672, 0, 0, 2629),
  1412. (33927, 41678, 0, 0, 2629),
  1413. (33927, 41683, 0, 0, 2470),
  1414. (33927, 40828, 0, 0, 2629),
  1415. (33927, 41199, 0, 0, 2340),
  1416. (33927, 41715, 0, 0, 2470),
  1417. (33927, 41205, 0, 0, 2340),
  1418. (33927, 41211, 0, 0, 2470),
  1419. (33927, 41217, 0, 0, 2470),
  1420. (33927, 41767, 0, 0, 2621),
  1421. (33927, 41773, 0, 0, 2621),
  1422. (33927, 41275, 0, 0, 2470),
  1423. (33927, 41281, 0, 0, 2470),
  1424. (33927, 41287, 0, 0, 2621),
  1425. (33927, 41293, 0, 0, 2621),
  1426. (33927, 41298, 0, 0, 2340),
  1427. (33927, 40787, 0, 0, 2622),
  1428. (33927, 40788, 0, 0, 2622),
  1429. (33927, 40789, 0, 0, 2622),
  1430. (33927, 41310, 0, 0, 2622),
  1431. (33927, 41321, 0, 0, 2629),
  1432. (33927, 41316, 0, 0, 2622),
  1433. (33927, 40807, 0, 0, 2621),
  1434. (33927, 40808, 0, 0, 2621),
  1435. (33927, 40809, 0, 0, 2621),
  1436. (33927, 41327, 0, 0, 2629),
  1437. (33927, 40826, 0, 0, 2629),
  1438. (33927, 40827, 0, 0, 2629),
  1439. (33927, 41854, 0, 0, 2629),
  1440. (33927, 41859, 0, 0, 2622),
  1441. (33927, 41864, 0, 0, 2340),
  1442. (33927, 41869, 0, 0, 2470),
  1443. (33927, 40847, 0, 0, 2340),
  1444. (33927, 40848, 0, 0, 2340),
  1445. (33927, 41874, 0, 0, 2621),
  1446. (33927, 45983, 0, 0, 2636),
  1447. (33927, 40866, 0, 0, 2470),
  1448. (33927, 40868, 0, 0, 2470),
  1449. (33927, 40869, 0, 0, 2470),
  1450. (33927, 41971, 0, 0, 2621),
  1451. (33927, 41915, 0, 0, 2629),
  1452. (33927, 41921, 0, 0, 2622),
  1453. (33927, 41927, 0, 0, 2340),
  1454. (33927, 40907, 0, 0, 2622),
  1455. (33927, 41934, 0, 0, 2470),
  1456. (33927, 41940, 0, 0, 2621),
  1457. (33927, 41946, 0, 0, 2629),
  1458. (33927, 40927, 0, 0, 2621),
  1459. (33927, 41953, 0, 0, 2622),
  1460. (33927, 40933, 0, 0, 2629),
  1461. (33927, 41959, 0, 0, 2340),
  1462. (33927, 40939, 0, 0, 2340),
  1463. (33927, 41965, 0, 0, 2470);
  1464.  
  1465. -- Xazi Smolderpipe
  1466. DELETE FROM `creature` WHERE `id` = '33922';
  1467. DELETE FROM `creature_template` WHERE `entry` = '33926';
  1468. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1469. ('33926','0','0','26464','0','26464','0','Xazi Smolderpipe','Arena Vendor','','75','75','8025','8025','0','0','8219','35','35','4224','1','1','0','342','485','0','392','1','2000','0','1','768','0','0','0','0','0','0','295','438','68','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1470. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  1471. ('33926','571','1','1','26464','0','5753.53','585.632','615.052','0.139626','300','0','0','8025','0','0','0');
  1472. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES
  1473. (33926, 45706, 0, 0, 2596),
  1474. (33926, 42588, 0, 0, 2608),
  1475. (33926, 42583, 0, 0, 2608),
  1476. (33926, 42578, 0, 0, 2608),
  1477. (33926, 42852, 0, 0, 2608),
  1478. (33926, 42614, 0, 0, 2608),
  1479. (33926, 42620, 0, 0, 2608),
  1480. (33926, 42607, 0, 0, 2608),
  1481. (33926, 42602, 0, 0, 2608),
  1482. (33926, 42597, 0, 0, 2608),
  1483. (33926, 40962, 0, 0, 2613),
  1484. (33926, 41992, 0, 0, 2612),
  1485. (33926, 41997, 0, 0, 2611),
  1486. (33926, 42004, 0, 0, 2610),
  1487. (33926, 42010, 0, 0, 2613),
  1488. (33926, 40990, 0, 0, 2611),
  1489. (33926, 40991, 0, 0, 2611),
  1490. (33926, 42016, 0, 0, 2609),
  1491. (33926, 41000, 0, 0, 2609),
  1492. (33926, 41006, 0, 0, 2609),
  1493. (33926, 41012, 0, 0, 2612),
  1494. (33926, 41018, 0, 0, 2612),
  1495. (33926, 41026, 0, 0, 2610),
  1496. (33926, 41654, 0, 0, 2610),
  1497. (33926, 41032, 0, 0, 2610),
  1498. (33926, 41037, 0, 0, 2613),
  1499. (33926, 41043, 0, 0, 2613),
  1500. (33926, 41080, 0, 0, 2611),
  1501. (33926, 41086, 0, 0, 2611),
  1502. (33926, 41136, 0, 0, 2609),
  1503. (33926, 41649, 0, 0, 2611),
  1504. (33926, 41142, 0, 0, 2609),
  1505. (33926, 41660, 0, 0, 2611),
  1506. (33926, 41150, 0, 0, 2612),
  1507. (33926, 41666, 0, 0, 2610),
  1508. (33926, 41156, 0, 0, 2612),
  1509. (33926, 41671, 0, 0, 2612),
  1510. (33926, 41677, 0, 0, 2612),
  1511. (33926, 41682, 0, 0, 2613),
  1512. (33926, 41198, 0, 0, 2610),
  1513. (33926, 41714, 0, 0, 2613),
  1514. (33926, 41204, 0, 0, 2610),
  1515. (33926, 41210, 0, 0, 2613),
  1516. (33926, 41216, 0, 0, 2613),
  1517. (33926, 41766, 0, 0, 2609),
  1518. (33926, 41772, 0, 0, 2609),
  1519. (33926, 41274, 0, 0, 2613),
  1520. (33926, 41280, 0, 0, 2613),
  1521. (33926, 41286, 0, 0, 2609),
  1522. (33926, 40844, 0, 0, 2610),
  1523. (33926, 41292, 0, 0, 2609),
  1524. (33926, 40784, 0, 0, 2611),
  1525. (33926, 41297, 0, 0, 2610),
  1526. (33926, 40786, 0, 0, 2611),
  1527. (33926, 41303, 0, 0, 2610),
  1528. (33926, 41309, 0, 0, 2611),
  1529. (33926, 41315, 0, 0, 2611),
  1530. (33926, 40804, 0, 0, 2609),
  1531. (33926, 40805, 0, 0, 2609),
  1532. (33926, 40806, 0, 0, 2609),
  1533. (33926, 41320, 0, 0, 2612),
  1534. (33926, 41326, 0, 0, 2612),
  1535. (33926, 40823, 0, 0, 2612),
  1536. (33926, 40824, 0, 0, 2612),
  1537. (33926, 40825, 0, 0, 2612),
  1538. (33926, 41853, 0, 0, 2612),
  1539. (33926, 41858, 0, 0, 2611),
  1540. (33926, 41863, 0, 0, 2610),
  1541. (33926, 41868, 0, 0, 2613),
  1542. (33926, 40845, 0, 0, 2610),
  1543. (33926, 40846, 0, 0, 2610),
  1544. (33926, 41873, 0, 0, 2609),
  1545. (33926, 40862, 0, 0, 2613),
  1546. (33926, 40863, 0, 0, 2613),
  1547. (33926, 40864, 0, 0, 2613),
  1548. (33926, 41914, 0, 0, 2612),
  1549. (33926, 41920, 0, 0, 2611),
  1550. (33926, 41926, 0, 0, 2610),
  1551. (33926, 40905, 0, 0, 2611),
  1552. (33926, 41933, 0, 0, 2613),
  1553. (33926, 41939, 0, 0, 2609),
  1554. (33926, 41945, 0, 0, 2612),
  1555. (33926, 40926, 0, 0, 2609),
  1556. (33926, 41951, 0, 0, 2611),
  1557. (33926, 40932, 0, 0, 2612),
  1558. (33926, 41958, 0, 0, 2610),
  1559. (33926, 40785, 0, 0, 2611),
  1560. (33926, 40938, 0, 0, 2610),
  1561. (33926, 41964, 0, 0, 2613),
  1562. (33926, 41970, 0, 0, 2609);
  1563.  
  1564. -- Zom Bocom
  1565. DELETE FROM `creature` WHERE `id` = '33923';
  1566. DELETE FROM `creature_template` WHERE `entry` = '33925';
  1567. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1568. ('33925','0','0','26465','0','26465','0','Zom Bocom','Apprentice Arena Vendor','','75','75','8025','8025','0','0','8219','35','35','4224','1','1','0','342','485','0','392','1','2000','0','1','768','0','0','0','0','0','0','295','438','68','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1569. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  1570. ('33925','571','1','1','26465','0','5761.27','579.184','615.052','1.91986','300','0','0','8025','0','0','0');
  1571. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES
  1572. (33925, 45706, 0, 0, 2596),
  1573. (33925, 41857, 0, 0, 2440),
  1574. (33925, 41862, 0, 0, 2440),
  1575. (33925, 41991, 0, 0, 2440),
  1576. (33925, 40840, 0, 0, 2440),
  1577. (33925, 40841, 0, 0, 2440),
  1578. (33925, 41867, 0, 0, 2445),
  1579. (33925, 41314, 0, 0, 2440),
  1580. (33925, 40842, 0, 0, 2440),
  1581. (33925, 41325, 0, 0, 2440),
  1582. (33925, 41872, 0, 0, 2441),
  1583. (33925, 42001, 0, 0, 2440),
  1584. (33925, 42003, 0, 0, 2440),
  1585. (33925, 41969, 0, 0, 2441),
  1586. (33925, 42009, 0, 0, 2445),
  1587. (33925, 40859, 0, 0, 2445),
  1588. (33925, 40860, 0, 0, 2445),
  1589. (33925, 40989, 0, 0, 2440),
  1590. (33925, 41279, 0, 0, 2445),
  1591. (33925, 42015, 0, 0, 2441),
  1592. (33925, 40961, 0, 0, 2445),
  1593. (33925, 41765, 0, 0, 2441),
  1594. (33925, 41025, 0, 0, 2440),
  1595. (33925, 40999, 0, 0, 2441),
  1596. (33925, 40988, 0, 0, 2440),
  1597. (33925, 41771, 0, 0, 2441),
  1598. (33925, 41005, 0, 0, 2441),
  1599. (33925, 41011, 0, 0, 2440),
  1600. (33925, 41135, 0, 0, 2441),
  1601. (33925, 41648, 0, 0, 2440),
  1602. (33925, 40819, 0, 0, 2440),
  1603. (33925, 41141, 0, 0, 2441),
  1604. (33925, 41273, 0, 0, 2445),
  1605. (33925, 41659, 0, 0, 2440),
  1606. (33925, 41149, 0, 0, 2440),
  1607. (33925, 41913, 0, 0, 2440),
  1608. (33925, 41653, 0, 0, 2440),
  1609. (33925, 41665, 0, 0, 2440),
  1610. (33925, 41155, 0, 0, 2440),
  1611. (33925, 41284, 0, 0, 2441),
  1612. (33925, 41925, 0, 0, 2440),
  1613. (33925, 41670, 0, 0, 2440),
  1614. (33925, 41031, 0, 0, 2440),
  1615. (33925, 40904, 0, 0, 2440),
  1616. (33925, 41036, 0, 0, 2445),
  1617. (33925, 41162, 0, 0, 2440),
  1618. (33925, 41931, 0, 0, 2445),
  1619. (33925, 41676, 0, 0, 2440),
  1620. (33925, 40781, 0, 0, 2440),
  1621. (33925, 40782, 0, 0, 2440),
  1622. (33925, 40783, 0, 0, 2440),
  1623. (33925, 41296, 0, 0, 2440),
  1624. (33925, 41681, 0, 0, 2445),
  1625. (33925, 41042, 0, 0, 2445),
  1626. (33925, 40931, 0, 0, 2440),
  1627. (33925, 41302, 0, 0, 2440),
  1628. (33925, 41017, 0, 0, 2440),
  1629. (33925, 41944, 0, 0, 2440),
  1630. (33925, 41291, 0, 0, 2441),
  1631. (33925, 41308, 0, 0, 2440),
  1632. (33925, 40925, 0, 0, 2441),
  1633. (33925, 41950, 0, 0, 2440),
  1634. (33925, 40801, 0, 0, 2441),
  1635. (33925, 40802, 0, 0, 2441),
  1636. (33925, 40803, 0, 0, 2441),
  1637. (33925, 41957, 0, 0, 2440),
  1638. (33925, 41319, 0, 0, 2440),
  1639. (33925, 40861, 0, 0, 2445),
  1640. (33925, 40937, 0, 0, 2440),
  1641. (33925, 41963, 0, 0, 2445),
  1642. (33925, 41938, 0, 0, 2441),
  1643. (33925, 41713, 0, 0, 2445),
  1644. (33925, 41203, 0, 0, 2440),
  1645. (33925, 40820, 0, 0, 2440),
  1646. (33925, 40821, 0, 0, 2440),
  1647. (33925, 41079, 0, 0, 2440),
  1648. (33925, 41209, 0, 0, 2445),
  1649. (33925, 41919, 0, 0, 2440),
  1650. (33925, 41852, 0, 0, 2440),
  1651. (33925, 41085, 0, 0, 2440),
  1652. (33925, 41215, 0, 0, 2445);
  1653.  
  1654. -- Trapjaw Rix
  1655. DELETE FROM `creature_template` WHERE `entry` = '34092';
  1656. DELETE FROM `creature_template` WHERE `entry` = '34095';
  1657. INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) VALUES
  1658. ('34092','0','0','29076','0','29076','0','Trapjaw Rix','Exceptional Arena Weaponry','','70','70','6986','6986','0','0','8219','35','35','4224','1','1','0','342','485','0','392','1','2000','0','1','768','0','0','0','0','0','0','295','438','68','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');
  1659. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  1660. ('34092','571','1','1','29076','0','5755.385254','579.977112','613.762878','0.916566','300','0','0','8025','0','0','0');
  1661. INSERT INTO `npc_vendor` (entry,item,maxcount,incrtime,extendedcost) VALUES (34092,45983,0,0,2636),
  1662. (34092,45961,0,0,2635),
  1663. (34092,45957,0,0,2634),
  1664. (34092,45966,0,0,2635),
  1665. (34092,45964,0,0,2635),
  1666. (34092,45971,0,0,2633),
  1667. (34092,45959,0,0,2634),
  1668. (34092,45960,0,0,2634),
  1669. (34092,45965,0,0,2635),
  1670. (34092,45962,0,0,2635),
  1671. (34092,45967,0,0,2635),
  1672. (34092,45970,0,0,2633),
  1673. (34092,45958,0,0,2634),
  1674. (34092,45969,0,0,2634),
  1675. (34092,45968,0,0,2635),
  1676. (34092,45963,0,0,2635),
  1677. (34092,45948,0,0,2632),
  1678. (34092,45949,0,0,2632),
  1679. (34092,45950,0,0,2632),
  1680. (34092,45951,0,0,2632),
  1681. (34092,45954,0,0,2632),
  1682. (34092,45953,0,0,2632),
  1683. (34092,45952,0,0,2632),
  1684. (34092,45956,0,0,2632),
  1685. (34092,45955,0,0,2632),
  1686. (34092,45938,0,0,2632),
  1687. (34092,45939,0,0,2632),
  1688. (34092,45937,0,0,2632);
create new paste | create new version of this paste RAW Paste Data