]>
Commit | Line | Data |
---|---|---|
36bfab86 AD |
1 | <? |
2 | // Original from http://www.daniweb.com/code/snippet43.html | |
3 | ||
4 | require_once "config.php"; | |
5 | require_once "db.php"; | |
6 | ||
898a9cdb | 7 | $session_expire = SESSION_EXPIRE_TIME; //seconds |
36bfab86 AD |
8 | |
9 | ini_set("session.gc_probability", 50); | |
8fd92701 | 10 | ini_set("session.name", "ttrss_sid"); |
c5466b7f | 11 | ini_set("session.use_only_cookies", true); |
36bfab86 AD |
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 | ||
09018e95 | 26 | $query = "SELECT data FROM ttrss_sessions WHERE id='$id' $address_check_qpart"; |
36bfab86 AD |
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', | |
09018e95 | 53 | expire='$expire' WHERE id='$id' $address_check_qpart"; |
36bfab86 | 54 | } else { |
a2e9b457 AD |
55 | $query = "INSERT INTO ttrss_sessions (id, data, expire) |
56 | VALUES ('$id', '$data', '$expire')"; | |
36bfab86 AD |
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; | |
09018e95 | 75 | |
09018e95 | 76 | $query = "DELETE FROM ttrss_sessions WHERE id = '$id' $address_check_qpart"; |
36bfab86 AD |
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 | ||
5ccc1cf5 | 92 | // session_set_cookie_params(SESSION_COOKIE_LIFETIME); |
686c3ccf | 93 | |
8fd92701 | 94 | if (DATABASE_BACKED_SESSIONS) { |
c5466b7f | 95 | session_set_save_handler("open", "close", "read", "write", "destroy", "gc"); |
8fd92701 AD |
96 | } |
97 | ||
36bfab86 AD |
98 | session_start(); |
99 | ?> |