From b1b1d25f50f6d4df0cea2aaf20f08944563d6e58 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 22 Mar 2013 10:24:30 +0400 Subject: [PATCH] remove obsolete entries from ccache on login --- include/functions.php | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/include/functions.php b/include/functions.php index 238ba012..355fcd32 100644 --- 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"); + } + } } -- 2.39.5