user_count.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<?
include_once("inc/auth.php");

//----- 更新最后访问时间 -----
$CUR_TIME=date("Y-m-d H:i:s",time());
$ONLINE_REF_NORMAL=$ONLINE_REF_SEC-5;

$query = "SELECT UNIX_TIMESTAMP(LAST_VISIT_TIME) from USER where USER_ID='$LOGIN_USER_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
   $LAST_VISIT_TIME=$ROW[0];

if(time()-$LAST_VISIT_TIME>$ONLINE_REF_NORMAL)
{
   $query = "update USER set ONLINE=ONLINE+$ONLINE_REF_SEC,LAST_VISIT_TIME='$CUR_TIME' where USER_ID='$LOGIN_USER_ID'";
   exequery($connection,$query);
}

//------ 返回在线总数 --------
$ONLINE_LIMIT=$ONLINE_REF_SEC+5;
$USER_COUNT=1;
$query = "SELECT count(*) from USER where UNIX_TIMESTAMP('$CUR_TIME')-UNIX_TIMESTAMP(LAST_VISIT_TIME)<$ONLINE_LIMIT";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
   $USER_COUNT=$ROW[0];

ob_end_clean();
echo $USER_COUNT;
?>