Problem with Vendors

[souljahx]

Alright so earlier I was making vendors for my server everything was going fine untill I realised you can't buy more than one item of the same type. Basically, if you try and buy 5 Cimson Spinels for example, the chat log will show that you bought 5 but only one will show up in your inventory.


I've tried changing the ammounts you can buy, reloading my tables, restarting the server and recreating the vendors...nothing works.

These are what my vendor tables look like

694206	32410	0	0	0	0

My creature_proto

694206	75	75	1741	100000	100000	100000	1	128	1800	0	150	250	1800	500	650	0	0	0	0	0	0	0	0	0	0	36000	0	0	0	0	0	0	0	1	0	MEMO	0	0	0	0	2.5	8	14	0	0	0	0	0	0

And my creature_names

694206	Meta Gems			0	7	0	0	0		18551	18551	0	0	1	1	1

I really can't think of anything else to do. Any help is appreciated.

[Kiyoshi]

Try using this if you haven't already:

http://www.mmowned.com/forums/progra...0-06-08-a.html

[soul02]

694206	32410	0	0	0	0

run this

replace `vendors` values('694206', '32410', '1', '1', '0');

[God-Of-War]

try draging the items to you bag that should work!

[souljahx]

@Cloud - although that program is full of win, sadly it didn't work.

@soul02 - got this error ERROR 1136 : Column count doesn't match value count at row 1

@God-Of-War - Works but it's kind fo a pain when i wanna buy over 20 of an item

[soul02]

694206 32410 0 0 0 0

then go in vendor table and change
694206 32410 1 1 0 0

[souljahx]

Tried it, tried changing around the numbers doesn't work

[soul02]

what ur server addy?

[kebabkungen]

try download a new DB and then try it

becouse somethimes the Dbs f**k up

[souljahx]

My server isn't public yet lol. Gonna try downloading a new DB now I'll let you know how it goes

[soul02]

it easy fix man.. let me access to ur db and i fix it for u dont worry i wont fuk u up.. but since u getting new db then its cool...

[souljahx]

My server is on lan and I cbf'd setting it to public. Anyway, I installed a new DB added items in vendors table, made my NPC with ADE then tried, still shows in chat that you buy multiple items but it only shows one.

Strangly enough if I try to buy multiple of the same item through .npc vendoradditem it'll do it yet it doesn't want to do it when I add the items through the database. I guess I'll just add them through .vendor additem =.=