API tools faq
paste
View difference between Paste ID: mSk24Q1n and zpjmRwF7
SHOW: | | - or go back to the newest paste.
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),

8+
VALUES (@CreatureEntry, @ItemStartEntry, @MaxCount, @ExtendedCostID);

9-
VALUES (@CreatureEntry, @ItemStartEntry+1, @MaxCount, @ExtendedCostID),

9+
10-
VALUES (@CreatureEntry, @ItemStartEntry+2, @MaxCount, @ExtendedCostID),

10+
VALUES (@CreatureEntry, @ItemStartEntry+1, @MaxCount, @ExtendedCostID);

11-
VALUES (@CreatureEntry, @ItemStartEntry+3, @MaxCount, @ExtendedCostID),

11+
12-
VALUES (@CreatureEntry, @ItemStartEntry+4, @MaxCount, @ExtendedCostID),

12+
VALUES (@CreatureEntry, @ItemStartEntry+2, @MaxCount, @ExtendedCostID);

13-
VALUES (@CreatureEntry, @ItemStartEntry+5, @MaxCount, @ExtendedCostID),

13+
14-
VALUES (@CreatureEntry, @ItemStartEntry+6, @MaxCount, @ExtendedCostID),

14+
VALUES (@CreatureEntry, @ItemStartEntry+3, @MaxCount, @ExtendedCostID);

15-
VALUES (@CreatureEntry, @ItemStartEntry+7, @MaxCount, @ExtendedCostID),

15+
16-
VALUES (@CreatureEntry, @ItemStartEntry+8, @MaxCount, @ExtendedCostID),

16+
VALUES (@CreatureEntry, @ItemStartEntry+4, @MaxCount, @ExtendedCostID);

17-
VALUES (@CreatureEntry, @ItemStartEntry+9, @MaxCount, @ExtendedCostID),

17+
18-
VALUES (@CreatureEntry, @ItemStartEntry+10, @MaxCount, @ExtendedCostID),

18+
VALUES (@CreatureEntry, @ItemStartEntry+5, @MaxCount, @ExtendedCostID);

19-
VALUES (@CreatureEntry, @ItemStartEntry+11, @MaxCount, @ExtendedCostID),

19+
20-
VALUES (@CreatureEntry, @ItemStartEntry+12, @MaxCount, @ExtendedCostID),

20+
VALUES (@CreatureEntry, @ItemStartEntry+6, @MaxCount, @ExtendedCostID);

21-
VALUES (@CreatureEntry, @ItemStartEntry+13, @MaxCount, @ExtendedCostID),

21+
22-
VALUES (@CreatureEntry, @ItemStartEntry+14, @MaxCount, @ExtendedCostID),

22+
VALUES (@CreatureEntry, @ItemStartEntry+7, @MaxCount, @ExtendedCostID);

23-
VALUES (@CreatureEntry, @ItemStartEntry+15, @MaxCount, @ExtendedCostID),

23+
24-
VALUES (@CreatureEntry, @ItemStartEntry+16, @MaxCount, @ExtendedCostID),

24+
VALUES (@CreatureEntry, @ItemStartEntry+8, @MaxCount, @ExtendedCostID);

25-
VALUES (@CreatureEntry, @ItemStartEntry+17, @MaxCount, @ExtendedCostID),

25+
26-
VALUES (@CreatureEntry, @ItemStartEntry+18, @MaxCount, @ExtendedCostID),

26+
VALUES (@CreatureEntry, @ItemStartEntry+9, @MaxCount, @ExtendedCostID);

27-
VALUES (@CreatureEntry, @ItemStartEntry+19, @MaxCount, @ExtendedCostID),

27+
28-
VALUES (@CreatureEntry, @ItemStartEntry+20, @MaxCount, @ExtendedCostID),

28+
VALUES (@CreatureEntry, @ItemStartEntry+10, @MaxCount, @ExtendedCostID);

29-
VALUES (@CreatureEntry, @ItemStartEntry+21, @MaxCount, @ExtendedCostID),

29+
30-
VALUES (@CreatureEntry, @ItemStartEntry+22, @MaxCount, @ExtendedCostID),

30+
VALUES (@CreatureEntry, @ItemStartEntry+11, @MaxCount, @ExtendedCostID);

31-
VALUES (@CreatureEntry, @ItemStartEntry+23, @MaxCount, @ExtendedCostID),

31+
32-
VALUES (@CreatureEntry, @ItemStartEntry+24, @MaxCount, @ExtendedCostID),

32+
VALUES (@CreatureEntry, @ItemStartEntry+12, @MaxCount, @ExtendedCostID);

33-
VALUES (@CreatureEntry, @ItemStartEntry+25, @MaxCount, @ExtendedCostID),

33+
34-
VALUES (@CreatureEntry, @ItemStartEntry+26, @MaxCount, @ExtendedCostID),

34+
VALUES (@CreatureEntry, @ItemStartEntry+13, @MaxCount, @ExtendedCostID);

35-
VALUES (@CreatureEntry, @ItemStartEntry+27, @MaxCount, @ExtendedCostID),

35+
36-
VALUES (@CreatureEntry, @ItemStartEntry+28, @MaxCount, @ExtendedCostID),

36+
VALUES (@CreatureEntry, @ItemStartEntry+14, @MaxCount, @ExtendedCostID);

37-
VALUES (@CreatureEntry, @ItemStartEntry+29, @MaxCount, @ExtendedCostID),

37+
38-
VALUES (@CreatureEntry, @ItemStartEntry+30, @MaxCount, @ExtendedCostID),

38+
VALUES (@CreatureEntry, @ItemStartEntry+15, @MaxCount, @ExtendedCostID);

39-
VALUES (@CreatureEntry, @ItemStartEntry+31, @MaxCount, @ExtendedCostID),

39+
40-
VALUES (@CreatureEntry, @ItemStartEntry+32, @MaxCount, @ExtendedCostID),

40+
VALUES (@CreatureEntry, @ItemStartEntry+16, @MaxCount, @ExtendedCostID);

41-
VALUES (@CreatureEntry, @ItemStartEntry+33, @MaxCount, @ExtendedCostID),

41+
42-
VALUES (@CreatureEntry, @ItemStartEntry+34, @MaxCount, @ExtendedCostID),

42+
VALUES (@CreatureEntry, @ItemStartEntry+17, @MaxCount, @ExtendedCostID);

43-
VALUES (@CreatureEntry, @ItemStartEntry+35, @MaxCount, @ExtendedCostID),

43+
44-
VALUES (@CreatureEntry, @ItemStartEntry+36, @MaxCount, @ExtendedCostID),

44+
VALUES (@CreatureEntry, @ItemStartEntry+18, @MaxCount, @ExtendedCostID);

45-
VALUES (@CreatureEntry, @ItemStartEntry+37, @MaxCount, @ExtendedCostID),

45+
46-
VALUES (@CreatureEntry, @ItemStartEntry+38, @MaxCount, @ExtendedCostID),

46+
VALUES (@CreatureEntry, @ItemStartEntry+19, @MaxCount, @ExtendedCostID);

47-
VALUES (@CreatureEntry, @ItemStartEntry+39, @MaxCount, @ExtendedCostID),

47+
48-
VALUES (@CreatureEntry, @ItemStartEntry+40, @MaxCount, @ExtendedCostID),

48+
VALUES (@CreatureEntry, @ItemStartEntry+20, @MaxCount, @ExtendedCostID);

49-
VALUES (@CreatureEntry, @ItemStartEntry+41, @MaxCount, @ExtendedCostID),

49+
50-
VALUES (@CreatureEntry, @ItemStartEntry+42, @MaxCount, @ExtendedCostID),

50+
VALUES (@CreatureEntry, @ItemStartEntry+21, @MaxCount, @ExtendedCostID);

51-
VALUES (@CreatureEntry, @ItemStartEntry+43, @MaxCount, @ExtendedCostID),

51+
52-
VALUES (@CreatureEntry, @ItemStartEntry+44, @MaxCount, @ExtendedCostID),

52+
VALUES (@CreatureEntry, @ItemStartEntry+22, @MaxCount, @ExtendedCostID);

53-
VALUES (@CreatureEntry, @ItemStartEntry+45, @MaxCount, @ExtendedCostID),

53+
54-
VALUES (@CreatureEntry, @ItemStartEntry+46, @MaxCount, @ExtendedCostID),

54+
VALUES (@CreatureEntry, @ItemStartEntry+23, @MaxCount, @ExtendedCostID);

55-
VALUES (@CreatureEntry, @ItemStartEntry+47, @MaxCount, @ExtendedCostID),

55+
56-
VALUES (@CreatureEntry, @ItemStartEntry+48, @MaxCount, @ExtendedCostID),

56+
VALUES (@CreatureEntry, @ItemStartEntry+24, @MaxCount, @ExtendedCostID);

57-
VALUES (@CreatureEntry, @ItemStartEntry+49, @MaxCount, @ExtendedCostID),

57+
58-
VALUES (@CreatureEntry, @ItemStartEntry+50, @MaxCount, @ExtendedCostID),

58+
VALUES (@CreatureEntry, @ItemStartEntry+25, @MaxCount, @ExtendedCostID);

59-
VALUES (@CreatureEntry, @ItemStartEntry+51, @MaxCount, @ExtendedCostID),

59+
60-
VALUES (@CreatureEntry, @ItemStartEntry+52, @MaxCount, @ExtendedCostID),

60+
VALUES (@CreatureEntry, @ItemStartEntry+26, @MaxCount, @ExtendedCostID);

61-
VALUES (@CreatureEntry, @ItemStartEntry+53, @MaxCount, @ExtendedCostID),

61+
62-
VALUES (@CreatureEntry, @ItemStartEntry+54, @MaxCount, @ExtendedCostID),

62+
VALUES (@CreatureEntry, @ItemStartEntry+27, @MaxCount, @ExtendedCostID);

63-
VALUES (@CreatureEntry, @ItemStartEntry+55, @MaxCount, @ExtendedCostID),

63+
64-
VALUES (@CreatureEntry, @ItemStartEntry+56, @MaxCount, @ExtendedCostID),

64+
VALUES (@CreatureEntry, @ItemStartEntry+28, @MaxCount, @ExtendedCostID);

65-
VALUES (@CreatureEntry, @ItemStartEntry+57, @MaxCount, @ExtendedCostID),

65+
66-
VALUES (@CreatureEntry, @ItemStartEntry+58, @MaxCount, @ExtendedCostID),

66+
VALUES (@CreatureEntry, @ItemStartEntry+29, @MaxCount, @ExtendedCostID);

67-
VALUES (@CreatureEntry, @ItemStartEntry+59, @MaxCount, @ExtendedCostID),

67+
68-
VALUES (@CreatureEntry, @ItemStartEntry+60, @MaxCount, @ExtendedCostID),

68+
VALUES (@CreatureEntry, @ItemStartEntry+30, @MaxCount, @ExtendedCostID);

69-
VALUES (@CreatureEntry, @ItemStartEntry+61, @MaxCount, @ExtendedCostID),

69+
70-
VALUES (@CreatureEntry, @ItemStartEntry+62, @MaxCount, @ExtendedCostID),

70+
VALUES (@CreatureEntry, @ItemStartEntry+31, @MaxCount, @ExtendedCostID);

71-
VALUES (@CreatureEntry, @ItemStartEntry+63, @MaxCount, @ExtendedCostID),

71+
72-
VALUES (@CreatureEntry, @ItemStartEntry+64, @MaxCount, @ExtendedCostID),

72+
VALUES (@CreatureEntry, @ItemStartEntry+32, @MaxCount, @ExtendedCostID);

73-
VALUES (@CreatureEntry, @ItemStartEntry+65, @MaxCount, @ExtendedCostID),

73+
74-
VALUES (@CreatureEntry, @ItemStartEntry+66, @MaxCount, @ExtendedCostID),

74+
VALUES (@CreatureEntry, @ItemStartEntry+33, @MaxCount, @ExtendedCostID);

75-
VALUES (@CreatureEntry, @ItemStartEntry+67, @MaxCount, @ExtendedCostID),

75+
76-
VALUES (@CreatureEntry, @ItemStartEntry+68, @MaxCount, @ExtendedCostID),

76+
VALUES (@CreatureEntry, @ItemStartEntry+34, @MaxCount, @ExtendedCostID);

77-
VALUES (@CreatureEntry, @ItemStartEntry+69, @MaxCount, @ExtendedCostID),

77+
78-
VALUES (@CreatureEntry, @ItemStartEntry+70, @MaxCount, @ExtendedCostID),

78+
VALUES (@CreatureEntry, @ItemStartEntry+35, @MaxCount, @ExtendedCostID);

79-
VALUES (@CreatureEntry, @ItemStartEntry+71, @MaxCount, @ExtendedCostID),

79+
80-
VALUES (@CreatureEntry, @ItemStartEntry+72, @MaxCount, @ExtendedCostID),

80+
VALUES (@CreatureEntry, @ItemStartEntry+36, @MaxCount, @ExtendedCostID);

81-
VALUES (@CreatureEntry, @ItemStartEntry+73, @MaxCount, @ExtendedCostID),

81+
82-
VALUES (@CreatureEntry, @ItemStartEntry+74, @MaxCount, @ExtendedCostID),

82+
VALUES (@CreatureEntry, @ItemStartEntry+37, @MaxCount, @ExtendedCostID);

83-
VALUES (@CreatureEntry, @ItemStartEntry+75, @MaxCount, @ExtendedCostID),

83+
84-
VALUES (@CreatureEntry, @ItemStartEntry+76, @MaxCount, @ExtendedCostID),

84+
VALUES (@CreatureEntry, @ItemStartEntry+38, @MaxCount, @ExtendedCostID);

85-
VALUES (@CreatureEntry, @ItemStartEntry+77, @MaxCount, @ExtendedCostID),

85+
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);
        

    


            


                                


        

            



                
    

        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!