/[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.3 by joko, Tue Dec 3 16:13:21 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  //    Revision 1.3  2002/12/03 16:13:21  joko
25  //    + bugfix with autologout:  //    + bugfix with autologout:
26  //      + now just setting some message to site_state here  //      + now just setting some message to site_state here
# Line 31  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 41  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 60  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 75  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 92  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 101  class Session { Line 125  class Session {
125          }          }
126    }      }  
127        
   function validate_idle() {  
128    
129      //global $cfg, $site, $site_state;    
130      global $cfg, $site_state;    function get($attribute) {
131      $session_id = session_id();      global $sessionstate;
132    //print "session - get: " . Dumper($sessionstate) . "<br>";
133        return $sessionstate[$attribute];
134      }
135    
136      // get "max_idle_time"-time from database    function set($attribute, $value) {
137        $sql = "SELECT pvalue FROM td_global_private WHERE pname='max_idle_time'";      global $sessionstate;
138        $res = send_sql($sql);  //print "val: " . Dumper($value) . "<br>";
139        $row = mysql_fetch_array($res, MYSQL_ASSOC);      $sessionstate[$attribute] = $value;
140        $max_idle_time = $row[pvalue];  //print "session - set: " . Dumper($sessionstate) . "<br>";
141      }
     // use a default idle-time of half an hour if database-value is empty  
       if (!$max_idle_time) $max_idle_time = 60 * 30;  
     
     // get last "access"-time from database  
       $sql_mus = "SELECT last_date FROM f_td_sessions WHERE session_id='$session_id'";  
       $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);  
         //$site_state[_autologout] = array( langkey => getlt('table/notify/autologout', $tpl);  
         // throw user to (re)login-page  
         //$site->redirect( getlink('/pub/login/') );  
         $this->site->user->preLogout(1);  
         $this->site->request->overrideRequestIdentifier('/home/logout/');  
       }  
       
   }    
142    
143  }  }
144    
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.9
MailToCvsAdmin">MailToCvsAdmin
 ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed