| | |
| | | <?php |
| | | |
| | | /* |
| | | /** |
| | | +-----------------------------------------------------------------------+ |
| | | | This file is part of the Roundcube Webmail client | |
| | | | Copyright (C) 2005-2012, The Roundcube Dev Team | |
| | |
| | | */ |
| | | class rcube_imap_cache |
| | | { |
| | | const MODE_INDEX = 1; |
| | | const MODE_MESSAGE = 2; |
| | | |
| | | /** |
| | | * Instance of rcube_imap |
| | | * |
| | |
| | | private $ttl; |
| | | |
| | | /** |
| | | * Maximum cached message size |
| | | * |
| | | * @var int |
| | | */ |
| | | private $threshold; |
| | | |
| | | /** |
| | | * Internal (in-memory) cache |
| | | * |
| | | * @var array |
| | |
| | | private $icache = array(); |
| | | |
| | | private $skip_deleted = false; |
| | | private $mode; |
| | | |
| | | /** |
| | | * List of known flags. Thanks to this we can handle flag changes |
| | |
| | | * @param int $userid User identifier |
| | | * @param bool $skip_deleted skip_deleted flag |
| | | * @param string $ttl Expiration time of memcache/apc items |
| | | * |
| | | * @param int $threshold Maximum cached message size |
| | | */ |
| | | function __construct($db, $imap, $userid, $skip_deleted, $ttl=0) |
| | | function __construct($db, $imap, $userid, $skip_deleted, $ttl=0, $threshold=0) |
| | | { |
| | | // convert ttl string to seconds |
| | | $ttl = get_offset_sec($ttl); |
| | |
| | | $this->userid = $userid; |
| | | $this->skip_deleted = $skip_deleted; |
| | | $this->ttl = $ttl; |
| | | } |
| | | $this->threshold = $threshold; |
| | | |
| | | // cache all possible information by default |
| | | $this->mode = self::MODE_INDEX | self::MODE_MESSAGE; |
| | | |
| | | // database tables |
| | | $this->index_table = $db->table_name('cache_index', true); |
| | | $this->thread_table = $db->table_name('cache_thread', true); |
| | | $this->messages_table = $db->table_name('cache_messages', true); |
| | | } |
| | | |
| | | /** |
| | | * Cleanup actions (on shutdown). |
| | |
| | | $this->icache = null; |
| | | } |
| | | |
| | | /** |
| | | * Set cache mode |
| | | * |
| | | * @param int $mode Cache mode |
| | | */ |
| | | public function set_mode($mode) |
| | | { |
| | | $this->mode = $mode; |
| | | } |
| | | |
| | | /** |
| | | * Return (sorted) messages index (UIDs). |
| | |
| | | // Seek in internal cache |
| | | if (array_key_exists('index', $this->icache[$mailbox])) { |
| | | // The index was fetched from database already, but not validated yet |
| | | if (!array_key_exists('object', $this->icache[$mailbox]['index'])) { |
| | | if (empty($this->icache[$mailbox]['index']['validated'])) { |
| | | $index = $this->icache[$mailbox]['index']; |
| | | } |
| | | // We've got a valid index |
| | |
| | | } |
| | | |
| | | $this->icache[$mailbox]['index'] = array( |
| | | 'validated' => true, |
| | | 'object' => $data, |
| | | 'sort_field' => $sort_field, |
| | | 'modseq' => !empty($index['modseq']) ? $index['modseq'] : $mbox_data['HIGHESTMODSEQ'] |
| | |
| | | |
| | | return $data; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Return messages thread. |
| | |
| | | return $index['object']; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Returns list of messages (headers). See rcube_imap::fetch_headers(). |
| | | * |
| | |
| | | return array(); |
| | | } |
| | | |
| | | // Fetch messages from cache |
| | | $sql_result = $this->db->query( |
| | | "SELECT uid, data, flags" |
| | | ." FROM ".$this->db->table_name('cache_messages') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?" |
| | | ." AND uid IN (".$this->db->array2list($msgs, 'integer').")", |
| | | $this->userid, $mailbox); |
| | | |
| | | $msgs = array_flip($msgs); |
| | | $result = array(); |
| | | |
| | | while ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | | $uid = intval($sql_arr['uid']); |
| | | $result[$uid] = $this->build_message($sql_arr); |
| | | if ($this->mode & self::MODE_MESSAGE) { |
| | | // Fetch messages from cache |
| | | $sql_result = $this->db->query( |
| | | "SELECT `uid`, `data`, `flags`" |
| | | ." FROM {$this->messages_table}" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?" |
| | | ." AND `uid` IN (".$this->db->array2list($msgs, 'integer').")", |
| | | $this->userid, $mailbox); |
| | | |
| | | if (!empty($result[$uid])) { |
| | | // save memory, we don't need message body here (?) |
| | | $result[$uid]->body = null; |
| | | $msgs = array_flip($msgs); |
| | | |
| | | unset($msgs[$uid]); |
| | | while ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | | $uid = intval($sql_arr['uid']); |
| | | $result[$uid] = $this->build_message($sql_arr); |
| | | |
| | | if (!empty($result[$uid])) { |
| | | // save memory, we don't need message body here (?) |
| | | $result[$uid]->body = null; |
| | | |
| | | unset($msgs[$uid]); |
| | | } |
| | | } |
| | | |
| | | $msgs = array_flip($msgs); |
| | | } |
| | | |
| | | // Fetch not found messages from IMAP server |
| | | if (!empty($msgs)) { |
| | | $messages = $this->imap->fetch_headers($mailbox, array_keys($msgs), false, true); |
| | | $messages = $this->imap->fetch_headers($mailbox, $msgs, false, true); |
| | | |
| | | // Insert to DB and add to result list |
| | | if (!empty($messages)) { |
| | | foreach ($messages as $msg) { |
| | | $this->add_message($mailbox, $msg, !array_key_exists($msg->uid, $result)); |
| | | if ($this->mode & self::MODE_MESSAGE) { |
| | | $this->add_message($mailbox, $msg, !array_key_exists($msg->uid, $result)); |
| | | } |
| | | |
| | | $result[$msg->uid] = $msg; |
| | | } |
| | | } |
| | |
| | | |
| | | return $result; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Returns message data. |
| | |
| | | return $this->icache['__message']['object']; |
| | | } |
| | | |
| | | $sql_result = $this->db->query( |
| | | "SELECT flags, data" |
| | | ." FROM ".$this->db->table_name('cache_messages') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?" |
| | | ." AND uid = ?", |
| | | $this->userid, $mailbox, (int)$uid); |
| | | if ($this->mode & self::MODE_MESSAGE) { |
| | | $sql_result = $this->db->query( |
| | | "SELECT `flags`, `data`" |
| | | ." FROM {$this->messages_table}" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?" |
| | | ." AND `uid` = ?", |
| | | $this->userid, $mailbox, (int)$uid); |
| | | |
| | | if ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | | $message = $this->build_message($sql_arr); |
| | | $found = true; |
| | | if ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | | $message = $this->build_message($sql_arr); |
| | | $found = true; |
| | | } |
| | | } |
| | | |
| | | // Get the message from IMAP server |
| | | if (empty($message) && $update) { |
| | | $message = $this->imap->get_message_headers($uid, $mailbox, true); |
| | | // cache will be updated in close(), see below |
| | | } |
| | | |
| | | if (!($this->mode & self::MODE_MESSAGE)) { |
| | | return $message; |
| | | } |
| | | |
| | | // Save the message in internal cache, will be written to DB in close() |
| | |
| | | return $message; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Saves the message in cache. |
| | | * |
| | |
| | | function add_message($mailbox, $message, $force = false) |
| | | { |
| | | if (!is_object($message) || empty($message->uid)) { |
| | | return; |
| | | } |
| | | |
| | | if (!($this->mode & self::MODE_MESSAGE)) { |
| | | return; |
| | | } |
| | | |
| | |
| | | // here will work as select, assume row exist if affected_rows=0) |
| | | if (!$force) { |
| | | $res = $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_messages') |
| | | ." SET flags = ?, data = ?, expires = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?" |
| | | ." AND uid = ?", |
| | | "UPDATE {$this->messages_table}" |
| | | ." SET `flags` = ?, `data` = ?, `expires` = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?" |
| | | ." AND `uid` = ?", |
| | | $flags, $msg, $this->userid, $mailbox, (int) $message->uid); |
| | | |
| | | if ($this->db->affected_rows($res)) { |
| | |
| | | |
| | | // insert new record |
| | | $res = $this->db->query( |
| | | "INSERT INTO ".$this->db->table_name('cache_messages') |
| | | ." (user_id, mailbox, uid, flags, expires, data)" |
| | | "INSERT INTO {$this->messages_table}" |
| | | ." (`user_id`, `mailbox`, `uid`, `flags`, `expires`, `data`)" |
| | | ." VALUES (?, ?, ?, ?, ". ($this->ttl ? $this->db->now($this->ttl) : 'NULL') . ", ?)", |
| | | $this->userid, $mailbox, (int) $message->uid, $flags, $msg); |
| | | |
| | |
| | | // thanks to ignore_key_errors "duplicate row" errors will be ignored |
| | | if ($force && !$res && !$this->db->is_error($res)) { |
| | | $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_messages') |
| | | ." SET expires = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | .", flags = ?, data = ?" |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?" |
| | | ." AND uid = ?", |
| | | "UPDATE {$this->messages_table}" |
| | | ." SET `expires` = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | .", `flags` = ?, `data` = ?" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?" |
| | | ." AND `uid` = ?", |
| | | $flags, $msg, $this->userid, $mailbox, (int) $message->uid); |
| | | } |
| | | |
| | | $this->db->set_option('ignore_key_errors', false); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Sets the flag for specified message. |
| | |
| | | function change_flag($mailbox, $uids, $flag, $enabled = false) |
| | | { |
| | | if (empty($uids)) { |
| | | return; |
| | | } |
| | | |
| | | if (!($this->mode & self::MODE_MESSAGE)) { |
| | | return; |
| | | } |
| | | |
| | |
| | | } |
| | | } |
| | | |
| | | $binary_check = $this->db->db_provider == 'oracle' ? "BITAND(`flags`, %d)" : "(`flags` & %d)"; |
| | | |
| | | $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_messages') |
| | | ." SET expires = ". ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | .", flags = flags ".($enabled ? "+ $idx" : "- $idx") |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?" |
| | | .(!empty($uids) ? " AND uid IN (".$this->db->array2list($uids, 'integer').")" : "") |
| | | ." AND (flags & $idx) ".($enabled ? "= 0" : "= $idx"), |
| | | "UPDATE {$this->messages_table}" |
| | | ." SET `expires` = ". ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | .", `flags` = `flags` ".($enabled ? "+ $idx" : "- $idx") |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?" |
| | | .(!empty($uids) ? " AND `uid` IN (".$this->db->array2list($uids, 'integer').")" : "") |
| | | ." AND " . sprintf($binary_check, $idx) . ($enabled ? " = 0" : " = $idx"), |
| | | $this->userid, $mailbox); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Removes message(s) from cache. |
| | |
| | | */ |
| | | function remove_message($mailbox = null, $uids = null) |
| | | { |
| | | if (!($this->mode & self::MODE_MESSAGE)) { |
| | | return; |
| | | } |
| | | |
| | | if (!strlen($mailbox)) { |
| | | $this->db->query( |
| | | "DELETE FROM ".$this->db->table_name('cache_messages') |
| | | ." WHERE user_id = ?", |
| | | "DELETE FROM {$this->messages_table}" |
| | | ." WHERE `user_id` = ?", |
| | | $this->userid); |
| | | } |
| | | else { |
| | |
| | | } |
| | | |
| | | $this->db->query( |
| | | "DELETE FROM ".$this->db->table_name('cache_messages') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?" |
| | | .($uids !== null ? " AND uid IN (".$this->db->array2list((array)$uids, 'integer').")" : ""), |
| | | "DELETE FROM {$this->messages_table}" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?" |
| | | .($uids !== null ? " AND `uid` IN (".$this->db->array2list((array)$uids, 'integer').")" : ""), |
| | | $this->userid, $mailbox); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Clears index cache. |
| | |
| | | // otherwise use 'valid' flag to not loose HIGHESTMODSEQ value |
| | | if ($remove) { |
| | | $this->db->query( |
| | | "DELETE FROM ".$this->db->table_name('cache_index') |
| | | ." WHERE user_id = ?" |
| | | .(strlen($mailbox) ? " AND mailbox = ".$this->db->quote($mailbox) : ""), |
| | | "DELETE FROM {$this->index_table}" |
| | | ." WHERE `user_id` = ?" |
| | | .(strlen($mailbox) ? " AND `mailbox` = ".$this->db->quote($mailbox) : ""), |
| | | $this->userid |
| | | ); |
| | | } |
| | | else { |
| | | $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_index') |
| | | ." SET valid = 0" |
| | | ." WHERE user_id = ?" |
| | | .(strlen($mailbox) ? " AND mailbox = ".$this->db->quote($mailbox) : ""), |
| | | "UPDATE {$this->index_table}" |
| | | ." SET `valid` = 0" |
| | | ." WHERE `user_id` = ?" |
| | | .(strlen($mailbox) ? " AND `mailbox` = ".$this->db->quote($mailbox) : ""), |
| | | $this->userid |
| | | ); |
| | | } |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Clears thread cache. |
| | | * |
| | |
| | | function remove_thread($mailbox = null) |
| | | { |
| | | $this->db->query( |
| | | "DELETE FROM ".$this->db->table_name('cache_thread') |
| | | ." WHERE user_id = ?" |
| | | .(strlen($mailbox) ? " AND mailbox = ".$this->db->quote($mailbox) : ""), |
| | | "DELETE FROM {$this->thread_table}" |
| | | ." WHERE `user_id` = ?" |
| | | .(strlen($mailbox) ? " AND `mailbox` = ".$this->db->quote($mailbox) : ""), |
| | | $this->userid |
| | | ); |
| | | |
| | |
| | | $this->icache = array(); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Clears the cache. |
| | |
| | | $this->remove_message($mailbox, $uids); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Delete expired cache entries |
| | | */ |
| | |
| | | { |
| | | $rcube = rcube::get_instance(); |
| | | $db = $rcube->get_dbh(); |
| | | $now = $db->now(); |
| | | |
| | | $db->query("DELETE FROM ".$db->table_name('cache_messages') |
| | | ." WHERE expires < " . $db->now()); |
| | | $db->query("DELETE FROM " . $db->table_name('cache_messages', true) |
| | | ." WHERE `expires` < $now"); |
| | | |
| | | $db->query("DELETE FROM ".$db->table_name('cache_index') |
| | | ." WHERE expires < " . $db->now()); |
| | | $db->query("DELETE FROM " . $db->table_name('cache_index', true) |
| | | ." WHERE `expires` < $now"); |
| | | |
| | | $db->query("DELETE FROM ".$db->table_name('cache_thread') |
| | | ." WHERE expires < " . $db->now()); |
| | | $db->query("DELETE FROM ".$db->table_name('cache_thread', true) |
| | | ." WHERE `expires` < $now"); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Fetches index data from database |
| | |
| | | { |
| | | // Get index from DB |
| | | $sql_result = $this->db->query( |
| | | "SELECT data, valid" |
| | | ." FROM ".$this->db->table_name('cache_index') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?", |
| | | "SELECT `data`, `valid`" |
| | | ." FROM {$this->index_table}" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?", |
| | | $this->userid, $mailbox); |
| | | |
| | | if ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | |
| | | return null; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Fetches thread data from database |
| | | */ |
| | |
| | | { |
| | | // Get thread from DB |
| | | $sql_result = $this->db->query( |
| | | "SELECT data" |
| | | ." FROM ".$this->db->table_name('cache_thread') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?", |
| | | "SELECT `data`" |
| | | ." FROM {$this->thread_table}" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?", |
| | | $this->userid, $mailbox); |
| | | |
| | | if ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | |
| | | return null; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Saves index data into database |
| | | */ |
| | |
| | | (int) $mbox_data['UIDNEXT'], |
| | | $modseq ? $modseq : $mbox_data['HIGHESTMODSEQ'], |
| | | ); |
| | | $data = implode('@', $data); |
| | | |
| | | $data = implode('@', $data); |
| | | $expires = $this->ttl ? $this->db->now($this->ttl) : 'NULL'; |
| | | |
| | | if ($exists) { |
| | | $res = $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_index') |
| | | ." SET data = ?, valid = 1, expires = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?", |
| | | "UPDATE {$this->index_table}" |
| | | ." SET `data` = ?, `valid` = 1, `expires` = $expires" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?", |
| | | $data, $this->userid, $mailbox); |
| | | |
| | | if ($this->db->affected_rows($res)) { |
| | |
| | | $this->db->set_option('ignore_key_errors', true); |
| | | |
| | | $res = $this->db->query( |
| | | "INSERT INTO ".$this->db->table_name('cache_index') |
| | | ." (user_id, mailbox, valid, expires, data)" |
| | | ." VALUES (?, ?, 1, ". ($this->ttl ? $this->db->now($this->ttl) : 'NULL') .", ?)", |
| | | "INSERT INTO {$this->index_table}" |
| | | ." (`user_id`, `mailbox`, `valid`, `expires`, `data`)" |
| | | ." VALUES (?, ?, 1, $expires, ?)", |
| | | $this->userid, $mailbox, $data); |
| | | |
| | | // race-condition, insert failed so try update (#1489146) |
| | | // thanks to ignore_key_errors "duplicate row" errors will be ignored |
| | | if (!$exists && !$res && !$this->db->is_error($res)) { |
| | | $res = $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_index') |
| | | ." SET data = ?, valid = 1, expires = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?", |
| | | "UPDATE {$this->index_table}" |
| | | ." SET `data` = ?, `valid` = 1, `expires` = $expires" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?", |
| | | $data, $this->userid, $mailbox); |
| | | } |
| | | |
| | | $this->db->set_option('ignore_key_errors', false); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Saves thread data into database |
| | |
| | | (int) $mbox_data['UIDVALIDITY'], |
| | | (int) $mbox_data['UIDNEXT'], |
| | | ); |
| | | $data = implode('@', $data); |
| | | |
| | | $expires = ($this->ttl ? $this->db->now($this->ttl) : 'NULL'); |
| | | $data = implode('@', $data); |
| | | $expires = $this->ttl ? $this->db->now($this->ttl) : 'NULL'; |
| | | |
| | | if ($exists) { |
| | | $res = $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_thread') |
| | | ." SET data = ?, expires = $expires" |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?", |
| | | "UPDATE {$this->thread_table}" |
| | | ." SET `data` = ?, `expires` = $expires" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?", |
| | | $data, $this->userid, $mailbox); |
| | | |
| | | if ($this->db->affected_rows($res)) { |
| | |
| | | $this->db->set_option('ignore_key_errors', true); |
| | | |
| | | $res = $this->db->query( |
| | | "INSERT INTO ".$this->db->table_name('cache_thread') |
| | | ." (user_id, mailbox, expires, data)" |
| | | "INSERT INTO {$this->thread_table}" |
| | | ." (`user_id`, `mailbox`, `expires`, `data`)" |
| | | ." VALUES (?, ?, $expires, ?)", |
| | | $this->userid, $mailbox, $data); |
| | | |
| | |
| | | // thanks to ignore_key_errors "duplicate row" errors will be ignored |
| | | if (!$exists && !$res && !$this->db->is_error($res)) { |
| | | $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_thread') |
| | | ." SET expires = $expires, data = ?" |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?", |
| | | "UPDATE {$this->thread_table}" |
| | | ." SET `expires` = $expires, `data` = ?" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?", |
| | | $data, $this->userid, $mailbox); |
| | | } |
| | | |
| | | $this->db->set_option('ignore_key_errors', false); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Checks index/thread validity |
| | |
| | | if (empty($object)) { |
| | | return false; |
| | | } |
| | | |
| | | $index['validated'] = true; |
| | | |
| | | // Get mailbox data (UIDVALIDITY, counters, etc.) for status check |
| | | $mbox_data = $this->imap->folder_data($mailbox); |
| | |
| | | return false; |
| | | } |
| | | // ... and max UID |
| | | if ($object->max() != $this->imap->id2uid($mbox_data['EXISTS'], $mailbox, true)) { |
| | | if ($object->max() != $this->imap->id2uid($mbox_data['EXISTS'], $mailbox)) { |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | return true; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Synchronizes the mailbox. |
| | |
| | | $removed = array(); |
| | | |
| | | // Get known UIDs |
| | | $sql_result = $this->db->query( |
| | | "SELECT uid" |
| | | ." FROM ".$this->db->table_name('cache_messages') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?", |
| | | $this->userid, $mailbox); |
| | | if ($this->mode & self::MODE_MESSAGE) { |
| | | $sql_result = $this->db->query( |
| | | "SELECT `uid`" |
| | | ." FROM {$this->messages_table}" |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?", |
| | | $this->userid, $mailbox); |
| | | |
| | | while ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | | $uids[] = $sql_arr['uid']; |
| | | while ($sql_arr = $this->db->fetch_assoc($sql_result)) { |
| | | $uids[] = $sql_arr['uid']; |
| | | } |
| | | } |
| | | |
| | | // Synchronize messages data |
| | |
| | | } |
| | | |
| | | $this->db->query( |
| | | "UPDATE ".$this->db->table_name('cache_messages') |
| | | ." SET flags = ?, expires = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | ." WHERE user_id = ?" |
| | | ." AND mailbox = ?" |
| | | ." AND uid = ?" |
| | | ." AND flags <> ?", |
| | | "UPDATE {$this->messages_table}" |
| | | ." SET `flags` = ?, `expires` = " . ($this->ttl ? $this->db->now($this->ttl) : 'NULL') |
| | | ." WHERE `user_id` = ?" |
| | | ." AND `mailbox` = ?" |
| | | ." AND `uid` = ?" |
| | | ." AND `flags` <> ?", |
| | | $flags, $this->userid, $mailbox, $uid, $flags); |
| | | } |
| | | } |
| | |
| | | $this->icache[$mailbox]['index']['object'] = $data; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Converts cache row into message object. |
| | | * |
| | |
| | | return $message; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Saves message stored in internal cache |
| | | */ |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Prepares message object to be stored in database. |
| | | * |
| | | * @param rcube_message_header|rcube_message_part |
| | | */ |
| | | private function message_object_prepare(&$msg) |
| | | private function message_object_prepare(&$msg, &$size = 0) |
| | | { |
| | | // Remove body too big (>25kB) |
| | | if ($msg->body && strlen($msg->body) > 25 * 1024) { |
| | | unset($msg->body); |
| | | // Remove body too big |
| | | if (isset($msg->body)) { |
| | | $length = strlen($msg->body); |
| | | |
| | | if ($msg->body_modified || $size + $length > $this->threshold * 1024) { |
| | | unset($msg->body); |
| | | } |
| | | else { |
| | | $size += $length; |
| | | } |
| | | } |
| | | |
| | | // Fix mimetype which might be broken by some code when message is displayed |
| | |
| | | |
| | | unset($msg->replaces); |
| | | |
| | | if (is_array($msg->structure->parts)) { |
| | | foreach ($msg->structure->parts as $part) { |
| | | $this->message_object_prepare($part); |
| | | } |
| | | if (is_object($msg->structure)) { |
| | | $this->message_object_prepare($msg->structure, $size); |
| | | } |
| | | |
| | | if (is_array($msg->parts)) { |
| | | foreach ($msg->parts as $part) { |
| | | $this->message_object_prepare($part); |
| | | $this->message_object_prepare($part, $size); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Fetches index data from IMAP server |
| | |
| | | return $index; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Fetches thread data from IMAP server |
| | | */ |
| | |
| | | |
| | | return new rcube_result_thread($mailbox, '* THREAD'); |
| | | } |
| | | |
| | | } |
| | | |
| | | // for backward compat. |