[release] wotlk item stack fix

[knaur]

ok, i have irritated so long that almost all stackable items
in wotlk didnt stack at all, like reagents, cloth, or heroism marks...

I first thought it was the items theyrself that was ****ed,

then i got the idea that maybe the vendors was wrong,
and i was right. If Amount field is 0 or -1 then it will never stack

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

Run this into your world database and ALL stackable items
will work again :P

[knaur]

also if some items still dont stack,
change your lock_material field to "8" instead of 0 or -1
at your items field. but only 2 - 3 wotlk items
i found had that problem

[Ground Zero]

Very Epic Knaur, Thanks +Rep x2 If i can.
This bug has been annoying me for ages.

[Flake0207]

didnt work for me executed successfully and everything
items still have item stack bug

[Aelus]

Nice man, fixed it. +Rep

[knaur]

didnt work for me executed successfully and everything
items still have item stack bug

and ofcourse im sure you remembered to deleted your wowcache
after install it, correct?

anyway, i know it works, since it worked on both our realms,

and as you see, works for other ppl too

[y2kss66]

nice fix knaur! +RepX2

[Flake0207]

ok i have a gem vendor maby im getting somthign to fix somthigne else

i buy a gem
goes into bags i buy another one it just goes on top of the one o i just bought but doesnt stack with numbers or anything it styays blank

[knaur]

the fix repaired all my gems. it doesnt stack cause vendor table
has 0 or -1 on amount on those items.

Try open vendors table in mysql and sort it after amount field.
then you see if you still have any fields with 0 or -1. if you have,
chance then to 1.

[Mango Jerry]

Thanks alot, m8.
Epic.. Epic!

[massanaconda]

Hmm, i fixed this bug by putting at the requiredclass in the items table : 32767...and then it works , but thx for this

[simonsamiiee]

Nice job man

[keazain]

always the best as usefull +Rep x2 m8

[neomagneto]

Thanks for this +Rep

[tashiro]

Well congrats man. I had this fix ready for posting weeks ago but due to all the moderation I didn't want to risk a ban [I've posted on it before]. You took a chance and banked on it, great release =].