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