19 / 29 twink vendor macroes

[Redrik]

Came across these a bunch of conveniantly placed IDs made by skype for macros to make twink vendors for your servers


cloth
/s .npc vendoradditem 5202
/s .npc vendoradditem 1486
/s .npc vendoradditem 6465
/s .npc vendoradditem 6226
/s .npc vendoradditem 14374
/s .npc vendoradditem 3065

/s .npc vendoradditem 3076
/s .npc vendoradditem 5970
/s .npc vendoradditem 3066
/s .npc vendoradditem 19972
/s .npc vendoradditem 12987
/s .npc vendoradditem 4698

/s .npc vendoradditem 14169
/s .npc vendoradditem 4314
/s .npc vendoradditem 2911
/s .npc vendoradditem 3229
/s .npc vendoradditem 4708
/s .npc vendoradditem 3647

/s .npc vendoradditem 25558
/s .npc vendoradditem 13216
/s .npc vendoradditem 10782

Leather
/s .npc vendoradditem 6473
/s .npc vendoradditem 10399
/s .npc vendoradditem 1121
/s .npc vendoradditem 10411
/s .npc vendoradditem 10402
/s .npc vendoradditem 14572

/s .npc vendoradditem 7285
/s .npc vendoradditem 7284
/s .npc vendoradditem 19972
/s .npc vendoradditem 10410
/s .npc vendoradditem 5961
/s .npc vendoradditem 5404

/s .npc vendoradditem 14567
/s .npc vendoradditem 5975
/s .npc vendoradditem 3429
/s .npc vendoradditem 3202
/s .npc vendoradditem 25558

/s .npc vendoradditem 13216
/s .npc vendoradditem 10782

Mail
/s .npc vendoradditem 14730
/s .npc vendoradditem 2989
/s .npc vendoradditem 6731
/s .npc vendoradditem 6459
/s .npc vendoradditem 12982
/s .npc vendoradditem 12994

/s .npc vendoradditem 2992
/s .npc vendoradditem 1448
/s .npc vendoradditem 14747
/s .npc vendoradditem 19972
/s .npc vendoradditem 25558
/s .npc vendoradditem 13216

/s .npc vendoradditem 10782
/s .npc vendoradditem 4816
/s .npc vendoradditem 4800
/s .npc vendoradditem 1445
/s .npc vendoradditem 15496
/s .npc vendoradditem 15505
/s .npc vendoradditem 3480

/s .npc vendoradditem 6460
/s .npc vendoradditem 5425
/s .npc vendoradditem 12978
/s .npc vendoradditem 14743

Wepons

/s .npc vendoradditem 1318
/s .npc vendoradditem 5423
/s .npc vendoradditem 872
/s .npc vendoradditem 5196
/s .npc vendoradditem 5194
/s .npc vendoradditem 5426

/s .npc vendoradditem 20437
/s .npc vendoradditem 20438
/s .npc vendoradditem 6469
/s .npc vendoradditem 1935
/s .npc vendoradditem 2169
/s .npc vendoradditem 14151
/s .npc vendoradditem 2567

/s .npc vendoradditem 3194
/s .npc vendoradditem 5197
/s .npc vendoradditem 1483
/s .npc vendoradditem 12983
/s .npc vendoradditem 5187
/s .npc vendoradditem 2256
/s .npc vendoradditem 7230

/s .npc vendoradditem 6472
/s .npc vendoradditem 20425
/s .npc vendoradditem 5201
/s .npc vendoradditem 20434
/s .npc vendoradditem 2271
/s .npc vendoradditem 3415
/s .npc vendoradditem 890

/s .npc vendoradditem 1484
/s .npc vendoradditem 6633
/s .npc vendoradditem 5191
/s .npc vendoradditem 14145
/s .npc vendoradditem 935
/s .npc vendoradditem 20440
/s .npc vendoradditem 12992

/s .npc vendoradditem 1482
/s .npc vendoradditem 5192
/s .npc vendoradditem 5198
/s .npc vendoradditem 5243
/s .npc vendoradditem 12984


and here is the 29 crap down here


