[v2] Adding exact % energy

[illegalife]

I want the query to give exactly 10% of energy but this is not right

$db->query("UPDATE users SET energy=energy+10 WHERE userid=$userid");

$db->query("UPDATE users SET energy=maxenergy WHERE energy > maxenergy");

What do i do so it is the percent not the value?

[AlabamaHit]

Re: [v2] Adding exact % energy

 

$db->query("UPDATE users SET energy=maxenergy/10 WHERE userid=$userid");
$db->query("UPDATE users SET energy=maxenergy WHERE energy > maxenergy");

 

Maybe?

[Guest Anonymous]

Re: [v2] Adding exact % energy

One also has to question the point of using two queries...

Ever heard of LEAST()

[Zero-Affect]

Re: [v2] Adding exact % energy

Very informative Nyna + 1

[POG1]

Re: [v2] Adding exact % energy

$energy = floor($ir[energy] * 10%);

maybe something like that?

[Zero-Affect]

Re: [v2] Adding exact % energy

im sure that would not work

$energy = floor($ir[energy] * $ir[maxenergy]/10);

now that's 10 %

let me make it clear what im saying is 10% in-case someone misunderstands me lol

$ir[maxenergy]/10

^^

[POG1]

Re: [v2] Adding exact % energy

$energy = floor($ir[energy] * 10%);

That would work;

10% is a tenth of a whole so to times it by any number would give a tenth of the number.

[Zero-Affect]

Re: [v2] Adding exact % energy

but i always thought % wouldn't work since you not specifying what your wanting a percentage of, i maybe wrong

[AlabamaHit]

Re: [v2] Adding exact % energy

lol @ Zero..

I said the same thing early in post..

They will not always be exact 10% though...Like Luke said.

[Zero-Affect]

Re: [v2] Adding exact % energy

lmao ok use

floor($ir[maxenergy]/10)

i mean obviously there will be a little left over but close enough...