remove obsolete entries from ccache on login

[tt-rss.git] / include / functions.php

diff --git a/include/functions.php b/include/functions.php
index 238ba0121e8d51a6498684851e25c088b22cfa16..355fcd32ba7505f5b193e9a32634013f85e092ca 100644 (file)
--- a/include/functions.php
+++ b/include/functions.php
@@ -778,7 +778,21 @@
                        if ($_SESSION["uid"]) {
                                cache_prefs($link);
                                load_user_plugins($link, $_SESSION["uid"]);
+
+                               /* cleanup ccache */
+
+                               db_query($link, "DELETE FROM ttrss_counters_cache WHERE owner_uid = ".
+                                       $_SESSION["uid"] . " AND
+                                               (SELECT COUNT(id) FROM ttrss_feeds WHERE
+                                                       ttrss_feeds.id = feed_id) = 0");
+
+                               db_query($link, "DELETE FROM ttrss_cat_counters_cache WHERE owner_uid = ".
+                                       $_SESSION["uid"] . " AND
+                                               (SELECT COUNT(id) FROM ttrss_feed_categories WHERE
+                                                       ttrss_feed_categories.id = feed_id) = 0");
+
                        }
+
                }
        }