Re: Medical - Reduce Hospital Time
well in mine i have:
}
else if($r['itmtypename'] == 'Medical')
{
$f=mysql_query("SELECT * FROM medical WHERE item_id={$r['itmid']}",$c);
$fr=mysql_fetch_array($f);
mysql_query("UPDATE inventory SET inv_qty=inv_qty-1 WHERE inv_id={$_GET['ID']}",$c);
mysql_query("DELETE FROM inventory WHERE inv_qty=0",$c);
mysql_query("UPDATE users SET hp=hp+{$fr['health']} WHERE userid=$userid");
mysql_query("UPDATE users SET hp=maxhp WHERE hp > maxhp");
mysql_query("UPDATE users SET hospital=hospital-{$fr['hosp_time']} where userid=$userid");
mysql_query("UPDATE users SET hospital=0 WHERE hospital < 0");
Replace with:
}
else if($r['itmtypename'] == 'Medical')
{
$f=mysql_query("SELECT * FROM medical WHERE item_id={$r['itmid']}",$c);
$fr=mysql_fetch_array($f);
mysql_query("UPDATE inventory SET inv_qty=inv_qty-1 WHERE inv_id={$_GET['ID']}",$c);
mysql_query("DELETE FROM inventory WHERE inv_qty=0",$c);
mysql_query("UPDATE users SET hp=hp+{$fr['health']} WHERE userid=$userid");
mysql_query("UPDATE users SET hp=maxhp WHERE hp > maxhp");
mysql_query("UPDATE users SET hospital=hospital-1000 where userid=$userid");
mysql_query("UPDATE users SET hospital=0 WHERE hospital < 0");