Vendor BuG

[Royalaty]

Hy dear mmowners!

I have a bug with my vendors!

If i buy something after that i returnto fierst page...so i need go back to buy any item then back to fierst......whats wrong?

Any idea how to fiX it? :wave:

OFC +Rep

[Vision1000]

Your using Arcemu?

Happens on my server too, not anything gamebreaking though. You could fix it yourself or you can just wait until arcemu fixes it. To fix it yourself you'd need to know C++

[Royalaty]

Nop.. i remember one mmowner give me a sql code where fix that buG!

[stoneharry]

Put amount as 1, max amount as -1 and inctime as 0. Should work now after reloading vendors and respawning the npc, or restart the server.

[Royalaty]

Put amount as 1, max amount as -1 and inctime as 0. Should work now after reloading vendors and respawning the npc, or restart the server.

stoneharry - can u give me please a correct sql code for that?

Tnx a lot :wave:

[stoneharry]

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`, `extended_cost`) values('npc id','item id','1','-1','0','0');

Change bits in red and then execute, in code box:

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`, `extended_cost`) values('npc id','item id','1','-1','0','0');

[Royalaty]

Hmmm 1 row affected 2 warnings...Damnnn something wrong in this code man...

[Royalaty]

Ouu damn u think i need manually put all bugeg vendors ID and they items ID?

[stoneharry]

npc id','item id

Did you change these in the code?
If so what is the error?
Duplicate entry = Already in there, change from insert into to replace into.
Incorect syntax means your not using ArcEmu.
Good luck!

[Royalaty]

I Have latest Arcemu Core....be shure!

Whai i need change there npc id and item id? what i need put there? Vendor ID and item ID?

Mybe someone know where is the problem and can give to me a corect sql code who fiX all vendors if they be buged.. ! I remember - that code are! They look like this but they work perfect for me!

[Reflection]

Stoneharry, that query would just fix the vendors he adds after. He can use this syntax instead: (might get syntax errors because I can't remember it from the top of my head.)

UPDATE `vendors` SET `amount` ='1';
UPDATE `vendors` SET `max_amount` ='-1';
UPDATE `vendors` SET `inctime` ='0';

[stoneharry]

Aye that would work, I thought he ment to insert new items.

[Royalaty]

Ohh guy's sorry for my english i am from Baltic states......


Tnx to all who help and enjoY!

Get +rep from me!

[Baxterzz]

is it the right one for the revision

[Royalaty]

Hmm not work for me on NCDB 100 Rev 2713