API tools faq
paste
image

S8 - Org

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