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(); } } }
} else { $message = "Problemas na operação."; } } if ($action == 3) { $date = new Date(); $date->SetConverted($sess_date); $date->ConvertToFullDate(); $session = new Session(); $session->SetDatabase($database); $session->SetId($sess_id); $session->SetActive($sess_active); $session->SetName($date->GetDate()); $session->SetIp($sess_ip); $session->SetUser($sess_user_id); if ($session->Update()) { $message = $screen_module_name . " alterado com sucesso."; } else { $message = "Problemas na operação."; } } if ($action == 4) { $session = new Session(); $session->SetDatabase($database); $session->SetId($sess_id); if ($session->Delete()) { $date = new Date(); $message = $screen_module_name . " excluído com sucesso."; $sess_id = ""; $sess_active = ""; $sess_date = $date->GetNowFull();