Changeset 5278 in subversion

Timestamp:

Sep 26, 2011 2:28:01 AM (20 months ago)

Author:

thomasb

Message:

Add method to remove outdated cache entries from sql DB

File:

• trunk/roundcubemail/program/include/rcube_cache.php (modified) (2 diffs)

trunk/roundcubemail/program/include/rcube_cache.php

@@ -29 +29 @@
  * @author     Thomas Bruederli <roundcube@gmail.com>
  * @author     Aleksander Machniak <alec@alec.pl>
- * @version    1.0
+ * @version    1.1
  */
 class rcube_cache
@@ -189 +189 @@
 
     /**
+     * Remove cache records older than ttl
+     */
+    function expunge()
+    {
+        if ($this->type == 'db' && $this->db) {
+            $this->db->query(
+                "DELETE FROM ".get_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.
      */