示例#1
0
 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();
         }
     }
 }
示例#2
0
        $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.";
        }
    }
}
?>
示例#3
0
 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();
 }