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