API tools faq
paste
image

EoF vendorz

image
Dec 17th, 2011
194
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 11.45 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `creature` WHERE `id` IN ('37941', '37942');
  2. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  3. VALUES
  4. ('37941', '571', '1', '1', '0', '0', '5936.98', '509.241', '650.178', '2.18146', '600', '0', '0', '10080', '8814', '0', '0'),
  5. ('37942', '571', '1', '1', '0', '0', '5765.45', '734.38', '653.748', '2.72271', '600', '0', '0', '10080', '8814', '0', '0');
  6.  
  7. -- HORDE 37941
  8. 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;
  9. DELETE FROM `npc_vendor` WHERE `entry`='37941';
  10. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  11. VALUES
  12. ('37941', '40790', '0', '0', '2742'),
  13. ('37941', '40791', '0', '0', '2742'),
  14. ('37941', '40792', '0', '0', '2742'),
  15. ('37941', '40810', '0', '0', '2740'),
  16. ('37941', '40811', '0', '0', '2740'),
  17. ('37941', '40812', '0', '0', '2740'),
  18. ('37941', '40829', '0', '0', '2742'),
  19. ('37941', '40830', '0', '0', '2742'),
  20. ('37941', '40831', '0', '0', '2742'),
  21. ('37941', '40850', '0', '0', '2742'),
  22. ('37941', '40851', '0', '0', '2742'),
  23. ('37941', '40852', '0', '0', '2742'),
  24. ('37941', '40870', '0', '0', '2740'),
  25. ('37941', '40871', '0', '0', '2740'),
  26. ('37941', '40872', '0', '0', '2740'),
  27. ('37941', '40910', '0', '0', '2742'),
  28. ('37941', '40928', '0', '0', '2740'),
  29. ('37941', '40934', '0', '0', '2742'),
  30. ('37941', '40940', '0', '0', '2742'),
  31. ('37941', '40964', '0', '0', '2740'),
  32. ('37941', '40994', '0', '0', '2742'),
  33. ('37941', '40995', '0', '0', '2742'),
  34. ('37941', '41002', '0', '0', '2740'),
  35. ('37941', '41008', '0', '0', '2740'),
  36. ('37941', '41014', '0', '0', '2742'),
  37. ('37941', '41020', '0', '0', '2742'),
  38. ('37941', '41028', '0', '0', '2742'),
  39. ('37941', '41034', '0', '0', '2742'),
  40. ('37941', '41039', '0', '0', '2740'),
  41. ('37941', '41045', '0', '0', '2740'),
  42. ('37941', '41082', '0', '0', '2742'),
  43. ('37941', '41088', '0', '0', '2742'),
  44. ('37941', '41138', '0', '0', '2740'),
  45. ('37941', '41144', '0', '0', '2740'),
  46. ('37941', '41152', '0', '0', '2742'),
  47. ('37941', '41158', '0', '0', '2742'),
  48. ('37941', '41200', '0', '0', '2742'),
  49. ('37941', '41206', '0', '0', '2742'),
  50. ('37941', '41212', '0', '0', '2740'),
  51. ('37941', '41218', '0', '0', '2740'),
  52. ('37941', '41276', '0', '0', '2740'),
  53. ('37941', '41282', '0', '0', '2740'),
  54. ('37941', '41288', '0', '0', '2740'),
  55. ('37941', '41294', '0', '0', '2740'),
  56. ('37941', '41299', '0', '0', '2742'),
  57. ('37941', '41305', '0', '0', '2742'),
  58. ('37941', '41311', '0', '0', '2742'),
  59. ('37941', '41317', '0', '0', '2742'),
  60. ('37941', '41322', '0', '0', '2742'),
  61. ('37941', '41328', '0', '0', '2742'),
  62. ('37941', '41651', '0', '0', '2742'),
  63. ('37941', '41656', '0', '0', '2742'),
  64. ('37941', '41662', '0', '0', '2742'),
  65. ('37941', '41668', '0', '0', '2742'),
  66. ('37941', '41673', '0', '0', '2742'),
  67. ('37941', '41679', '0', '0', '2742'),
  68. ('37941', '41684', '0', '0', '2740'),
  69. ('37941', '41716', '0', '0', '2740'),
  70. ('37941', '41768', '0', '0', '2740'),
  71. ('37941', '41774', '0', '0', '2740'),
  72. ('37941', '41855', '0', '0', '2742'),
  73. ('37941', '41860', '0', '0', '2742'),
  74. ('37941', '41865', '0', '0', '2742'),
  75. ('37941', '41870', '0', '0', '2740'),
  76. ('37941', '41875', '0', '0', '2740'),
  77. ('37941', '41916', '0', '0', '2742'),
  78. ('37941', '41922', '0', '0', '2742'),
  79. ('37941', '41928', '0', '0', '2742'),
  80. ('37941', '41935', '0', '0', '2740'),
  81. ('37941', '41941', '0', '0', '2740'),
  82. ('37941', '41947', '0', '0', '2742'),
  83. ('37941', '41954', '0', '0', '2742'),
  84. ('37941', '41960', '0', '0', '2742'),
  85. ('37941', '41966', '0', '0', '2740'),
  86. ('37941', '41972', '0', '0', '2740'),
  87. ('37941', '41994', '0', '0', '2742'),
  88. ('37941', '41999', '0', '0', '2742'),
  89. ('37941', '42006', '0', '0', '2742'),
  90. ('37941', '42012', '0', '0', '2740'),
  91. ('37941', '42018', '0', '0', '2740'),
  92. ('37941', '47241', '0', '0', '2743'),
  93. ('37941', '49908', '0', '0', '2744'),
  94. ('37941', '50355', '0', '0', '2740'),
  95. ('37941', '50356', '0', '0', '2740'),
  96. ('37941', '50357', '0', '0', '2740'),
  97. ('37941', '50358', '0', '0', '2740'),
  98. ('37941', '50454', '0', '0', '2739'),
  99. ('37941', '50455', '0', '0', '2739'),
  100. ('37941', '50456', '0', '0', '2739'),
  101. ('37941', '50457', '0', '0', '2739'),
  102. ('37941', '50458', '0', '0', '2739'),
  103. ('37941', '50459', '0', '0', '2739'),
  104. ('37941', '50460', '0', '0', '2739'),
  105. ('37941', '50461', '0', '0', '2739'),
  106. ('37941', '50462', '0', '0', '2739'),
  107. ('37941', '50463', '0', '0', '2739'),
  108. ('37941', '50464', '0', '0', '2739'),
  109. ('37941', '50466', '0', '0', '2741'),
  110. ('37941', '50467', '0', '0', '2741'),
  111. ('37941', '50468', '0', '0', '2741'),
  112. ('37941', '50469', '0', '0', '2741'),
  113. ('37941', '50470', '0', '0', '2741'),
  114. ('37941', '50474', '0', '0', '2739'),
  115. ('37941', '50965', '0', '0', '2742'),
  116. ('37941', '50968', '0', '0', '2742'),
  117. ('37941', '50969', '0', '0', '2742'),
  118. ('37941', '50970', '0', '0', '2742'),
  119. ('37941', '50971', '0', '0', '2742'),
  120. ('37941', '50972', '0', '0', '2742'),
  121. ('37941', '50973', '0', '0', '2742'),
  122. ('37941', '50974', '0', '0', '2742'),
  123. ('37941', '50975', '0', '0', '2742'),
  124. ('37941', '50976', '0', '0', '2740'),
  125. ('37941', '50977', '0', '0', '2740'),
  126. ('37941', '50978', '0', '0', '2740'),
  127. ('37941', '50979', '0', '0', '2740'),
  128. ('37941', '50980', '0', '0', '2740'),
  129. ('37941', '50981', '0', '0', '2740'),
  130. ('37941', '50982', '0', '0', '2740'),
  131. ('37941', '50983', '0', '0', '2740'),
  132. ('37941', '50984', '0', '0', '2740'),
  133. ('37941', '50987', '0', '0', '2740'),
  134. ('37941', '50989', '0', '0', '2740'),
  135. ('37941', '50991', '0', '0', '2740'),
  136. ('37941', '50992', '0', '0', '2740'),
  137. ('37941', '50993', '0', '0', '2740'),
  138. ('37941', '50994', '0', '0', '2740'),
  139. ('37941', '50995', '0', '0', '2740'),
  140. ('37941', '50996', '0', '0', '2740'),
  141. ('37941', '50997', '0', '0', '2740');
  142.  
  143.  
  144. -- ALLIANCE 37942
  145. 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;
  146. DELETE FROM `npc_vendor` WHERE `entry`='37942';
  147. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  148. VALUES
  149. ('37942', '40790', '0', '0', '2742'),
  150. ('37942', '40791', '0', '0', '2742'),
  151. ('37942', '40792', '0', '0', '2742'),
  152. ('37942', '40810', '0', '0', '2740'),
  153. ('37942', '40811', '0', '0', '2740'),
  154. ('37942', '40812', '0', '0', '2740'),
  155. ('37942', '40829', '0', '0', '2742'),
  156. ('37942', '40830', '0', '0', '2742'),
  157. ('37942', '40831', '0', '0', '2742'),
  158. ('37942', '40850', '0', '0', '2742'),
  159. ('37942', '40851', '0', '0', '2742'),
  160. ('37942', '40852', '0', '0', '2742'),
  161. ('37942', '40870', '0', '0', '2740'),
  162. ('37942', '40871', '0', '0', '2740'),
  163. ('37942', '40872', '0', '0', '2740'),
  164. ('37942', '40910', '0', '0', '2742'),
  165. ('37942', '40928', '0', '0', '2740'),
  166. ('37942', '40934', '0', '0', '2742'),
  167. ('37942', '40940', '0', '0', '2742'),
  168. ('37942', '40964', '0', '0', '2740'),
  169. ('37942', '40994', '0', '0', '2742'),
  170. ('37942', '40995', '0', '0', '2742'),
  171. ('37942', '41002', '0', '0', '2740'),
  172. ('37942', '41008', '0', '0', '2740'),
  173. ('37942', '41014', '0', '0', '2742'),
  174. ('37942', '41020', '0', '0', '2742'),
  175. ('37942', '41028', '0', '0', '2742'),
  176. ('37942', '41034', '0', '0', '2742'),
  177. ('37942', '41039', '0', '0', '2740'),
  178. ('37942', '41045', '0', '0', '2740'),
  179. ('37942', '41082', '0', '0', '2742'),
  180. ('37942', '41088', '0', '0', '2742'),
  181. ('37942', '41138', '0', '0', '2740'),
  182. ('37942', '41144', '0', '0', '2740'),
  183. ('37942', '41152', '0', '0', '2742'),
  184. ('37942', '41158', '0', '0', '2742'),
  185. ('37942', '41200', '0', '0', '2742'),
  186. ('37942', '41206', '0', '0', '2742'),
  187. ('37942', '41212', '0', '0', '2740'),
  188. ('37942', '41218', '0', '0', '2740'),
  189. ('37942', '41276', '0', '0', '2740'),
  190. ('37942', '41282', '0', '0', '2740'),
  191. ('37942', '41288', '0', '0', '2740'),
  192. ('37942', '41294', '0', '0', '2740'),
  193. ('37942', '41299', '0', '0', '2742'),
  194. ('37942', '41305', '0', '0', '2742'),
  195. ('37942', '41311', '0', '0', '2742'),
  196. ('37942', '41317', '0', '0', '2742'),
  197. ('37942', '41322', '0', '0', '2742'),
  198. ('37942', '41328', '0', '0', '2742'),
  199. ('37942', '41651', '0', '0', '2742'),
  200. ('37942', '41656', '0', '0', '2742'),
  201. ('37942', '41662', '0', '0', '2742'),
  202. ('37942', '41668', '0', '0', '2742'),
  203. ('37942', '41673', '0', '0', '2742'),
  204. ('37942', '41679', '0', '0', '2742'),
  205. ('37942', '41684', '0', '0', '2740'),
  206. ('37942', '41716', '0', '0', '2740'),
  207. ('37942', '41768', '0', '0', '2740'),
  208. ('37942', '41774', '0', '0', '2740'),
  209. ('37942', '41855', '0', '0', '2742'),
  210. ('37942', '41860', '0', '0', '2742'),
  211. ('37942', '41865', '0', '0', '2742'),
  212. ('37942', '41870', '0', '0', '2740'),
  213. ('37942', '41875', '0', '0', '2740'),
  214. ('37942', '41916', '0', '0', '2742'),
  215. ('37942', '41922', '0', '0', '2742'),
  216. ('37942', '41928', '0', '0', '2742'),
  217. ('37942', '41935', '0', '0', '2740'),
  218. ('37942', '41941', '0', '0', '2740'),
  219. ('37942', '41947', '0', '0', '2742'),
  220. ('37942', '41954', '0', '0', '2742'),
  221. ('37942', '41960', '0', '0', '2742'),
  222. ('37942', '41966', '0', '0', '2740'),
  223. ('37942', '41972', '0', '0', '2740'),
  224. ('37942', '41994', '0', '0', '2742'),
  225. ('37942', '41999', '0', '0', '2742'),
  226. ('37942', '42006', '0', '0', '2742'),
  227. ('37942', '42012', '0', '0', '2740'),
  228. ('37942', '42018', '0', '0', '2740'),
  229. ('37942', '47241', '0', '0', '2743'),
  230. ('37942', '49908', '0', '0', '2744'),
  231. ('37942', '50355', '0', '0', '2740'),
  232. ('37942', '50356', '0', '0', '2740'),
  233. ('37942', '50357', '0', '0', '2740'),
  234. ('37942', '50358', '0', '0', '2740'),
  235. ('37942', '50454', '0', '0', '2739'),
  236. ('37942', '50455', '0', '0', '2739'),
  237. ('37942', '50456', '0', '0', '2739'),
  238. ('37942', '50457', '0', '0', '2739'),
  239. ('37942', '50458', '0', '0', '2739'),
  240. ('37942', '50459', '0', '0', '2739'),
  241. ('37942', '50460', '0', '0', '2739'),
  242. ('37942', '50461', '0', '0', '2739'),
  243. ('37942', '50462', '0', '0', '2739'),
  244. ('37942', '50463', '0', '0', '2739'),
  245. ('37942', '50464', '0', '0', '2739'),
  246. ('37942', '50466', '0', '0', '2741'),
  247. ('37942', '50467', '0', '0', '2741'),
  248. ('37942', '50468', '0', '0', '2741'),
  249. ('37942', '50469', '0', '0', '2741'),
  250. ('37942', '50470', '0', '0', '2741'),
  251. ('37942', '50474', '0', '0', '2739'),
  252. ('37942', '50965', '0', '0', '2742'),
  253. ('37942', '50968', '0', '0', '2742'),
  254. ('37942', '50969', '0', '0', '2742'),
  255. ('37942', '50970', '0', '0', '2742'),
  256. ('37942', '50971', '0', '0', '2742'),
  257. ('37942', '50972', '0', '0', '2742'),
  258. ('37942', '50973', '0', '0', '2742'),
  259. ('37942', '50974', '0', '0', '2742'),
  260. ('37942', '50975', '0', '0', '2742'),
  261. ('37942', '50976', '0', '0', '2740'),
  262. ('37942', '50977', '0', '0', '2740'),
  263. ('37942', '50978', '0', '0', '2740'),
  264. ('37942', '50979', '0', '0', '2740'),
  265. ('37942', '50980', '0', '0', '2740'),
  266. ('37942', '50981', '0', '0', '2740'),
  267. ('37942', '50982', '0', '0', '2740'),
  268. ('37942', '50983', '0', '0', '2740'),
  269. ('37942', '50984', '0', '0', '2740'),
  270. ('37942', '50987', '0', '0', '2740'),
  271. ('37942', '50989', '0', '0', '2740'),
  272. ('37942', '50991', '0', '0', '2740'),
  273. ('37942', '50992', '0', '0', '2740'),
  274. ('37942', '50993', '0', '0', '2740'),
  275. ('37942', '50994', '0', '0', '2740'),
  276. ('37942', '50995', '0', '0', '2740'),
  277. ('37942', '50996', '0', '0', '2740'),
  278. ('37942', '50997', '0', '0', '2740');
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!