| commit | author | age | ||
| 4e17e6 | 1 | <?php |
| T | 2 | |
| 3 | /* | |
| 4 | +-----------------------------------------------------------------------+ | |
| 5 | | program/include/session.inc | | |
| 6 | | | | |
| 7 | | This file is part of the RoundCube Webmail client | | |
| 8 | | Copyright (C) 2005, RoundCube Dev, - Switzerland | | |
| 30233b | 9 | | Licensed under the GNU GPL | |
| 4e17e6 | 10 | | | |
| T | 11 | | PURPOSE: | |
| 12 | | Provide database supported session management | | |
| 13 | | | | |
| 14 | +-----------------------------------------------------------------------+ | |
| 15 | | Author: Thomas Bruederli <roundcube@gmail.com> | | |
| 16 | +-----------------------------------------------------------------------+ | |
| 17 | ||
| 18 | $Id$ | |
| 19 | ||
| 20 | */ | |
| 21 | ||
| 22 | ||
| 23 | function sess_open($save_path, $session_name) | |
| 24 | { | |
| 25 | return TRUE; | |
| 26 | } | |
| 27 | ||
| 28 | ||
| 29 | ||
| 30 | function sess_close() | |
| 31 | { | |
| 32 | return TRUE; | |
| 33 | } | |
| 34 | ||
| 35 | ||
| 36 | // read session data | |
| 37 | function sess_read($key) | |
| 38 | { | |
| 39 | global $DB, $SESS_CHANGED; | |
| 40 | ||
| d7cb77 | 41 | $sql_result = $DB->query("SELECT vars, ip, ".$DB->unixtimestamp('changed')." AS changed |
| S | 42 | FROM ".get_table_name('session')." |
| 43 | WHERE sess_id=?", | |
| 44 | $key); | |
| 4e17e6 | 45 | |
| T | 46 | if ($sql_arr = $DB->fetch_assoc($sql_result)) |
| 47 | { | |
| e170b4 | 48 | $SESS_CHANGED = $sql_arr['changed']; |
| 4e17e6 | 49 | |
| T | 50 | if (strlen($sql_arr['vars'])) |
| 51 | return $sql_arr['vars']; | |
| 52 | } | |
| 53 | ||
| 54 | return FALSE; | |
| 55 | } | |
| 56 | ||
| 57 | ||
| 58 | // save session data | |
| 59 | function sess_write($key, $vars) | |
| 60 | { | |
| 61 | global $DB; | |
| 1cded8 | 62 | |
| d7cb77 | 63 | $sql_result = $DB->query("SELECT 1 |
| S | 64 | FROM ".get_table_name('session')." |
| 65 | WHERE sess_id=?", | |
| 66 | $key); | |
| 4e17e6 | 67 | |
| T | 68 | if ($DB->num_rows($sql_result)) |
| 69 | { | |
| 70 | session_decode($vars); | |
| d7cb77 | 71 | $DB->query("UPDATE ".get_table_name('session')." |
| S | 72 | SET vars=?, |
| 107bde | 73 | changed=".$DB->now()." |
| d7cb77 | 74 | WHERE sess_id=?", |
| S | 75 | $vars, |
| 76 | $key); | |
| 4e17e6 | 77 | } |
| T | 78 | else |
| 79 | { | |
| d7cb77 | 80 | $DB->query("INSERT INTO ".get_table_name('session')." |
| S | 81 | (sess_id, vars, ip, created, changed) |
| 107bde | 82 | VALUES (?, ?, ?, ".$DB->now().", ".$DB->now().")", |
| d7cb77 | 83 | $key, |
| S | 84 | $vars, |
| 85 | $_SERVER['REMOTE_ADDR']); | |
| 1cded8 | 86 | |
| T | 87 | |
| 4e17e6 | 88 | } |
| T | 89 | |
| 90 | return TRUE; | |
| 91 | } | |
| 92 | ||
| 93 | ||
| 94 | // handler for session_destroy() | |
| 95 | function sess_destroy($key) | |
| 96 | { | |
| 97 | global $DB; | |
| 98 | ||
| d7cb77 | 99 | // delete session entries in cache table |
| S | 100 | $DB->query("DELETE FROM ".get_table_name('cache')." |
| 101 | WHERE session_id=?", | |
| 102 | $key); | |
| 103 | ||
| 104 | $DB->query("DELETE FROM ".get_table_name('session')." | |
| 105 | WHERE sess_id=?", | |
| 106 | $key); | |
| 1cded8 | 107 | |
| 4e17e6 | 108 | return TRUE; |
| T | 109 | } |
| 110 | ||
| 111 | ||
| 112 | // garbage collecting function | |
| 113 | function sess_gc($maxlifetime) | |
| 114 | { | |
| 115 | global $DB; | |
| 116 | ||
| 117 | // get all expired sessions | |
| d7cb77 | 118 | $sql_result = $DB->query("SELECT sess_id |
| S | 119 | FROM ".get_table_name('session')." |
| 107bde | 120 | WHERE ".$DB->unixtimestamp($DB->now())."-".$DB->unixtimestamp('changed')." > ?", |
| d7cb77 | 121 | $maxlifetime); |
| 4e17e6 | 122 | |
| T | 123 | $a_exp_sessions = array(); |
| 124 | while ($sql_arr = $DB->fetch_assoc($sql_result)) | |
| 125 | $a_exp_sessions[] = $sql_arr['sess_id']; | |
| 126 | ||
| 127 | ||
| 128 | if (sizeof($a_exp_sessions)) | |
| 129 | { | |
| d7cb77 | 130 | // delete session cache records |
| S | 131 | $DB->query("DELETE FROM ".get_table_name('cache')." |
| 132 | WHERE session_id IN ('".join("','", $a_exp_sessions)."')"); | |
| 133 | ||
| 4e17e6 | 134 | // delete session records |
| d7cb77 | 135 | $DB->query("DELETE FROM ".get_table_name('session')." |
| S | 136 | WHERE sess_id IN ('".join("','", $a_exp_sessions)."')"); |
| 4e17e6 | 137 | } |
| T | 138 | |
| cc9570 | 139 | // also run message cache GC |
| T | 140 | rcmail_message_cache_gc(); |
| 70d4b9 | 141 | rcmail_temp_gc(); |
| cc9570 | 142 | |
| 4e17e6 | 143 | return TRUE; |
| T | 144 | } |
| 145 | ||
| 146 | ||
| 147 | // set custom functions for PHP session management | |
| 148 | session_set_save_handler('sess_open', 'sess_close', 'sess_read', 'sess_write', 'sess_destroy', 'sess_gc'); | |
| 149 | ||
| 150 | ?> | |
