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(); } } }
$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(); $sess_ip = ""; $sess_user_id = ""; } else { $message = "Problemas na operação."; } } } ?>
function DropTables() { $moderator = new Moderator(); $moderator->SetDatabase($this); $moderator->Drop(); $message = new Message(); $message->SetDatabase($this); $message->Drop(); $topic = new Topic(); $topic->SetDatabase($this); $topic->Drop(); $user_info = new UserInfo(); $user_info->SetDatabase($this); $user_info->Drop(); $session = new Session(); $session->SetDatabase($this); $session->Drop(); $new = new News(); $new->SetDatabase($this); $new->Drop(); $shout = new Shout(); $shout->SetDatabase($this); $shout->Drop(); $paragraph = new Paragraph(); $paragraph->SetDatabase($this); $paragraph->Drop(); $privilege = new Privilege(); $privilege->SetDatabase($this); $privilege->Drop(); $role = new Role(); $role->SetDatabase($this); $role->Drop(); $menu_item = new MenuItem(); $menu_item->SetDatabase($this); $menu_item->Drop(); $module = new Module(); $module->SetDatabase($this); $module->Drop(); $page = new Page(); $page->SetDatabase($this); $page->Drop(); $article = new Article(); $article->SetDatabase($this); $article->Drop(); $subject = new Subject(); $subject->SetDatabase($this); $subject->Drop(); $menu = new Menu(); $menu->SetDatabase($this); $menu->Drop(); $profile = new Profile(); $profile->SetDatabase($this); $profile->Drop(); $user = new User(); $user->SetDatabase($this); $user->Drop(); }