Advertisement
tok124

SQL Vendor

Aug 6th, 2014
218
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. VALUES (@CreatureEntry, @ItemStartEntry+1, @MaxCount, @ExtendedCostID),
  10. VALUES (@CreatureEntry, @ItemStartEntry+2, @MaxCount, @ExtendedCostID),
  11. VALUES (@CreatureEntry, @ItemStartEntry+3, @MaxCount, @ExtendedCostID),
  12. VALUES (@CreatureEntry, @ItemStartEntry+4, @MaxCount, @ExtendedCostID),
  13. VALUES (@CreatureEntry, @ItemStartEntry+5, @MaxCount, @ExtendedCostID),
  14. VALUES (@CreatureEntry, @ItemStartEntry+6, @MaxCount, @ExtendedCostID),
  15. VALUES (@CreatureEntry, @ItemStartEntry+7, @MaxCount, @ExtendedCostID),
  16. VALUES (@CreatureEntry, @ItemStartEntry+8, @MaxCount, @ExtendedCostID),
  17. VALUES (@CreatureEntry, @ItemStartEntry+9, @MaxCount, @ExtendedCostID),
  18. VALUES (@CreatureEntry, @ItemStartEntry+10, @MaxCount, @ExtendedCostID),
  19. VALUES (@CreatureEntry, @ItemStartEntry+11, @MaxCount, @ExtendedCostID),
  20. VALUES (@CreatureEntry, @ItemStartEntry+12, @MaxCount, @ExtendedCostID),
  21. VALUES (@CreatureEntry, @ItemStartEntry+13, @MaxCount, @ExtendedCostID),
  22. VALUES (@CreatureEntry, @ItemStartEntry+14, @MaxCount, @ExtendedCostID),
  23. VALUES (@CreatureEntry, @ItemStartEntry+15, @MaxCount, @ExtendedCostID),
  24. VALUES (@CreatureEntry, @ItemStartEntry+16, @MaxCount, @ExtendedCostID),
  25. VALUES (@CreatureEntry, @ItemStartEntry+17, @MaxCount, @ExtendedCostID),
  26. VALUES (@CreatureEntry, @ItemStartEntry+18, @MaxCount, @ExtendedCostID),
  27. VALUES (@CreatureEntry, @ItemStartEntry+19, @MaxCount, @ExtendedCostID),
  28. VALUES (@CreatureEntry, @ItemStartEntry+20, @MaxCount, @ExtendedCostID),
  29. VALUES (@CreatureEntry, @ItemStartEntry+21, @MaxCount, @ExtendedCostID),
  30. VALUES (@CreatureEntry, @ItemStartEntry+22, @MaxCount, @ExtendedCostID),
  31. VALUES (@CreatureEntry, @ItemStartEntry+23, @MaxCount, @ExtendedCostID),
  32. VALUES (@CreatureEntry, @ItemStartEntry+24, @MaxCount, @ExtendedCostID),
  33. VALUES (@CreatureEntry, @ItemStartEntry+25, @MaxCount, @ExtendedCostID),
  34. VALUES (@CreatureEntry, @ItemStartEntry+26, @MaxCount, @ExtendedCostID),
  35. VALUES (@CreatureEntry, @ItemStartEntry+27, @MaxCount, @ExtendedCostID),
  36. VALUES (@CreatureEntry, @ItemStartEntry+28, @MaxCount, @ExtendedCostID),
  37. VALUES (@CreatureEntry, @ItemStartEntry+29, @MaxCount, @ExtendedCostID),
  38. VALUES (@CreatureEntry, @ItemStartEntry+30, @MaxCount, @ExtendedCostID),
  39. VALUES (@CreatureEntry, @ItemStartEntry+31, @MaxCount, @ExtendedCostID),
  40. VALUES (@CreatureEntry, @ItemStartEntry+32, @MaxCount, @ExtendedCostID),
  41. VALUES (@CreatureEntry, @ItemStartEntry+33, @MaxCount, @ExtendedCostID),
  42. VALUES (@CreatureEntry, @ItemStartEntry+34, @MaxCount, @ExtendedCostID),
  43. VALUES (@CreatureEntry, @ItemStartEntry+35, @MaxCount, @ExtendedCostID),
  44. VALUES (@CreatureEntry, @ItemStartEntry+36, @MaxCount, @ExtendedCostID),
  45. VALUES (@CreatureEntry, @ItemStartEntry+37, @MaxCount, @ExtendedCostID),
  46. VALUES (@CreatureEntry, @ItemStartEntry+38, @MaxCount, @ExtendedCostID),
  47. VALUES (@CreatureEntry, @ItemStartEntry+39, @MaxCount, @ExtendedCostID),
  48. VALUES (@CreatureEntry, @ItemStartEntry+40, @MaxCount, @ExtendedCostID),
  49. VALUES (@CreatureEntry, @ItemStartEntry+41, @MaxCount, @ExtendedCostID),
  50. VALUES (@CreatureEntry, @ItemStartEntry+42, @MaxCount, @ExtendedCostID),
  51. VALUES (@CreatureEntry, @ItemStartEntry+43, @MaxCount, @ExtendedCostID),
  52. VALUES (@CreatureEntry, @ItemStartEntry+44, @MaxCount, @ExtendedCostID),
  53. VALUES (@CreatureEntry, @ItemStartEntry+45, @MaxCount, @ExtendedCostID),
  54. VALUES (@CreatureEntry, @ItemStartEntry+46, @MaxCount, @ExtendedCostID),
  55. VALUES (@CreatureEntry, @ItemStartEntry+47, @MaxCount, @ExtendedCostID),
  56. VALUES (@CreatureEntry, @ItemStartEntry+48, @MaxCount, @ExtendedCostID),
  57. VALUES (@CreatureEntry, @ItemStartEntry+49, @MaxCount, @ExtendedCostID),
  58. VALUES (@CreatureEntry, @ItemStartEntry+50, @MaxCount, @ExtendedCostID),
  59. VALUES (@CreatureEntry, @ItemStartEntry+51, @MaxCount, @ExtendedCostID),
  60. VALUES (@CreatureEntry, @ItemStartEntry+52, @MaxCount, @ExtendedCostID),
  61. VALUES (@CreatureEntry, @ItemStartEntry+53, @MaxCount, @ExtendedCostID),
  62. VALUES (@CreatureEntry, @ItemStartEntry+54, @MaxCount, @ExtendedCostID),
  63. VALUES (@CreatureEntry, @ItemStartEntry+55, @MaxCount, @ExtendedCostID),
  64. VALUES (@CreatureEntry, @ItemStartEntry+56, @MaxCount, @ExtendedCostID),
  65. VALUES (@CreatureEntry, @ItemStartEntry+57, @MaxCount, @ExtendedCostID),
  66. VALUES (@CreatureEntry, @ItemStartEntry+58, @MaxCount, @ExtendedCostID),
  67. VALUES (@CreatureEntry, @ItemStartEntry+59, @MaxCount, @ExtendedCostID),
  68. VALUES (@CreatureEntry, @ItemStartEntry+60, @MaxCount, @ExtendedCostID),
  69. VALUES (@CreatureEntry, @ItemStartEntry+61, @MaxCount, @ExtendedCostID),
  70. VALUES (@CreatureEntry, @ItemStartEntry+62, @MaxCount, @ExtendedCostID),
  71. VALUES (@CreatureEntry, @ItemStartEntry+63, @MaxCount, @ExtendedCostID),
  72. VALUES (@CreatureEntry, @ItemStartEntry+64, @MaxCount, @ExtendedCostID),
  73. VALUES (@CreatureEntry, @ItemStartEntry+65, @MaxCount, @ExtendedCostID),
  74. VALUES (@CreatureEntry, @ItemStartEntry+66, @MaxCount, @ExtendedCostID),
  75. VALUES (@CreatureEntry, @ItemStartEntry+67, @MaxCount, @ExtendedCostID),
  76. VALUES (@CreatureEntry, @ItemStartEntry+68, @MaxCount, @ExtendedCostID),
  77. VALUES (@CreatureEntry, @ItemStartEntry+69, @MaxCount, @ExtendedCostID),
  78. VALUES (@CreatureEntry, @ItemStartEntry+70, @MaxCount, @ExtendedCostID),
  79. VALUES (@CreatureEntry, @ItemStartEntry+71, @MaxCount, @ExtendedCostID),
  80. VALUES (@CreatureEntry, @ItemStartEntry+72, @MaxCount, @ExtendedCostID),
  81. VALUES (@CreatureEntry, @ItemStartEntry+73, @MaxCount, @ExtendedCostID),
  82. VALUES (@CreatureEntry, @ItemStartEntry+74, @MaxCount, @ExtendedCostID),
  83. VALUES (@CreatureEntry, @ItemStartEntry+75, @MaxCount, @ExtendedCostID),
  84. VALUES (@CreatureEntry, @ItemStartEntry+76, @MaxCount, @ExtendedCostID),
  85. VALUES (@CreatureEntry, @ItemStartEntry+77, @MaxCount, @ExtendedCostID),
  86. VALUES (@CreatureEntry, @ItemStartEntry+78, @MaxCount, @ExtendedCostID);
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement