SHOW:
|
|
- or go back to the newest paste.
| 1 | SET | |
| 2 | @CreatureEntry = 60001, | |
| 3 | @ItemStartEntry = 61000, | |
| 4 | @MaxCount = 0, | |
| 5 | - | @ExtendedCostID = 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); |
