芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/logoutjob.php

<?php
//$db_host="quicksubmit.db.2984246.hostedresource.com";
//$db_user="quicksubmit";
//$db_pass="Qsabsi@2274";
//$db_name="quicksubmit";
$db_host="db519824284.db.1and1.com";
$db_user="dbo519824284";
$db_pass="Qsabsi@2274";
$db_name="db519824284";
$sql_select=mysql_connect($db_host, $db_user, $db_pass) or die(mysql_error());
//select database
mysql_select_db($db_name, $sql_select) or die("could not find DB.");
mysql_query("insert into test set post_date=now()");
//exit();
/*----get online user-----*/
$sqluser = "select `user_id`,`last_time` from `sat_users` where `online`=1";
$qryuser = mysql_query($sqluser);
$rowuser = mysql_num_rows($qryuser);
if($rowuser > 0){
	while($arr = mysql_fetch_array($qryuser)){
		$userId = $arr['user_id'];
		$online = 0;
		$last_time = $arr['last_time'];
		$curTime = time();
		$timeDiff = $curTime - $last_time;
		if($timeDiff > 5){
			$sql = sprintf("update `sat_users` set `online`='%s' where `user_id`='%s'",$online,$userId);
			$qry = mysql_query($sql);
		}
	}
}
/*----get online user-----*/

///web/cgi-bin/php5 "$HOME/html/AbsiUsaCom_New/qs/logoutjob.php"
?>