org.netfrag.flib/Tracker/Session.php

<?
//    -------------------------------------------------------------------------
//    $Id: Session.php,v 1.5 2002/12/04 10:13:21 joko Exp $
//    -------------------------------------------------------------------------
//    $Log: Session.php,v $
//    Revision 1.5  2002/12/04 10:13:21  joko
//    - purged old code in validate_session
//
//    Revision 1.3  2002/12/03 16:13:21  joko
//    + bugfix with autologout:
//      + now just setting some message to site_state here
//      + no direct getlt! (it's a shortcut function)
//      + $this->site->user->preLogout(1);  as autoload mechanism
//
//    Revision 1.2  2002/12/01 22:32:45  joko
//    + bugfix: wrong object-hierarchy:
//       use $this->site->user->preLogout and/or $this->site->request->overrideReq...
//    + documented
//
//    Revision 1.1  2002/11/12 05:42:31  joko
//    + initial checkin
//
//    -------------------------------------------------------------------------


class Session {
  
  //============== session functions=============
  function &Session() {
    global $session_cfg;
    $session_cfg["session_id"] = session_id();
    $session_cfg["remote_ip"] = $_SERVER["REMOTE_ADDR"];
    $session_cfg["remote_port"] = $_SERVER["REMOTE_PORT"];
    $session_cfg["user_agent"] = $_SERVER["HTTP_USER_AGENT"];    
    $session_cfg["http_referer"] = $_SERVER["HTTP_REFERER"];
    $session_cfg["date"] = date('Y-m-d H:i:s', time());

    if (session_register_safe('sessionstate')) {
    }

  } 
  
  function start() {
    global $session_cfg;
    $session_exists = $this->exists($session_cfg["session_id"]);
    //print Dumper($session_exists);
    if (!is_array($session_exists)) {
      $this->add_session($session_cfg);
    } else {
      $session_cfg["session_uid"] = $session_exists["session_uid"];
      if ($this->site->user->isLoggedOn()) {
        //print "val - idle<br>";
        $this->validate_idle();
      }
      //print "val - session<br>";
      $this->validate_session($session_cfg);
    }
  }
  
  function validate_session($scfgt) {
    $this->update_session($scfgt);
  }
  
  function update_session($scfg) {
    $sql = "UPDATE f_td_sessions SET session_hits=session_hits+1,last_date='$scfg[date]' WHERE session_uid='$scfg[session_uid]'";
    $res = send_sql($sql);
  }
  
  function add_session($scfg) {
      //session_start();
      //session_register('user_status_val');
      connectdb();
      $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]')";
      $res = send_sql($sql);
  }
  
  function bindUser() {
    $session_id = session_id();
        $session_tm = $this->exists($session_id);
    $date = date('Y-m-d H:i:s', time());
    $sql = "SELECT mid FROM f_map_user_session WHERE user_uid='$site->user->get('oid')' AND last='1'";
    if($res = send_sql($sql)) {
        $row = mysql_fetch_array($res,MYSQL_ASSOC);
    //if (!mysql_num_rows($res)>0) {
      $sql2 = "INSERT INTO f_map_user_session VALUES ('','$site->user->get('oid')','$session_tm[session_uid]','$date','','1')";
      $res2 = send_sql($sql2);
    }
    else {
        //print_r($row);
      $sql3 = "Update f_map_user_session SET last='0' WHERE mid='$row[mid]'";
      $res3 = send_sql($sql3);  
      $sql4 = "INSERT INTO f_map_user_session VALUES ('','$site->user->get('oid')','$session_tm[session_uid]','$date','','1')";
      $res4 = send_sql($sql4);
    }
  }
  
  function exists($session_id) {
    // check if sessionID exists
    connectdb();
    $sql_exists = "SELECT session_uid,session_id FROM f_td_sessions WHERE session_id='$session_id'";
    $res_exists = send_sql($sql_exists);
    if (!mysql_num_rows($res_exists) > 0) {
      return 0;
    }
    else {
          $row = mysql_fetch_array($res_exists, MYSQL_ASSOC);
          return $row;
        }
  }  
  
  function validate_idle() {

    //global $cfg, $site, $site_state;
    global $cfg, $site_state;
    $session_id = session_id();

    // get "max_idle_time"-time from database
      $sql = "SELECT pvalue FROM td_global_private WHERE pname='max_idle_time'";
      $res = send_sql($sql);
      $row = mysql_fetch_array($res, MYSQL_ASSOC);
      $max_idle_time = $row[pvalue];

    // 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) {
        // TODO: REVIEW (re-enable?)
        // throw user to (re)login-page
        // $site->redirect( getlink('/pub/login/') );
        $this->site->user->preLogout(1);
        $this->site->request->overrideRequestIdentifier('/home/logout/');
      }
    
  }
  
  
  function get($attribute) {
    global $sessionstate;
    return $sessionstate[$attribute];
  }

  function set($attribute, $value) {
    global $sessionstate;
    $sessionstate[$attribute] = $value;
  }

}

