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(); if (substr($lastname,-1,1) != "_") { $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; } } } $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(); ?> <br /> <b>Notice</b>: Use of undefined constant SYSNAME - assumed 'SYSNAME' in <b>C:\xampp\htdocs\opensim\loginscreen.php</b> on line <b>46</b><br /> SYSNAME Login