API tools faq
paste
image

S8 - SW

image
Dec 17th, 2011
353
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.92 KB | None | 0 0
raw download clone embed print report
  1. -- SEASON 8 VENDORS STORMWIND
  2. -- SPAWN
  3. DELETE FROM `creature` WHERE `id` IN ('34075', '34078', '40607');
  4. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  5. VALUES
  6. ('34075', '0', '1', '1', '0', '0', '-8780.87', '419.882', '105.233', '5.91525', '600', '0', '0', '11828', '0', '0', '0'),
  7. ('34078', '0', '1', '1', '0', '0', '-8772.79', '426.167', '105.233', '4.57851', '600', '0', '0', '21270', '0', '0', '0'),
  8. ('40607', '0', '1', '1', '0', '0', '-8775.4', '424.078', '105.233', '4.74815', '600', '0', '0', '21270', '0', '0', '0');
  9.  
  10. -- TEMPLATE UP
  11. 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;
  12. 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;
  13. DELETE FROM `creature_equip_template` WHERE `entry`='1935';
  14. INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`)
  15. VALUES
  16. ('1935', '34520', '29638', '0');
  17. UPDATE creature_template SET `modelid3` = "0", `expansion` = "2" WHERE entry=40607;
  18.  
  19.  
  20. -- [34075] - Captain Dirgehammer
  21. DELETE FROM `npc_vendor` WHERE `entry`='34075';
  22. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  23. VALUES
  24. ('34075', '40883', '0', '0', '2966'),
  25. ('34075', '40884', '0', '0', '2966'),
  26. ('34075', '40890', '0', '0', '2967'),
  27. ('34075', '40978', '0', '0', '2966'),
  28. ('34075', '40979', '0', '0', '2966'),
  29. ('34075', '40984', '0', '0', '2967'),
  30. ('34075', '41052', '0', '0', '2966'),
  31. ('34075', '41056', '0', '0', '2966'),
  32. ('34075', '41061', '0', '0', '2967'),
  33. ('34075', '41066', '0', '0', '2967'),
  34. ('34075', '41071', '0', '0', '2966'),
  35. ('34075', '41076', '0', '0', '2966'),
  36. ('34075', '41226', '0', '0', '2967'),
  37. ('34075', '41231', '0', '0', '2966'),
  38. ('34075', '41236', '0', '0', '2966'),
  39. ('34075', '41618', '0', '0', '2966'),
  40. ('34075', '41622', '0', '0', '2966'),
  41. ('34075', '41626', '0', '0', '2967'),
  42. ('34075', '41631', '0', '0', '2966'),
  43. ('34075', '41636', '0', '0', '2966'),
  44. ('34075', '41641', '0', '0', '2967'),
  45. ('34075', '41833', '0', '0', '2966'),
  46. ('34075', '41837', '0', '0', '2966'),
  47. ('34075', '41841', '0', '0', '2967'),
  48. ('34075', '41882', '0', '0', '2966'),
  49. ('34075', '41886', '0', '0', '2966'),
  50. ('34075', '41894', '0', '0', '2967'),
  51. ('34075', '41899', '0', '0', '2966'),
  52. ('34075', '41904', '0', '0', '2966'),
  53. ('34075', '41910', '0', '0', '2967'),
  54. ('34075', '42041', '0', '0', '2968'),
  55. ('34075', '42042', '0', '0', '2968'),
  56. ('34075', '42043', '0', '0', '2968'),
  57. ('34075', '42044', '0', '0', '2968'),
  58. ('34075', '42045', '0', '0', '2968'),
  59. ('34075', '42046', '0', '0', '2968'),
  60. ('34075', '42047', '0', '0', '2968'),
  61. ('34075', '42076', '0', '0', '2968'),
  62. ('34075', '42077', '0', '0', '2968'),
  63. ('34075', '42078', '0', '0', '2968'),
  64. ('34075', '42079', '0', '0', '2968'),
  65. ('34075', '42080', '0', '0', '2968'),
  66. ('34075', '42081', '0', '0', '2968'),
  67. ('34075', '42082', '0', '0', '2968'),
  68. ('34075', '42118', '0', '0', '2968'),
  69. ('34075', '42119', '0', '0', '2968'),
  70. ('34075', '42133', '0', '0', '2966'),
  71. ('34075', '42134', '0', '0', '2966'),
  72. ('34075', '42135', '0', '0', '2966'),
  73. ('34075', '42136', '0', '0', '2966'),
  74. ('34075', '42137', '0', '0', '2966'),
  75. ('34075', '46374', '0', '0', '2968'),
  76. ('34075', '49179', '0', '0', '2966'),
  77. ('34075', '49181', '0', '0', '2967'),
  78. ('34075', '49183', '0', '0', '2966');
  79.  
  80.  
  81. -- [34078] - Lieutenant Tristia
  82. DELETE FROM `npc_vendor` WHERE `entry`='34078';
  83. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  84. VALUES
  85. ('34078', '51327', '0', '0', '2962'),
  86. ('34078', '51328', '0', '0', '2961'),
  87. ('34078', '51329', '0', '0', '2963'),
  88. ('34078', '51330', '0', '0', '2964'),
  89. ('34078', '51331', '0', '0', '2964'),
  90. ('34078', '51332', '0', '0', '2964'),
  91. ('34078', '51333', '0', '0', '2964'),
  92. ('34078', '51334', '0', '0', '2964'),
  93. ('34078', '51335', '0', '0', '2964'),
  94. ('34078', '51336', '0', '0', '2964'),
  95. ('34078', '51337', '0', '0', '2962'),
  96. ('34078', '51338', '0', '0', '2961'),
  97. ('34078', '51339', '0', '0', '2963'),
  98. ('34078', '51340', '0', '0', '2962'),
  99. ('34078', '51341', '0', '0', '2961'),
  100. ('34078', '51342', '0', '0', '2963'),
  101. ('34078', '51343', '0', '0', '2962'),
  102. ('34078', '51344', '0', '0', '2961'),
  103. ('34078', '51345', '0', '0', '2963'),
  104. ('34078', '51346', '0', '0', '2964'),
  105. ('34078', '51347', '0', '0', '2964'),
  106. ('34078', '51348', '0', '0', '2964'),
  107. ('34078', '51349', '0', '0', '2964'),
  108. ('34078', '51350', '0', '0', '2962'),
  109. ('34078', '51351', '0', '0', '2961'),
  110. ('34078', '51352', '0', '0', '2963'),
  111. ('34078', '51353', '0', '0', '2964'),
  112. ('34078', '51354', '0', '0', '2964'),
  113. ('34078', '51355', '0', '0', '2964'),
  114. ('34078', '51356', '0', '0', '2964'),
  115. ('34078', '51357', '0', '0', '2964'),
  116. ('34078', '51358', '0', '0', '2964'),
  117. ('34078', '51359', '0', '0', '2962'),
  118. ('34078', '51360', '0', '0', '2961'),
  119. ('34078', '51361', '0', '0', '2963'),
  120. ('34078', '51362', '0', '0', '2962'),
  121. ('34078', '51363', '0', '0', '2961'),
  122. ('34078', '51364', '0', '0', '2963'),
  123. ('34078', '51365', '0', '0', '2962'),
  124. ('34078', '51366', '0', '0', '2961'),
  125. ('34078', '51367', '0', '0', '2963'),
  126. ('34078', '51368', '0', '0', '2962'),
  127. ('34078', '51369', '0', '0', '2961'),
  128. ('34078', '51370', '0', '0', '2963'),
  129. ('34078', '51371', '0', '0', '2962'),
  130. ('34078', '51372', '0', '0', '2961'),
  131. ('34078', '51373', '0', '0', '2963'),
  132. ('34078', '51374', '0', '0', '2962'),
  133. ('34078', '51375', '0', '0', '2961'),
  134. ('34078', '51376', '0', '0', '2963'),
  135. ('34078', '51377', '0', '0', '2965');
  136.  
  137.  
  138. -- [40607] - Knight-Lieutenant T'Maire Sydes
  139. DELETE FROM `npc_vendor` WHERE `entry`='40607';
  140. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  141. VALUES
  142. ('40607', '40787', '0', '0', '2959'),
  143. ('40607', '40788', '0', '0', '2959'),
  144. ('40607', '40789', '0', '0', '2959'),
  145. ('40607', '40807', '0', '0', '2960'),
  146. ('40607', '40808', '0', '0', '2960'),
  147. ('40607', '40809', '0', '0', '2960'),
  148. ('40607', '40826', '0', '0', '2959'),
  149. ('40607', '40827', '0', '0', '2959'),
  150. ('40607', '40828', '0', '0', '2959'),
  151. ('40607', '40847', '0', '0', '2958'),
  152. ('40607', '40848', '0', '0', '2958'),
  153. ('40607', '40849', '0', '0', '2958'),
  154. ('40607', '40866', '0', '0', '2958'),
  155. ('40607', '40868', '0', '0', '2958'),
  156. ('40607', '40869', '0', '0', '2958'),
  157. ('40607', '40907', '0', '0', '2959'),
  158. ('40607', '40927', '0', '0', '2960'),
  159. ('40607', '40933', '0', '0', '2959'),
  160. ('40607', '40939', '0', '0', '2958'),
  161. ('40607', '40963', '0', '0', '2958'),
  162. ('40607', '40992', '0', '0', '2959'),
  163. ('40607', '40993', '0', '0', '2959'),
  164. ('40607', '41001', '0', '0', '2960'),
  165. ('40607', '41007', '0', '0', '2960'),
  166. ('40607', '41013', '0', '0', '2959'),
  167. ('40607', '41019', '0', '0', '2959'),
  168. ('40607', '41027', '0', '0', '2958'),
  169. ('40607', '41033', '0', '0', '2958'),
  170. ('40607', '41038', '0', '0', '2958'),
  171. ('40607', '41044', '0', '0', '2958'),
  172. ('40607', '41081', '0', '0', '2959'),
  173. ('40607', '41087', '0', '0', '2959'),
  174. ('40607', '41137', '0', '0', '2960'),
  175. ('40607', '41143', '0', '0', '2960'),
  176. ('40607', '41151', '0', '0', '2959'),
  177. ('40607', '41157', '0', '0', '2959'),
  178. ('40607', '41199', '0', '0', '2958'),
  179. ('40607', '41205', '0', '0', '2958'),
  180. ('40607', '41211', '0', '0', '2958'),
  181. ('40607', '41217', '0', '0', '2958'),
  182. ('40607', '41275', '0', '0', '2958'),
  183. ('40607', '41281', '0', '0', '2958'),
  184. ('40607', '41287', '0', '0', '2960'),
  185. ('40607', '41293', '0', '0', '2960'),
  186. ('40607', '41298', '0', '0', '2958'),
  187. ('40607', '41304', '0', '0', '2958'),
  188. ('40607', '41310', '0', '0', '2959'),
  189. ('40607', '41316', '0', '0', '2959'),
  190. ('40607', '41321', '0', '0', '2959'),
  191. ('40607', '41327', '0', '0', '2959'),
  192. ('40607', '41650', '0', '0', '2959'),
  193. ('40607', '41655', '0', '0', '2958'),
  194. ('40607', '41661', '0', '0', '2959'),
  195. ('40607', '41667', '0', '0', '2958'),
  196. ('40607', '41672', '0', '0', '2959'),
  197. ('40607', '41678', '0', '0', '2959'),
  198. ('40607', '41683', '0', '0', '2958'),
  199. ('40607', '41715', '0', '0', '2958'),
  200. ('40607', '41767', '0', '0', '2960'),
  201. ('40607', '41773', '0', '0', '2960'),
  202. ('40607', '41854', '0', '0', '2959'),
  203. ('40607', '41859', '0', '0', '2959'),
  204. ('40607', '41864', '0', '0', '2958'),
  205. ('40607', '41869', '0', '0', '2958'),
  206. ('40607', '41874', '0', '0', '2960'),
  207. ('40607', '41915', '0', '0', '2959'),
  208. ('40607', '41921', '0', '0', '2959'),
  209. ('40607', '41927', '0', '0', '2958'),
  210. ('40607', '41934', '0', '0', '2958'),
  211. ('40607', '41940', '0', '0', '2960'),
  212. ('40607', '41946', '0', '0', '2959'),
  213. ('40607', '41953', '0', '0', '2959'),
  214. ('40607', '41959', '0', '0', '2958'),
  215. ('40607', '41965', '0', '0', '2958'),
  216. ('40607', '41971', '0', '0', '2960'),
  217. ('40607', '41993', '0', '0', '2959'),
  218. ('40607', '41998', '0', '0', '2959'),
  219. ('40607', '42005', '0', '0', '2958'),
  220. ('40607', '42011', '0', '0', '2958'),
  221. ('40607', '42017', '0', '0', '2960'),
  222. ('40607', '42579', '0', '0', '2969'),
  223. ('40607', '42584', '0', '0', '2969'),
  224. ('40607', '42589', '0', '0', '2969'),
  225. ('40607', '42598', '0', '0', '2969'),
  226. ('40607', '42603', '0', '0', '2969'),
  227. ('40607', '42608', '0', '0', '2969'),
  228. ('40607', '42615', '0', '0', '2969'),
  229. ('40607', '42621', '0', '0', '2969'),
  230. ('40607', '42853', '0', '0', '2969'),
  231. ('40607', '45706', '0', '0', '2596');
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!