Advertisement
tok124

SQL Vendor

Aug 6th, 2014
232
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SET
  2. @CreatureEntry = 60001,
  3. @ItemStartEntry = 61000,
  4. @MaxCount = 0,
  5. @ExtendedCostID = 0;
  6.  
  7. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  8. VALUES (@CreatureEntry, @ItemStartEntry, @MaxCount, @ExtendedCostID);
  9. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  10. VALUES (@CreatureEntry, @ItemStartEntry+1, @MaxCount, @ExtendedCostID);
  11. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  12. VALUES (@CreatureEntry, @ItemStartEntry+2, @MaxCount, @ExtendedCostID);
  13. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  14. VALUES (@CreatureEntry, @ItemStartEntry+3, @MaxCount, @ExtendedCostID);
  15. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  16. VALUES (@CreatureEntry, @ItemStartEntry+4, @MaxCount, @ExtendedCostID);
  17. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  18. VALUES (@CreatureEntry, @ItemStartEntry+5, @MaxCount, @ExtendedCostID);
  19. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  20. VALUES (@CreatureEntry, @ItemStartEntry+6, @MaxCount, @ExtendedCostID);
  21. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  22. VALUES (@CreatureEntry, @ItemStartEntry+7, @MaxCount, @ExtendedCostID);
  23. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  24. VALUES (@CreatureEntry, @ItemStartEntry+8, @MaxCount, @ExtendedCostID);
  25. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  26. VALUES (@CreatureEntry, @ItemStartEntry+9, @MaxCount, @ExtendedCostID);
  27. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  28. VALUES (@CreatureEntry, @ItemStartEntry+10, @MaxCount, @ExtendedCostID);
  29. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  30. VALUES (@CreatureEntry, @ItemStartEntry+11, @MaxCount, @ExtendedCostID);
  31. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  32. VALUES (@CreatureEntry, @ItemStartEntry+12, @MaxCount, @ExtendedCostID);
  33. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  34. VALUES (@CreatureEntry, @ItemStartEntry+13, @MaxCount, @ExtendedCostID);
  35. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  36. VALUES (@CreatureEntry, @ItemStartEntry+14, @MaxCount, @ExtendedCostID);
  37. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  38. VALUES (@CreatureEntry, @ItemStartEntry+15, @MaxCount, @ExtendedCostID);
  39. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  40. VALUES (@CreatureEntry, @ItemStartEntry+16, @MaxCount, @ExtendedCostID);
  41. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  42. VALUES (@CreatureEntry, @ItemStartEntry+17, @MaxCount, @ExtendedCostID);
  43. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  44. VALUES (@CreatureEntry, @ItemStartEntry+18, @MaxCount, @ExtendedCostID);
  45. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  46. VALUES (@CreatureEntry, @ItemStartEntry+19, @MaxCount, @ExtendedCostID);
  47. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  48. VALUES (@CreatureEntry, @ItemStartEntry+20, @MaxCount, @ExtendedCostID);
  49. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  50. VALUES (@CreatureEntry, @ItemStartEntry+21, @MaxCount, @ExtendedCostID);
  51. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  52. VALUES (@CreatureEntry, @ItemStartEntry+22, @MaxCount, @ExtendedCostID);
  53. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  54. VALUES (@CreatureEntry, @ItemStartEntry+23, @MaxCount, @ExtendedCostID);
  55. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  56. VALUES (@CreatureEntry, @ItemStartEntry+24, @MaxCount, @ExtendedCostID);
  57. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  58. VALUES (@CreatureEntry, @ItemStartEntry+25, @MaxCount, @ExtendedCostID);
  59. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  60. VALUES (@CreatureEntry, @ItemStartEntry+26, @MaxCount, @ExtendedCostID);
  61. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  62. VALUES (@CreatureEntry, @ItemStartEntry+27, @MaxCount, @ExtendedCostID);
  63. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  64. VALUES (@CreatureEntry, @ItemStartEntry+28, @MaxCount, @ExtendedCostID);
  65. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  66. VALUES (@CreatureEntry, @ItemStartEntry+29, @MaxCount, @ExtendedCostID);
  67. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  68. VALUES (@CreatureEntry, @ItemStartEntry+30, @MaxCount, @ExtendedCostID);
  69. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  70. VALUES (@CreatureEntry, @ItemStartEntry+31, @MaxCount, @ExtendedCostID);
  71. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  72. VALUES (@CreatureEntry, @ItemStartEntry+32, @MaxCount, @ExtendedCostID);
  73. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  74. VALUES (@CreatureEntry, @ItemStartEntry+33, @MaxCount, @ExtendedCostID);
  75. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  76. VALUES (@CreatureEntry, @ItemStartEntry+34, @MaxCount, @ExtendedCostID);
  77. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  78. VALUES (@CreatureEntry, @ItemStartEntry+35, @MaxCount, @ExtendedCostID);
  79. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  80. VALUES (@CreatureEntry, @ItemStartEntry+36, @MaxCount, @ExtendedCostID);
  81. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  82. VALUES (@CreatureEntry, @ItemStartEntry+37, @MaxCount, @ExtendedCostID);
  83. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  84. VALUES (@CreatureEntry, @ItemStartEntry+38, @MaxCount, @ExtendedCostID);
  85. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  86. VALUES (@CreatureEntry, @ItemStartEntry+39, @MaxCount, @ExtendedCostID);
  87. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  88. VALUES (@CreatureEntry, @ItemStartEntry+40, @MaxCount, @ExtendedCostID);
  89. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  90. VALUES (@CreatureEntry, @ItemStartEntry+41, @MaxCount, @ExtendedCostID);
  91. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  92. VALUES (@CreatureEntry, @ItemStartEntry+42, @MaxCount, @ExtendedCostID);
  93. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  94. VALUES (@CreatureEntry, @ItemStartEntry+43, @MaxCount, @ExtendedCostID);
  95. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  96. VALUES (@CreatureEntry, @ItemStartEntry+44, @MaxCount, @ExtendedCostID);
  97. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  98. VALUES (@CreatureEntry, @ItemStartEntry+45, @MaxCount, @ExtendedCostID);
  99. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  100. VALUES (@CreatureEntry, @ItemStartEntry+46, @MaxCount, @ExtendedCostID);
  101. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  102. VALUES (@CreatureEntry, @ItemStartEntry+47, @MaxCount, @ExtendedCostID);
  103. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  104. VALUES (@CreatureEntry, @ItemStartEntry+48, @MaxCount, @ExtendedCostID);
  105. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  106. VALUES (@CreatureEntry, @ItemStartEntry+49, @MaxCount, @ExtendedCostID);
  107. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  108. VALUES (@CreatureEntry, @ItemStartEntry+50, @MaxCount, @ExtendedCostID);
  109. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  110. VALUES (@CreatureEntry, @ItemStartEntry+51, @MaxCount, @ExtendedCostID);
  111. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  112. VALUES (@CreatureEntry, @ItemStartEntry+52, @MaxCount, @ExtendedCostID);
  113. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  114. VALUES (@CreatureEntry, @ItemStartEntry+53, @MaxCount, @ExtendedCostID);
  115. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  116. VALUES (@CreatureEntry, @ItemStartEntry+54, @MaxCount, @ExtendedCostID);
  117. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  118. VALUES (@CreatureEntry, @ItemStartEntry+55, @MaxCount, @ExtendedCostID);
  119. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  120. VALUES (@CreatureEntry, @ItemStartEntry+56, @MaxCount, @ExtendedCostID);
  121. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  122. VALUES (@CreatureEntry, @ItemStartEntry+57, @MaxCount, @ExtendedCostID);
  123. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  124. VALUES (@CreatureEntry, @ItemStartEntry+58, @MaxCount, @ExtendedCostID);
  125. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  126. VALUES (@CreatureEntry, @ItemStartEntry+59, @MaxCount, @ExtendedCostID);
  127. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  128. VALUES (@CreatureEntry, @ItemStartEntry+60, @MaxCount, @ExtendedCostID);
  129. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  130. VALUES (@CreatureEntry, @ItemStartEntry+61, @MaxCount, @ExtendedCostID);
  131. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  132. VALUES (@CreatureEntry, @ItemStartEntry+62, @MaxCount, @ExtendedCostID);
  133. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  134. VALUES (@CreatureEntry, @ItemStartEntry+63, @MaxCount, @ExtendedCostID);
  135. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  136. VALUES (@CreatureEntry, @ItemStartEntry+64, @MaxCount, @ExtendedCostID);
  137. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  138. VALUES (@CreatureEntry, @ItemStartEntry+65, @MaxCount, @ExtendedCostID);
  139. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  140. VALUES (@CreatureEntry, @ItemStartEntry+66, @MaxCount, @ExtendedCostID);
  141. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  142. VALUES (@CreatureEntry, @ItemStartEntry+67, @MaxCount, @ExtendedCostID);
  143. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  144. VALUES (@CreatureEntry, @ItemStartEntry+68, @MaxCount, @ExtendedCostID);
  145. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  146. VALUES (@CreatureEntry, @ItemStartEntry+69, @MaxCount, @ExtendedCostID);
  147. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  148. VALUES (@CreatureEntry, @ItemStartEntry+70, @MaxCount, @ExtendedCostID);
  149. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  150. VALUES (@CreatureEntry, @ItemStartEntry+71, @MaxCount, @ExtendedCostID);
  151. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  152. VALUES (@CreatureEntry, @ItemStartEntry+72, @MaxCount, @ExtendedCostID);
  153. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  154. VALUES (@CreatureEntry, @ItemStartEntry+73, @MaxCount, @ExtendedCostID);
  155. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  156. VALUES (@CreatureEntry, @ItemStartEntry+74, @MaxCount, @ExtendedCostID);
  157. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  158. VALUES (@CreatureEntry, @ItemStartEntry+75, @MaxCount, @ExtendedCostID);
  159. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  160. VALUES (@CreatureEntry, @ItemStartEntry+76, @MaxCount, @ExtendedCostID);
  161. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  162. VALUES (@CreatureEntry, @ItemStartEntry+77, @MaxCount, @ExtendedCostID);
  163. INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
  164. VALUES (@CreatureEntry, @ItemStartEntry+78, @MaxCount, @ExtendedCostID);
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement