query("SELECT gridstatus,active,color,title,message FROM ".C_INFOWINDOW_TBL." ");
list($GRIDSTATUS,$INFOBOX,$BOXCOLOR,$BOX_TITLE,$BOX_INFOTEXT) = $DbLink->next_record();
// Doing it the same as the Who's Online now part
$DbLink = new DB;
/*
$DbLink->query("SELECT UserID, HomeRegionID FROM ".C_AGENTS_TBL." WHERE Online != 'False' ".
"ORDER BY login DESC");
$NOWONLINE = 0;
while(list($UUID,$regionUUID) = $DbLink->next_record())
{
// Let's get the user info
$DbLink2 = new DB;
$DbLink2->query("SELECT FirstName, LastName from ".C_USERS_TBL." where PrincipalID = '".$UUID."'");
list($firstname, $lastname) = $DbLink2->next_record();
$username = $firstname." ".$lastname;
// Let's get the region information
$DbLink3 = new DB;
$DbLink3->query("SELECT regionName from ".C_REGIONS_TBL." where UUID = '".$regionUUID."'");
list($region) = $DbLink3->next_record();
if ($region != "")
{
$NOWONLINE = $NOWONLINE + 1;
}
}
*/
// Or do it the proper way.
$DbLink->query("SELECT count(*) FROM griddy.presence_culled");
list($NOWONLINE) = $DbLink->next_record();
$DbLink->query("SELECT count(*) FROM ".C_AGENTS_TBL." where login > UNIX_TIMESTAMP(FROM_UNIXTIME(UNIX_TIMESTAMP(now()) - 2419200))");
list($LASTMONTHONLINE) = $DbLink->next_record();
$DbLink->query("SELECT count(*) FROM ".C_USERS_TBL."");
list($USERCOUNT) = $DbLink->next_record();
$DbLink->query("SELECT count(*) FROM ".C_REGIONS_TBL."");
list($REGIONSCOUNT) = $DbLink->next_record();
?>
SYSNAME Login
