sessions.php

   1 <?
   2         // Original from http://www.daniweb.com/code/snippet43.html
   3
   4         require_once "config.php";
   5         require_once "db.php";
   6
   7         $session_expire = SESSION_EXPIRE_TIME; //seconds
   8
   9         ini_set("session.gc_probability", 50);
  10         ini_set("session.name", "ttrss_sid");
  11         ini_set("session.use_only_cookies", true);
  12         ini_set("session.gc_maxlifetime", SESSION_EXPIRE_TIME);
  13
  14         function open ($s, $n) {
  15
  16                 global $session_connection;
  17
  18                 $session_connection = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  19
  20                 return true;
  21         }
  22
  23         function read ($id){
  24
  25                 global $session_connection,$session_read;
  26
  27                 $query = "SELECT data FROM ttrss_sessions WHERE id='$id' $address_check_qpart";
  28
  29                 $res = db_query($session_connection, $query);
  30
  31                 if (db_num_rows($res) != 1) {
  32                         return "";
  33                 } else {
  34                         $session_read = db_fetch_assoc($res);
  35                         $session_read["data"] = base64_decode($session_read["data"]);
  36                         return $session_read["data"];
  37                 }
  38         }
  39
  40         function write ($id, $data) {
  41
  42                 if (! $data) {
  43                         return false;
  44                 }
  45
  46                 global $session_connection, $session_read, $session_expire;
  47
  48                 $expire = time() + $session_expire;
  49
  50                 $data = db_escape_string(base64_encode($data), $session_connection);
  51
  52                 if ($session_read) {
  53                         $query = "UPDATE ttrss_sessions SET data='$data',
  54                                         expire='$expire' WHERE id='$id' $address_check_qpart";
  55                 } else {
  56                         $query = "INSERT INTO ttrss_sessions (id, data, expire)
  57                                         VALUES ('$id', '$data', '$expire')";
  58                 }
  59
  60                 db_query($session_connection, $query);
  61                 return true;
  62         }
  63
  64         function close () {
  65
  66                 global $session_connection;
  67
  68                 db_close($session_connection);
  69
  70                 return true;
  71         }
  72
  73         function destroy ($id) {
  74
  75                 global $session_connection;
  76
  77                 $query = "DELETE FROM ttrss_sessions WHERE id = '$id' $address_check_qpart";
  78
  79                 db_query($session_connection, $query);
  80
  81                 return true;
  82         }
  83
  84         function gc ($expire) {
  85
  86                 global $session_connection;
  87
  88                 $query = "DELETE FROM ttrss_sessions WHERE expire < " . time();
  89
  90                 db_query($session_connection, $query);
  91         }
  92
  93 //      session_set_cookie_params(SESSION_COOKIE_LIFETIME);
  94
  95         if (DATABASE_BACKED_SESSIONS) {
  96                 session_set_save_handler("open", "close", "read", "write", "destroy", "gc");
  97         }
  98
  99         session_start();
 100 ?>