Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[kingdkknox]

I need something that will reduce all my users stats by a percentage so that everyone is still in order but just been lowered. RIght now I got users at 10 mill stats. ANy sugestion on how to slow this down would be good also!

[Danny696]

UPDATE `userstats` SET `strength`=((`strength`/100)*PERCENTTOLEAVEHERE);

Thats th SQL, replace `strength` for agility, guard and labour, and mabey IQ

[kingdkknox]

Thanks dannny bout to try it now!!!

[kingdkknox]

Anyone got any suggestions on how to slow down the stats?

[derek412]

It depends on the Gym you're using, and what other things in the game gives users stats. It's a fairly complex overall percentage, and I always err on the side of less stats; tends to eliminate problems down the road like you're having.

[kingdkknox]

I need to exclude users that have 10 or less in a stat... how do I do that I tried

Code: [Select]

UPDATE `userstats` SET `strength`=((`strength`/100)*10) >10; but it didn't work mess the stats up everything went to 0. @derek412  Well as far as I know only thing that is giving my users stats is gym and school...

[Danny696]

UPDATE `userstats` SET `strength`=((`strength`/100)*10) WHERE (`strength` > 10);

[kingdkknox]

Thanks Danny!