EQEmulator Forums - Question; SQL help: Increase stats on all armor, server-wide

Here's what I used a couple years back for a local server, please note it is old and some things have changed in the schema since then.

Code:

update items set hp=hp*5 where hp>0 and hp<2000;

update items set mana=mana*5 where mana>0;

update items set endur=endur*5 where endur>0;

update items set ac=ac*5 where ac>0;

update items set mr=mr*1.5 where mr>0 and mr<200;

update items set pr=pr*1.5 where pr>0 and pr<200;

update items set cr=cr*1.5 where cr>0 and cr<200;

update items set fr=fr*1.5 where fr>0 and fr<200;

update items set dr=dr*1.5 where dr>0 and dr<200;

update items set astr=astr*1.3 where astr>0;

update items set aagi=aagi*1.3 where aagi>0;

update items set adex=adex*1.3 where adex>0;

update items set asta=asta*1.3 where asta>0;

update items set aint=aint*1.3 where aint>0;

update items set awis=awis*1.3 where awis>0;

update items set acha=acha*1.3 where acha>0;

update items set damage=damage*1.5 where damage>0;

update items set regen=regen*2 where regen>0;

update items set manaregen=manaregen*6 where manaregen>0;

update items set enduranceregen=enduranceregen*6 where enduranceregen>0;

update items set damageshield=damageshield*5 where damageshield>0;

update items set dotshielding=dotshielding*5 where dotshielding>0;

update items set shielding=shielding*5 where shielding>0;

update items set spellshield=spellshield*5 where spellshield>0;

update items set strikethrough=strikethrough*5 where strikethrough>0;

update items set stunresist=stunresist*5 where stunresist>0;

update items set healamt=healamt*5 where healamt>0;

Just replace the *1.3's and the like with the value of your choosing and watch out for negative results if the x5 boosts them too high - resists were especially susceptible to it.