PHP question on while query

Question

Could someone help me figure out how to do this.

I have a game where a player can use potions to enhance their abilities.

This is on a timer which works fine. However Im now looking to add to this query when the player uses 2 different type of potions. I can get it to work but not 100% how I wish.

Player uses potion 1 and their stats are boosted by 20% for 20minutes. Player then uses potion 2 and their stats are boosted by 60% for 20minutes.

With my code at the moment

$check = sprintf("SELECT time,strmod FROM `effects` WHERE `userid` = %u", $userid);

$exe = mysql_query($check);

while($bonus = mysql_fetch_array($exe))
{

$last = $bonus['time'];

$strmod=$bonus['strmod']);

It will display the users bonus (base strength in this example is 2,364,195)

Potion 1 boost your base strength to 2837034 (+20%) Potion 2 boost your base strength to 3782712 (+60%)

Is there a solution where I can get the second 60% potion to take into account the bonus received from the 1st potion. So 60% of 2837034 rather than 2364195. Before I consider recoding the whole thing :D

I hope thats clear bit hard to explain.

Thanks

SorcyCat · Accepted Answer · 2010-01-11 21:02:07Z

1

I presume the database table contains the list of potions in effect. Try something which keeps the value over the while loop...

$multiplier = 1;
while($bonus = mysql_fetch_array($exe))
{
    $last = $bonus['time'];
    $strmod=$bonus['strmod']);
    $multiplier += $strmod/100; // convert from percent to decimal
}

$currStrength = $multiplier*$baseStrength;

edited Jan 11, 2010 at 21:02

answered Jan 11, 2010 at 20:56

SorcyCat

1,21610 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mr-sk · Accepted Answer · 2010-01-11 20:49:21Z

0

Probably not the way your doing it, since your not recording the original players HP, you just have the current (after modifiers have been applied) HP.

answered Jan 11, 2010 at 20:49

mr-sk

13.5k13 gold badges70 silver badges103 bronze badges

Collectives™ on Stack Overflow

PHP question on while query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related