API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
65
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 10.80 KB | None | 0 0
raw download clone embed print report
  1. -- Knight Dameron <Wintergrasp Quartermaster>
  2. DELETE FROM `npc_vendor` WHERE `entry`='32294';
  3. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  4. VALUES
  5. ('32294', '41727', '0', '0', '2481'),
  6. ('32294', '41728', '0', '0', '2481'),
  7. ('32294', '41730', '0', '0', '2481'),
  8. ('32294', '41732', '0', '0', '2481'),
  9. ('32294', '41733', '0', '0', '2481'),
  10. ('32294', '41734', '0', '0', '2481'),
  11. ('32294', '41735', '0', '0', '2481'),
  12. ('32294', '41736', '0', '0', '2481'),
  13. ('32294', '41737', '0', '0', '2481'),
  14. ('32294', '41738', '0', '0', '2481'),
  15. ('32294', '41740', '0', '0', '2481'),
  16. ('32294', '41742', '0', '0', '2482'),
  17. ('32294', '41743', '0', '0', '2482'),
  18. ('32294', '41744', '0', '0', '2482'),
  19. ('32294', '43956', '0', '0', '2552'),
  20. ('32294', '44066', '0', '0', '2545'),
  21. ('32294', '44067', '0', '0', '2546'),
  22. ('32294', '44068', '0', '0', '2546'),
  23. ('32294', '44069', '0', '0', '2549'),
  24. ('32294', '44075', '0', '0', '2549'),
  25. ('32294', '44076', '0', '0', '2547'),
  26. ('32294', '44078', '0', '0', '2547'),
  27. ('32294', '44081', '0', '0', '2547'),
  28. ('32294', '44082', '0', '0', '2547'),
  29. ('32294', '44084', '0', '0', '2547'),
  30. ('32294', '44087', '0', '0', '2547'),
  31. ('32294', '44088', '0', '0', '2547'),
  32. ('32294', '44089', '0', '0', '2547'),
  33. ('32294', '44091', '0', '0', '2542'),
  34. ('32294', '44092', '0', '0', '2543'),
  35. ('32294', '44093', '0', '0', '2543'),
  36. ('32294', '44094', '0', '0', '2544'),
  37. ('32294', '44095', '0', '0', '2543'),
  38. ('32294', '44096', '0', '0', '2542'),
  39. ('32294', '44098', '0', '0', '2544'),
  40. ('32294', '44099', '0', '0', '2542'),
  41. ('32294', '44100', '0', '0', '2542'),
  42. ('32294', '44101', '0', '0', '2542'),
  43. ('32294', '44102', '0', '0', '2542'),
  44. ('32294', '44103', '0', '0', '2542'),
  45. ('32294', '44105', '0', '0', '2542'),
  46. ('32294', '44107', '0', '0', '2542'),
  47. ('32294', '44115', '0', '0', '2546'),
  48. ('32294', '44891', '0', '0', '2577'),
  49. ('32294', '44892', '0', '0', '2577'),
  50. ('32294', '44893', '0', '0', '2577'),
  51. ('32294', '44894', '0', '0', '2577'),
  52. ('32294', '44895', '0', '0', '2577'),
  53. ('32294', '44896', '0', '0', '2577'),
  54. ('32294', '44897', '0', '0', '2577'),
  55. ('32294', '44898', '0', '0', '2577'),
  56. ('32294', '44899', '0', '0', '2577'),
  57. ('32294', '44900', '0', '0', '2577'),
  58. ('32294', '44901', '0', '0', '2579'),
  59. ('32294', '44902', '0', '0', '2579'),
  60. ('32294', '44903', '0', '0', '2579'),
  61. ('32294', '44904', '0', '0', '2579'),
  62. ('32294', '44905', '0', '0', '2579'),
  63. ('32294', '44906', '0', '0', '2579'),
  64. ('32294', '44907', '0', '0', '2579'),
  65. ('32294', '44908', '0', '0', '2579'),
  66. ('32294', '44909', '0', '0', '2579'),
  67. ('32294', '44910', '0', '0', '2579'),
  68. ('32294', '44912', '0', '0', '2578'),
  69. ('32294', '44914', '0', '0', '2578'),
  70. ('32294', '46057', '0', '0', '2579'),
  71. ('32294', '46058', '0', '0', '2579'),
  72. ('32294', '46059', '0', '0', '2579'),
  73. ('32294', '46060', '0', '0', '2579'),
  74. ('32294', '46061', '0', '0', '2579'),
  75. ('32294', '46062', '0', '0', '2579'),
  76. ('32294', '46063', '0', '0', '2579'),
  77. ('32294', '46064', '0', '0', '2579'),
  78. ('32294', '46065', '0', '0', '2579'),
  79. ('32294', '46066', '0', '0', '2579'),
  80. ('32294', '46071', '0', '0', '2577'),
  81. ('32294', '46072', '0', '0', '2577'),
  82. ('32294', '46073', '0', '0', '2577'),
  83. ('32294', '46074', '0', '0', '2577'),
  84. ('32294', '46075', '0', '0', '2577'),
  85. ('32294', '46076', '0', '0', '2577'),
  86. ('32294', '46077', '0', '0', '2577'),
  87. ('32294', '46078', '0', '0', '2577'),
  88. ('32294', '46079', '0', '0', '2577'),
  89. ('32294', '46080', '0', '0', '2577'),
  90. ('32294', '46081', '0', '0', '2578'),
  91. ('32294', '46082', '0', '0', '2578'),
  92. ('32294', '46083', '0', '0', '2578'),
  93. ('32294', '46084', '0', '0', '2578'),
  94. ('32294', '46085', '0', '0', '2578'),
  95. ('32294', '46086', '0', '0', '2578'),
  96. ('32294', '46087', '0', '0', '2578'),
  97. ('32294', '46088', '0', '0', '2578'),
  98. ('32294', '48974', '0', '0', '2577'),
  99. ('32294', '48975', '0', '0', '2577'),
  100. ('32294', '48976', '0', '0', '2577'),
  101. ('32294', '48977', '0', '0', '2577'),
  102. ('32294', '48978', '0', '0', '2577'),
  103. ('32294', '48979', '0', '0', '2577'),
  104. ('32294', '48980', '0', '0', '2577'),
  105. ('32294', '48981', '0', '0', '2577'),
  106. ('32294', '48982', '0', '0', '2577'),
  107. ('32294', '48983', '0', '0', '2579'),
  108. ('32294', '48987', '0', '0', '2579'),
  109. ('32294', '48988', '0', '0', '2579'),
  110. ('32294', '48990', '0', '0', '2579'),
  111. ('32294', '48991', '0', '0', '2579'),
  112. ('32294', '48992', '0', '0', '2579'),
  113. ('32294', '48993', '0', '0', '2579'),
  114. ('32294', '48994', '0', '0', '2579'),
  115. ('32294', '48997', '0', '0', '2579'),
  116. ('32294', '48998', '0', '0', '2579'),
  117. ('32294', '48999', '0', '0', '2577'),
  118. ('32294', '49000', '0', '0', '2577');
  119.  
  120.  
  121. -- Stone Guard Mukar <Wintergrasp Quartermaster>
  122. DELETE FROM `npc_vendor` WHERE `entry`='32296';
  123. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  124. VALUES
  125. ('32296', '41727', '0', '0', '2481'),
  126. ('32296', '41728', '0', '0', '2481'),
  127. ('32296', '41730', '0', '0', '2481'),
  128. ('32296', '41732', '0', '0', '2481'),
  129. ('32296', '41733', '0', '0', '2481'),
  130. ('32296', '41734', '0', '0', '2481'),
  131. ('32296', '41735', '0', '0', '2481'),
  132. ('32296', '41736', '0', '0', '2481'),
  133. ('32296', '41737', '0', '0', '2481'),
  134. ('32296', '41738', '0', '0', '2481'),
  135. ('32296', '41740', '0', '0', '2481'),
  136. ('32296', '41742', '0', '0', '2482'),
  137. ('32296', '41743', '0', '0', '2482'),
  138. ('32296', '41744', '0', '0', '2482'),
  139. ('32296', '44066', '0', '0', '2545'),
  140. ('32296', '44067', '0', '0', '2546'),
  141. ('32296', '44068', '0', '0', '2546'),
  142. ('32296', '44069', '0', '0', '2549'),
  143. ('32296', '44075', '0', '0', '2549'),
  144. ('32296', '44076', '0', '0', '2547'),
  145. ('32296', '44077', '0', '0', '2552'),
  146. ('32296', '44078', '0', '0', '2547'),
  147. ('32296', '44081', '0', '0', '2547'),
  148. ('32296', '44082', '0', '0', '2547'),
  149. ('32296', '44084', '0', '0', '2547'),
  150. ('32296', '44087', '0', '0', '2547'),
  151. ('32296', '44088', '0', '0', '2547'),
  152. ('32296', '44089', '0', '0', '2547'),
  153. ('32296', '44091', '0', '0', '2542'),
  154. ('32296', '44092', '0', '0', '2543'),
  155. ('32296', '44093', '0', '0', '2543'),
  156. ('32296', '44094', '0', '0', '2544'),
  157. ('32296', '44095', '0', '0', '2543'),
  158. ('32296', '44096', '0', '0', '2542'),
  159. ('32296', '44097', '0', '0', '2544'),
  160. ('32296', '44099', '0', '0', '2542'),
  161. ('32296', '44100', '0', '0', '2542'),
  162. ('32296', '44101', '0', '0', '2542'),
  163. ('32296', '44102', '0', '0', '2542'),
  164. ('32296', '44103', '0', '0', '2542'),
  165. ('32296', '44105', '0', '0', '2542'),
  166. ('32296', '44107', '0', '0', '2542'),
  167. ('32296', '44115', '0', '0', '2546'),
  168. ('32296', '44891', '0', '0', '2577'),
  169. ('32296', '44892', '0', '0', '2577'),
  170. ('32296', '44893', '0', '0', '2577'),
  171. ('32296', '44894', '0', '0', '2577'),
  172. ('32296', '44895', '0', '0', '2577'),
  173. ('32296', '44896', '0', '0', '2577'),
  174. ('32296', '44897', '0', '0', '2577'),
  175. ('32296', '44898', '0', '0', '2577'),
  176. ('32296', '44899', '0', '0', '2577'),
  177. ('32296', '44900', '0', '0', '2577'),
  178. ('32296', '44901', '0', '0', '2579'),
  179. ('32296', '44902', '0', '0', '2579'),
  180. ('32296', '44903', '0', '0', '2579'),
  181. ('32296', '44904', '0', '0', '2579'),
  182. ('32296', '44905', '0', '0', '2579'),
  183. ('32296', '44906', '0', '0', '2579'),
  184. ('32296', '44907', '0', '0', '2579'),
  185. ('32296', '44908', '0', '0', '2579'),
  186. ('32296', '44909', '0', '0', '2579'),
  187. ('32296', '44910', '0', '0', '2579'),
  188. ('32296', '44912', '0', '0', '2578'),
  189. ('32296', '44914', '0', '0', '2578'),
  190. ('32296', '46057', '0', '0', '2579'),
  191. ('32296', '46058', '0', '0', '2579'),
  192. ('32296', '46059', '0', '0', '2579'),
  193. ('32296', '46060', '0', '0', '2579'),
  194. ('32296', '46061', '0', '0', '2579'),
  195. ('32296', '46062', '0', '0', '2579'),
  196. ('32296', '46063', '0', '0', '2579'),
  197. ('32296', '46064', '0', '0', '2579'),
  198. ('32296', '46065', '0', '0', '2579'),
  199. ('32296', '46066', '0', '0', '2579'),
  200. ('32296', '46071', '0', '0', '2577'),
  201. ('32296', '46072', '0', '0', '2577'),
  202. ('32296', '46073', '0', '0', '2577'),
  203. ('32296', '46074', '0', '0', '2577'),
  204. ('32296', '46075', '0', '0', '2577'),
  205. ('32296', '46076', '0', '0', '2577'),
  206. ('32296', '46077', '0', '0', '2577'),
  207. ('32296', '46078', '0', '0', '2577'),
  208. ('32296', '46079', '0', '0', '2577'),
  209. ('32296', '46080', '0', '0', '2577'),
  210. ('32296', '46081', '0', '0', '2578'),
  211. ('32296', '46082', '0', '0', '2578'),
  212. ('32296', '46083', '0', '0', '2578'),
  213. ('32296', '46084', '0', '0', '2578'),
  214. ('32296', '46085', '0', '0', '2578'),
  215. ('32296', '46086', '0', '0', '2578'),
  216. ('32296', '46087', '0', '0', '2578'),
  217. ('32296', '46088', '0', '0', '2578'),
  218. ('32296', '48974', '0', '0', '2577'),
  219. ('32296', '48975', '0', '0', '2577'),
  220. ('32296', '48976', '0', '0', '2577'),
  221. ('32296', '48977', '0', '0', '2577'),
  222. ('32296', '48978', '0', '0', '2577'),
  223. ('32296', '48979', '0', '0', '2577'),
  224. ('32296', '48980', '0', '0', '2577'),
  225. ('32296', '48981', '0', '0', '2577'),
  226. ('32296', '48982', '0', '0', '2577'),
  227. ('32296', '48983', '0', '0', '2579'),
  228. ('32296', '48987', '0', '0', '2579'),
  229. ('32296', '48988', '0', '0', '2579'),
  230. ('32296', '48990', '0', '0', '2579'),
  231. ('32296', '48991', '0', '0', '2579'),
  232. ('32296', '48992', '0', '0', '2579'),
  233. ('32296', '48993', '0', '0', '2579'),
  234. ('32296', '48994', '0', '0', '2579'),
  235. ('32296', '48997', '0', '0', '2579'),
  236. ('32296', '48998', '0', '0', '2579'),
  237. ('32296', '48999', '0', '0', '2577'),
  238. ('32296', '49000', '0', '0', '2577');
  239.  
  240.  
  241. -- Morgan Day <Jewelcrafter>
  242. DELETE FROM `creature` WHERE `id`='30489';
  243. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  244. VALUES
  245. ('30489', '571', '1', '1', '0', '0', '5367.1', '2826.57', '409.24', '3.23883', '600', '0', '0', '71798', '0', '0', '0');
  246. UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1892", `faction_H` = "1892", `mindmg` = "404", `maxdmg` = "606", `attackpower` = "151", `dmg_multiplier` = "1.4", `rangeattacktime` = "2000", `unit_flags` = "768", `minrangedmg` = "323", `maxrangedmg` = "485", `rangedattackpower` = "121", `InhabitType` = "3", `equipment_id` = "93" WHERE entry=30489;
  247. DELETE FROM `npc_vendor` WHERE `entry`='30489';
  248. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  249. VALUES
  250. ('30489', '41727', '0', '0', '2481'),
  251. ('30489', '41728', '0', '0', '2481'),
  252. ('30489', '41730', '0', '0', '2481'),
  253. ('30489', '41733', '0', '0', '2481'),
  254. ('30489', '41734', '0', '0', '2481'),
  255. ('30489', '41735', '0', '0', '2481'),
  256. ('30489', '41737', '0', '0', '2481'),
  257. ('30489', '41738', '0', '0', '2481'),
  258. ('30489', '41740', '0', '0', '2481'),
  259. ('30489', '41742', '0', '0', '2482'),
  260. ('30489', '41743', '0', '0', '2482'),
  261. ('30489', '41744', '0', '0', '2482'),
  262. ('30489', '44066', '0', '0', '2545'),
  263. ('30489', '44076', '0', '0', '2547'),
  264. ('30489', '44078', '0', '0', '2547'),
  265. ('30489', '44081', '0', '0', '2547'),
  266. ('30489', '44082', '0', '0', '2547'),
  267. ('30489', '44084', '0', '0', '2547'),
  268. ('30489', '44087', '0', '0', '2547'),
  269. ('30489', '44088', '0', '0', '2547'),
  270. ('30489', '44089', '0', '0', '2547');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!