I have the following script for tracking user. I need help how to define variable for TimeOUT ($timeout). Please help. :rolleyes:
Code is the following:
[code=php]
<?PHP
/* Connect to MySQL-Server */
…
/* Open $db */
…
$username=$_COOKIE[‘username’];
// I would like to Update The Session TimeOut
$result = query( “UPDATE users_sessions
SET
timeout = UNIX_TIMESTAMP()+{$timeout} WHERE
SESSID = ‘{$SESSID}'” );
$result1 = mysql_query($result);
}
// Setcookies and authentication
if($_POST[‘remember’] != ‘1’)
{
$SESSID = md5( time() );
$sql = query(” DELETE FROM users_sessions WHERE username = ‘{$_POST[‘usernamelogin’]}'”);
$sql = mysql_query($sql);
$result= query (” INSERT INTO users_sessions SET
`SESSID` = ‘{$SESSID}’,
`username` = ‘{$_POST[‘usernamelogin’]}’,
`IP` = ‘{$_SERVER[‘REMOTE_ADDR’]}’,
`TimeOut` = UNIX_TIMESTAMP()+{$timeout}” );
$result2 = mysql_query($result);
}
else
{
// Checking CheckBox Remember Me
if( $_POST[‘remember’] == ‘1’ )
{
setcookie(‘username’, $_POST[‘usernamelogin’], time() + 60*60*24*30 );
}
else
{
setcookie(‘username’, $_POST[‘usernamelogin’]);
}
}
?>