示例#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
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 = "";
示例#3
0
 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;
 }