EQEmulator Forums - x2 item stats with mysql??

Quote:

Originally Posted by joligario (Post 182017)

The stats have an 'a' in front of them. Without testing, it will be something like:

Code:

UPDATE items SET astr = astr * 2, asta = asta * 2, aagi = aagi * 2, adex = adex * 2;

Also, most likely mySQL will allow you to use *= if you want. Like: astr *= 2

Be careful when you do that, though. If you go over 127 stats on items, it makes them appear as negative. The weird part is augmentations bypass this limit.

Of course, everything is fine and dandy serverside. I would run the stats * 2 query and then update like so:

Quote:

update items set astr = 127 where astr > 127

Also, you may want to remove the stat caps in source. You can do this in client_mods.cpp. It's this function:

Quote:

sint16 Client::GetMaxStat() const {
int level = GetLevel();

sint16 base = 0;

if (level < 61) {
base = 255;
}
else if (GetClientVersion() == EQClientSoF) {
base = 255 + 5 * (level - 60);
}
else if (level < 71) {
base = 255 + 5 * (level - 60);
}
else {
base = 330;
}

return(base);
}

Base is the variable for stats. If you wanted to increase the statistics cap to say, 2000, all you would need to do is remove the other code in that function and replace that with:

Quote:

sint16 Client::GetMaxStat() const {
return(2000);
}

Happy statting!