1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| function mysql_session_open($path,$name) {
return true;
}
function mysql_session_close() {
return true;
}
function mysql_session_read($idsession) {
if ($dataread=mysql_query("SELECT data FROM cms_sessions WHERE idsession='". $idsession . "'")) {
if (mysql_fetch_array($dataread)) {
return $dataread['data'];
}
}
return "";
}
function mysql_session_write($idsession,$data) {
if ($dataselect=mysql_query("SELECT idss from cms_sessions where idsession='". $idsession ."'")) {
if (mysql_num_rows($dataselect)==0) {
if (mysql_query("INSERT INTO cms_sessions (idsession,data,firstconnect, lastconnect,ip) VALUES ('".$idsession."','".$data."',now(),now(),'".$_SERVER['REMOTE_ADDR']."')")) {
return true;
} else {
echo mysql_error();
return false;
}
} else {
if ($dataupdate=mysql_query("UPDATE cms_sessions SET data='".$data."',lastconnect=now() WHERE idsession='".$idsession ."'")) {
return true;
} else return false;
}
} else {
echo mysql_error();
return false;
}
}
function mysql_session_destroy($idsession) {
mysql_query("DELETE FROM cms_sessions WHERE where idsession='". $idsession ."'");
}
function mysql_session_garbage($lifetime) {
mysql_query("DELETE FROM cms_sessions WHERE DATE_ADD(lastconnect,INTERVAL 900 second)<now()");
}
session_set_save_handler('mysql_session_open','mysql_session_close','mysql_session_read','mysql_session_write','mysql_session_destroy','mysql_session_garbage');
session_start(); |
Partager