/** * 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'); }