[Lawyer]

I thought it was a DB issue, but I think its something to do with the core? I'm using NCDB Rev 101.




Thanks in advance.

[Hopla]

If you look at the BuyOpcode you'll see:

	if( it->MaxCount > 0 && amount*item.amount > it->MaxCount )
	{
		_player->GetItemInterface()->BuildInventoryChangeError(0, 0, INV_ERR_ITEM_CANT_STACK);
		return;
	}

It means that the core requires items to have a maxcount bigger than 0.
So you can create a query for it to put max count to something like 5000, lol.

[Lawyer]

Could you help with a query to do that with ALL bags in my DB? I have no idea how to do all of them all in one go? ..

Thanks in advance.

[Hopla]

Lawyer, on Jun 1 2009, 01:52 PM, said:

Could you help with a query to do that with ALL bags in my DB? I have no idea how to do all of them all in one go? ..

Thanks in advance.

Oh wait, MaxCount is stack count, I was mixing it with unique count of item.
Basicly run something like this:

UPDATE items SET maxcount = '1' WHERE maxcount = '0';

Should do the trick.

[Lawyer]

(0 row(s) affected)
Execution Time : 00:00:00:390
Transfer Time  : 00:00:00:000
Total Time	 : 00:00:00:390

Hmm that didnt work, DB is fine, So its the core ?

[TOXRMC]

Run this sql:

update vendors set amount = 1 where amount = -1;
update vendors set amount = 1 where amount = 0;

[Lawyer]

Yes! That works great, Thanks TOXRMC.