View Single Post
  #2  
Old 06-28-2017, 01:05 PM
Burningsoul
Discordant
 
Join Date: Oct 2009
Posts: 312
Default

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.
Reply With Quote