| | |
| | | | This file is part of the Roundcube Webmail client | |
| | | | Copyright (C) 2011, The Roundcube Dev Team | |
| | | | Copyright (C) 2011, Kolab Systems AG | |
| | | | Licensed under the GNU GPL | |
| | | | | |
| | | | Licensed under the GNU General Public License version 3 or | |
| | | | any later version with exceptions for skins & plugins. | |
| | | | See the README file for a full license statement. | |
| | | | | |
| | | | PURPOSE: | |
| | | | Caching engine | |
| | |
| | | * @package Cache |
| | | * @author Thomas Bruederli <roundcube@gmail.com> |
| | | * @author Aleksander Machniak <alec@alec.pl> |
| | | * @version 1.0 |
| | | * @version 1.1 |
| | | */ |
| | | class rcube_cache |
| | | { |
| | |
| | | */ |
| | | function __construct($type, $userid, $prefix='', $ttl=0, $packed=true) |
| | | { |
| | | $rcmail = rcmail::get_instance(); |
| | | $rcmail = rcube::get_instance(); |
| | | $type = strtolower($type); |
| | | |
| | | if ($type == 'memcache') { |
| | |
| | | |
| | | |
| | | /** |
| | | * Remove cache records older than ttl |
| | | */ |
| | | function expunge() |
| | | { |
| | | if ($this->type == 'db' && $this->db) { |
| | | $this->db->query( |
| | | "DELETE FROM ".$this->db->table_name('cache'). |
| | | " WHERE user_id = ?". |
| | | " AND cache_key LIKE ?". |
| | | " AND " . $this->db->unixtimestamp('created')." < ?", |
| | | $this->userid, |
| | | $this->prefix.'.%', |
| | | time() - $this->ttl); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Writes the cache back to the DB. |
| | | */ |
| | | function close() |
| | |
| | | return null; |
| | | } |
| | | |
| | | if ($this->type == 'memcache') { |
| | | $data = $this->db->get($this->ckey($key)); |
| | | } |
| | | else if ($this->type == 'apc') { |
| | | $data = apc_fetch($this->ckey($key)); |
| | | } |
| | | |
| | | if ($data) { |
| | | $md5sum = md5($data); |
| | | $data = $this->packed ? unserialize($data) : $data; |
| | | |
| | | if ($nostore) { |
| | | return $data; |
| | | if ($this->type != 'db') { |
| | | if ($this->type == 'memcache') { |
| | | $data = $this->db->get($this->ckey($key)); |
| | | } |
| | | else if ($this->type == 'apc') { |
| | | $data = apc_fetch($this->ckey($key)); |
| | | } |
| | | |
| | | $this->cache_sums[$key] = $md5sum; |
| | | $this->cache[$key] = $data; |
| | | if ($data) { |
| | | $md5sum = md5($data); |
| | | $data = $this->packed ? unserialize($data) : $data; |
| | | |
| | | if ($nostore) { |
| | | return $data; |
| | | } |
| | | |
| | | $this->cache_sums[$key] = $md5sum; |
| | | $this->cache[$key] = $data; |
| | | } |
| | | else { |
| | | $this->cache[$key] = null; |
| | | } |
| | | } |
| | | |
| | | if ($this->type == 'db') { |
| | | else { |
| | | $sql_result = $this->db->limitquery( |
| | | "SELECT cache_id, data, cache_key". |
| | | " FROM ".get_table_name('cache'). |
| | | " FROM ".$this->db->table_name('cache'). |
| | | " WHERE user_id = ?". |
| | | " AND cache_key = ?". |
| | | // for better performance we allow more records for one key |
| | |
| | | $this->cache[$key] = $data; |
| | | $this->cache_sums[$key] = $md5sum; |
| | | $this->cache_keys[$key] = $sql_arr['cache_id']; |
| | | } |
| | | else { |
| | | $this->cache[$key] = null; |
| | | } |
| | | } |
| | | |
| | |
| | | // Remove NULL rows (here we don't need to check if the record exist) |
| | | if ($data == 'N;') { |
| | | $this->db->query( |
| | | "DELETE FROM ".get_table_name('cache'). |
| | | "DELETE FROM ".$this->db->table_name('cache'). |
| | | " WHERE user_id = ?". |
| | | " AND cache_key = ?", |
| | | $this->userid, $key); |
| | |
| | | // update existing cache record |
| | | if ($key_exists) { |
| | | $result = $this->db->query( |
| | | "UPDATE ".get_table_name('cache'). |
| | | "UPDATE ".$this->db->table_name('cache'). |
| | | " SET created = ". $this->db->now().", data = ?". |
| | | " WHERE user_id = ?". |
| | | " AND cache_key = ?", |
| | |
| | | // for better performance we allow more records for one key |
| | | // so, no need to check if record exist (see rcube_cache::read_record()) |
| | | $result = $this->db->query( |
| | | "INSERT INTO ".get_table_name('cache'). |
| | | "INSERT INTO ".$this->db->table_name('cache'). |
| | | " (created, user_id, cache_key, data)". |
| | | " VALUES (".$this->db->now().", ?, ?, ?)", |
| | | $this->userid, $key, $data); |
| | |
| | | } |
| | | |
| | | $this->db->query( |
| | | "DELETE FROM ".get_table_name('cache'). |
| | | "DELETE FROM ".$this->db->table_name('cache'). |
| | | " WHERE user_id = ?" . $where, |
| | | $this->userid); |
| | | } |