Medical items

[ignite]

I've made some medical items witch reduce certain amounts of time when a user is in hospital. The problem is if a user is in hospital for 19 minuets and uses a small medi kit witch takes of 20 minuets. It will put the user in hospital for -1 minuets.

Heres the code i used.

if($r['itmname'] == 'Medi kit')

{

mysql_query("UPDATE users SET hospital=hospital-1 WHERE userid=$userid",$c);

}

print "You spray a {$r['itmname']} into your mouth. You feel a bit of health coming back to you.";

[vinyl]

Re: Medical items

add

mysql_query("UPDATE users SET hospital=0 where hospital<0");

[ignite]

Re: Medical items

thanks thats worked a treat.