function TerminateExpiredSessions() { $select = "select sess_id, sess_active, sess_date_start, sess_date_last, sess_ip, sess_user_id " . "from sessions " . "where sess_active = 1"; $result = $this->database->Execute($select); while ($data = $this->database->FetchArray($result)) { $time = $data["sess_date_last"]; $day = substr($time, 0, 2); $month = substr($time, 3, 2); $year = substr($time, 6, 4); $hour = substr($time, 11, 2); $minute = substr($time, 14, 2); $second = substr($time, 17, 2); $time1 = mktime($hour, $minute, $second, $month, $day, $year); $time2 = time(); $diff = ($time2 - $time1) / 60; if ($diff > 5) { $session = new Session(); $session->SetDatabase($this->database); $session->SetId($data["sess_id"]); $session->SelectById(); $session->SetActive(0); $session->SetDateLast(date('Y-m-d H:i:s', $time2)); $session->Update(); } } }
require '../../' . $WEB_SITE . 'src/cdSession.php'; require '../../' . $WEB_SITE . 'src/cdGuardian.php'; $screen_module_name = "Sessão"; if (isset($_POST["p_action"])) { $action = $_POST["p_action"]; $sess_id = $_POST["p_sess_id"]; $sess_active = $_POST["p_sess_active"]; $sess_date = $_POST["p_sess_date"]; $sess_ip = $_POST["p_sess_ip"]; $sess_user_id = $_POST["p_sess_user_id"]; $message = ""; if ($action == 1) { $session = new Session(); $session->SetDatabase($database); $session->SetId($sess_id); $session->SelectById(); $date = new Date(); $date->Setdate($session->GetDate()); $date->ConvertToFullDisplay(); $sess_id = $session->GetId(); $sess_date = $date->GetConverted(); $sess_active = $session->GetActive(); $sess_ip = $session->GetIp(); $sess_user_id = $session->GetUser(); if ($sess_id == "") { $message = $screen_module_name . " não encontrado."; $sess_id = ""; $sess_active = ""; $sess_date = $date->GetNowFull(); $sess_ip = ""; $sess_user_id = "";
function Update() { $select = "update sessions set sess_date_start = \"" . $this->date_start . "\", sess_date_last = \"" . $this->date_last . "\", sess_active = " . $this->active . ", " . "sess_ip = \"" . $this->ip . "\", sess_user_id = " . $this->user . " " . "where sess_id = \"" . $this->id . "\""; $old = new Session(); $old->id = $this->id; $old->database = $this->database; $old->SelectById(); if ($this->date_start == $old->date_start && $this->date_last == $old->date_last && $this->active == $old->active && $this->ip == $old->ip && $this->user == $old->user) { return true; } $result = $this->database->Execute($select); if (mysql_affected_rows() == 1) { return true; } return false; }