SQL request: Item Stacking to 255, Multiply Item Stats

[octium]

Looking for some simple sql queries:

• a max stack size of 255 for any item that can stack
• allow me to multiply stats, stamina etc, item damage
• anything else that is friendly to making single player more feasible

I've tried to look for scripts I remembered that I used to use, but I can't find them anymore. Always is a link to a page that no longer exists. Then again the pages always tend to be about 2 years old, so any leads on someone working on making the game more single or two player friendly would be fantastic.

---

› See More: SQL request: Item Stacking to 255, Multiply Item Stats

[treetree]

Arcemu Stack Fix

DOWNLOAD NOW!

All items will stack now

tree

[octium]

I'm using Trinity, and I guess I should have mentioned that. Thanks for the quick response regardless. for ya

Aside from that, I have no experience with SQL yet. Just want to change some simple stats in the item_template table.

I'd like to take 'stat_value1' in 'item_template' for example, and multiply all the values in that column by 5

In terms of the 'stackable', I'd like to take any value between 2 and 250 and change it to 255.