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(); } } }