Automatické odhlásenie?

27. 4. 2011 03:47:14

Ako upraviť tento kód aby prihlásených užívateľov automaticky odhlásil z web stránky po 30 min. nečinnosti?

if($login)

{

$Res=$dbh->query("select user_id,status from users where username='$login' and password='$pass' and active='Y' and suspend='N' and deleted='N' and user_type!='system'");

if(@mysql_num_rows($Res)>0)

{

$Data=@mysql_fetch_object($Res);

if($Data->status=='Y')

{

@session_start();

@session_register('SESSIONUSERID');

$_SESSION = $Data->user_id;

$sql=$dbh->query("update users set online='Y' where user_id='$_SESSION'");

$timeoutseconds = 60; // length of session, 1 minutes

$timestamp=$CURRENT_TIME;

$timeout=$timestamp-$timeoutseconds;

$Res1=$dbh->query("select * from tbl_session where sysID='".$_SESSION."'");

$Data1=@mysql_fetch_object($Res1);

if(@mysql_num_rows($Res1)==0)

{

$insertQry=$dbh->query("insert into tbl_session (sess_id, ip,Timestamp,sysID,login_date,login_time,browser,online_time,active) values('".session_id()."','".$_SERVER."','$timestamp','".$_SESSION."','".date("d-m-Y")."','".date("H:m:s")."','".$_SERVER."','".$CURRENT_TIME."',1)");

$_SESSION=mysql_insert_id();

}

else

{

$dbh->query("update tbl_session set Timestamp='$timestamp', active='1', sess_id= '".session_id()."', IP='".$_SERVER."', login_date='".date("d-m-Y")."', login_time='".date("H:m:s")."', browser='".$_SERVER."', online_time='".$CURRENT_TIME."' where sysID='".$_SESSION."'");

$_SESSION=$Data1->id;

}

echo '';

}

else

echo '';

}

else

echo '';

}

if($error==1)

$Message=$lang;