/s .npc vendoradditem 7728
/s .npc vendoradditem 4476
/s .npc vendoradditem 7051
/s .npc vendoradditem 7065
/s .npc vendoradditem 1997
/s .npc vendoradditem 14405
/s .npc vendoradditem 19529

/s .npc vendoradditem 19533
/s .npc vendoradditem 13108
/s .npc vendoradditem 14409
/s .npc vendoradditem 5181
/s .npc vendoradditem 20162
/s .npc vendoradditem 6406
/s .npc vendoradditem 9395

/s .npc vendoradditem 4040
/s .npc vendoradditem 14403
/s .npc vendoradditem 9491
/s .npc vendoradditem 9492
/s .npc vendoradditem 2721
/s .npc vendoradditem 20832
/s .npc vendoradditem 4322

/s .npc vendoradditem 14401
/s .npc vendoradditem 4323
/s .npc vendoradditem 6910
/s .npc vendoradditem 14404
/s .npc vendoradditem 6697
/s .npc vendoradditem 14397
/s .npc vendoradditem 20164

/s .npc vendoradditem 4463
/s .npc vendoradditem 4720
/s .npc vendoradditem 14414
/s .npc vendoradditem 13106
/s .npc vendoradditem 9448
/s .npc vendoradditem 6407
/s .npc vendoradditem 14416

Leather

/s .npc vendoradditem 1489
/s .npc vendoradditem 14581
/s .npc vendoradditem 6396
/s .npc vendoradditem 4255
/s .npc vendoradditem 4455
/s .npc vendoradditem 5782
/s .npc vendoradditem 20157

/s .npc vendoradditem 20188
/s .npc vendoradditem 20169
/s .npc vendoradditem 20201
/s .npc vendoradditem 9450
/s .npc vendoradditem 14579
/s .npc vendoradditem 4055
/s .npc vendoradditem 7756

/s .npc vendoradditem 14583
/s .npc vendoradditem 6408
/s .npc vendoradditem 3020
/s .npc vendoradditem 6688
/s .npc vendoradditem 4048
/s .npc vendoradditem 5753
/s .npc vendoradditem 6204

/s .npc vendoradditem 6690
/s .npc vendoradditem 5963
/s .npc vendoradditem 14585
/s .npc vendoradditem 7373
/s .npc vendoradditem 4050
/s .npc vendoradditem 5962
/s .npc vendoradditem 2278

/s .npc vendoradditem 7727
/s .npc vendoradditem 14587
/s .npc vendoradditem 20152
/s .npc vendoradditem 20191
/s .npc vendoradditem 20172
/s .npc vendoradditem 20197
/s .npc vendoradditem 6911

/s .npc vendoradditem 4257
/s .npc vendoradditem 4258
/s .npc vendoradditem 6409
/s .npc vendoradditem 4456
/s .npc vendoradditem 18948
/s .npc vendoradditem 6410

Mail

/s .npc vendoradditem 1488
/s .npc vendoradditem 7914
/s .npc vendoradditem 4071
/s .npc vendoradditem 14751
/s .npc vendoradditem 9510
/s .npc vendoradditem 20182
/s .npc vendoradditem 20210

/s .npc vendoradditem 4073
/s .npc vendoradditem 4464
/s .npc vendoradditem 9445
/s .npc vendoradditem 4465
/s .npc vendoradditem 3341
/s .npc vendoradditem 4075
/s .npc vendoradditem 13127

/s .npc vendoradditem 5819
/s .npc vendoradditem 6686
/s .npc vendoradditem 6389
/s .npc vendoradditem 3836
/s .npc vendoradditem 14753
/s .npc vendoradditem 13010
/s .npc vendoradditem 3843

/s .npc vendoradditem 3842
/s .npc vendoradditem 10423
/s .npc vendoradditem 14757
/s .npc vendoradditem 13131
/s .npc vendoradditem 7913
/s .npc vendoradditem 3231
/s .npc vendoradditem 4835

/s .npc vendoradditem 6388
/s .npc vendoradditem 4833
/s .npc vendoradditem 3840
/s .npc vendoradditem 14749
/s .npc vendoradditem 4705
/s .npc vendoradditem 3481
/s .npc vendoradditem 14758

/s .npc vendoradditem 20178
/s .npc vendoradditem 20207
/s .npc vendoradditem 9405
/s .npc vendoradditem 14761
/s .npc vendoradditem 6200
/s .npc vendoradditem 4712
/s .npc vendoradditem 4707

/s .npc vendoradditem 4717
/s .npc vendoradditem 14755
/s .npc vendoradditem 3228
/s .npc vendoradditem 4438
/s .npc vendoradditem 13012
/s .npc vendoradditem 14759
/s .npc vendoradditem 6387

/s .npc vendoradditem 3212
/s .npc vendoradditem 6403
/s .npc vendoradditem 2868
/s .npc vendoradditem 5943
/s .npc vendoradditem 14750

Wepons

/s .npc vendoradditem 7753
/s .npc vendoradditem 2299
/s .npc vendoradditem 6687
/s .npc vendoradditem 9459
/s .npc vendoradditem 12249
/s .npc vendoradditem 12250
/s .npc vendoradditem 13019

/s .npc vendoradditem 6696
/s .npc vendoradditem 19561
/s .npc vendoradditem 15285
/s .npc vendoradditem 4474
/s .npc vendoradditem 11306
/s .npc vendoradditem 3037
/s .npc vendoradditem 13037

/s .npc vendoradditem 2912
/s .npc vendoradditem 19545
/s .npc vendoradditem 6681
/s .npc vendoradditem 7682
/s .npc vendoradditem 9453
/s .npc vendoradditem 776
/s .npc vendoradditem 12247

/s .npc vendoradditem 12248
/s .npc vendoradditem 20954
/s .npc vendoradditem 7729
/s .npc vendoradditem 13137
/s .npc vendoradditem 7730
/s .npc vendoradditem 2816
/s .npc vendoradditem 7752

/s .npc vendoradditem 13048
/s .npc vendoradditem 9449
/s .npc vendoradditem 3852
/s .npc vendoradditem 1991
/s .npc vendoradditem 3851
/s .npc vendoradditem 19569
/s .npc vendoradditem 9452

/s .npc vendoradditem 19573
/s .npc vendoradditem 6689
/s .npc vendoradditem 1998
/s .npc vendoradditem 2877
/s .npc vendoradditem 13049
/s .npc vendoradditem 9446
/s .npc vendoradditem 19553

/s .npc vendoradditem 6909
/s .npc vendoradditem 12974
/s .npc vendoradditem 8226
/s .npc vendoradditem 13033
/s .npc vendoradditem 3849
/s .npc vendoradditem 29201
/s .npc vendoradditem 13063

/s .npc vendoradditem 5214
/s .npc vendoradditem 5245
/s .npc vendoradditem 9489
/s .npc vendoradditem 11289


enjoy all :D

[Xalor]

Nice Rep+ May I Suggest To Put It In A SQL File?

[enegue]

Same here. Putting it in a SQL file would be so much easier than copying and pasting the whole thing bit by bit. Would be good if you can tell us what items are for which item IDs.

[Lbniese]

Same here. Putting it in a SQL file would be so much easier than copying and pasting the whole thing bit by bit. Would be good if you can tell us what items are for which item IDs.
thats right :D

[Virus]

nice +rep

[Dimman]

Let me help :D




INSERT INTO vendors(entry, item, amount, extendedcost) VALUES ('CREATURE ID', 'ITEMID', 'AMOUNT', 'EXTENDEDCOST');

If you are going to have it free or gold price just leave the extendedcost to "0"

And if you are going to change the goldcost..



GG = gold SS = Silver CC = cooper

So if you want the cost to be 10 gold, 50 silver and 28 Cooper

SET buyprice=105028



Or 133 G 59 S and 11 C

SET buyprice=1335911





UPDATE items SET buyprice=GGSSCC WHERE entry IN (ITEMID, ITEMID, ITEMID, ITEMID, ITEMID, ITEMID, ITEMID, ITEMID, ITEMID, ITEMID);

[enegue]

3 cheers :D

[mag1212]

i would recommend doing it in ur DB instead of this since it can bug the sell template

[Dimman]

i would recommend doing it in ur DB instead of this since it can bug the sell template
What do you mean ?:confused: