Print

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

[Dusty]

mysql_query("UPDATE users SET will=will+30 WHERE will<maxwill AND userid = $userid");

this is what I have..       This is what I want it to do ...    Where it says it will add +30 to the will and stop at the max will ..  well 30 works fine as long at the maxwill is a low number..   the higher it is the lower the % is  when it fills up ..       

I've tryed added a % with that 30 but it dont work ..  SOOOOO   if i want that 30 to fill will for 5% or 10% for all maxwill how do I make that number into a working % number.

[Danny696]

Im not sure what you mean?

[Dusty]

mysql_query("UPDATE users SET will=will+30 WHERE will<maxwill AND userid = $userid");

That code if for an item called a will pill  some thing that they will find in the game playing the streets or what ever.   This item give you will BUT not 100% will..    you see where it says set will=will+30  well I need that to say SET will=will+5% or 10% and work ..   If put in 5% but it dont work at all it works with +30 in there but it dont give 5% or 10% like I would like for it to do .    I need to know what I need to do to make that + number 5 or 10%

[Cronus]

Code: [Select]

$percent=.05;
mysql_query("UPDATE users SET will=will+(maxwill*$percent) WHERE will<maxwill AND userid = $userid");
This would make it 5 percent, change the .05 to .1 for 10 percent, etc.

[Dusty]

Thanks Cronus  Ill post on how the out come turns out.. as soon as I add that to it   Thanks again

[Dusty]

Worked Great..  Thanks Again.