PDA

View Full Version : SQL request: Item Stacking to 255, Multiply Item Stats



octium
18-02-10, 01:43 PM
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.

treetree
18-02-10, 05:16 PM
Arcemu Stack Fix

DOWNLOAD NOW! (http://filebeam.com/6facb6d8bb9cbcba71a4313e7b1e0304)

All items will stack now :)

tree :)

octium
20-02-10, 10:42 AM
I'm using Trinity, and I guess I should have mentioned that. Thanks for the quick response regardless. +rep 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.