Hospital Jail Counter in Main Menu always at zero (MWG Fixed-Thank You!)

[Curt]

Hey, you could do a row count like so :

 

 

$HOSPCNT=$db->query("SELECT userid FROM users WHERE hospital>0");
$HCNT=$db->num_rows($HOSPCNT);

 

You can do the same for jail :

 

$JAILCNT=$db->query("SELECT userid FROM users WHERE jail>0");
$JCNT=$db->num_rows($JAILCNT);

 

$HCNT and $JCNT will display how many people are in the hospital and jail...

Hope that helps you..