Cronwerks MCCode/MCCodes Forums

Please login or register.

Login with username, password and session length

News:

Have you purchased a mod and are struggling to install it? Cronwerks now installs mods for only $3/$2.50. Message Cronus to discuss the details or purchase.


This forum is now closed and has moved to a new location! Click here to find out why.

AuthorTopic: Reduce stats by a pecenatge  (Read 559 times)

kingdkknox

  • Basic Member
  • *
  • Reputation Power: 30
  • kingdkknox has no influence.
  • Offline Offline
  • Posts: 25
    • View Profile
    • WWW
Reduce stats by a pecenatge
« on: June 10, 2010, 07:44:12 AM »
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!
Logged
If you are for hire or if you want to find some work it can be found here.
Freelance work at home jobs

Danny696

  • Senior Member
  • ****
  • Reputation Power: 317
  • Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.
  • Offline Offline
  • Posts: 540
    • View Profile
    • WWW
Re: Reduce stats by a pecenatge
« Reply #1 on: June 10, 2010, 08:37:59 AM »
UPDATE `userstats` SET `strength`=((`strength`/100)*PERCENTTOLEAVEHERE);

Thats th SQL, replace `strength` for agility, guard and labour, and mabey IQ
Logged
Project Choosen - 10%
Daniel - Hanson . Com

kingdkknox

  • Basic Member
  • *
  • Reputation Power: 30
  • kingdkknox has no influence.
  • Offline Offline
  • Posts: 25
    • View Profile
    • WWW
Re: Reduce stats by a pecenatge
« Reply #2 on: June 10, 2010, 11:55:15 AM »
Thanks dannny bout to try it now!!!
Logged
If you are for hire or if you want to find some work it can be found here.
Freelance work at home jobs

kingdkknox

  • Basic Member
  • *
  • Reputation Power: 30
  • kingdkknox has no influence.
  • Offline Offline
  • Posts: 25
    • View Profile
    • WWW
Re: Reduce stats by a pecenatge
« Reply #3 on: June 10, 2010, 12:53:23 PM »
Anyone got any suggestions on how to slow down the stats?
Logged
If you are for hire or if you want to find some work it can be found here.
Freelance work at home jobs

derek412

  • Mod Seller
  • Basic Member
  • *****
  • Reputation Power: 51
  • derek412 has no influence.
  • Offline Offline
  • Posts: 13
    • View Profile
    • Email
Re: Reduce stats by a pecenatge
« Reply #4 on: June 10, 2010, 01:26:58 PM »
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.
Logged

kingdkknox

  • Basic Member
  • *
  • Reputation Power: 30
  • kingdkknox has no influence.
  • Offline Offline
  • Posts: 25
    • View Profile
    • WWW
Re: Reduce stats by a pecenatge
« Reply #5 on: June 10, 2010, 04:58:05 PM »
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...
« Last Edit: June 11, 2010, 03:30:24 AM by kingdkknox »
Logged
If you are for hire or if you want to find some work it can be found here.
Freelance work at home jobs

Danny696

  • Senior Member
  • ****
  • Reputation Power: 317
  • Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.Danny696 is a force to reckon with.
  • Offline Offline
  • Posts: 540
    • View Profile
    • WWW
Re: Reduce stats by a pecenatge
« Reply #6 on: June 11, 2010, 08:42:14 AM »
UPDATE `userstats` SET `strength`=((`strength`/100)*10) WHERE (`strength` > 10);
Logged
Project Choosen - 10%
Daniel - Hanson . Com

kingdkknox

  • Basic Member
  • *
  • Reputation Power: 30
  • kingdkknox has no influence.
  • Offline Offline
  • Posts: 25
    • View Profile
    • WWW
Re: Reduce stats by a pecenatge
« Reply #7 on: June 11, 2010, 04:58:10 PM »
Thanks Danny!
Logged
If you are for hire or if you want to find some work it can be found here.
Freelance work at home jobs
 


This forum is now closed and has moved to a new location! Click here to find out why.