Changeset 1007 for trunk/include/functions_session.inc.php
- Timestamp:
- Jan 18, 2006, 4:16:30 PM (18 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/functions_session.inc.php
r1004 r1007 26 26 // +-----------------------------------------------------------------------+ 27 27 28 if (isset($conf['session_save_handler']) and ($conf['session_save_handler'] == 'db')) { 28 if (isset($conf['session_save_handler']) 29 and ($conf['session_save_handler'] == 'db')) 30 { 29 31 session_set_save_handler('pwg_session_open', 30 31 32 33 34 35 32 'pwg_session_close', 33 'pwg_session_read', 34 'pwg_session_write', 35 'pwg_session_destroy', 36 'pwg_session_gc' 37 ); 36 38 } 37 38 ini_set('session.use_cookies', $conf['session_use_cookies']); 39 ini_set('session.use_only_cookies', $conf['session_use_only_cookies']); 40 ini_set('session.use_trans_sid', $conf['session_use_trans_sid']); 41 ini_set('session.name', $conf['session_name']); 39 if (isset($conf['session_use_cookies'])) 40 { 41 ini_set('session.use_cookies', $conf['session_use_cookies']); 42 } 43 if (isset($conf['session_use_only_cookies'])) 44 { 45 ini_set('session.use_only_cookies', $conf['session_use_only_cookies']); 46 } 47 if (isset($conf['session_use_trans_sid'])) 48 { 49 ini_set('session.use_trans_sid', intval($conf['session_use_trans_sid'])); 50 } 51 if (isset($conf['session_name'])) 52 { 53 ini_set('session.name', $conf['session_name']); 54 } 42 55 43 56 function pwg_session_open($path, $name) … … 54 67 function pwg_session_read($session_id) 55 68 { 56 $query = "SELECT data FROM " . SESSIONS_TABLE; 57 $query .= " WHERE id = '$session_id'"; 69 $query = ' 70 SELECT data FROM '.SESSIONS_TABLE.' 71 WHERE id = \''.$session_id.'\''; 58 72 $result = pwg_query($query); 59 if ($result) { 73 if ($result) 74 { 60 75 $row = mysql_fetch_assoc($result); 61 76 return $row['data']; 62 } else { 77 } 78 else 79 { 63 80 return ''; 64 81 } … … 67 84 function pwg_session_write($session_id, $data) 68 85 { 69 $query = "SELECT id FROM " . SESSIONS_TABLE; 70 $query .= " WHERE id = '$session_id'"; 86 $query = ' 87 SELECT id FROM '.SESSIONS_TABLE.' 88 WHERE id = \''.$session_id.'\''; 71 89 $result = pwg_query($query); 72 if (mysql_num_rows($result)) { 73 $query = "UPDATE " . SESSIONS_TABLE . " SET expiration = now()"; 74 $query .= " WHERE id = '$session_id'"; 90 if (mysql_num_rows($result)) 91 { 92 $query = ' 93 UPDATE '.SESSIONS_TABLE.' SET expiration = now() 94 WHERE id = \''.$session_id.'\''; 75 95 pwg_query($query); 76 } else { 77 $query = "INSERT INTO " . SESSIONS_TABLE . " (id,data,expiration)"; 78 $query .= " VALUES('$session_id','$data',now())"; 96 } 97 else 98 { 99 $query = ' 100 INSERT INTO '.SESSIONS_TABLE.'(id,data,expiration) 101 VALUES(\''.$session_id.'\',\''.$data.'\',now())'; 79 102 pwg_query($query); 80 103 } … … 84 107 function pwg_session_destroy($session_id) 85 108 { 86 $query = "DELETE FROM " . SESSIONS_TABLE; 87 $query .= " WHERE id = '$session_id'"; 109 $query = ' 110 DELETE FROM '.SESSIONS_TABLE.' 111 WHERE id = '.$session_id; 88 112 pwg_query($query); 89 113 return true; … … 94 118 global $conf; 95 119 96 $query = "DELETE FROM " . SESSIONS_TABLE; 97 $query .= " WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(expiration) > " . $conf['session_length']; 120 $query = ' 121 DELETE FROM '.SESSIONS_TABLE.' 122 WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(expiration) > ' 123 .$conf['session_length']; 98 124 pwg_query($query); 99 125 return true;
Note: See TracChangeset
for help on using the changeset viewer.