/**
* Last Activité exec
* update users_sys with last activité usuful for auto logout
* return log && Error
*
*/
private function last_active()
{
global $db;
//Get last activity time and compare with now
//if is elapsed logout
$sql = "SELECT TIMESTAMPDIFF(MINUTE, lastactive, CURRENT_TIMESTAMP) as expir\n\t\t\t\tFROM users_sys \n\t\t where id = " . MySQL::SQLValue(session::get('userid'));
$time = $db->QuerySingleValue0($sql);
if ($time > 20) {
$this->error = false;
$this->log .= ' </br>vous avez été deconnecté du serveur pour une inactivité de ' . $time . ' Minutes //AUTO_LOGOUT';
$new_logout = new MLogin();
$new_logout->token = session::get('username');
$new_logout->logout();
} else {
//Update lastactive into users_sys
$val_time['lastactive'] = 'CURRENT_TIMESTAMP';
$whr_user['id'] = MySQL::SQLValue(session::get('userid'));
if (!$db->UpdateRows('users_sys', $val_time, $whr_user)) {
$this->log .= $db->Error();
$this->error = false;
$this->log .= '</br>Problème MAJ dérnière activité';
}
}
}
<?php
$new_logout = new MLogin();
$new_logout->token = session::get('username');
if ($new_logout->logout()) {
header('location:./');
} else {
MInit::msg_cor($new_logout->log, $err = "", $return = "");
//exit('error');
}
