Merchant Temp Lists not working

[Angelox]

I thought the same for a while - the temp lists work fine, problem is, they are over loaded with crap. they need to get pruned out of all the garbage there.
I did already with my AX_CLASSIC DB, and it works great now. You can DL my DB and make the test, see if i'm right.

[Angelox]

What I mean by 'crap' is all the items that got caught up in the packets that were applied to the merchant lists, that really were not supposed to be there

[cavedude]

KLS and I were talking about this one day. You're 100% correct merchants all over are overloaded with crap. However, we've seen this same problem on merchants with little or no items. That leads us to believe that there is a (probably minor) code issue that is contributing to this. But I tend to agree, the quick and dirty solution is to clean off merchants, they need it anyway.

[Angelox]

Originally Posted by cavedude

KLS and I were talking about this one day. You're 100% correct merchants all over are overloaded with crap. However, we've seen this same problem on merchants with little or no items. That leads us to believe that there is a (probably minor) code issue that is contributing to this. But I tend to agree, the quick and dirty solution is to clean off merchants, they need it anyway.

I sent you an Email I'll do that for you if you want - can't offer you mine because I got custom stuff on vendors, yours probably changed anyways , But I will clean up yours.
I think the 'full' merchants interfere with the empty ones, maybe too big a cache of items or something. once I cleared mine, it seemed everything was OK and vendors I sold to, would retain items (but that's just me, one player on an empty test- server)

[Irreverent]

Ok, so you're saying that the vendor master list of items is too large? I can't even get a vendor selling only 5 things to retain any temp items. It looks like he did while still in the same vendor screen...but if I close it and click on him right away...they're gone.

[Angelox]

Originally Posted by Irreverent

Ok, so you're saying that the vendor master list of items is too large? I can't even get a vendor selling only 5 things to retain any temp items. It looks like he did while still in the same vendor screen...but if I close it and click on him right away...they're gone.

I think the whole table needs to be cleaned out first - I had this problem and it went away when I cleaned out all the extra trash on all the merchants
I can sell stuff to merchants, then come back the next day, they still be there (unless I restart server)

[Congdar]

Originally Posted by Angelox

I think the whole table needs to be cleaned out first - I had this problem and it went away when I cleaned out all the extra trash on all the merchants
I can sell stuff to merchants, then come back the next day, they still be there (unless I restart server)

Cleaned out is... what? do you have a sql string? That would be awesome.