Re: Cron Optimization question
That looks good to me, I am trying it out.
I also did this:
$db->query("UPDATE users set hospital=hospital-1 WHERE hospital>0");
$db->query("UPDATE users SET jail=jail-1 WHERE jail > 0");
//$hc=$db->num_rows($db->query("SELECT * FROM users WHERE hospital > 0"));
//$jc=$db->num_rows($db->query("SELECT * FROM users WHERE jail > 0"));
//$db->query("UPDATE settings SET conf_value='$hc' WHERE conf_name='hospital_count'");
//$db->query("UPDATE settings SET conf_value='$jc' WHERE conf_name='jail_count'");
$db->query("UPDATE settings SET conf_value=(select count(*) from users where jail > 0) WHERE conf_name='jail_count';");
$db->query("UPDATE settings SET conf_value=(select count(*) from users where hospital > 0) WHERE conf_name='hospital_count';");
