user_count.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 27 行

<?
  include_once 'inc/auth.php';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  $ONLINE_REF_NORMAL = ($ONLINE_REF_SEC - 10);
  $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 (($ONLINE_REF_NORMAL < (time () - $LAST_VISIT_TIME)))
  {
    $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;
?>