发表于 2009-1-5 19:48
| 
鍩轰簬鏁版嵁搴撶殑鍦ㄧ嚎浜烘暟锛屾棩璁块棶閲忕瓑缁熻
鍙戝竷: 2008-6-27 15:56 | 浣滆: admin | 鏌ョ湅: 9娆
鍙互瀹炵幇鍦ㄧ嚎浜烘暟缁熻锛屾棩璁块棶閲忕粺璁★紝鏈堣闂噺缁熻銆傘傘傘傘
$sql = "CREATE TABLE guestinfo(id integer DEFAULT '0' NOT NULL AUTO_INCREMENT,
ipaddress varchar(20),
host varchar(20),
cometime datetime,
refreshtime datetime,
leavetime datetime,
PRIMARY KEY(id),
UNIQUE id(id),
index guestinfo(id)
)";
mysql_query($sql, $connect);
?>
$duration = 300;
$sql = "select * from guestinfo where (leavetime is null or leavetime=') and ( UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(refreshtime))>$duration";
$result=@mysql_query($sql);
while($row=@mysql_fetch_array($result))
{
$id = $row['id'];
$sql = "update guestinfo set leavetime=now() where id='$id'";
mysql_query($sql);
}
$sql = "select * from guestinfo where ipaddress='$REMOTE_ADDR' and (leavetime is null or leavetime=')";
$result = @mysql_query($sql);
if($row=@mysql_fetch_array($result))
{
$id = $row['id'];
$sql="update guestinfo set refreshtime=now() where id='$id'";