?>
1	joko	1.1	<?
2			// -------------------------------------------------------------------------
3	joko	1.6	// $Id: Session.php,v 1.5 2002/12/04 10:13:21 joko Exp $
4	joko	1.1	// -------------------------------------------------------------------------
5	joko	1.2	// $Log: Session.php,v $
6	joko	1.6	// Revision 1.5 2002/12/04 10:13:21 joko
7			// - purged old code in validate_session
8			//
9	jonen	1.4	// Revision 1.3 2002/12/03 16:13:21 joko
10			// + bugfix with autologout:
11			// + now just setting some message to site_state here
12			// + no direct getlt! (it's a shortcut function)
13			// + $this->site->user->preLogout(1); as autoload mechanism
14			//
15	joko	1.3	// Revision 1.2 2002/12/01 22:32:45 joko
16			// + bugfix: wrong object-hierarchy:
17			// use $this->site->user->preLogout and/or $this->site->request->overrideReq...
18			// + documented
19			//
20	joko	1.2	// Revision 1.1 2002/11/12 05:42:31 joko
21			// + initial checkin
22			//
23	joko	1.1	// -------------------------------------------------------------------------
24
25
26			class Session {
27
28			//============== session functions=============
29			function &Session() {
30			global $session_cfg;
31			$session_cfg["session_id"] = session_id();
32			$session_cfg["remote_ip"] = $_SERVER["REMOTE_ADDR"];
33			$session_cfg["remote_port"] = $_SERVER["REMOTE_PORT"];
34			$session_cfg["user_agent"] = $_SERVER["HTTP_USER_AGENT"];
35			$session_cfg["http_referer"] = $_SERVER["HTTP_REFERER"];
36			$session_cfg["date"] = date('Y-m-d H:i:s', time());
37	joko	1.6
38			if (session_register_safe('sessionstate')) {
39			}
40
41	joko	1.1	}
42
43			function start() {
44			global $session_cfg;
45			$session_exists = $this->exists($session_cfg["session_id"]);
46	joko	1.2	//print Dumper($session_exists);
47	joko	1.1	if (!is_array($session_exists)) {
48			$this->add_session($session_cfg);
49	joko	1.2	} else {
50	joko	1.1	$session_cfg["session_uid"] = $session_exists["session_uid"];
51	joko	1.2	if ($this->site->user->isLoggedOn()) {
52			//print "val - idle<br>";
53			$this->validate_idle();
54			}
55			//print "val - session<br>";
56	joko	1.1	$this->validate_session($session_cfg);
57			}
58			}
59
60			function validate_session($scfgt) {
61			$this->update_session($scfgt);
62			}
63
64			function update_session($scfg) {
65			$sql = "UPDATE f_td_sessions SET session_hits=session_hits+1,last_date='$scfg[date]' WHERE session_uid='$scfg[session_uid]'";
66			$res = send_sql($sql);
67			}
68
69			function add_session($scfg) {
70			//session_start();
71			//session_register('user_status_val');
72			connectdb();
73			$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]')";
74			$res = send_sql($sql);
75			}
76
77			function bindUser() {
78			$session_id = session_id();
79			$session_tm = $this->exists($session_id);
80			$date = date('Y-m-d H:i:s', time());
81			$sql = "SELECT mid FROM f_map_user_session WHERE user_uid='$site->user->get('oid')' AND last='1'";
82			if($res = send_sql($sql)) {
83			$row = mysql_fetch_array($res,MYSQL_ASSOC);
84			//if (!mysql_num_rows($res)>0) {
85			$sql2 = "INSERT INTO f_map_user_session VALUES ('','$site->user->get('oid')','$session_tm[session_uid]','$date','','1')";
86			$res2 = send_sql($sql2);
87			}
88			else {
89			//print_r($row);
90			$sql3 = "Update f_map_user_session SET last='0' WHERE mid='$row[mid]'";
91			$res3 = send_sql($sql3);
92			$sql4 = "INSERT INTO f_map_user_session VALUES ('','$site->user->get('oid')','$session_tm[session_uid]','$date','','1')";
93			$res4 = send_sql($sql4);
94			}
95			}
96
97			function exists($session_id) {
98			// check if sessionID exists
99			connectdb();
100			$sql_exists = "SELECT session_uid,session_id FROM f_td_sessions WHERE session_id='$session_id'";
101			$res_exists = send_sql($sql_exists);
102	joko	1.2	if (!mysql_num_rows($res_exists) > 0) {
103	joko	1.1	return 0;
104			}
105			else {
106			$row = mysql_fetch_array($res_exists, MYSQL_ASSOC);
107			return $row;
108			}
109			}
110
111			function validate_idle() {
112	joko	1.2
113			//global $cfg, $site, $site_state;
114			global $cfg, $site_state;
115	joko	1.1	$session_id = session_id();
116	joko	1.3
117	joko	1.1	// get "max_idle_time"-time from database
118			$sql = "SELECT pvalue FROM td_global_private WHERE pname='max_idle_time'";
119			$res = send_sql($sql);
120	joko	1.2	$row = mysql_fetch_array($res, MYSQL_ASSOC);
121			$max_idle_time = $row[pvalue];
122
123			// use a default idle-time of half an hour if database-value is empty
124			if (!$max_idle_time) $max_idle_time = 60 * 30;
125	joko	1.1
126			// get last "access"-time from database
127			$sql_mus = "SELECT last_date FROM f_td_sessions WHERE session_id='$session_id'";
128			$res_mus = send_sql($sql_mus);
129	joko	1.2	$mus = mysql_fetch_array($res_mus, MYSQL_ASSOC);
130	joko	1.1
131			// calculate idletime
132	joko	1.2	$time_now = time();
133	joko	1.1	$last_date = strtotime($mus[last_date]);
134	joko	1.2	$max_idle_date = $last_date + $max_idle_time;
135	joko	1.5
136	joko	1.1	// check timeout
137	joko	1.2	if ($time_now > $max_idle_date) {
138	joko	1.5	// TODO: REVIEW (re-enable?)
139	joko	1.2	// throw user to (re)login-page
140	joko	1.5	// $site->redirect( getlink('/pub/login/') );
141	joko	1.3	$this->site->user->preLogout(1);
142			$this->site->request->overrideRequestIdentifier('/home/logout/');
143	joko	1.2	}
144	joko	1.5
145	joko	1.6	}
146
147
148			function get($attribute) {
149			global $sessionstate;
150			return $sessionstate[$attribute];
151			}
152
153			function set($attribute, $value) {
154			global $sessionstate;
155			$sessionstate[$attribute] = $value;
156			}
157	joko	1.1
158			}
159
160			?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26