API tools faq
paste
image

3.3 alle

image
Dec 20th, 2011
229
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 106.13 KB | None | 0 0
raw download clone embed print report
  1. -- Dalaran Fountain
  2. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  3. VALUES
  4. ('202443', '571', '1', '1', '5804.2', '639.833', '647.773', '5.59055', '0', '0', '0.339436', '-0.940629', '300', '100', '1'),
  5. ('202616', '571', '1', '1', '5804.2', '639.833', '647.773', '5.59055', '0', '0', '0.339436', '-0.940629', '300', '0', '0');
  6.  
  7.  
  8. DELETE FROM `gossip_menu` WHERE `entry`='11431';
  9. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  10. VALUES
  11. ('11431', '15921', '0', '0', '0', '0', '0', '0');
  12.  
  13. DELETE FROM `npc_text` WHERE `id`='15921';
  14. INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`)
  15. VALUES
  16. ('15921', 'Dedicated to those that fell to the Scourge during the war in the frozen wastes.', '', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
  17.  
  18. DELETE FROM `gossip_menu_option` WHERE `menu_id`='11431';
  19. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  20. VALUES
  21. ('11431', '0', '0', 'See the fall of the Lich King.', '1', '1', '-1', '0', '11431', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  22.  
  23. DELETE FROM `gossip_scripts` WHERE `id`='11431';
  24. INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`)
  25. VALUES
  26. ('11431', '0', '19', '16', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
  27.  
  28.  
  29. DELETE FROM `creature` WHERE `id` IN ('37941', '37942');
  30. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  31. VALUES
  32. ('37941', '571', '1', '1', '0', '0', '5936.98', '509.241', '650.178', '2.18146', '600', '0', '0', '10080', '8814', '0', '0'),
  33. ('37942', '571', '1', '1', '0', '0', '5765.45', '734.38', '653.748', '2.72271', '600', '0', '0', '10080', '8814', '0', '0');
  34.  
  35. -- HORDE 37941
  36. UPDATE creature_template SET `modelid3` = "0", `armor` = "7784", `faction_A` = "2123", `faction_H` = "2123", `npcflag` = "128", `mindmg` = "307", `maxdmg` = "459", `attackpower` = "115", `dmg_multiplier` = "1.4", `unit_flags` = "768", `minrangedmg` = "246", `maxrangedmg` = "367", `rangedattackpower` = "92", `flags_extra` = "2" WHERE entry=37941;
  37. DELETE FROM `npc_vendor` WHERE `entry`='37941';
  38. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  39. VALUES
  40. ('37941', '40790', '0', '0', '2742'),
  41. ('37941', '40791', '0', '0', '2742'),
  42. ('37941', '40792', '0', '0', '2742'),
  43. ('37941', '40810', '0', '0', '2740'),
  44. ('37941', '40811', '0', '0', '2740'),
  45. ('37941', '40812', '0', '0', '2740'),
  46. ('37941', '40829', '0', '0', '2742'),
  47. ('37941', '40830', '0', '0', '2742'),
  48. ('37941', '40831', '0', '0', '2742'),
  49. ('37941', '40850', '0', '0', '2742'),
  50. ('37941', '40851', '0', '0', '2742'),
  51. ('37941', '40852', '0', '0', '2742'),
  52. ('37941', '40870', '0', '0', '2740'),
  53. ('37941', '40871', '0', '0', '2740'),
  54. ('37941', '40872', '0', '0', '2740'),
  55. ('37941', '40910', '0', '0', '2742'),
  56. ('37941', '40928', '0', '0', '2740'),
  57. ('37941', '40934', '0', '0', '2742'),
  58. ('37941', '40940', '0', '0', '2742'),
  59. ('37941', '40964', '0', '0', '2740'),
  60. ('37941', '40994', '0', '0', '2742'),
  61. ('37941', '40995', '0', '0', '2742'),
  62. ('37941', '41002', '0', '0', '2740'),
  63. ('37941', '41008', '0', '0', '2740'),
  64. ('37941', '41014', '0', '0', '2742'),
  65. ('37941', '41020', '0', '0', '2742'),
  66. ('37941', '41028', '0', '0', '2742'),
  67. ('37941', '41034', '0', '0', '2742'),
  68. ('37941', '41039', '0', '0', '2740'),
  69. ('37941', '41045', '0', '0', '2740'),
  70. ('37941', '41082', '0', '0', '2742'),
  71. ('37941', '41088', '0', '0', '2742'),
  72. ('37941', '41138', '0', '0', '2740'),
  73. ('37941', '41144', '0', '0', '2740'),
  74. ('37941', '41152', '0', '0', '2742'),
  75. ('37941', '41158', '0', '0', '2742'),
  76. ('37941', '41200', '0', '0', '2742'),
  77. ('37941', '41206', '0', '0', '2742'),
  78. ('37941', '41212', '0', '0', '2740'),
  79. ('37941', '41218', '0', '0', '2740'),
  80. ('37941', '41276', '0', '0', '2740'),
  81. ('37941', '41282', '0', '0', '2740'),
  82. ('37941', '41288', '0', '0', '2740'),
  83. ('37941', '41294', '0', '0', '2740'),
  84. ('37941', '41299', '0', '0', '2742'),
  85. ('37941', '41305', '0', '0', '2742'),
  86. ('37941', '41311', '0', '0', '2742'),
  87. ('37941', '41317', '0', '0', '2742'),
  88. ('37941', '41322', '0', '0', '2742'),
  89. ('37941', '41328', '0', '0', '2742'),
  90. ('37941', '41651', '0', '0', '2742'),
  91. ('37941', '41656', '0', '0', '2742'),
  92. ('37941', '41662', '0', '0', '2742'),
  93. ('37941', '41668', '0', '0', '2742'),
  94. ('37941', '41673', '0', '0', '2742'),
  95. ('37941', '41679', '0', '0', '2742'),
  96. ('37941', '41684', '0', '0', '2740'),
  97. ('37941', '41716', '0', '0', '2740'),
  98. ('37941', '41768', '0', '0', '2740'),
  99. ('37941', '41774', '0', '0', '2740'),
  100. ('37941', '41855', '0', '0', '2742'),
  101. ('37941', '41860', '0', '0', '2742'),
  102. ('37941', '41865', '0', '0', '2742'),
  103. ('37941', '41870', '0', '0', '2740'),
  104. ('37941', '41875', '0', '0', '2740'),
  105. ('37941', '41916', '0', '0', '2742'),
  106. ('37941', '41922', '0', '0', '2742'),
  107. ('37941', '41928', '0', '0', '2742'),
  108. ('37941', '41935', '0', '0', '2740'),
  109. ('37941', '41941', '0', '0', '2740'),
  110. ('37941', '41947', '0', '0', '2742'),
  111. ('37941', '41954', '0', '0', '2742'),
  112. ('37941', '41960', '0', '0', '2742'),
  113. ('37941', '41966', '0', '0', '2740'),
  114. ('37941', '41972', '0', '0', '2740'),
  115. ('37941', '41994', '0', '0', '2742'),
  116. ('37941', '41999', '0', '0', '2742'),
  117. ('37941', '42006', '0', '0', '2742'),
  118. ('37941', '42012', '0', '0', '2740'),
  119. ('37941', '42018', '0', '0', '2740'),
  120. ('37941', '47241', '0', '0', '2743'),
  121. ('37941', '49908', '0', '0', '2744'),
  122. ('37941', '50355', '0', '0', '2740'),
  123. ('37941', '50356', '0', '0', '2740'),
  124. ('37941', '50357', '0', '0', '2740'),
  125. ('37941', '50358', '0', '0', '2740'),
  126. ('37941', '50454', '0', '0', '2739'),
  127. ('37941', '50455', '0', '0', '2739'),
  128. ('37941', '50456', '0', '0', '2739'),
  129. ('37941', '50457', '0', '0', '2739'),
  130. ('37941', '50458', '0', '0', '2739'),
  131. ('37941', '50459', '0', '0', '2739'),
  132. ('37941', '50460', '0', '0', '2739'),
  133. ('37941', '50461', '0', '0', '2739'),
  134. ('37941', '50462', '0', '0', '2739'),
  135. ('37941', '50463', '0', '0', '2739'),
  136. ('37941', '50464', '0', '0', '2739'),
  137. ('37941', '50466', '0', '0', '2741'),
  138. ('37941', '50467', '0', '0', '2741'),
  139. ('37941', '50468', '0', '0', '2741'),
  140. ('37941', '50469', '0', '0', '2741'),
  141. ('37941', '50470', '0', '0', '2741'),
  142. ('37941', '50474', '0', '0', '2739'),
  143. ('37941', '50965', '0', '0', '2742'),
  144. ('37941', '50968', '0', '0', '2742'),
  145. ('37941', '50969', '0', '0', '2742'),
  146. ('37941', '50970', '0', '0', '2742'),
  147. ('37941', '50971', '0', '0', '2742'),
  148. ('37941', '50972', '0', '0', '2742'),
  149. ('37941', '50973', '0', '0', '2742'),
  150. ('37941', '50974', '0', '0', '2742'),
  151. ('37941', '50975', '0', '0', '2742'),
  152. ('37941', '50976', '0', '0', '2740'),
  153. ('37941', '50977', '0', '0', '2740'),
  154. ('37941', '50978', '0', '0', '2740'),
  155. ('37941', '50979', '0', '0', '2740'),
  156. ('37941', '50980', '0', '0', '2740'),
  157. ('37941', '50981', '0', '0', '2740'),
  158. ('37941', '50982', '0', '0', '2740'),
  159. ('37941', '50983', '0', '0', '2740'),
  160. ('37941', '50984', '0', '0', '2740'),
  161. ('37941', '50987', '0', '0', '2740'),
  162. ('37941', '50989', '0', '0', '2740'),
  163. ('37941', '50991', '0', '0', '2740'),
  164. ('37941', '50992', '0', '0', '2740'),
  165. ('37941', '50993', '0', '0', '2740'),
  166. ('37941', '50994', '0', '0', '2740'),
  167. ('37941', '50995', '0', '0', '2740'),
  168. ('37941', '50996', '0', '0', '2740'),
  169. ('37941', '50997', '0', '0', '2740');
  170.  
  171.  
  172. -- ALLIANCE 37942
  173. UPDATE creature_template SET `modelid3` = "0", `armor` = "7784", `faction_A` = "2027", `faction_H` = "2027", `npcflag` = "128", `mindmg` = "307", `maxdmg` = "459", `attackpower` = "115", `dmg_multiplier` = "1.4", `unit_flags` = "768", `minrangedmg` = "246", `maxrangedmg` = "367", `rangedattackpower` = "92", `flags_extra` = "2" WHERE entry=37942;
  174. DELETE FROM `creature_equip_template` WHERE `entry`='1994';
  175. INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`)
  176. VALUES
  177. ('1994', '49935', '0', '0');
  178. DELETE FROM `npc_vendor` WHERE `entry`='37942';
  179. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  180. VALUES
  181. ('37942', '40790', '0', '0', '2742'),
  182. ('37942', '40791', '0', '0', '2742'),
  183. ('37942', '40792', '0', '0', '2742'),
  184. ('37942', '40810', '0', '0', '2740'),
  185. ('37942', '40811', '0', '0', '2740'),
  186. ('37942', '40812', '0', '0', '2740'),
  187. ('37942', '40829', '0', '0', '2742'),
  188. ('37942', '40830', '0', '0', '2742'),
  189. ('37942', '40831', '0', '0', '2742'),
  190. ('37942', '40850', '0', '0', '2742'),
  191. ('37942', '40851', '0', '0', '2742'),
  192. ('37942', '40852', '0', '0', '2742'),
  193. ('37942', '40870', '0', '0', '2740'),
  194. ('37942', '40871', '0', '0', '2740'),
  195. ('37942', '40872', '0', '0', '2740'),
  196. ('37942', '40910', '0', '0', '2742'),
  197. ('37942', '40928', '0', '0', '2740'),
  198. ('37942', '40934', '0', '0', '2742'),
  199. ('37942', '40940', '0', '0', '2742'),
  200. ('37942', '40964', '0', '0', '2740'),
  201. ('37942', '40994', '0', '0', '2742'),
  202. ('37942', '40995', '0', '0', '2742'),
  203. ('37942', '41002', '0', '0', '2740'),
  204. ('37942', '41008', '0', '0', '2740'),
  205. ('37942', '41014', '0', '0', '2742'),
  206. ('37942', '41020', '0', '0', '2742'),
  207. ('37942', '41028', '0', '0', '2742'),
  208. ('37942', '41034', '0', '0', '2742'),
  209. ('37942', '41039', '0', '0', '2740'),
  210. ('37942', '41045', '0', '0', '2740'),
  211. ('37942', '41082', '0', '0', '2742'),
  212. ('37942', '41088', '0', '0', '2742'),
  213. ('37942', '41138', '0', '0', '2740'),
  214. ('37942', '41144', '0', '0', '2740'),
  215. ('37942', '41152', '0', '0', '2742'),
  216. ('37942', '41158', '0', '0', '2742'),
  217. ('37942', '41200', '0', '0', '2742'),
  218. ('37942', '41206', '0', '0', '2742'),
  219. ('37942', '41212', '0', '0', '2740'),
  220. ('37942', '41218', '0', '0', '2740'),
  221. ('37942', '41276', '0', '0', '2740'),
  222. ('37942', '41282', '0', '0', '2740'),
  223. ('37942', '41288', '0', '0', '2740'),
  224. ('37942', '41294', '0', '0', '2740'),
  225. ('37942', '41299', '0', '0', '2742'),
  226. ('37942', '41305', '0', '0', '2742'),
  227. ('37942', '41311', '0', '0', '2742'),
  228. ('37942', '41317', '0', '0', '2742'),
  229. ('37942', '41322', '0', '0', '2742'),
  230. ('37942', '41328', '0', '0', '2742'),
  231. ('37942', '41651', '0', '0', '2742'),
  232. ('37942', '41656', '0', '0', '2742'),
  233. ('37942', '41662', '0', '0', '2742'),
  234. ('37942', '41668', '0', '0', '2742'),
  235. ('37942', '41673', '0', '0', '2742'),
  236. ('37942', '41679', '0', '0', '2742'),
  237. ('37942', '41684', '0', '0', '2740'),
  238. ('37942', '41716', '0', '0', '2740'),
  239. ('37942', '41768', '0', '0', '2740'),
  240. ('37942', '41774', '0', '0', '2740'),
  241. ('37942', '41855', '0', '0', '2742'),
  242. ('37942', '41860', '0', '0', '2742'),
  243. ('37942', '41865', '0', '0', '2742'),
  244. ('37942', '41870', '0', '0', '2740'),
  245. ('37942', '41875', '0', '0', '2740'),
  246. ('37942', '41916', '0', '0', '2742'),
  247. ('37942', '41922', '0', '0', '2742'),
  248. ('37942', '41928', '0', '0', '2742'),
  249. ('37942', '41935', '0', '0', '2740'),
  250. ('37942', '41941', '0', '0', '2740'),
  251. ('37942', '41947', '0', '0', '2742'),
  252. ('37942', '41954', '0', '0', '2742'),
  253. ('37942', '41960', '0', '0', '2742'),
  254. ('37942', '41966', '0', '0', '2740'),
  255. ('37942', '41972', '0', '0', '2740'),
  256. ('37942', '41994', '0', '0', '2742'),
  257. ('37942', '41999', '0', '0', '2742'),
  258. ('37942', '42006', '0', '0', '2742'),
  259. ('37942', '42012', '0', '0', '2740'),
  260. ('37942', '42018', '0', '0', '2740'),
  261. ('37942', '47241', '0', '0', '2743'),
  262. ('37942', '49908', '0', '0', '2744'),
  263. ('37942', '50355', '0', '0', '2740'),
  264. ('37942', '50356', '0', '0', '2740'),
  265. ('37942', '50357', '0', '0', '2740'),
  266. ('37942', '50358', '0', '0', '2740'),
  267. ('37942', '50454', '0', '0', '2739'),
  268. ('37942', '50455', '0', '0', '2739'),
  269. ('37942', '50456', '0', '0', '2739'),
  270. ('37942', '50457', '0', '0', '2739'),
  271. ('37942', '50458', '0', '0', '2739'),
  272. ('37942', '50459', '0', '0', '2739'),
  273. ('37942', '50460', '0', '0', '2739'),
  274. ('37942', '50461', '0', '0', '2739'),
  275. ('37942', '50462', '0', '0', '2739'),
  276. ('37942', '50463', '0', '0', '2739'),
  277. ('37942', '50464', '0', '0', '2739'),
  278. ('37942', '50466', '0', '0', '2741'),
  279. ('37942', '50467', '0', '0', '2741'),
  280. ('37942', '50468', '0', '0', '2741'),
  281. ('37942', '50469', '0', '0', '2741'),
  282. ('37942', '50470', '0', '0', '2741'),
  283. ('37942', '50474', '0', '0', '2739'),
  284. ('37942', '50965', '0', '0', '2742'),
  285. ('37942', '50968', '0', '0', '2742'),
  286. ('37942', '50969', '0', '0', '2742'),
  287. ('37942', '50970', '0', '0', '2742'),
  288. ('37942', '50971', '0', '0', '2742'),
  289. ('37942', '50972', '0', '0', '2742'),
  290. ('37942', '50973', '0', '0', '2742'),
  291. ('37942', '50974', '0', '0', '2742'),
  292. ('37942', '50975', '0', '0', '2742'),
  293. ('37942', '50976', '0', '0', '2740'),
  294. ('37942', '50977', '0', '0', '2740'),
  295. ('37942', '50978', '0', '0', '2740'),
  296. ('37942', '50979', '0', '0', '2740'),
  297. ('37942', '50980', '0', '0', '2740'),
  298. ('37942', '50981', '0', '0', '2740'),
  299. ('37942', '50982', '0', '0', '2740'),
  300. ('37942', '50983', '0', '0', '2740'),
  301. ('37942', '50984', '0', '0', '2740'),
  302. ('37942', '50987', '0', '0', '2740'),
  303. ('37942', '50989', '0', '0', '2740'),
  304. ('37942', '50991', '0', '0', '2740'),
  305. ('37942', '50992', '0', '0', '2740'),
  306. ('37942', '50993', '0', '0', '2740'),
  307. ('37942', '50994', '0', '0', '2740'),
  308. ('37942', '50995', '0', '0', '2740'),
  309. ('37942', '50996', '0', '0', '2740'),
  310. ('37942', '50997', '0', '0', '2740');
  311.  
  312.  
  313.  
  314. -- FROZO THE RENOWNED
  315. DELETE FROM `creature` WHERE `id`='40160';
  316. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  317. VALUES
  318. ('40160', '571', '1', '1', '0', '0', '5910.08', '720.278', '643.425', '3.26377', '600', '0', '0', '8508', '7981', '0', '0');
  319.  
  320. UPDATE creature_template SET `modelid3` = "0", `armor` = "6588", `npcflag` = "128", `speed_run` = "2.28571", `mindmg` = "248", `maxdmg` = "372", `attackpower` = "93", `dmg_multiplier` = "1.4", `unit_flags` = "32768", `minrangedmg` = "198", `maxrangedmg` = "298", `rangedattackpower` = "74", `equipment_id` = "2286", `InhabitType` = "4" WHERE entry=40160;
  321. -- KIS KOZMETIKA
  322. DELETE FROM `creature_equip_template` WHERE `entry`='2286';
  323. INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`)
  324. VALUES
  325. ('2286', '0', '36459', '0');
  326. DELETE FROM `creature_template_addon` WHERE `entry`='40160';
  327. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_pvp_state`, `emote`, `moveflags`, `auras`)
  328. VALUES
  329. ('40160', '31837', '0', '1', '1', '0', '0', '75387');
  330.  
  331. -- VENDOR PART
  332. DELETE FROM `npc_vendor` WHERE `entry`='40160';
  333. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  334. VALUES
  335. ('40160', '35622', '0', '0', '2985'),
  336. ('40160', '35623', '0', '0', '2985'),
  337. ('40160', '35624', '0', '0', '2985'),
  338. ('40160', '35625', '0', '0', '2985'),
  339. ('40160', '35627', '0', '0', '2985'),
  340. ('40160', '36860', '0', '0', '2985'),
  341. ('40160', '36908', '0', '0', '2985'),
  342. ('40160', '45087', '0', '0', '2987'),
  343. ('40160', '47556', '0', '0', '2986'),
  344. ('40160', '54798', '0', '0', '2986');
  345.  
  346.  
  347.  
  348. -- SEASON 8 VENDORS
  349. -- SPAWN
  350. DELETE FROM `creature` WHERE `id` IN ('33933', '33940', '33941', '34094');
  351. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  352. VALUES
  353. ('33933', '530', '1', '1', '0', '0', '3070.07', '3635', '143.781', '0.733741', '600', '0', '0', '6986', '0', '0', '0'),
  354. ('33940', '530', '1', '1', '0', '0', '3066.1', '3638.35', '145.025', '0.910453', '600', '0', '0', '6986', '0', '0', '0'),
  355. ('33941', '530', '1', '1', '0', '0', '3074.04', '3633.83', '143.779', '1.68171', '600', '0', '0', '6986', '0', '0', '0'),
  356. ('34094', '530', '1', '1', '0', '0', '3078.48', '3637.11', '145.242', '3.02318', '600', '0', '0', '6986', '0', '0', '0');
  357.  
  358. -- TEMPLATE UP
  359. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33933;
  360. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33940;
  361. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "4224", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33941;
  362. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=34094;
  363.  
  364.  
  365. -- VENDOR PART
  366. -- [33933] - Big Zokk Torquewrench
  367. DELETE FROM `npc_vendor` WHERE `entry`='33933';
  368. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  369. VALUES
  370. ('33933', '40790', '0', '0', '2956'),
  371. ('33933', '40791', '0', '0', '2956'),
  372. ('33933', '40792', '0', '0', '2956'),
  373. ('33933', '40810', '0', '0', '2957'),
  374. ('33933', '40811', '0', '0', '2957'),
  375. ('33933', '40812', '0', '0', '2957'),
  376. ('33933', '40829', '0', '0', '2956'),
  377. ('33933', '40830', '0', '0', '2956'),
  378. ('33933', '40831', '0', '0', '2956'),
  379. ('33933', '40850', '0', '0', '2956'),
  380. ('33933', '40851', '0', '0', '2956'),
  381. ('33933', '40852', '0', '0', '2956'),
  382. ('33933', '40870', '0', '0', '2955'),
  383. ('33933', '40871', '0', '0', '2955'),
  384. ('33933', '40872', '0', '0', '2955'),
  385. ('33933', '40910', '0', '0', '2956'),
  386. ('33933', '40928', '0', '0', '2957'),
  387. ('33933', '40934', '0', '0', '2956'),
  388. ('33933', '40940', '0', '0', '2956'),
  389. ('33933', '40964', '0', '0', '2955'),
  390. ('33933', '40994', '0', '0', '2956'),
  391. ('33933', '40995', '0', '0', '2956'),
  392. ('33933', '41002', '0', '0', '2957'),
  393. ('33933', '41008', '0', '0', '2957'),
  394. ('33933', '41014', '0', '0', '2956'),
  395. ('33933', '41020', '0', '0', '2956'),
  396. ('33933', '41028', '0', '0', '2956'),
  397. ('33933', '41034', '0', '0', '2956'),
  398. ('33933', '41039', '0', '0', '2955'),
  399. ('33933', '41045', '0', '0', '2955'),
  400. ('33933', '41082', '0', '0', '2956'),
  401. ('33933', '41088', '0', '0', '2956'),
  402. ('33933', '41138', '0', '0', '2957'),
  403. ('33933', '41144', '0', '0', '2957'),
  404. ('33933', '41152', '0', '0', '2956'),
  405. ('33933', '41158', '0', '0', '2956'),
  406. ('33933', '41200', '0', '0', '2956'),
  407. ('33933', '41206', '0', '0', '2956'),
  408. ('33933', '41212', '0', '0', '2955'),
  409. ('33933', '41218', '0', '0', '2955'),
  410. ('33933', '41276', '0', '0', '2955'),
  411. ('33933', '41282', '0', '0', '2955'),
  412. ('33933', '41288', '0', '0', '2957'),
  413. ('33933', '41294', '0', '0', '2957'),
  414. ('33933', '41299', '0', '0', '2956'),
  415. ('33933', '41305', '0', '0', '2956'),
  416. ('33933', '41311', '0', '0', '2956'),
  417. ('33933', '41317', '0', '0', '2956'),
  418. ('33933', '41322', '0', '0', '2956'),
  419. ('33933', '41328', '0', '0', '2956'),
  420. ('33933', '41651', '0', '0', '2956'),
  421. ('33933', '41656', '0', '0', '2956'),
  422. ('33933', '41662', '0', '0', '2956'),
  423. ('33933', '41668', '0', '0', '2956'),
  424. ('33933', '41673', '0', '0', '2956'),
  425. ('33933', '41679', '0', '0', '2956'),
  426. ('33933', '41684', '0', '0', '2955'),
  427. ('33933', '41716', '0', '0', '2955'),
  428. ('33933', '41768', '0', '0', '2957'),
  429. ('33933', '41774', '0', '0', '2957'),
  430. ('33933', '41855', '0', '0', '2956'),
  431. ('33933', '41860', '0', '0', '2956'),
  432. ('33933', '41865', '0', '0', '2956'),
  433. ('33933', '41870', '0', '0', '2955'),
  434. ('33933', '41875', '0', '0', '2957'),
  435. ('33933', '41916', '0', '0', '2956'),
  436. ('33933', '41922', '0', '0', '2956'),
  437. ('33933', '41928', '0', '0', '2956'),
  438. ('33933', '41935', '0', '0', '2955'),
  439. ('33933', '41941', '0', '0', '2957'),
  440. ('33933', '41947', '0', '0', '2956'),
  441. ('33933', '41954', '0', '0', '2956'),
  442. ('33933', '41960', '0', '0', '2956'),
  443. ('33933', '41966', '0', '0', '2955'),
  444. ('33933', '41972', '0', '0', '2957'),
  445. ('33933', '41994', '0', '0', '2956'),
  446. ('33933', '41999', '0', '0', '2956'),
  447. ('33933', '42006', '0', '0', '2956'),
  448. ('33933', '42012', '0', '0', '2955'),
  449. ('33933', '42018', '0', '0', '2957'),
  450. ('33933', '42580', '0', '0', '2608'),
  451. ('33933', '42585', '0', '0', '2608'),
  452. ('33933', '42591', '0', '0', '2608'),
  453. ('33933', '42599', '0', '0', '2608'),
  454. ('33933', '42604', '0', '0', '2608'),
  455. ('33933', '42609', '0', '0', '2608'),
  456. ('33933', '42616', '0', '0', '2608'),
  457. ('33933', '42622', '0', '0', '2608'),
  458. ('33933', '42854', '0', '0', '2608'),
  459. ('33933', '45706', '0', '0', '2596');
  460.  
  461.  
  462. -- [33940] - Kezzik the Striker
  463. DELETE FROM `npc_vendor` WHERE `entry`='33940';
  464. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  465. VALUES
  466. ('33940', '51388', '0', '0', '2936'),
  467. ('33940', '51390', '0', '0', '2936'),
  468. ('33940', '51392', '0', '0', '2936'),
  469. ('33940', '51394', '0', '0', '2936'),
  470. ('33940', '51396', '0', '0', '2950'),
  471. ('33940', '51397', '0', '0', '2943'),
  472. ('33940', '51400', '0', '0', '2936'),
  473. ('33940', '51402', '0', '0', '2936'),
  474. ('33940', '51404', '0', '0', '2936'),
  475. ('33940', '51406', '0', '0', '2943'),
  476. ('33940', '51407', '0', '0', '2950'),
  477. ('33940', '51408', '0', '0', '2950'),
  478. ('33940', '51409', '0', '0', '2950'),
  479. ('33940', '51410', '0', '0', '2951'),
  480. ('33940', '51411', '0', '0', '2936'),
  481. ('33940', '51413', '0', '0', '2952'),
  482. ('33940', '51414', '0', '0', '2954'),
  483. ('33940', '51415', '0', '0', '2949'),
  484. ('33940', '51416', '0', '0', '2953'),
  485. ('33940', '51417', '0', '0', '2951'),
  486. ('33940', '51418', '0', '0', '2948'),
  487. ('33940', '51419', '0', '0', '2952'),
  488. ('33940', '51420', '0', '0', '2954'),
  489. ('33940', '51421', '0', '0', '2949'),
  490. ('33940', '51422', '0', '0', '2953'),
  491. ('33940', '51423', '0', '0', '2951'),
  492. ('33940', '51424', '0', '0', '2948'),
  493. ('33940', '51425', '0', '0', '2952'),
  494. ('33940', '51426', '0', '0', '2954'),
  495. ('33940', '51427', '0', '0', '2949'),
  496. ('33940', '51428', '0', '0', '2953'),
  497. ('33940', '51429', '0', '0', '2951'),
  498. ('33940', '51430', '0', '0', '2948'),
  499. ('33940', '51431', '0', '0', '2936'),
  500. ('33940', '51433', '0', '0', '2952'),
  501. ('33940', '51434', '0', '0', '2954'),
  502. ('33940', '51435', '0', '0', '2949'),
  503. ('33940', '51436', '0', '0', '2953'),
  504. ('33940', '51437', '0', '0', '2951'),
  505. ('33940', '51438', '0', '0', '2948'),
  506. ('33940', '51439', '0', '0', '2946'),
  507. ('33940', '51441', '0', '0', '2946'),
  508. ('33940', '51443', '0', '0', '2946'),
  509. ('33940', '51445', '0', '0', '2946'),
  510. ('33940', '51447', '0', '0', '2946'),
  511. ('33940', '51449', '0', '0', '2936'),
  512. ('33940', '51451', '0', '0', '2951'),
  513. ('33940', '51452', '0', '0', '2950'),
  514. ('33940', '51453', '0', '0', '2943'),
  515. ('33940', '51455', '0', '0', '2950'),
  516. ('33940', '51456', '0', '0', '2936'),
  517. ('33940', '51458', '0', '0', '2952'),
  518. ('33940', '51459', '0', '0', '2954'),
  519. ('33940', '51460', '0', '0', '2949'),
  520. ('33940', '51461', '0', '0', '2953'),
  521. ('33940', '51462', '0', '0', '2948'),
  522. ('33940', '51463', '0', '0', '2952'),
  523. ('33940', '51464', '0', '0', '2954'),
  524. ('33940', '51465', '0', '0', '2949'),
  525. ('33940', '51466', '0', '0', '2953'),
  526. ('33940', '51467', '0', '0', '2948'),
  527. ('33940', '51468', '0', '0', '2952'),
  528. ('33940', '51469', '0', '0', '2954'),
  529. ('33940', '51470', '0', '0', '2949'),
  530. ('33940', '51471', '0', '0', '2953'),
  531. ('33940', '51472', '0', '0', '2951'),
  532. ('33940', '51473', '0', '0', '2948'),
  533. ('33940', '51474', '0', '0', '2952'),
  534. ('33940', '51475', '0', '0', '2954'),
  535. ('33940', '51476', '0', '0', '2949'),
  536. ('33940', '51477', '0', '0', '2953'),
  537. ('33940', '51478', '0', '0', '2951'),
  538. ('33940', '51479', '0', '0', '2948'),
  539. ('33940', '51480', '0', '0', '2936'),
  540. ('33940', '51482', '0', '0', '2952'),
  541. ('33940', '51483', '0', '0', '2954'),
  542. ('33940', '51484', '0', '0', '2949'),
  543. ('33940', '51485', '0', '0', '2953'),
  544. ('33940', '51486', '0', '0', '2948'),
  545. ('33940', '51487', '0', '0', '2952'),
  546. ('33940', '51488', '0', '0', '2954'),
  547. ('33940', '51489', '0', '0', '2949'),
  548. ('33940', '51490', '0', '0', '2953'),
  549. ('33940', '51491', '0', '0', '2948'),
  550. ('33940', '51492', '0', '0', '2952'),
  551. ('33940', '51493', '0', '0', '2954'),
  552. ('33940', '51494', '0', '0', '2949'),
  553. ('33940', '51495', '0', '0', '2953'),
  554. ('33940', '51496', '0', '0', '2948'),
  555. ('33940', '51497', '0', '0', '2952'),
  556. ('33940', '51498', '0', '0', '2954'),
  557. ('33940', '51499', '0', '0', '2949'),
  558. ('33940', '51500', '0', '0', '2953'),
  559. ('33940', '51501', '0', '0', '2951'),
  560. ('33940', '51502', '0', '0', '2948'),
  561. ('33940', '51503', '0', '0', '2952'),
  562. ('33940', '51504', '0', '0', '2954'),
  563. ('33940', '51505', '0', '0', '2949'),
  564. ('33940', '51506', '0', '0', '2953'),
  565. ('33940', '51507', '0', '0', '2951'),
  566. ('33940', '51508', '0', '0', '2948'),
  567. ('33940', '51509', '0', '0', '2952'),
  568. ('33940', '51510', '0', '0', '2954'),
  569. ('33940', '51511', '0', '0', '2949'),
  570. ('33940', '51512', '0', '0', '2953'),
  571. ('33940', '51513', '0', '0', '2951'),
  572. ('33940', '51514', '0', '0', '2948'),
  573. ('33940', '51515', '0', '0', '2945'),
  574. ('33940', '51517', '0', '0', '2945'),
  575. ('33940', '51519', '0', '0', '2945'),
  576. ('33940', '51521', '0', '0', '2945'),
  577. ('33940', '51523', '0', '0', '2945'),
  578. ('33940', '51525', '0', '0', '2946'),
  579. ('33940', '51527', '0', '0', '2946'),
  580. ('33940', '51530', '0', '0', '2946'),
  581. ('33940', '51531', '0', '0', '2951'),
  582. ('33940', '51532', '0', '0', '2951'),
  583. ('33940', '51533', '0', '0', '2950'),
  584. ('33940', '51535', '0', '0', '2951'),
  585. ('33940', '51536', '0', '0', '2952'),
  586. ('33940', '51537', '0', '0', '2954'),
  587. ('33940', '51538', '0', '0', '2949'),
  588. ('33940', '51539', '0', '0', '2953'),
  589. ('33940', '51540', '0', '0', '2948'),
  590. ('33940', '51541', '0', '0', '2952'),
  591. ('33940', '51542', '0', '0', '2954'),
  592. ('33940', '51543', '0', '0', '2949'),
  593. ('33940', '51544', '0', '0', '2953'),
  594. ('33940', '51545', '0', '0', '2948');
  595.  
  596.  
  597. -- [33941] - Leeni "Smiley" Smalls
  598. DELETE FROM `npc_vendor` WHERE `entry`='33941';
  599. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  600. VALUES
  601. ('33941', '40787', '0', '0', '2959'),
  602. ('33941', '40788', '0', '0', '2959'),
  603. ('33941', '40789', '0', '0', '2959'),
  604. ('33941', '40807', '0', '0', '2960'),
  605. ('33941', '40808', '0', '0', '2960'),
  606. ('33941', '40809', '0', '0', '2960'),
  607. ('33941', '40826', '0', '0', '2959'),
  608. ('33941', '40827', '0', '0', '2959'),
  609. ('33941', '40828', '0', '0', '2959'),
  610. ('33941', '40847', '0', '0', '2958'),
  611. ('33941', '40848', '0', '0', '2958'),
  612. ('33941', '40849', '0', '0', '2958'),
  613. ('33941', '40866', '0', '0', '2958'),
  614. ('33941', '40868', '0', '0', '2958'),
  615. ('33941', '40869', '0', '0', '2958'),
  616. ('33941', '40907', '0', '0', '2959'),
  617. ('33941', '40927', '0', '0', '2960'),
  618. ('33941', '40933', '0', '0', '2959'),
  619. ('33941', '40939', '0', '0', '2958'),
  620. ('33941', '40963', '0', '0', '2958'),
  621. ('33941', '40992', '0', '0', '2959'),
  622. ('33941', '40993', '0', '0', '2959'),
  623. ('33941', '41001', '0', '0', '2960'),
  624. ('33941', '41007', '0', '0', '2960'),
  625. ('33941', '41013', '0', '0', '2959'),
  626. ('33941', '41019', '0', '0', '2959'),
  627. ('33941', '41027', '0', '0', '2958'),
  628. ('33941', '41033', '0', '0', '2958'),
  629. ('33941', '41038', '0', '0', '2958'),
  630. ('33941', '41044', '0', '0', '2958'),
  631. ('33941', '41081', '0', '0', '2959'),
  632. ('33941', '41087', '0', '0', '2959'),
  633. ('33941', '41137', '0', '0', '2960'),
  634. ('33941', '41143', '0', '0', '2960'),
  635. ('33941', '41151', '0', '0', '2959'),
  636. ('33941', '41157', '0', '0', '2959'),
  637. ('33941', '41199', '0', '0', '2958'),
  638. ('33941', '41205', '0', '0', '2958'),
  639. ('33941', '41211', '0', '0', '2958'),
  640. ('33941', '41217', '0', '0', '2958'),
  641. ('33941', '41275', '0', '0', '2958'),
  642. ('33941', '41281', '0', '0', '2958'),
  643. ('33941', '41287', '0', '0', '2960'),
  644. ('33941', '41293', '0', '0', '2960'),
  645. ('33941', '41298', '0', '0', '2958'),
  646. ('33941', '41304', '0', '0', '2958'),
  647. ('33941', '41310', '0', '0', '2959'),
  648. ('33941', '41316', '0', '0', '2959'),
  649. ('33941', '41321', '0', '0', '2959'),
  650. ('33941', '41327', '0', '0', '2959'),
  651. ('33941', '41650', '0', '0', '2959'),
  652. ('33941', '41655', '0', '0', '2958'),
  653. ('33941', '41661', '0', '0', '2959'),
  654. ('33941', '41667', '0', '0', '2958'),
  655. ('33941', '41672', '0', '0', '2959'),
  656. ('33941', '41678', '0', '0', '2959'),
  657. ('33941', '41683', '0', '0', '2958'),
  658. ('33941', '41715', '0', '0', '2958'),
  659. ('33941', '41767', '0', '0', '2960'),
  660. ('33941', '41773', '0', '0', '2960'),
  661. ('33941', '41854', '0', '0', '2959'),
  662. ('33941', '41859', '0', '0', '2959'),
  663. ('33941', '41864', '0', '0', '2958'),
  664. ('33941', '41869', '0', '0', '2958'),
  665. ('33941', '41874', '0', '0', '2960'),
  666. ('33941', '41915', '0', '0', '2959'),
  667. ('33941', '41921', '0', '0', '2959'),
  668. ('33941', '41927', '0', '0', '2958'),
  669. ('33941', '41934', '0', '0', '2958'),
  670. ('33941', '41940', '0', '0', '2960'),
  671. ('33941', '41946', '0', '0', '2959'),
  672. ('33941', '41953', '0', '0', '2959'),
  673. ('33941', '41959', '0', '0', '2958'),
  674. ('33941', '41965', '0', '0', '2958'),
  675. ('33941', '41971', '0', '0', '2960'),
  676. ('33941', '41993', '0', '0', '2959'),
  677. ('33941', '41998', '0', '0', '2959'),
  678. ('33941', '42005', '0', '0', '2958'),
  679. ('33941', '42011', '0', '0', '2958'),
  680. ('33941', '42017', '0', '0', '2960'),
  681. ('33941', '42579', '0', '0', '2969'),
  682. ('33941', '42584', '0', '0', '2969'),
  683. ('33941', '42589', '0', '0', '2969'),
  684. ('33941', '42598', '0', '0', '2969'),
  685. ('33941', '42603', '0', '0', '2969'),
  686. ('33941', '42608', '0', '0', '2969'),
  687. ('33941', '42615', '0', '0', '2969'),
  688. ('33941', '42621', '0', '0', '2969'),
  689. ('33941', '42853', '0', '0', '2969'),
  690. ('33941', '45706', '0', '0', '2596');
  691.  
  692.  
  693. -- [34094] - Grex Brainboiler
  694. DELETE FROM `npc_vendor` WHERE `entry`='34094';
  695. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  696. VALUES
  697. ('34094', '51389', '0', '0', '2939'),
  698. ('34094', '51391', '0', '0', '2939'),
  699. ('34094', '51393', '0', '0', '2939'),
  700. ('34094', '51395', '0', '0', '2939'),
  701. ('34094', '51398', '0', '0', '2940'),
  702. ('34094', '51399', '0', '0', '2940'),
  703. ('34094', '51401', '0', '0', '2939'),
  704. ('34094', '51403', '0', '0', '2939'),
  705. ('34094', '51405', '0', '0', '2939'),
  706. ('34094', '51412', '0', '0', '2939'),
  707. ('34094', '51432', '0', '0', '2939'),
  708. ('34094', '51440', '0', '0', '2947'),
  709. ('34094', '51442', '0', '0', '2947'),
  710. ('34094', '51444', '0', '0', '2947'),
  711. ('34094', '51446', '0', '0', '2947'),
  712. ('34094', '51448', '0', '0', '2947'),
  713. ('34094', '51450', '0', '0', '2939'),
  714. ('34094', '51454', '0', '0', '2940'),
  715. ('34094', '51457', '0', '0', '2939'),
  716. ('34094', '51481', '0', '0', '2939'),
  717. ('34094', '51516', '0', '0', '2944'),
  718. ('34094', '51518', '0', '0', '2944'),
  719. ('34094', '51520', '0', '0', '2944'),
  720. ('34094', '51522', '0', '0', '2944'),
  721. ('34094', '51524', '0', '0', '2944'),
  722. ('34094', '51526', '0', '0', '2947'),
  723. ('34094', '51528', '0', '0', '2947'),
  724. ('34094', '51529', '0', '0', '2947'),
  725. ('34094', '51534', '0', '0', '2937');
  726.  
  727.  
  728.  
  729. -- SEASON 8 DALARAN VENDORS
  730. -- SPAWN
  731. DELETE FROM `creature` WHERE `id` IN ('33934', '33935', '33939', '34093');
  732. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  733. VALUES
  734. ('33936', '571', '1', '65535', '0', '0', '5753.39', '585.66', '614.969', '5.65498', '600', '0', '0', '8025', '0', '0', '0'),
  735. ('33937', '571', '1', '65535', '0', '0', '5751.4', '584.833', '614.969', '5.63141', '600', '0', '0', '8025', '0', '0', '0'),
  736. ('33938', '571', '1', '65535', '0', '0', '5751.3', '583.16', '614.969', '5.85132', '600', '0', '0', '8025', '0', '0', '0'),
  737. ('34095', '571', '1', '65535', '0', '0', '5761.39', '578.411', '614.969', '2.02643', '600', '0', '0', '6986', '0', '0', '0');
  738.  
  739. -- TEMPLATE UP
  740. 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;
  741. 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;
  742. 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;
  743. 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;
  744.  
  745. -- [33936] - Nargle Lashcord
  746. DELETE FROM `npc_vendor` WHERE `entry`='33936';
  747. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  748. VALUES
  749. ('33936', '51388', '0', '0', '2936'),
  750. ('33936', '51390', '0', '0', '2936'),
  751. ('33936', '51392', '0', '0', '2936'),
  752. ('33936', '51394', '0', '0', '2936'),
  753. ('33936', '51396', '0', '0', '2950'),
  754. ('33936', '51397', '0', '0', '2943'),
  755. ('33936', '51400', '0', '0', '2936'),
  756. ('33936', '51402', '0', '0', '2936'),
  757. ('33936', '51404', '0', '0', '2936'),
  758. ('33936', '51406', '0', '0', '2943'),
  759. ('33936', '51407', '0', '0', '2950'),
  760. ('33936', '51408', '0', '0', '2950'),
  761. ('33936', '51409', '0', '0', '2950'),
  762. ('33936', '51410', '0', '0', '2951'),
  763. ('33936', '51411', '0', '0', '2936'),
  764. ('33936', '51413', '0', '0', '2952'),
  765. ('33936', '51414', '0', '0', '2954'),
  766. ('33936', '51415', '0', '0', '2949'),
  767. ('33936', '51416', '0', '0', '2953'),
  768. ('33936', '51417', '0', '0', '2951'),
  769. ('33936', '51418', '0', '0', '2948'),
  770. ('33936', '51419', '0', '0', '2952'),
  771. ('33936', '51420', '0', '0', '2954'),
  772. ('33936', '51421', '0', '0', '2949'),
  773. ('33936', '51422', '0', '0', '2953'),
  774. ('33936', '51423', '0', '0', '2951'),
  775. ('33936', '51424', '0', '0', '2948'),
  776. ('33936', '51425', '0', '0', '2952'),
  777. ('33936', '51426', '0', '0', '2954'),
  778. ('33936', '51427', '0', '0', '2949'),
  779. ('33936', '51428', '0', '0', '2953'),
  780. ('33936', '51429', '0', '0', '2951'),
  781. ('33936', '51430', '0', '0', '2948'),
  782. ('33936', '51431', '0', '0', '2936'),
  783. ('33936', '51433', '0', '0', '2952'),
  784. ('33936', '51434', '0', '0', '2954'),
  785. ('33936', '51435', '0', '0', '2949'),
  786. ('33936', '51436', '0', '0', '2953'),
  787. ('33936', '51437', '0', '0', '2951'),
  788. ('33936', '51438', '0', '0', '2948'),
  789. ('33936', '51439', '0', '0', '2946'),
  790. ('33936', '51441', '0', '0', '2946'),
  791. ('33936', '51443', '0', '0', '2946'),
  792. ('33936', '51445', '0', '0', '2946'),
  793. ('33936', '51447', '0', '0', '2946'),
  794. ('33936', '51449', '0', '0', '2936'),
  795. ('33936', '51451', '0', '0', '2951'),
  796. ('33936', '51452', '0', '0', '2950'),
  797. ('33936', '51453', '0', '0', '2943'),
  798. ('33936', '51455', '0', '0', '2950'),
  799. ('33936', '51456', '0', '0', '2936'),
  800. ('33936', '51458', '0', '0', '2952'),
  801. ('33936', '51459', '0', '0', '2954'),
  802. ('33936', '51460', '0', '0', '2949'),
  803. ('33936', '51461', '0', '0', '2953'),
  804. ('33936', '51462', '0', '0', '2948'),
  805. ('33936', '51463', '0', '0', '2952'),
  806. ('33936', '51464', '0', '0', '2954'),
  807. ('33936', '51465', '0', '0', '2949'),
  808. ('33936', '51466', '0', '0', '2953'),
  809. ('33936', '51467', '0', '0', '2948'),
  810. ('33936', '51468', '0', '0', '2952'),
  811. ('33936', '51469', '0', '0', '2954'),
  812. ('33936', '51470', '0', '0', '2949'),
  813. ('33936', '51471', '0', '0', '2953'),
  814. ('33936', '51472', '0', '0', '2951'),
  815. ('33936', '51473', '0', '0', '2948'),
  816. ('33936', '51474', '0', '0', '2952'),
  817. ('33936', '51475', '0', '0', '2954'),
  818. ('33936', '51476', '0', '0', '2949'),
  819. ('33936', '51477', '0', '0', '2953'),
  820. ('33936', '51478', '0', '0', '2951'),
  821. ('33936', '51479', '0', '0', '2948'),
  822. ('33936', '51480', '0', '0', '2936'),
  823. ('33936', '51482', '0', '0', '2952'),
  824. ('33936', '51483', '0', '0', '2954'),
  825. ('33936', '51484', '0', '0', '2949'),
  826. ('33936', '51485', '0', '0', '2953'),
  827. ('33936', '51486', '0', '0', '2948'),
  828. ('33936', '51487', '0', '0', '2952'),
  829. ('33936', '51488', '0', '0', '2954'),
  830. ('33936', '51489', '0', '0', '2949'),
  831. ('33936', '51490', '0', '0', '2953'),
  832. ('33936', '51491', '0', '0', '2948'),
  833. ('33936', '51492', '0', '0', '2952'),
  834. ('33936', '51493', '0', '0', '2954'),
  835. ('33936', '51494', '0', '0', '2949'),
  836. ('33936', '51495', '0', '0', '2953'),
  837. ('33936', '51496', '0', '0', '2948'),
  838. ('33936', '51497', '0', '0', '2952'),
  839. ('33936', '51498', '0', '0', '2954'),
  840. ('33936', '51499', '0', '0', '2949'),
  841. ('33936', '51500', '0', '0', '2953'),
  842. ('33936', '51501', '0', '0', '2951'),
  843. ('33936', '51502', '0', '0', '2948'),
  844. ('33936', '51503', '0', '0', '2952'),
  845. ('33936', '51504', '0', '0', '2954'),
  846. ('33936', '51505', '0', '0', '2949'),
  847. ('33936', '51506', '0', '0', '2953'),
  848. ('33936', '51507', '0', '0', '2951'),
  849. ('33936', '51508', '0', '0', '2948'),
  850. ('33936', '51509', '0', '0', '2952'),
  851. ('33936', '51510', '0', '0', '2954'),
  852. ('33936', '51511', '0', '0', '2949'),
  853. ('33936', '51512', '0', '0', '2953'),
  854. ('33936', '51513', '0', '0', '2951'),
  855. ('33936', '51514', '0', '0', '2948'),
  856. ('33936', '51515', '0', '0', '2945'),
  857. ('33936', '51517', '0', '0', '2945'),
  858. ('33936', '51519', '0', '0', '2945'),
  859. ('33936', '51521', '0', '0', '2945'),
  860. ('33936', '51523', '0', '0', '2945'),
  861. ('33936', '51525', '0', '0', '2946'),
  862. ('33936', '51527', '0', '0', '2946'),
  863. ('33936', '51530', '0', '0', '2946'),
  864. ('33936', '51531', '0', '0', '2951'),
  865. ('33936', '51532', '0', '0', '2951'),
  866. ('33936', '51533', '0', '0', '2950'),
  867. ('33936', '51535', '0', '0', '2951'),
  868. ('33936', '51536', '0', '0', '2952'),
  869. ('33936', '51537', '0', '0', '2954'),
  870. ('33936', '51538', '0', '0', '2949'),
  871. ('33936', '51539', '0', '0', '2953'),
  872. ('33936', '51540', '0', '0', '2948'),
  873. ('33936', '51541', '0', '0', '2952'),
  874. ('33936', '51542', '0', '0', '2954'),
  875. ('33936', '51543', '0', '0', '2949'),
  876. ('33936', '51544', '0', '0', '2953'),
  877. ('33936', '51545', '0', '0', '2948');
  878.  
  879.  
  880. -- [33937] - Xazi Smolderpipe
  881. DELETE FROM `npc_vendor` WHERE `entry`='33937';
  882. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  883. VALUES
  884. ('33937', '40790', '0', '0', '2956'),
  885. ('33937', '40791', '0', '0', '2956'),
  886. ('33937', '40792', '0', '0', '2956'),
  887. ('33937', '40810', '0', '0', '2957'),
  888. ('33937', '40811', '0', '0', '2957'),
  889. ('33937', '40812', '0', '0', '2957'),
  890. ('33937', '40829', '0', '0', '2956'),
  891. ('33937', '40830', '0', '0', '2956'),
  892. ('33937', '40831', '0', '0', '2956'),
  893. ('33937', '40850', '0', '0', '2956'),
  894. ('33937', '40851', '0', '0', '2956'),
  895. ('33937', '40852', '0', '0', '2956'),
  896. ('33937', '40870', '0', '0', '2955'),
  897. ('33937', '40871', '0', '0', '2955'),
  898. ('33937', '40872', '0', '0', '2955'),
  899. ('33937', '40910', '0', '0', '2956'),
  900. ('33937', '40928', '0', '0', '2957'),
  901. ('33937', '40934', '0', '0', '2956'),
  902. ('33937', '40940', '0', '0', '2956'),
  903. ('33937', '40964', '0', '0', '2955'),
  904. ('33937', '40994', '0', '0', '2956'),
  905. ('33937', '40995', '0', '0', '2956'),
  906. ('33937', '41002', '0', '0', '2957'),
  907. ('33937', '41008', '0', '0', '2957'),
  908. ('33937', '41014', '0', '0', '2956'),
  909. ('33937', '41020', '0', '0', '2956'),
  910. ('33937', '41028', '0', '0', '2956'),
  911. ('33937', '41034', '0', '0', '2956'),
  912. ('33937', '41039', '0', '0', '2955'),
  913. ('33937', '41045', '0', '0', '2955'),
  914. ('33937', '41082', '0', '0', '2956'),
  915. ('33937', '41088', '0', '0', '2956'),
  916. ('33937', '41138', '0', '0', '2957'),
  917. ('33937', '41144', '0', '0', '2957'),
  918. ('33937', '41152', '0', '0', '2956'),
  919. ('33937', '41158', '0', '0', '2956'),
  920. ('33937', '41200', '0', '0', '2956'),
  921. ('33937', '41206', '0', '0', '2956'),
  922. ('33937', '41212', '0', '0', '2955'),
  923. ('33937', '41218', '0', '0', '2955'),
  924. ('33937', '41276', '0', '0', '2955'),
  925. ('33937', '41282', '0', '0', '2955'),
  926. ('33937', '41288', '0', '0', '2957'),
  927. ('33937', '41294', '0', '0', '2957'),
  928. ('33937', '41299', '0', '0', '2956'),
  929. ('33937', '41305', '0', '0', '2956'),
  930. ('33937', '41311', '0', '0', '2956'),
  931. ('33937', '41317', '0', '0', '2956'),
  932. ('33937', '41322', '0', '0', '2956'),
  933. ('33937', '41328', '0', '0', '2956'),
  934. ('33937', '41651', '0', '0', '2956'),
  935. ('33937', '41656', '0', '0', '2956'),
  936. ('33937', '41662', '0', '0', '2956'),
  937. ('33937', '41668', '0', '0', '2956'),
  938. ('33937', '41673', '0', '0', '2956'),
  939. ('33937', '41679', '0', '0', '2956'),
  940. ('33937', '41684', '0', '0', '2955'),
  941. ('33937', '41716', '0', '0', '2955'),
  942. ('33937', '41768', '0', '0', '2957'),
  943. ('33937', '41774', '0', '0', '2957'),
  944. ('33937', '41855', '0', '0', '2956'),
  945. ('33937', '41860', '0', '0', '2956'),
  946. ('33937', '41865', '0', '0', '2956'),
  947. ('33937', '41870', '0', '0', '2955'),
  948. ('33937', '41875', '0', '0', '2957'),
  949. ('33937', '41916', '0', '0', '2956'),
  950. ('33937', '41922', '0', '0', '2956'),
  951. ('33937', '41928', '0', '0', '2956'),
  952. ('33937', '41935', '0', '0', '2955'),
  953. ('33937', '41941', '0', '0', '2957'),
  954. ('33937', '41947', '0', '0', '2956'),
  955. ('33937', '41954', '0', '0', '2956'),
  956. ('33937', '41960', '0', '0', '2956'),
  957. ('33937', '41966', '0', '0', '2955'),
  958. ('33937', '41972', '0', '0', '2957'),
  959. ('33937', '41994', '0', '0', '2956'),
  960. ('33937', '41999', '0', '0', '2956'),
  961. ('33937', '42006', '0', '0', '2956'),
  962. ('33937', '42012', '0', '0', '2955'),
  963. ('33937', '42018', '0', '0', '2957'),
  964. ('33937', '42580', '0', '0', '2608'),
  965. ('33937', '42585', '0', '0', '2608'),
  966. ('33937', '42591', '0', '0', '2608'),
  967. ('33937', '42599', '0', '0', '2608'),
  968. ('33937', '42604', '0', '0', '2608'),
  969. ('33937', '42609', '0', '0', '2608'),
  970. ('33937', '42616', '0', '0', '2608'),
  971. ('33937', '42622', '0', '0', '2608'),
  972. ('33937', '42854', '0', '0', '2608'),
  973. ('33937', '45706', '0', '0', '2596');
  974.  
  975. -- [33938] - Zom Bocom
  976. DELETE FROM `npc_vendor` WHERE `entry`='33938';
  977. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  978. VALUES
  979. ('33938', '40787', '0', '0', '2959'),
  980. ('33938', '40788', '0', '0', '2959'),
  981. ('33938', '40789', '0', '0', '2959'),
  982. ('33938', '40807', '0', '0', '2960'),
  983. ('33938', '40808', '0', '0', '2960'),
  984. ('33938', '40809', '0', '0', '2960'),
  985. ('33938', '40826', '0', '0', '2959'),
  986. ('33938', '40827', '0', '0', '2959'),
  987. ('33938', '40828', '0', '0', '2959'),
  988. ('33938', '40847', '0', '0', '2958'),
  989. ('33938', '40848', '0', '0', '2958'),
  990. ('33938', '40849', '0', '0', '2958'),
  991. ('33938', '40866', '0', '0', '2958'),
  992. ('33938', '40868', '0', '0', '2958'),
  993. ('33938', '40869', '0', '0', '2958'),
  994. ('33938', '40907', '0', '0', '2959'),
  995. ('33938', '40927', '0', '0', '2960'),
  996. ('33938', '40933', '0', '0', '2959'),
  997. ('33938', '40939', '0', '0', '2958'),
  998. ('33938', '40963', '0', '0', '2958'),
  999. ('33938', '40992', '0', '0', '2959'),
  1000. ('33938', '40993', '0', '0', '2959'),
  1001. ('33938', '41001', '0', '0', '2960'),
  1002. ('33938', '41007', '0', '0', '2960'),
  1003. ('33938', '41013', '0', '0', '2959'),
  1004. ('33938', '41019', '0', '0', '2959'),
  1005. ('33938', '41027', '0', '0', '2958'),
  1006. ('33938', '41033', '0', '0', '2958'),
  1007. ('33938', '41038', '0', '0', '2958'),
  1008. ('33938', '41044', '0', '0', '2958'),
  1009. ('33938', '41081', '0', '0', '2959'),
  1010. ('33938', '41087', '0', '0', '2959'),
  1011. ('33938', '41137', '0', '0', '2960'),
  1012. ('33938', '41143', '0', '0', '2960'),
  1013. ('33938', '41151', '0', '0', '2959'),
  1014. ('33938', '41157', '0', '0', '2959'),
  1015. ('33938', '41199', '0', '0', '2958'),
  1016. ('33938', '41205', '0', '0', '2958'),
  1017. ('33938', '41211', '0', '0', '2958'),
  1018. ('33938', '41217', '0', '0', '2958'),
  1019. ('33938', '41275', '0', '0', '2958'),
  1020. ('33938', '41281', '0', '0', '2958'),
  1021. ('33938', '41287', '0', '0', '2960'),
  1022. ('33938', '41293', '0', '0', '2960'),
  1023. ('33938', '41298', '0', '0', '2958'),
  1024. ('33938', '41304', '0', '0', '2958'),
  1025. ('33938', '41310', '0', '0', '2959'),
  1026. ('33938', '41316', '0', '0', '2959'),
  1027. ('33938', '41321', '0', '0', '2959'),
  1028. ('33938', '41327', '0', '0', '2959'),
  1029. ('33938', '41650', '0', '0', '2959'),
  1030. ('33938', '41655', '0', '0', '2958'),
  1031. ('33938', '41661', '0', '0', '2959'),
  1032. ('33938', '41667', '0', '0', '2958'),
  1033. ('33938', '41672', '0', '0', '2959'),
  1034. ('33938', '41678', '0', '0', '2959'),
  1035. ('33938', '41683', '0', '0', '2958'),
  1036. ('33938', '41715', '0', '0', '2958'),
  1037. ('33938', '41767', '0', '0', '2960'),
  1038. ('33938', '41773', '0', '0', '2960'),
  1039. ('33938', '41854', '0', '0', '2959'),
  1040. ('33938', '41859', '0', '0', '2959'),
  1041. ('33938', '41864', '0', '0', '2958'),
  1042. ('33938', '41869', '0', '0', '2958'),
  1043. ('33938', '41874', '0', '0', '2960'),
  1044. ('33938', '41915', '0', '0', '2959'),
  1045. ('33938', '41921', '0', '0', '2959'),
  1046. ('33938', '41927', '0', '0', '2958'),
  1047. ('33938', '41934', '0', '0', '2958'),
  1048. ('33938', '41940', '0', '0', '2960'),
  1049. ('33938', '41946', '0', '0', '2959'),
  1050. ('33938', '41953', '0', '0', '2959'),
  1051. ('33938', '41959', '0', '0', '2958'),
  1052. ('33938', '41965', '0', '0', '2958'),
  1053. ('33938', '41971', '0', '0', '2960'),
  1054. ('33938', '41993', '0', '0', '2959'),
  1055. ('33938', '41998', '0', '0', '2959'),
  1056. ('33938', '42005', '0', '0', '2958'),
  1057. ('33938', '42011', '0', '0', '2958'),
  1058. ('33938', '42017', '0', '0', '2960'),
  1059. ('33938', '42579', '0', '0', '2969'),
  1060. ('33938', '42584', '0', '0', '2969'),
  1061. ('33938', '42589', '0', '0', '2969'),
  1062. ('33938', '42598', '0', '0', '2969'),
  1063. ('33938', '42603', '0', '0', '2969'),
  1064. ('33938', '42608', '0', '0', '2969'),
  1065. ('33938', '42615', '0', '0', '2969'),
  1066. ('33938', '42621', '0', '0', '2969'),
  1067. ('33938', '42853', '0', '0', '2969'),
  1068. ('33938', '45706', '0', '0', '2596');
  1069.  
  1070. -- [34095] - Trapjaw Rix
  1071. DELETE FROM `npc_vendor` WHERE `entry`='34095';
  1072. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1073. VALUES
  1074. ('34095', '51389', '0', '0', '2939'),
  1075. ('34095', '51391', '0', '0', '2939'),
  1076. ('34095', '51393', '0', '0', '2939'),
  1077. ('34095', '51395', '0', '0', '2939'),
  1078. ('34095', '51398', '0', '0', '2940'),
  1079. ('34095', '51399', '0', '0', '2940'),
  1080. ('34095', '51401', '0', '0', '2939'),
  1081. ('34095', '51403', '0', '0', '2939'),
  1082. ('34095', '51405', '0', '0', '2939'),
  1083. ('34095', '51412', '0', '0', '2939'),
  1084. ('34095', '51432', '0', '0', '2939'),
  1085. ('34095', '51440', '0', '0', '2947'),
  1086. ('34095', '51442', '0', '0', '2947'),
  1087. ('34095', '51444', '0', '0', '2947'),
  1088. ('34095', '51446', '0', '0', '2947'),
  1089. ('34095', '51448', '0', '0', '2947'),
  1090. ('34095', '51450', '0', '0', '2939'),
  1091. ('34095', '51454', '0', '0', '2940'),
  1092. ('34095', '51457', '0', '0', '2939'),
  1093. ('34095', '51481', '0', '0', '2939'),
  1094. ('34095', '51516', '0', '0', '2944'),
  1095. ('34095', '51518', '0', '0', '2944'),
  1096. ('34095', '51520', '0', '0', '2944'),
  1097. ('34095', '51522', '0', '0', '2944'),
  1098. ('34095', '51524', '0', '0', '2944'),
  1099. ('34095', '51526', '0', '0', '2947'),
  1100. ('34095', '51528', '0', '0', '2947'),
  1101. ('34095', '51529', '0', '0', '2947'),
  1102. ('34095', '51534', '0', '0', '2937');
  1103.  
  1104.  
  1105.  
  1106. -- SEASON 8 VENDORS
  1107. -- SPAWN
  1108. DELETE FROM `creature` WHERE `id` IN ('33934', '33935', '33939', '34093');
  1109. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  1110. VALUES
  1111. ('33934', '1', '1', '1', '0', '0', '-7120.75', '-3774.16', '9.0363', '0.767945', '600', '0', '0', '6986', '0', '0', '0'),
  1112. ('33935', '1', '1', '1', '0', '915', '-7121.21', '-3772.24', '9.10584', '0.417131', '600', '0', '0', '6986', '0', '0', '0'),
  1113. ('33939', '1', '1', '1', '0', '0', '-7117.46', '-3779.66', '8.68703', '0.205764', '600', '0', '0', '7000', '0', '0', '0'),
  1114. ('34093', '1', '1', '1', '0', '0', '-7126.62', '-3761.68', '9.40626', '0.547374', '600', '0', '0', '6986', '0', '0', '0');
  1115.  
  1116. -- TEMPLATE UP
  1117. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "4224", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33934;
  1118. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33935;
  1119. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `equipment_id` = "1417", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=33939;
  1120. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "1", `minhealth` = "6986", `maxhealth` = "6986", `armor` = "6740", `npcflag` = "128", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `equipment_id` = "1936", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=34093;
  1121.  
  1122.  
  1123. -- VENDOR PART
  1124. -- [33934] - Ecton Brasstumbler
  1125. DELETE FROM `npc_vendor` WHERE `entry`='33934';
  1126. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1127. VALUES
  1128. ('33934', '40787', '0', '0', '2959'),
  1129. ('33934', '40788', '0', '0', '2959'),
  1130. ('33934', '40789', '0', '0', '2959'),
  1131. ('33934', '40807', '0', '0', '2960'),
  1132. ('33934', '40808', '0', '0', '2960'),
  1133. ('33934', '40809', '0', '0', '2960'),
  1134. ('33934', '40826', '0', '0', '2959'),
  1135. ('33934', '40827', '0', '0', '2959'),
  1136. ('33934', '40828', '0', '0', '2959'),
  1137. ('33934', '40847', '0', '0', '2958'),
  1138. ('33934', '40848', '0', '0', '2958'),
  1139. ('33934', '40849', '0', '0', '2958'),
  1140. ('33934', '40866', '0', '0', '2958'),
  1141. ('33934', '40868', '0', '0', '2958'),
  1142. ('33934', '40869', '0', '0', '2958'),
  1143. ('33934', '40907', '0', '0', '2959'),
  1144. ('33934', '40927', '0', '0', '2960'),
  1145. ('33934', '40933', '0', '0', '2959'),
  1146. ('33934', '40939', '0', '0', '2958'),
  1147. ('33934', '40963', '0', '0', '2958'),
  1148. ('33934', '40992', '0', '0', '2959'),
  1149. ('33934', '40993', '0', '0', '2959'),
  1150. ('33934', '41001', '0', '0', '2960'),
  1151. ('33934', '41007', '0', '0', '2960'),
  1152. ('33934', '41013', '0', '0', '2959'),
  1153. ('33934', '41019', '0', '0', '2959'),
  1154. ('33934', '41027', '0', '0', '2958'),
  1155. ('33934', '41033', '0', '0', '2958'),
  1156. ('33934', '41038', '0', '0', '2958'),
  1157. ('33934', '41044', '0', '0', '2958'),
  1158. ('33934', '41081', '0', '0', '2959'),
  1159. ('33934', '41087', '0', '0', '2959'),
  1160. ('33934', '41137', '0', '0', '2960'),
  1161. ('33934', '41143', '0', '0', '2960'),
  1162. ('33934', '41151', '0', '0', '2959'),
  1163. ('33934', '41157', '0', '0', '2959'),
  1164. ('33934', '41199', '0', '0', '2958'),
  1165. ('33934', '41205', '0', '0', '2958'),
  1166. ('33934', '41211', '0', '0', '2958'),
  1167. ('33934', '41217', '0', '0', '2958'),
  1168. ('33934', '41275', '0', '0', '2958'),
  1169. ('33934', '41281', '0', '0', '2958'),
  1170. ('33934', '41287', '0', '0', '2960'),
  1171. ('33934', '41293', '0', '0', '2960'),
  1172. ('33934', '41298', '0', '0', '2958'),
  1173. ('33934', '41304', '0', '0', '2958'),
  1174. ('33934', '41310', '0', '0', '2959'),
  1175. ('33934', '41316', '0', '0', '2959'),
  1176. ('33934', '41321', '0', '0', '2959'),
  1177. ('33934', '41327', '0', '0', '2959'),
  1178. ('33934', '41650', '0', '0', '2959'),
  1179. ('33934', '41655', '0', '0', '2958'),
  1180. ('33934', '41661', '0', '0', '2959'),
  1181. ('33934', '41667', '0', '0', '2958'),
  1182. ('33934', '41672', '0', '0', '2959'),
  1183. ('33934', '41678', '0', '0', '2959'),
  1184. ('33934', '41683', '0', '0', '2958'),
  1185. ('33934', '41715', '0', '0', '2958'),
  1186. ('33934', '41767', '0', '0', '2960'),
  1187. ('33934', '41773', '0', '0', '2960'),
  1188. ('33934', '41854', '0', '0', '2959'),
  1189. ('33934', '41859', '0', '0', '2959'),
  1190. ('33934', '41864', '0', '0', '2958'),
  1191. ('33934', '41869', '0', '0', '2958'),
  1192. ('33934', '41874', '0', '0', '2960'),
  1193. ('33934', '41915', '0', '0', '2959'),
  1194. ('33934', '41921', '0', '0', '2959'),
  1195. ('33934', '41927', '0', '0', '2958'),
  1196. ('33934', '41934', '0', '0', '2958'),
  1197. ('33934', '41940', '0', '0', '2960'),
  1198. ('33934', '41946', '0', '0', '2959'),
  1199. ('33934', '41953', '0', '0', '2959'),
  1200. ('33934', '41959', '0', '0', '2958'),
  1201. ('33934', '41965', '0', '0', '2958'),
  1202. ('33934', '41971', '0', '0', '2960'),
  1203. ('33934', '41993', '0', '0', '2959'),
  1204. ('33934', '41998', '0', '0', '2959'),
  1205. ('33934', '42005', '0', '0', '2958'),
  1206. ('33934', '42011', '0', '0', '2958'),
  1207. ('33934', '42017', '0', '0', '2960'),
  1208. ('33934', '42579', '0', '0', '2969'),
  1209. ('33934', '42584', '0', '0', '2969'),
  1210. ('33934', '42589', '0', '0', '2969'),
  1211. ('33934', '42598', '0', '0', '2969'),
  1212. ('33934', '42603', '0', '0', '2969'),
  1213. ('33934', '42608', '0', '0', '2969'),
  1214. ('33934', '42615', '0', '0', '2969'),
  1215. ('33934', '42621', '0', '0', '2969'),
  1216. ('33934', '42853', '0', '0', '2969'),
  1217. ('33934', '45706', '0', '0', '2596');
  1218.  
  1219.  
  1220. -- [33935] - Evee Copperspring
  1221. DELETE FROM `npc_vendor` WHERE `entry`='33935';
  1222. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1223. VALUES
  1224. ('33935', '40790', '0', '0', '2956'),
  1225. ('33935', '40791', '0', '0', '2956'),
  1226. ('33935', '40792', '0', '0', '2956'),
  1227. ('33935', '40810', '0', '0', '2957'),
  1228. ('33935', '40811', '0', '0', '2957'),
  1229. ('33935', '40812', '0', '0', '2957'),
  1230. ('33935', '40829', '0', '0', '2956'),
  1231. ('33935', '40830', '0', '0', '2956'),
  1232. ('33935', '40831', '0', '0', '2956'),
  1233. ('33935', '40850', '0', '0', '2956'),
  1234. ('33935', '40851', '0', '0', '2956'),
  1235. ('33935', '40852', '0', '0', '2956'),
  1236. ('33935', '40870', '0', '0', '2955'),
  1237. ('33935', '40871', '0', '0', '2955'),
  1238. ('33935', '40872', '0', '0', '2955'),
  1239. ('33935', '40910', '0', '0', '2956'),
  1240. ('33935', '40928', '0', '0', '2957'),
  1241. ('33935', '40934', '0', '0', '2956'),
  1242. ('33935', '40940', '0', '0', '2956'),
  1243. ('33935', '40964', '0', '0', '2955'),
  1244. ('33935', '40994', '0', '0', '2956'),
  1245. ('33935', '40995', '0', '0', '2956'),
  1246. ('33935', '41002', '0', '0', '2957'),
  1247. ('33935', '41008', '0', '0', '2957'),
  1248. ('33935', '41014', '0', '0', '2956'),
  1249. ('33935', '41020', '0', '0', '2956'),
  1250. ('33935', '41028', '0', '0', '2956'),
  1251. ('33935', '41034', '0', '0', '2956'),
  1252. ('33935', '41039', '0', '0', '2955'),
  1253. ('33935', '41045', '0', '0', '2955'),
  1254. ('33935', '41082', '0', '0', '2956'),
  1255. ('33935', '41088', '0', '0', '2956'),
  1256. ('33935', '41138', '0', '0', '2957'),
  1257. ('33935', '41144', '0', '0', '2957'),
  1258. ('33935', '41152', '0', '0', '2956'),
  1259. ('33935', '41158', '0', '0', '2956'),
  1260. ('33935', '41200', '0', '0', '2956'),
  1261. ('33935', '41206', '0', '0', '2956'),
  1262. ('33935', '41212', '0', '0', '2955'),
  1263. ('33935', '41218', '0', '0', '2955'),
  1264. ('33935', '41276', '0', '0', '2955'),
  1265. ('33935', '41282', '0', '0', '2955'),
  1266. ('33935', '41288', '0', '0', '2957'),
  1267. ('33935', '41294', '0', '0', '2957'),
  1268. ('33935', '41299', '0', '0', '2956'),
  1269. ('33935', '41305', '0', '0', '2956'),
  1270. ('33935', '41311', '0', '0', '2956'),
  1271. ('33935', '41317', '0', '0', '2956'),
  1272. ('33935', '41322', '0', '0', '2956'),
  1273. ('33935', '41328', '0', '0', '2956'),
  1274. ('33935', '41651', '0', '0', '2956'),
  1275. ('33935', '41656', '0', '0', '2956'),
  1276. ('33935', '41662', '0', '0', '2956'),
  1277. ('33935', '41668', '0', '0', '2956'),
  1278. ('33935', '41673', '0', '0', '2956'),
  1279. ('33935', '41679', '0', '0', '2956'),
  1280. ('33935', '41684', '0', '0', '2955'),
  1281. ('33935', '41716', '0', '0', '2955'),
  1282. ('33935', '41768', '0', '0', '2957'),
  1283. ('33935', '41774', '0', '0', '2957'),
  1284. ('33935', '41855', '0', '0', '2956'),
  1285. ('33935', '41860', '0', '0', '2956'),
  1286. ('33935', '41865', '0', '0', '2956'),
  1287. ('33935', '41870', '0', '0', '2955'),
  1288. ('33935', '41875', '0', '0', '2957'),
  1289. ('33935', '41916', '0', '0', '2956'),
  1290. ('33935', '41922', '0', '0', '2956'),
  1291. ('33935', '41928', '0', '0', '2956'),
  1292. ('33935', '41935', '0', '0', '2955'),
  1293. ('33935', '41941', '0', '0', '2957'),
  1294. ('33935', '41947', '0', '0', '2956'),
  1295. ('33935', '41954', '0', '0', '2956'),
  1296. ('33935', '41960', '0', '0', '2956'),
  1297. ('33935', '41966', '0', '0', '2955'),
  1298. ('33935', '41972', '0', '0', '2957'),
  1299. ('33935', '41994', '0', '0', '2956'),
  1300. ('33935', '41999', '0', '0', '2956'),
  1301. ('33935', '42006', '0', '0', '2956'),
  1302. ('33935', '42012', '0', '0', '2955'),
  1303. ('33935', '42018', '0', '0', '2957'),
  1304. ('33935', '42580', '0', '0', '2608'),
  1305. ('33935', '42585', '0', '0', '2608'),
  1306. ('33935', '42591', '0', '0', '2608'),
  1307. ('33935', '42599', '0', '0', '2608'),
  1308. ('33935', '42604', '0', '0', '2608'),
  1309. ('33935', '42609', '0', '0', '2608'),
  1310. ('33935', '42616', '0', '0', '2608'),
  1311. ('33935', '42622', '0', '0', '2608'),
  1312. ('33935', '42854', '0', '0', '2608'),
  1313. ('33935', '45706', '0', '0', '2596');
  1314.  
  1315.  
  1316. -- [33939] - Argex Irongut
  1317. DELETE FROM `npc_vendor` WHERE `entry`='33939';
  1318. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1319. VALUES
  1320. ('33939', '51388', '0', '0', '2936'),
  1321. ('33939', '51390', '0', '0', '2936'),
  1322. ('33939', '51392', '0', '0', '2936'),
  1323. ('33939', '51394', '0', '0', '2936'),
  1324. ('33939', '51396', '0', '0', '2950'),
  1325. ('33939', '51397', '0', '0', '2943'),
  1326. ('33939', '51400', '0', '0', '2936'),
  1327. ('33939', '51402', '0', '0', '2936'),
  1328. ('33939', '51404', '0', '0', '2936'),
  1329. ('33939', '51406', '0', '0', '2943'),
  1330. ('33939', '51407', '0', '0', '2950'),
  1331. ('33939', '51408', '0', '0', '2950'),
  1332. ('33939', '51409', '0', '0', '2950'),
  1333. ('33939', '51410', '0', '0', '2951'),
  1334. ('33939', '51411', '0', '0', '2936'),
  1335. ('33939', '51413', '0', '0', '2952'),
  1336. ('33939', '51414', '0', '0', '2954'),
  1337. ('33939', '51415', '0', '0', '2949'),
  1338. ('33939', '51416', '0', '0', '2953'),
  1339. ('33939', '51417', '0', '0', '2951'),
  1340. ('33939', '51418', '0', '0', '2948'),
  1341. ('33939', '51419', '0', '0', '2952'),
  1342. ('33939', '51420', '0', '0', '2954'),
  1343. ('33939', '51421', '0', '0', '2949'),
  1344. ('33939', '51422', '0', '0', '2953'),
  1345. ('33939', '51423', '0', '0', '2951'),
  1346. ('33939', '51424', '0', '0', '2948'),
  1347. ('33939', '51425', '0', '0', '2952'),
  1348. ('33939', '51426', '0', '0', '2954'),
  1349. ('33939', '51427', '0', '0', '2949'),
  1350. ('33939', '51428', '0', '0', '2953'),
  1351. ('33939', '51429', '0', '0', '2951'),
  1352. ('33939', '51430', '0', '0', '2948'),
  1353. ('33939', '51431', '0', '0', '2936'),
  1354. ('33939', '51433', '0', '0', '2952'),
  1355. ('33939', '51434', '0', '0', '2954'),
  1356. ('33939', '51435', '0', '0', '2949'),
  1357. ('33939', '51436', '0', '0', '2953'),
  1358. ('33939', '51437', '0', '0', '2951'),
  1359. ('33939', '51438', '0', '0', '2948'),
  1360. ('33939', '51439', '0', '0', '2946'),
  1361. ('33939', '51441', '0', '0', '2946'),
  1362. ('33939', '51443', '0', '0', '2946'),
  1363. ('33939', '51445', '0', '0', '2946'),
  1364. ('33939', '51447', '0', '0', '2946'),
  1365. ('33939', '51449', '0', '0', '2936'),
  1366. ('33939', '51451', '0', '0', '2951'),
  1367. ('33939', '51452', '0', '0', '2950'),
  1368. ('33939', '51453', '0', '0', '2943'),
  1369. ('33939', '51455', '0', '0', '2950'),
  1370. ('33939', '51456', '0', '0', '2936'),
  1371. ('33939', '51458', '0', '0', '2952'),
  1372. ('33939', '51459', '0', '0', '2954'),
  1373. ('33939', '51460', '0', '0', '2949'),
  1374. ('33939', '51461', '0', '0', '2953'),
  1375. ('33939', '51462', '0', '0', '2948'),
  1376. ('33939', '51463', '0', '0', '2952'),
  1377. ('33939', '51464', '0', '0', '2954'),
  1378. ('33939', '51465', '0', '0', '2949'),
  1379. ('33939', '51466', '0', '0', '2953'),
  1380. ('33939', '51467', '0', '0', '2948'),
  1381. ('33939', '51468', '0', '0', '2952'),
  1382. ('33939', '51469', '0', '0', '2954'),
  1383. ('33939', '51470', '0', '0', '2949'),
  1384. ('33939', '51471', '0', '0', '2953'),
  1385. ('33939', '51472', '0', '0', '2951'),
  1386. ('33939', '51473', '0', '0', '2948'),
  1387. ('33939', '51474', '0', '0', '2952'),
  1388. ('33939', '51475', '0', '0', '2954'),
  1389. ('33939', '51476', '0', '0', '2949'),
  1390. ('33939', '51477', '0', '0', '2953'),
  1391. ('33939', '51478', '0', '0', '2951'),
  1392. ('33939', '51479', '0', '0', '2948'),
  1393. ('33939', '51480', '0', '0', '2936'),
  1394. ('33939', '51482', '0', '0', '2952'),
  1395. ('33939', '51483', '0', '0', '2954'),
  1396. ('33939', '51484', '0', '0', '2949'),
  1397. ('33939', '51485', '0', '0', '2953'),
  1398. ('33939', '51486', '0', '0', '2948'),
  1399. ('33939', '51487', '0', '0', '2952'),
  1400. ('33939', '51488', '0', '0', '2954'),
  1401. ('33939', '51489', '0', '0', '2949'),
  1402. ('33939', '51490', '0', '0', '2953'),
  1403. ('33939', '51491', '0', '0', '2948'),
  1404. ('33939', '51492', '0', '0', '2952'),
  1405. ('33939', '51493', '0', '0', '2954'),
  1406. ('33939', '51494', '0', '0', '2949'),
  1407. ('33939', '51495', '0', '0', '2953'),
  1408. ('33939', '51496', '0', '0', '2948'),
  1409. ('33939', '51497', '0', '0', '2952'),
  1410. ('33939', '51498', '0', '0', '2954'),
  1411. ('33939', '51499', '0', '0', '2949'),
  1412. ('33939', '51500', '0', '0', '2953'),
  1413. ('33939', '51501', '0', '0', '2951'),
  1414. ('33939', '51502', '0', '0', '2948'),
  1415. ('33939', '51503', '0', '0', '2952'),
  1416. ('33939', '51504', '0', '0', '2954'),
  1417. ('33939', '51505', '0', '0', '2949'),
  1418. ('33939', '51506', '0', '0', '2953'),
  1419. ('33939', '51507', '0', '0', '2951'),
  1420. ('33939', '51508', '0', '0', '2948'),
  1421. ('33939', '51509', '0', '0', '2952'),
  1422. ('33939', '51510', '0', '0', '2954'),
  1423. ('33939', '51511', '0', '0', '2949'),
  1424. ('33939', '51512', '0', '0', '2953'),
  1425. ('33939', '51513', '0', '0', '2951'),
  1426. ('33939', '51514', '0', '0', '2948'),
  1427. ('33939', '51515', '0', '0', '2945'),
  1428. ('33939', '51517', '0', '0', '2945'),
  1429. ('33939', '51519', '0', '0', '2945'),
  1430. ('33939', '51521', '0', '0', '2945'),
  1431. ('33939', '51523', '0', '0', '2945'),
  1432. ('33939', '51525', '0', '0', '2946'),
  1433. ('33939', '51527', '0', '0', '2946'),
  1434. ('33939', '51530', '0', '0', '2946'),
  1435. ('33939', '51531', '0', '0', '2951'),
  1436. ('33939', '51532', '0', '0', '2951'),
  1437. ('33939', '51533', '0', '0', '2950'),
  1438. ('33939', '51535', '0', '0', '2951'),
  1439. ('33939', '51536', '0', '0', '2952'),
  1440. ('33939', '51537', '0', '0', '2954'),
  1441. ('33939', '51538', '0', '0', '2949'),
  1442. ('33939', '51539', '0', '0', '2953'),
  1443. ('33939', '51540', '0', '0', '2948'),
  1444. ('33939', '51541', '0', '0', '2952'),
  1445. ('33939', '51542', '0', '0', '2954'),
  1446. ('33939', '51543', '0', '0', '2949'),
  1447. ('33939', '51544', '0', '0', '2953'),
  1448. ('33939', '51545', '0', '0', '2948');
  1449.  
  1450.  
  1451. -- [34093] - Blazzek the Biter
  1452. DELETE FROM `npc_vendor` WHERE `entry`='34093';
  1453. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1454. VALUES
  1455. ('34093', '51389', '0', '0', '2939'),
  1456. ('34093', '51391', '0', '0', '2939'),
  1457. ('34093', '51393', '0', '0', '2939'),
  1458. ('34093', '51395', '0', '0', '2939'),
  1459. ('34093', '51398', '0', '0', '2940'),
  1460. ('34093', '51399', '0', '0', '2940'),
  1461. ('34093', '51401', '0', '0', '2939'),
  1462. ('34093', '51403', '0', '0', '2939'),
  1463. ('34093', '51405', '0', '0', '2939'),
  1464. ('34093', '51412', '0', '0', '2939'),
  1465. ('34093', '51432', '0', '0', '2939'),
  1466. ('34093', '51440', '0', '0', '2947'),
  1467. ('34093', '51442', '0', '0', '2947'),
  1468. ('34093', '51444', '0', '0', '2947'),
  1469. ('34093', '51446', '0', '0', '2947'),
  1470. ('34093', '51448', '0', '0', '2947'),
  1471. ('34093', '51450', '0', '0', '2939'),
  1472. ('34093', '51454', '0', '0', '2940'),
  1473. ('34093', '51457', '0', '0', '2939'),
  1474. ('34093', '51481', '0', '0', '2939'),
  1475. ('34093', '51516', '0', '0', '2944'),
  1476. ('34093', '51518', '0', '0', '2944'),
  1477. ('34093', '51520', '0', '0', '2944'),
  1478. ('34093', '51522', '0', '0', '2944'),
  1479. ('34093', '51524', '0', '0', '2944'),
  1480. ('34093', '51526', '0', '0', '2947'),
  1481. ('34093', '51528', '0', '0', '2947'),
  1482. ('34093', '51529', '0', '0', '2947'),
  1483. ('34093', '51534', '0', '0', '2937');
  1484.  
  1485.  
  1486.  
  1487. -- SEASON 8 VENDORS
  1488. -- SPAWN
  1489. DELETE FROM `creature` WHERE `id` IN ('34038', '34060', '34063');
  1490. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  1491. VALUES
  1492. ('34038', '1', '1', '1', '0', '0', '1668.12', '-4197.15', '56.383', '3.93607', '600', '0', '0', '11828', '0', '0', '0'),
  1493. ('34060', '1', '1', '1', '0', '0', '1672.79', '-4202.75', '56.3826', '3.42006', '600', '0', '0', '9780', '14392', '0', '0'),
  1494. ('34063', '1', '1', '1', '0', '0', '1670.98', '-4199.92', '56.3826', '3.5418', '600', '0', '0', '11828', '0', '0', '0');
  1495.  
  1496. -- TEMPLATE UP
  1497. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "65", `maxlevel` = "65", `expansion` = "2", `minhealth` = "11828", `maxhealth` = "11828", `armor` = "5245", `faction_A` = "29", `faction_H` = "29", `npcflag` = "4224", `mindmg` = "188", `maxdmg` = "282", `attackpower` = "70", `minrangedmg` = "150", `maxrangedmg` = "226", `unit_flags`='768', `rangedattackpower` = "56", `RegenHealth` = "1", `equipment_id` = "819", `flags_extra` = "2" WHERE entry=34038;
  1498. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "70", `maxlevel` = "70", `expansion` = "2", `minhealth` = "9780", `maxhealth` = "9780", `minmana` = "14392", `maxmana` = "14392", `armor` = "6740", `faction_A` = "29", `faction_H` = "29", `npcflag` = "4224", `mindmg` = "260", `maxdmg` = "390", `attackpower` = "97", `dmg_multiplier` = "5.1", `unit_flags`='768', `minrangedmg` = "208", `maxrangedmg` = "312", `rangedattackpower` = "78", `health_mod` = "2", `mana_mod` = "2", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=34060;
  1499. UPDATE creature_template SET `modelid3` = "0", `subname` = "Northrend Armor Quartermaster", `minlevel` = "65", `maxlevel` = "65", `expansion` = "2", `minhealth` = "11828", `maxhealth` = "11828", `armor` = "5245", `faction_A` = "29", `faction_H` = "29", `npcflag` = "4224", `mindmg` = "188", `maxdmg` = "282", `attackpower` = "70", `unit_flags`='768', `minrangedmg` = "150", `maxrangedmg` = "226", `rangedattackpower` = "56", `RegenHealth` = "1", `equipment_id` = "677", `flags_extra` = "2" WHERE entry=34063;
  1500.  
  1501.  
  1502. -- VENDOR PART
  1503. -- [34038] - Sergeant Thunderhorn
  1504. DELETE FROM `npc_vendor` WHERE `entry`='34038';
  1505. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1506. VALUES
  1507. ('34038', '40883', '0', '0', '2966'),
  1508. ('34038', '40884', '0', '0', '2966'),
  1509. ('34038', '40890', '0', '0', '2967'),
  1510. ('34038', '40978', '0', '0', '2966'),
  1511. ('34038', '40979', '0', '0', '2966'),
  1512. ('34038', '40984', '0', '0', '2967'),
  1513. ('34038', '41052', '0', '0', '2966'),
  1514. ('34038', '41056', '0', '0', '2966'),
  1515. ('34038', '41061', '0', '0', '2967'),
  1516. ('34038', '41066', '0', '0', '2967'),
  1517. ('34038', '41071', '0', '0', '2966'),
  1518. ('34038', '41076', '0', '0', '2966'),
  1519. ('34038', '41226', '0', '0', '2967'),
  1520. ('34038', '41231', '0', '0', '2966'),
  1521. ('34038', '41236', '0', '0', '2966'),
  1522. ('34038', '41618', '0', '0', '2966'),
  1523. ('34038', '41622', '0', '0', '2966'),
  1524. ('34038', '41626', '0', '0', '2967'),
  1525. ('34038', '41631', '0', '0', '2966'),
  1526. ('34038', '41636', '0', '0', '2966'),
  1527. ('34038', '41641', '0', '0', '2967'),
  1528. ('34038', '41833', '0', '0', '2966'),
  1529. ('34038', '41837', '0', '0', '2966'),
  1530. ('34038', '41841', '0', '0', '2967'),
  1531. ('34038', '41882', '0', '0', '2966'),
  1532. ('34038', '41886', '0', '0', '2966'),
  1533. ('34038', '41894', '0', '0', '2967'),
  1534. ('34038', '41899', '0', '0', '2966'),
  1535. ('34038', '41904', '0', '0', '2966'),
  1536. ('34038', '41910', '0', '0', '2967'),
  1537. ('34038', '42041', '0', '0', '2968'),
  1538. ('34038', '42042', '0', '0', '2968'),
  1539. ('34038', '42043', '0', '0', '2968'),
  1540. ('34038', '42044', '0', '0', '2968'),
  1541. ('34038', '42045', '0', '0', '2968'),
  1542. ('34038', '42046', '0', '0', '2968'),
  1543. ('34038', '42047', '0', '0', '2968'),
  1544. ('34038', '42076', '0', '0', '2968'),
  1545. ('34038', '42077', '0', '0', '2968'),
  1546. ('34038', '42078', '0', '0', '2968'),
  1547. ('34038', '42079', '0', '0', '2968'),
  1548. ('34038', '42080', '0', '0', '2968'),
  1549. ('34038', '42081', '0', '0', '2968'),
  1550. ('34038', '42082', '0', '0', '2968'),
  1551. ('34038', '42118', '0', '0', '2968'),
  1552. ('34038', '42119', '0', '0', '2968'),
  1553. ('34038', '42133', '0', '0', '2966'),
  1554. ('34038', '42134', '0', '0', '2966'),
  1555. ('34038', '42135', '0', '0', '2966'),
  1556. ('34038', '42136', '0', '0', '2966'),
  1557. ('34038', '42137', '0', '0', '2966'),
  1558. ('34038', '46374', '0', '0', '2968'),
  1559. ('34038', '49179', '0', '0', '2966'),
  1560. ('34038', '49181', '0', '0', '2967'),
  1561. ('34038', '49183', '0', '0', '2966');
  1562.  
  1563.  
  1564. -- [34060] - Doris Volanthius
  1565. DELETE FROM `npc_vendor` WHERE `entry`='34060';
  1566. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1567. VALUES
  1568. ('34060', '51327', '0', '0', '2962'),
  1569. ('34060', '51328', '0', '0', '2961'),
  1570. ('34060', '51329', '0', '0', '2963'),
  1571. ('34060', '51330', '0', '0', '2964'),
  1572. ('34060', '51331', '0', '0', '2964'),
  1573. ('34060', '51332', '0', '0', '2964'),
  1574. ('34060', '51333', '0', '0', '2964'),
  1575. ('34060', '51334', '0', '0', '2964'),
  1576. ('34060', '51335', '0', '0', '2964'),
  1577. ('34060', '51336', '0', '0', '2964'),
  1578. ('34060', '51337', '0', '0', '2962'),
  1579. ('34060', '51338', '0', '0', '2961'),
  1580. ('34060', '51339', '0', '0', '2963'),
  1581. ('34060', '51340', '0', '0', '2962'),
  1582. ('34060', '51341', '0', '0', '2961'),
  1583. ('34060', '51342', '0', '0', '2963'),
  1584. ('34060', '51343', '0', '0', '2962'),
  1585. ('34060', '51344', '0', '0', '2961'),
  1586. ('34060', '51345', '0', '0', '2963'),
  1587. ('34060', '51346', '0', '0', '2964'),
  1588. ('34060', '51347', '0', '0', '2964'),
  1589. ('34060', '51348', '0', '0', '2964'),
  1590. ('34060', '51349', '0', '0', '2964'),
  1591. ('34060', '51350', '0', '0', '2962'),
  1592. ('34060', '51351', '0', '0', '2961'),
  1593. ('34060', '51352', '0', '0', '2963'),
  1594. ('34060', '51353', '0', '0', '2964'),
  1595. ('34060', '51354', '0', '0', '2964'),
  1596. ('34060', '51355', '0', '0', '2964'),
  1597. ('34060', '51356', '0', '0', '2964'),
  1598. ('34060', '51357', '0', '0', '2964'),
  1599. ('34060', '51358', '0', '0', '2964'),
  1600. ('34060', '51359', '0', '0', '2962'),
  1601. ('34060', '51360', '0', '0', '2961'),
  1602. ('34060', '51361', '0', '0', '2963'),
  1603. ('34060', '51362', '0', '0', '2962'),
  1604. ('34060', '51363', '0', '0', '2961'),
  1605. ('34060', '51364', '0', '0', '2963'),
  1606. ('34060', '51365', '0', '0', '2962'),
  1607. ('34060', '51366', '0', '0', '2961'),
  1608. ('34060', '51367', '0', '0', '2963'),
  1609. ('34060', '51368', '0', '0', '2962'),
  1610. ('34060', '51369', '0', '0', '2961'),
  1611. ('34060', '51370', '0', '0', '2963'),
  1612. ('34060', '51371', '0', '0', '2962'),
  1613. ('34060', '51372', '0', '0', '2961'),
  1614. ('34060', '51373', '0', '0', '2963'),
  1615. ('34060', '51374', '0', '0', '2962'),
  1616. ('34060', '51375', '0', '0', '2961'),
  1617. ('34060', '51376', '0', '0', '2963'),
  1618. ('34060', '51378', '0', '0', '2965');
  1619.  
  1620.  
  1621. -- [34063] - Blood Guard Zar'shi
  1622. DELETE FROM `npc_vendor` WHERE `entry`='34060';
  1623. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1624. VALUES
  1625. ('34063', '40787', '0', '0', '2959'),
  1626. ('34063', '40788', '0', '0', '2959'),
  1627. ('34063', '40789', '0', '0', '2959'),
  1628. ('34063', '40807', '0', '0', '2960'),
  1629. ('34063', '40808', '0', '0', '2960'),
  1630. ('34063', '40809', '0', '0', '2960'),
  1631. ('34063', '40826', '0', '0', '2959'),
  1632. ('34063', '40827', '0', '0', '2959'),
  1633. ('34063', '40828', '0', '0', '2959'),
  1634. ('34063', '40847', '0', '0', '2958'),
  1635. ('34063', '40848', '0', '0', '2958'),
  1636. ('34063', '40849', '0', '0', '2958'),
  1637. ('34063', '40866', '0', '0', '2958'),
  1638. ('34063', '40868', '0', '0', '2958'),
  1639. ('34063', '40869', '0', '0', '2958'),
  1640. ('34063', '40907', '0', '0', '2959'),
  1641. ('34063', '40927', '0', '0', '2960'),
  1642. ('34063', '40933', '0', '0', '2959'),
  1643. ('34063', '40939', '0', '0', '2958'),
  1644. ('34063', '40963', '0', '0', '2958'),
  1645. ('34063', '40992', '0', '0', '2959'),
  1646. ('34063', '40993', '0', '0', '2959'),
  1647. ('34063', '41001', '0', '0', '2960'),
  1648. ('34063', '41007', '0', '0', '2960'),
  1649. ('34063', '41013', '0', '0', '2959'),
  1650. ('34063', '41019', '0', '0', '2959'),
  1651. ('34063', '41027', '0', '0', '2958'),
  1652. ('34063', '41033', '0', '0', '2958'),
  1653. ('34063', '41038', '0', '0', '2958'),
  1654. ('34063', '41044', '0', '0', '2958'),
  1655. ('34063', '41081', '0', '0', '2959'),
  1656. ('34063', '41087', '0', '0', '2959'),
  1657. ('34063', '41137', '0', '0', '2960'),
  1658. ('34063', '41143', '0', '0', '2960'),
  1659. ('34063', '41151', '0', '0', '2959'),
  1660. ('34063', '41157', '0', '0', '2959'),
  1661. ('34063', '41199', '0', '0', '2958'),
  1662. ('34063', '41205', '0', '0', '2958'),
  1663. ('34063', '41211', '0', '0', '2958'),
  1664. ('34063', '41217', '0', '0', '2958'),
  1665. ('34063', '41275', '0', '0', '2958'),
  1666. ('34063', '41281', '0', '0', '2958'),
  1667. ('34063', '41287', '0', '0', '2960'),
  1668. ('34063', '41293', '0', '0', '2960'),
  1669. ('34063', '41298', '0', '0', '2958'),
  1670. ('34063', '41304', '0', '0', '2958'),
  1671. ('34063', '41310', '0', '0', '2959'),
  1672. ('34063', '41316', '0', '0', '2959'),
  1673. ('34063', '41321', '0', '0', '2959'),
  1674. ('34063', '41327', '0', '0', '2959'),
  1675. ('34063', '41650', '0', '0', '2959'),
  1676. ('34063', '41655', '0', '0', '2958'),
  1677. ('34063', '41661', '0', '0', '2959'),
  1678. ('34063', '41667', '0', '0', '2958'),
  1679. ('34063', '41672', '0', '0', '2959'),
  1680. ('34063', '41678', '0', '0', '2959'),
  1681. ('34063', '41683', '0', '0', '2958'),
  1682. ('34063', '41715', '0', '0', '2958'),
  1683. ('34063', '41767', '0', '0', '2960'),
  1684. ('34063', '41773', '0', '0', '2960'),
  1685. ('34063', '41854', '0', '0', '2959'),
  1686. ('34063', '41859', '0', '0', '2959'),
  1687. ('34063', '41864', '0', '0', '2958'),
  1688. ('34063', '41869', '0', '0', '2958'),
  1689. ('34063', '41874', '0', '0', '2960'),
  1690. ('34063', '41915', '0', '0', '2959'),
  1691. ('34063', '41921', '0', '0', '2959'),
  1692. ('34063', '41927', '0', '0', '2958'),
  1693. ('34063', '41934', '0', '0', '2958'),
  1694. ('34063', '41940', '0', '0', '2960'),
  1695. ('34063', '41946', '0', '0', '2959'),
  1696. ('34063', '41953', '0', '0', '2959'),
  1697. ('34063', '41959', '0', '0', '2958'),
  1698. ('34063', '41965', '0', '0', '2958'),
  1699. ('34063', '41971', '0', '0', '2960'),
  1700. ('34063', '41993', '0', '0', '2959'),
  1701. ('34063', '41998', '0', '0', '2959'),
  1702. ('34063', '42005', '0', '0', '2958'),
  1703. ('34063', '42011', '0', '0', '2958'),
  1704. ('34063', '42017', '0', '0', '2960'),
  1705. ('34063', '42579', '0', '0', '2969'),
  1706. ('34063', '42584', '0', '0', '2969'),
  1707. ('34063', '42589', '0', '0', '2969'),
  1708. ('34063', '42598', '0', '0', '2969'),
  1709. ('34063', '42603', '0', '0', '2969'),
  1710. ('34063', '42608', '0', '0', '2969'),
  1711. ('34063', '42615', '0', '0', '2969'),
  1712. ('34063', '42621', '0', '0', '2969'),
  1713. ('34063', '42853', '0', '0', '2969'),
  1714. ('34063', '45706', '0', '0', '2596');
  1715.  
  1716.  
  1717.  
  1718. -- SEASON 8 VENDORS STORMWIND
  1719. -- SPAWN
  1720. DELETE FROM `creature` WHERE `id` IN ('34075', '34078', '40607');
  1721. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  1722. VALUES
  1723. ('34075', '0', '1', '1', '0', '0', '-8780.87', '419.882', '105.233', '5.91525', '600', '0', '0', '11828', '0', '0', '0'),
  1724. ('34078', '0', '1', '1', '0', '0', '-8772.79', '426.167', '105.233', '4.57851', '600', '0', '0', '21270', '0', '0', '0'),
  1725. ('40607', '0', '1', '1', '0', '0', '-8775.4', '424.078', '105.233', '4.74815', '600', '0', '0', '21270', '0', '0', '0');
  1726.  
  1727. -- TEMPLATE UP
  1728. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "65", `maxlevel` = "65", `expansion` = "1", `minhealth` = "11828", `maxhealth` = "11828", `armor` = "5245", `faction_A` = "12", `faction_H` = "12", `npcflag` = "4224", `mindmg` = "188", `maxdmg` = "282", `attackpower` = "70", `unit_flags`='768', `minrangedmg` = "150", `maxrangedmg` = "226", `rangedattackpower` = "56", `RegenHealth` = "1", `equipment_id` = "163", `flags_extra` = "2" WHERE entry=34075;
  1729. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "75", `maxlevel` = "75", `expansion` = "2", `minhealth` = "21270", `maxhealth` = "21270", `armor` = "8235", `faction_A` = "12", `faction_H` = "12", `npcflag` = "4224", `mindmg` = "340", `maxdmg` = "510", `attackpower` = "127", `unit_flags`='768', `minrangedmg` = "272", `maxrangedmg` = "408", `rangedattackpower` = "102", `equipment_id` = "1935", `RegenHealth` = "1", `flags_extra` = "2" WHERE entry=34078;
  1730. DELETE FROM `creature_equip_template` WHERE `entry`='1935';
  1731. INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`)
  1732. VALUES
  1733. ('1935', '34520', '29638', '0');
  1734. UPDATE creature_template SET `modelid3` = "0", `expansion` = "2" WHERE entry=40607;
  1735.  
  1736.  
  1737. -- [34075] - Captain Dirgehammer
  1738. DELETE FROM `npc_vendor` WHERE `entry`='34075';
  1739. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1740. VALUES
  1741. ('34075', '40883', '0', '0', '2966'),
  1742. ('34075', '40884', '0', '0', '2966'),
  1743. ('34075', '40890', '0', '0', '2967'),
  1744. ('34075', '40978', '0', '0', '2966'),
  1745. ('34075', '40979', '0', '0', '2966'),
  1746. ('34075', '40984', '0', '0', '2967'),
  1747. ('34075', '41052', '0', '0', '2966'),
  1748. ('34075', '41056', '0', '0', '2966'),
  1749. ('34075', '41061', '0', '0', '2967'),
  1750. ('34075', '41066', '0', '0', '2967'),
  1751. ('34075', '41071', '0', '0', '2966'),
  1752. ('34075', '41076', '0', '0', '2966'),
  1753. ('34075', '41226', '0', '0', '2967'),
  1754. ('34075', '41231', '0', '0', '2966'),
  1755. ('34075', '41236', '0', '0', '2966'),
  1756. ('34075', '41618', '0', '0', '2966'),
  1757. ('34075', '41622', '0', '0', '2966'),
  1758. ('34075', '41626', '0', '0', '2967'),
  1759. ('34075', '41631', '0', '0', '2966'),
  1760. ('34075', '41636', '0', '0', '2966'),
  1761. ('34075', '41641', '0', '0', '2967'),
  1762. ('34075', '41833', '0', '0', '2966'),
  1763. ('34075', '41837', '0', '0', '2966'),
  1764. ('34075', '41841', '0', '0', '2967'),
  1765. ('34075', '41882', '0', '0', '2966'),
  1766. ('34075', '41886', '0', '0', '2966'),
  1767. ('34075', '41894', '0', '0', '2967'),
  1768. ('34075', '41899', '0', '0', '2966'),
  1769. ('34075', '41904', '0', '0', '2966'),
  1770. ('34075', '41910', '0', '0', '2967'),
  1771. ('34075', '42041', '0', '0', '2968'),
  1772. ('34075', '42042', '0', '0', '2968'),
  1773. ('34075', '42043', '0', '0', '2968'),
  1774. ('34075', '42044', '0', '0', '2968'),
  1775. ('34075', '42045', '0', '0', '2968'),
  1776. ('34075', '42046', '0', '0', '2968'),
  1777. ('34075', '42047', '0', '0', '2968'),
  1778. ('34075', '42076', '0', '0', '2968'),
  1779. ('34075', '42077', '0', '0', '2968'),
  1780. ('34075', '42078', '0', '0', '2968'),
  1781. ('34075', '42079', '0', '0', '2968'),
  1782. ('34075', '42080', '0', '0', '2968'),
  1783. ('34075', '42081', '0', '0', '2968'),
  1784. ('34075', '42082', '0', '0', '2968'),
  1785. ('34075', '42118', '0', '0', '2968'),
  1786. ('34075', '42119', '0', '0', '2968'),
  1787. ('34075', '42133', '0', '0', '2966'),
  1788. ('34075', '42134', '0', '0', '2966'),
  1789. ('34075', '42135', '0', '0', '2966'),
  1790. ('34075', '42136', '0', '0', '2966'),
  1791. ('34075', '42137', '0', '0', '2966'),
  1792. ('34075', '46374', '0', '0', '2968'),
  1793. ('34075', '49179', '0', '0', '2966'),
  1794. ('34075', '49181', '0', '0', '2967'),
  1795. ('34075', '49183', '0', '0', '2966');
  1796.  
  1797.  
  1798. -- [34078] - Lieutenant Tristia
  1799. DELETE FROM `npc_vendor` WHERE `entry`='34078';
  1800. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1801. VALUES
  1802. ('34078', '51327', '0', '0', '2962'),
  1803. ('34078', '51328', '0', '0', '2961'),
  1804. ('34078', '51329', '0', '0', '2963'),
  1805. ('34078', '51330', '0', '0', '2964'),
  1806. ('34078', '51331', '0', '0', '2964'),
  1807. ('34078', '51332', '0', '0', '2964'),
  1808. ('34078', '51333', '0', '0', '2964'),
  1809. ('34078', '51334', '0', '0', '2964'),
  1810. ('34078', '51335', '0', '0', '2964'),
  1811. ('34078', '51336', '0', '0', '2964'),
  1812. ('34078', '51337', '0', '0', '2962'),
  1813. ('34078', '51338', '0', '0', '2961'),
  1814. ('34078', '51339', '0', '0', '2963'),
  1815. ('34078', '51340', '0', '0', '2962'),
  1816. ('34078', '51341', '0', '0', '2961'),
  1817. ('34078', '51342', '0', '0', '2963'),
  1818. ('34078', '51343', '0', '0', '2962'),
  1819. ('34078', '51344', '0', '0', '2961'),
  1820. ('34078', '51345', '0', '0', '2963'),
  1821. ('34078', '51346', '0', '0', '2964'),
  1822. ('34078', '51347', '0', '0', '2964'),
  1823. ('34078', '51348', '0', '0', '2964'),
  1824. ('34078', '51349', '0', '0', '2964'),
  1825. ('34078', '51350', '0', '0', '2962'),
  1826. ('34078', '51351', '0', '0', '2961'),
  1827. ('34078', '51352', '0', '0', '2963'),
  1828. ('34078', '51353', '0', '0', '2964'),
  1829. ('34078', '51354', '0', '0', '2964'),
  1830. ('34078', '51355', '0', '0', '2964'),
  1831. ('34078', '51356', '0', '0', '2964'),
  1832. ('34078', '51357', '0', '0', '2964'),
  1833. ('34078', '51358', '0', '0', '2964'),
  1834. ('34078', '51359', '0', '0', '2962'),
  1835. ('34078', '51360', '0', '0', '2961'),
  1836. ('34078', '51361', '0', '0', '2963'),
  1837. ('34078', '51362', '0', '0', '2962'),
  1838. ('34078', '51363', '0', '0', '2961'),
  1839. ('34078', '51364', '0', '0', '2963'),
  1840. ('34078', '51365', '0', '0', '2962'),
  1841. ('34078', '51366', '0', '0', '2961'),
  1842. ('34078', '51367', '0', '0', '2963'),
  1843. ('34078', '51368', '0', '0', '2962'),
  1844. ('34078', '51369', '0', '0', '2961'),
  1845. ('34078', '51370', '0', '0', '2963'),
  1846. ('34078', '51371', '0', '0', '2962'),
  1847. ('34078', '51372', '0', '0', '2961'),
  1848. ('34078', '51373', '0', '0', '2963'),
  1849. ('34078', '51374', '0', '0', '2962'),
  1850. ('34078', '51375', '0', '0', '2961'),
  1851. ('34078', '51376', '0', '0', '2963'),
  1852. ('34078', '51377', '0', '0', '2965');
  1853.  
  1854.  
  1855. -- [40607] - Knight-Lieutenant T'Maire Sydes
  1856. DELETE FROM `npc_vendor` WHERE `entry`='40607';
  1857. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  1858. VALUES
  1859. ('40607', '40787', '0', '0', '2959'),
  1860. ('40607', '40788', '0', '0', '2959'),
  1861. ('40607', '40789', '0', '0', '2959'),
  1862. ('40607', '40807', '0', '0', '2960'),
  1863. ('40607', '40808', '0', '0', '2960'),
  1864. ('40607', '40809', '0', '0', '2960'),
  1865. ('40607', '40826', '0', '0', '2959'),
  1866. ('40607', '40827', '0', '0', '2959'),
  1867. ('40607', '40828', '0', '0', '2959'),
  1868. ('40607', '40847', '0', '0', '2958'),
  1869. ('40607', '40848', '0', '0', '2958'),
  1870. ('40607', '40849', '0', '0', '2958'),
  1871. ('40607', '40866', '0', '0', '2958'),
  1872. ('40607', '40868', '0', '0', '2958'),
  1873. ('40607', '40869', '0', '0', '2958'),
  1874. ('40607', '40907', '0', '0', '2959'),
  1875. ('40607', '40927', '0', '0', '2960'),
  1876. ('40607', '40933', '0', '0', '2959'),
  1877. ('40607', '40939', '0', '0', '2958'),
  1878. ('40607', '40963', '0', '0', '2958'),
  1879. ('40607', '40992', '0', '0', '2959'),
  1880. ('40607', '40993', '0', '0', '2959'),
  1881. ('40607', '41001', '0', '0', '2960'),
  1882. ('40607', '41007', '0', '0', '2960'),
  1883. ('40607', '41013', '0', '0', '2959'),
  1884. ('40607', '41019', '0', '0', '2959'),
  1885. ('40607', '41027', '0', '0', '2958'),
  1886. ('40607', '41033', '0', '0', '2958'),
  1887. ('40607', '41038', '0', '0', '2958'),
  1888. ('40607', '41044', '0', '0', '2958'),
  1889. ('40607', '41081', '0', '0', '2959'),
  1890. ('40607', '41087', '0', '0', '2959'),
  1891. ('40607', '41137', '0', '0', '2960'),
  1892. ('40607', '41143', '0', '0', '2960'),
  1893. ('40607', '41151', '0', '0', '2959'),
  1894. ('40607', '41157', '0', '0', '2959'),
  1895. ('40607', '41199', '0', '0', '2958'),
  1896. ('40607', '41205', '0', '0', '2958'),
  1897. ('40607', '41211', '0', '0', '2958'),
  1898. ('40607', '41217', '0', '0', '2958'),
  1899. ('40607', '41275', '0', '0', '2958'),
  1900. ('40607', '41281', '0', '0', '2958'),
  1901. ('40607', '41287', '0', '0', '2960'),
  1902. ('40607', '41293', '0', '0', '2960'),
  1903. ('40607', '41298', '0', '0', '2958'),
  1904. ('40607', '41304', '0', '0', '2958'),
  1905. ('40607', '41310', '0', '0', '2959'),
  1906. ('40607', '41316', '0', '0', '2959'),
  1907. ('40607', '41321', '0', '0', '2959'),
  1908. ('40607', '41327', '0', '0', '2959'),
  1909. ('40607', '41650', '0', '0', '2959'),
  1910. ('40607', '41655', '0', '0', '2958'),
  1911. ('40607', '41661', '0', '0', '2959'),
  1912. ('40607', '41667', '0', '0', '2958'),
  1913. ('40607', '41672', '0', '0', '2959'),
  1914. ('40607', '41678', '0', '0', '2959'),
  1915. ('40607', '41683', '0', '0', '2958'),
  1916. ('40607', '41715', '0', '0', '2958'),
  1917. ('40607', '41767', '0', '0', '2960'),
  1918. ('40607', '41773', '0', '0', '2960'),
  1919. ('40607', '41854', '0', '0', '2959'),
  1920. ('40607', '41859', '0', '0', '2959'),
  1921. ('40607', '41864', '0', '0', '2958'),
  1922. ('40607', '41869', '0', '0', '2958'),
  1923. ('40607', '41874', '0', '0', '2960'),
  1924. ('40607', '41915', '0', '0', '2959'),
  1925. ('40607', '41921', '0', '0', '2959'),
  1926. ('40607', '41927', '0', '0', '2958'),
  1927. ('40607', '41934', '0', '0', '2958'),
  1928. ('40607', '41940', '0', '0', '2960'),
  1929. ('40607', '41946', '0', '0', '2959'),
  1930. ('40607', '41953', '0', '0', '2959'),
  1931. ('40607', '41959', '0', '0', '2958'),
  1932. ('40607', '41965', '0', '0', '2958'),
  1933. ('40607', '41971', '0', '0', '2960'),
  1934. ('40607', '41993', '0', '0', '2959'),
  1935. ('40607', '41998', '0', '0', '2959'),
  1936. ('40607', '42005', '0', '0', '2958'),
  1937. ('40607', '42011', '0', '0', '2958'),
  1938. ('40607', '42017', '0', '0', '2960'),
  1939. ('40607', '42579', '0', '0', '2969'),
  1940. ('40607', '42584', '0', '0', '2969'),
  1941. ('40607', '42589', '0', '0', '2969'),
  1942. ('40607', '42598', '0', '0', '2969'),
  1943. ('40607', '42603', '0', '0', '2969'),
  1944. ('40607', '42608', '0', '0', '2969'),
  1945. ('40607', '42615', '0', '0', '2969'),
  1946. ('40607', '42621', '0', '0', '2969'),
  1947. ('40607', '42853', '0', '0', '2969'),
  1948. ('40607', '45706', '0', '0', '2596');
  1949.  
  1950.  
  1951.  
  1952. -- WEEKLY QUESTS
  1953. DELETE FROM `creature_questrelation` WHERE `id`='20735';
  1954. INSERT INTO `creature_questrelation` (`id`, `quest`)
  1955. VALUES
  1956. ('20735', '24579'),
  1957. ('20735', '24580'),
  1958. ('20735', '24581'),
  1959. ('20735', '24582'),
  1960. ('20735', '24583'),
  1961. ('20735', '24584'),
  1962. ('20735', '24585'),
  1963. ('20735', '24586'),
  1964. ('20735', '24587'),
  1965. ('20735', '24588'),
  1966. ('20735', '24589'),
  1967. ('20735', '24590');
  1968.  
  1969.  
  1970. DELETE FROM `creature_involvedrelation` WHERE `id`='20735';
  1971. INSERT INTO `creature_involvedrelation` (`id`, `quest`)
  1972. VALUES
  1973. ('20735', '13245'),
  1974. ('20735', '13246'),
  1975. ('20735', '13247'),
  1976. ('20735', '13248'),
  1977. ('20735', '13249'),
  1978. ('20735', '13250'),
  1979. ('20735', '13251'),
  1980. ('20735', '13252'),
  1981. ('20735', '13253'),
  1982. ('20735', '13254'),
  1983. ('20735', '13255'),
  1984. ('20735', '13256'),
  1985. ('20735', '14199'),
  1986. ('20735', '24579'),
  1987. ('20735', '24580'),
  1988. ('20735', '24581'),
  1989. ('20735', '24582'),
  1990. ('20735', '24583'),
  1991. ('20735', '24584'),
  1992. ('20735', '24585'),
  1993. ('20735', '24586'),
  1994. ('20735', '24587'),
  1995. ('20735', '24588'),
  1996. ('20735', '24589'),
  1997. ('20735', '24590');
  1998.  
  1999.  
  2000. /*-- QUEST GROUP
  2001. DELETE FROM `quest_groups` WHERE `GroupId`='24579');
  2002. INSERT INTO `quest_groups` (`GroupId`, `QuestId`)
  2003. VALUES
  2004. ('24579', '24579'),
  2005. ('24579', '24580'),
  2006. ('24579', '24581'),
  2007. ('24579', '24582'),
  2008. ('24579', '24583'),
  2009. ('24579', '24584'),
  2010. ('24579', '24585'),
  2011. ('24579', '24586'),
  2012. ('24579', '24587'),
  2013. ('24579', '24588'),
  2014. ('24579', '24589'),
  2015. ('24579', '24590');*/
  2016.  
  2017. -- IMPLEMENT QUESTS
  2018. INSERT INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredClasses`, `RequiredRaces`, `RequiredSkill`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`)
  2019. VALUES
  2020. ('24579', '2', '4493', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Sartharion Must Die!', 'Sartharion, the Onyx Guardian, watches over the eggs of the Twilight Dragonflight. He rests within the Obsidian Sanctum in the Chamber of the Aspects underneath Wyrmrest Temple.$B$BThe Council of Six has decreed that Sartharion must die!', 'Kill Sartharion.$B$BThis quest can be completed with any difficulty or size raid.', 'With Sartharion slain, surely Deathwing and Sinestra\'s plans are now stalled.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28860', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2021. ('24580', '2', '3456', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Anub\'Rekhan Must Die!', 'Anub\'Rekhan, once-mighty Spider Lord of the nerubian empire, has been taken by the Lich King and corrupted into a state of undeath.$B$BNow a crypt lord, he sits in his parlor in the Arachnid Quarter of Naxxramas, spinning strategies for Kel\'Thuzad.$B$BThe Council of Six has decreed that Anub\'Rekhan must die!', 'Kill Anub\'Rekhan.$B$BThis quest can be completed with any difficulty or size raid.', 'Word of your success precedes you, $C. Anub\'Rekhan is no more. You did him a great service, $N.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15956', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2022. ('24581', '2', '3456', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Noth the Plaguebringer Must Die!', 'Noth the Plaguebringer, traitor and coward! Second only to the Lich King himself for the number of souls that have been Scourged!$B$BMake haste to Naxxramas. You will find him within the Plague Quarter hiding behind his undead minions.$B$BDestroy him! The Council of Six has decreed that Noth must die!', 'Kill Noth the Plaguebringer.$B$BThis quest can be completed with any difficulty or size raid.', 'That\'s one less thorn in our side. With Noth destroyed, Scourge research into refining the means of creating the undead will grind to a halt.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15954', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2023. ('24582', '2', '3456', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Instructor Razuvious Must Die!', 'Instructor Razuvious smugly struts about the Military Quarter of Naxxramas. It is said that only a death knight personally trained by him could possibly even withstand the prowess of his blade.$B$BYou and your group are going to prove everyone wrong.$B$BThe Council of Six has decreed that Razuvious must die!', 'Kill Instructor Razuvious.$B$BThis quest can be completed with any difficulty or size raid.', 'Well done, $C. The Scourge military command out of Naxxramas has been thrown into disarray by Razuvious\'s demise.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16061', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2024. ('24583', '2', '3456', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Patchwerk Must Die!', 'The so-called "avatar of war", Patchwerk is the ultimate abomination. It is also taking a heavy toll upon on our forces in the Dragonblight.$B$BI want you to assemble your companions and enter the Construct Quarter of Naxxramas. Disassemble the construct.$B$BThe Council of Six has decreed that Patchwerk must die!', 'Kill Patchwerk.$B$BThis quest can be completed with any difficulty or size raid.', 'Children everywhere will sleep easier knowing that Patchwerk is no more.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16028', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2025. ('24584', '2', '4500', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Malygos Must Die!', 'Our resources are strained. Malygos, the Spell-Weaver, is draining all of the magic out of the world, consolidating it in the Eye of Eternity. Without magic, we are doomed.$B$B$C, the Nexus War must be brought to an end. The Council of Six has decreed that Malygos must die!', 'Kill Malygos.$B$BThis quest can be completed with any difficulty or size raid.', 'With Malygos defeated, the Nexus War should come to a swift conclusion. You have the gratitude of the Kirin Tor, $N.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28859', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2026. ('24585', '2', '4273', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Flame Leviathan Must Die!', 'Within the Formation Grounds sits Ulduar\'s first line of defense: Flame Leviathan.$B$BThe Kirin Tor have been provided with information suggesting that this Keeper-created machine is soon to be transported to an undisclosed location and let loose to wreak havoc upon the mortals of Azeroth.$B$BThis must not come to pass. The Council of Six has decreed that Flame Leviathan must die!', 'Kill Flame Leviathan.$B$BThis quest can be completed with any difficulty or size raid.', 'I never cease to be amazed by the horrors that can be created through the use of technology.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '33113', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2027. ('24586', '2', '4273', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Razorscale Must Die!', 'Razorscale normally keeps to her aerie near the Colossal Forge in Ulduar. Of late, however, she has been spotted reigning fire down upon lands outside of the titan complex.$B$BThough the broodmother\'s is a sad tale, she poses an imminent threat to all of Northrend. The Council of Six has decreed that Razorscale must die!', 'Kill Razorscale.$B$BThis quest can be completed with any difficulty or size raid.', 'Now Veranus can finally rest in peace.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '33186', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2028. ('24587', '2', '4273', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ignis the Furnace Master Must Die!', 'The great fire giant, Ignis the Furnace Master toils away inside of Ulduar\'s Colossal Forge. Under orders from Loken, Ignis creates weapons that are terrifying in their power.$B$BThe Council of Six has decreed that Ignis must die!', 'Kill Ignis the Furnace Master.$B$BThis quest can be completed with any difficulty or size raid.', 'I trust that you did not have to face too many of his iron construct assistants?', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '33118', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2029. ('24588', '2', '4273', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'XT-002 Deconstructor Must Die!', 'Yet another strange construct of Mimiron, the XT-002 Deconstructor actually thinks that it is the keeper\'s son. Do not be fooled by its feigned innocence. It is a deadly machine!$B$BYou will find the Deconstructor within Ulduar\'s Scrapyard. The Council of Six has decreed that XT-002 Deconstructor must die!', 'Kill XT-002 Deconstructor.$B$BThis quest can be completed with any difficulty or size raid.', 'The greatest weakness of Ulduar is its masters\' blind faith in their inventions to protect it.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '33293', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2030. ('24589', '2', '4722', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Lord Jaraxxus Must Die!', 'Archmage Timear has foreseen a horrible event, which is about to transpire. A foolish gnome warlock is about to accidentally summon an Eredar lord of the Burning Legion into the middle of the Trial of the Crusader.$B$BYou must be there when it happens, $c. If Lord Jaraxxus escapes, he will open a portal and the Burning Legion will spill forth into our world once more.$B$BThe Council of Six has decreed that Lord Jaraxxus must die!', 'Kill Lord Jaraxxus.$B$BThis quest can be completed with any difficulty or size raid.', 'All of Azeroth is fortunate that Timear foresaw the Eredar lord\'s arrival and that you were there in time to slay him.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '34780', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  2031. ('24590', '2', '4812', '80', '83', '62', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32968', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Lord Marrowgar Must Die!', 'Lord Marrowgar is the guardian of the Frozen Throne within the Spire Chamber. Pieced together by the Lich King from the bones of a thousand vanquished adventurers, Marrowgar wields the power of the throne itself.$B$BWithout the destruction of this bone wraith, there is no hope of taking Icecrown Citadel.$B$BThe Council of Six has decreed that Lord Marrowgar must die!', 'Kill Lord Marrowgar.$B$BThis quest can be completed with any difficulty or size raid.', 'The Frozen Throne is without its chief guardian thanks to you. Our attacks upon the Lich King\'s forces will be all the more successful now.', '', '', 'Return to Archmage Lan\'dalock in Dalaran.', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36612', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '49426', '47241', '0', '0', '5', '5', '0', '0', '1090', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '296000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  2032.  
  2033.  
  2034.  
  2035. -- WINTERGRASP VENDORS SPAWN
  2036. DELETE FROM `creature` WHERE `id` IN ('39172', '39173');
  2037. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  2038. VALUES
  2039. ('39172', '571', '1', '385', '31346', '0', '5372.67', '2786.74', '409.442', '2.80998', '300', '0', '0', '12600', '0', '0', '0'),
  2040. ('39173', '571', '1', '65', '0', '0', '5372.67', '2786.74', '409.442', '2.80998', '600', '0', '0', '12600', '0', '0', '0');
  2041. DELETE FROM `creature_template_addon` WHERE `entry` IN ('39172', '39173');
  2042. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_pvp_state`, `emote`, `moveflags`, `auras`)
  2043. VALUES
  2044. ('39172', '28912', '0', '1', '0', '0', '0', ''),
  2045. ('39173', '29261', '0', '1', '0', '0', '0', '');
  2046.  
  2047.  
  2048. -- ALLIANCE 39172
  2049. UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1892", `faction_H` = "1892", `npcflag` = "128", `unit_flags` = "768" WHERE entry=39172;
  2050. -- STUFF SOLD
  2051. DELETE FROM `npc_vendor` WHERE `entry`='39172';
  2052. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  2053. VALUES
  2054. ('39172', '51568', '0', '0', '2578'),
  2055. ('39172', '51569', '0', '0', '2578'),
  2056. ('39172', '51570', '0', '0', '2578'),
  2057. ('39172', '51571', '0', '0', '2578'),
  2058. ('39172', '51572', '0', '0', '2579'),
  2059. ('39172', '51573', '0', '0', '2579'),
  2060. ('39172', '51574', '0', '0', '2579'),
  2061. ('39172', '51575', '0', '0', '2579'),
  2062. ('39172', '51576', '0', '0', '2579'),
  2063. ('39172', '51577', '0', '0', '2579'),
  2064. ('39172', '51578', '0', '0', '2579'),
  2065. ('39172', '51579', '0', '0', '2579'),
  2066. ('39172', '51580', '0', '0', '2579'),
  2067. ('39172', '51581', '0', '0', '2579');
  2068.  
  2069. -- HORDE
  2070. UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1981", `faction_H` = "1981", `npcflag` = "128", `unit_flags` = "768" WHERE entry=39173;
  2071. -- STUFF SOLD 39173
  2072. DELETE FROM `npc_vendor` WHERE `entry`='39173';
  2073. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  2074. VALUES
  2075. ('39173', '51568', '0', '0', '2578'),
  2076. ('39173', '51569', '0', '0', '2578'),
  2077. ('39173', '51570', '0', '0', '2578'),
  2078. ('39173', '51571', '0', '0', '2578'),
  2079. ('39173', '51572', '0', '0', '2579'),
  2080. ('39173', '51573', '0', '0', '2579'),
  2081. ('39173', '51574', '0', '0', '2579'),
  2082. ('39173', '51575', '0', '0', '2579'),
  2083. ('39173', '51576', '0', '0', '2579'),
  2084. ('39173', '51577', '0', '0', '2579'),
  2085. ('39173', '51578', '0', '0', '2579'),
  2086. ('39173', '51579', '0', '0', '2579'),
  2087. ('39173', '51580', '0', '0', '2579'),
  2088. ('39173', '51581', '0', '0', '2579');
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!