.
*
* ------------------------------------------------------------------------
* DESCRIPTION:
* ------------------------------------------------------------------------
* This library tells the PHP4 session handler to write to a MySQL database
* instead of creating individual files for each session.
*
* Create a new database in MySQL called "sessions" like so:
*
* CREATE TABLE `sessions` (
* `sesskey` varchar(32) NOT NULL default '',
* `expiry` int(11) unsigned NOT NULL default '0',
* `lastused` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
* `value` text NOT NULL,
* UNIQUE KEY `sesskey` (`sesskey`),
* )
*
* ------------------------------------------------------------------------
* USAGE:
* ------------------------------------------------------------------------
* Include this file in your scripts before you call session_start(), you
* don't have to do anything special after that.
*
*/
$SESS_DBHOST = DBHOST; /* database server hostname */
$SESS_DBNAME = DATABASE; /* database name */
$SESS_DBUSER = DBUSER; /* database user */
$SESS_DBPASS = DBPASS; /* database password */
$SESS_DBH = "";
$SESS_LIFE = get_cfg_var("session.gc_maxlifetime");
$SESS_LOCK = '';
function sess_open($save_path, $session_name) {
global $SESS_DBHOST, $SESS_DBNAME, $SESS_DBUSER, $SESS_DBPASS, $SESS_DBH;
if (! $SESS_DBH = mysql_connect($SESS_DBHOST, $SESS_DBUSER, $SESS_DBPASS)) {
echo "Can't connect to $SESS_DBHOST as $SESS_DBUSER";
echo "MySQL Error: ", mysql_error();
die;
}
if (! mysql_select_db($SESS_DBNAME, $SESS_DBH)) {
echo "Unable to select database $SESS_DBNAME";
die;
}
return true;
}
function sess_close() {
global $SESS_LOCK;
$qid = mysql_query("select release_lock('$SESS_LOCK')");
mysql_free_result($qid);
return true;
}
function sess_read($key) {
global $SESS_DBH, $SESS_LIFE, $SESS_LOCK;
$SESS_LOCK = mysql_real_escape_string('sess_'.$key, $SESS_DBH);
$qid = mysql_query("select get_lock('$SESS_LOCK', 60)");
$ret = mysql_fetch_row($qid);
mysql_free_result($qid);
if (!isset($ret[0])) {
echo "unable to obtain session lock ($SESS_LOCK)";
die;
}
$qry = "SELECT value FROM sessions WHERE sesskey = '$key'";
$qid = mysql_query($qry, $SESS_DBH);
$ret = mysql_fetch_row($qid);
mysql_free_result($qid);
if (list($value) = $ret) {
$ret = $value;
} else {
$ret = '';
}
return $ret;
}
function sess_write($key, $val) {
global $SESS_DBH, $SESS_LIFE;
$expiry = time() + $SESS_LIFE;
$value = mysql_real_escape_string($val, $SESS_DBH);
$x = isset($_SESSION['sessid']) ? intval($_SESSION['sessid']) : 0;
$qry = "REPLACE INTO sessions (sesskey, expiry, value) VALUES ('$key', $expiry, '$value')";
$success = mysql_query($qry, $SESS_DBH);
return $success;
}
function sess_destroy($key) {
global $SESS_DBH;
$qry = "DELETE FROM sessions WHERE sesskey = '$key'";
$success = mysql_query($qry, $SESS_DBH);
return $success;
}
function sess_gc($maxlifetime) {
global $SESS_DBH;
$qry = "DELETE FROM sessions WHERE expiry < " . time();
$qid = mysql_query($qry, $SESS_DBH);
return mysql_affected_rows($SESS_DBH);
}
session_set_save_handler(
"sess_open",
"sess_close",
"sess_read",
"sess_write",
"sess_destroy",
"sess_gc");
?>