/[cvs]/nfo/php/libs/org.netfrag.flib/Tracker/Session.php
ViewVC logotype

Diff of /nfo/php/libs/org.netfrag.flib/Tracker/Session.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by joko, Sun Dec 1 22:32:45 2002 UTC revision 1.9 by joko, Sun Feb 9 17:44:51 2003 UTC
# Line 3  Line 3 
3  //    $Id$  //    $Id$
4  //    -------------------------------------------------------------------------  //    -------------------------------------------------------------------------
5  //    $Log$  //    $Log$
6    //    Revision 1.9  2003/02/09 17:44:51  joko
7    //    + minor fix related to empty resultsets from rdbms
8    //
9    //    Revision 1.8  2002/12/28 01:17:53  jonen
10    //    - moved 'validate_idle()' to 'presentation.php' cause some problems
11    //      with '$site->request->overrideRequestIdentifer()' at class scope
12    //
13    //    Revision 1.7  2002/12/13 00:24:03  jonen
14    //    - added debug Dumper
15    //
16    //    Revision 1.6  2002/12/05 21:46:09  joko
17    //    + global $sessionstate (session-variable)
18    //    + function get
19    //    + function set
20    //
21    //    Revision 1.5  2002/12/04 10:13:21  joko
22    //    - purged old code in validate_session
23    //
24    //    Revision 1.3  2002/12/03 16:13:21  joko
25    //    + bugfix with autologout:
26    //      + now just setting some message to site_state here
27    //      + no direct getlt! (it's a shortcut function)
28    //      + $this->site->user->preLogout(1);  as autoload mechanism
29    //
30  //    Revision 1.2  2002/12/01 22:32:45  joko  //    Revision 1.2  2002/12/01 22:32:45  joko
31  //    + bugfix: wrong object-hierarchy:  //    + bugfix: wrong object-hierarchy:
32  //       use $this->site->user->preLogout and/or $this->site->request->overrideReq...  //       use $this->site->user->preLogout and/or $this->site->request->overrideReq...
# Line 25  class Session { Line 49  class Session {
49      $session_cfg["user_agent"] = $_SERVER["HTTP_USER_AGENT"];          $session_cfg["user_agent"] = $_SERVER["HTTP_USER_AGENT"];    
50      $session_cfg["http_referer"] = $_SERVER["HTTP_REFERER"];      $session_cfg["http_referer"] = $_SERVER["HTTP_REFERER"];
51      $session_cfg["date"] = date('Y-m-d H:i:s', time());      $session_cfg["date"] = date('Y-m-d H:i:s', time());
52    
53        if (session_register_safe('sessionstate')) {
54        }
55    
56    }    }
57        
58    function start() {    function start() {
59        // FIXME: global $session_cfg;
60      global $session_cfg;      global $session_cfg;
61      $session_exists = $this->exists($session_cfg["session_id"]);      $session_exists = $this->exists($session_cfg["session_id"]);
62      //print Dumper($session_exists);      //print Dumper($session_exists);
# Line 35  class Session { Line 64  class Session {
64        $this->add_session($session_cfg);        $this->add_session($session_cfg);
65      } else {      } else {
66        $session_cfg["session_uid"] = $session_exists["session_uid"];        $session_cfg["session_uid"] = $session_exists["session_uid"];
67        if ($this->site->user->isLoggedOn()) {        //if ($this->site->user->isLoggedOn()) {
68          //print "val - idle<br>";          //print "val - idle<br>";
69          $this->validate_idle();          //$this->validate_idle();
70        }        //}
71        //print "val - session<br>";        //print "val - session<br>";
72        $this->validate_session($session_cfg);        //$this->validate_session($session_cfg);
73      }      }
74    }    }
75        
# Line 54  class Session { Line 83  class Session {
83    }    }
84        
85    function add_session($scfg) {    function add_session($scfg) {
86        //session_start();      //session_start();
87        //session_register('user_status_val');      //session_register('user_status_val');
88        connectdb();      // FIXME: use PEAR here!
89        $sql="INSERT INTO f_td_sessions VALUES ('','$scfg[session_id]','1','$scfg[remote_ip]','$scfg[remote_port]','$scfg[user_agent]','$scfg[http_referer]','$scfg[date]','$scfg[date]')";      connectdb();
90        $res = send_sql($sql);      $sql="INSERT INTO f_td_sessions VALUES ('','$scfg[session_id]','1','$scfg[remote_ip]','$scfg[remote_port]','$scfg[user_agent]','$scfg[http_referer]','$scfg[date]','$scfg[date]')";
91        $res = send_sql($sql);
92    }    }
93        
94    function bindUser() {    function bindUser() {
# Line 69  class Session { Line 99  class Session {
99      if($res = send_sql($sql)) {      if($res = send_sql($sql)) {
100          $row = mysql_fetch_array($res,MYSQL_ASSOC);          $row = mysql_fetch_array($res,MYSQL_ASSOC);
101      //if (!mysql_num_rows($res)>0) {      //if (!mysql_num_rows($res)>0) {
102        $sql2 = "INSERT INTO f_map_user_session VALUES ('','$site->user->get('oid')','$session_tm[session_uid]','$date','','1')";        $sql2 = "INSERT INTO f_map_user_session VALUES ('','$this->site->user->get('oid')','$session_tm[session_uid]','$date','','1')";
103        $res2 = send_sql($sql2);        $res2 = send_sql($sql2);
104      }      }
105      else {      else {
106          //print_r($row);          //print_r($row);
107        $sql3 = "Update f_map_user_session SET last='0' WHERE mid='$row[mid]'";        $sql3 = "Update f_map_user_session SET last='0' WHERE mid='$row[mid]'";
108        $res3 = send_sql($sql3);          $res3 = send_sql($sql3);  
109        $sql4 = "INSERT INTO f_map_user_session VALUES ('','$site->user->get('oid')','$session_tm[session_uid]','$date','','1')";        $sql4 = "INSERT INTO f_map_user_session VALUES ('','$this->site->user->get('oid')','$session_tm[session_uid]','$date','','1')";
110        $res4 = send_sql($sql4);        $res4 = send_sql($sql4);
111      }      }
112    }    }
# Line 86  class Session { Line 116  class Session {
116      connectdb();      connectdb();
117      $sql_exists = "SELECT session_uid,session_id FROM f_td_sessions WHERE session_id='$session_id'";      $sql_exists = "SELECT session_uid,session_id FROM f_td_sessions WHERE session_id='$session_id'";
118      $res_exists = send_sql($sql_exists);      $res_exists = send_sql($sql_exists);
119      if (!mysql_num_rows($res_exists) > 0) {      if (!$res_exists || !mysql_num_rows($res_exists) > 0) {
120        return 0;        return 0;
121      }      }
122      else {      else {
# Line 95  class Session { Line 125  class Session {
125          }          }
126    }      }  
127        
   function validate_idle() {  
128    
     //global $cfg, $site, $site_state;  
     global $cfg, $site_state;  
     $session_id = session_id();  
129        
130      // get "max_idle_time"-time from database    function get($attribute) {
131        $sql = "SELECT pvalue FROM td_global_private WHERE pname='max_idle_time'";      global $sessionstate;
132        $res = send_sql($sql);  //print "session - get: " . Dumper($sessionstate) . "<br>";
133        $row = mysql_fetch_array($res, MYSQL_ASSOC);      return $sessionstate[$attribute];
134        $max_idle_time = $row[pvalue];    }
135    
136      // use a default idle-time of half an hour if database-value is empty    function set($attribute, $value) {
137        if (!$max_idle_time) $max_idle_time = 60 * 30;      global $sessionstate;
138      //print "val: " . Dumper($value) . "<br>";
139      // get last "access"-time from database      $sessionstate[$attribute] = $value;
140        $sql_mus = "SELECT last_date FROM f_td_sessions WHERE session_id='$session_id'";  //print "session - set: " . Dumper($sessionstate) . "<br>";
141        $res_mus = send_sql($sql_mus);    }
       $mus = mysql_fetch_array($res_mus, MYSQL_ASSOC);  
     
     // calculate idletime  
       $time_now = time();  
       $last_date = strtotime($mus[last_date]);  
       $max_idle_date = $last_date + $max_idle_time;  
     
     // check timeout  
       if ($time_now > $max_idle_date) {  
         // set autologout message  
         $tpl = array( 'idle_time' => $max_idle_time / 60, );  
         $site_state[message] = getlt('table/notify/autologout', $tpl);  
         // throw user to (re)login-page  
         //$site->redirect( getlink('/pub/login/') );  
         $this->site->user->preLogout();  
         $site->site->request->overrideRequestIdentifier('/home/logout/');  
       }  
       
   }    
142    
143  }  }
144    
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.9
MailToCvsAdmin">MailToCvsAdmin
 ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed