db = new db; } catch (Exception $e) { $this->db = false; } $this->timeout = $session_timeout; } function set_timeout($session_timeout = 0) { $old_timeout = $this->timeout; $this->timeout = $session_timeout; return $old_timeout; } function set_permanent($value = false) { $this->permanent = $value; } function open ($save_path, $session_name) { return true; } function close () { if (!empty($this->session_array)) { $result = $this->gc(ini_get('session.gc_maxlifetime')); return $result; } return false; } function read ($session_id) { if($this->timeout > 0) { $rec = $this->db->queryOneRecord("SELECT * FROM sys_session WHERE session_id = ? AND (`permanent` = 'y' OR last_updated >= DATE_SUB(NOW(), INTERVAL ? MINUTE))", $session_id, $this->timeout); } else { $rec = $this->db->queryOneRecord("SELECT * FROM sys_session WHERE session_id = ?", $session_id); } if (is_array($rec)) { $this->session_array = $rec; return $this->session_array['session_data']; } else { return ''; } } function write ($session_id, $session_data) { if (!empty($this->session_array) && $this->session_array['session_id'] != $session_id) { $this->session_array = array(); } // Dont write session_data to DB if session data has not been changed after reading it. if(isset($this->session_array['session_data']) && $this->session_array['session_data'] != '' && $this->session_array['session_data'] == $session_data) { $this->db->query("UPDATE sys_session SET last_updated = NOW() WHERE session_id = ?", $session_id); return true; } if (@$this->session_array['session_id'] == '') { $sql = "REPLACE INTO sys_session (session_id,date_created,last_updated,session_data,permanent) VALUES (?,NOW(),NOW(),?,?)"; $this->db->query($sql, $session_id, $session_data, ($this->permanent ? 'y' : 'n')); } else { $sql = "UPDATE sys_session SET last_updated = NOW(), session_data = ?" . ($this->permanent ? ", `permanent` = 'y'" : "") . " WHERE session_id = ?"; $this->db->query($sql, $session_data, $session_id); } return true; } function destroy ($session_id) { $sql = "DELETE FROM sys_session WHERE session_id = ?"; $this->db->query($sql, $session_id); return true; } function gc ($max_lifetime) { $sql = "DELETE FROM sys_session WHERE last_updated < DATE_SUB(NOW(), INTERVAL ? SECOND) AND `permanent` != 'y'"; $this->db->query($sql, intval($max_lifetime)); /* delete very old even if they are permanent */ $sql = "DELETE FROM sys_session WHERE last_updated < DATE_SUB(NOW(), INTERVAL 1 YEAR)"; $this->db->query($sql); return true; } function __destruct () { @session_write_close(); } } ?>