From 6080cca9ca1de60a5d4a1ef06d4873eca07d9ef2 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 24 Jan 2020 14:25:31 +0300 Subject: scrap counter cache system; rework counters to sum() booleans instead --- include/functions.php | 17 ----------------- 1 file changed, 17 deletions(-) (limited to 'include/functions.php') diff --git a/include/functions.php b/include/functions.php index 42b05ff15..ce8a07d51 100644 --- a/include/functions.php +++ b/include/functions.php @@ -731,24 +731,7 @@ if ($_SESSION["uid"]) { startup_gettext(); load_user_plugins($_SESSION["uid"]); - - /* cleanup ccache */ - - $sth = $pdo->prepare("DELETE FROM ttrss_counters_cache WHERE owner_uid = ? - AND - (SELECT COUNT(id) FROM ttrss_feeds WHERE - ttrss_feeds.id = feed_id) = 0"); - - $sth->execute([$_SESSION['uid']]); - - $sth = $pdo->prepare("DELETE FROM ttrss_cat_counters_cache WHERE owner_uid = ? - AND - (SELECT COUNT(id) FROM ttrss_feed_categories WHERE - ttrss_feed_categories.id = feed_id) = 0"); - - $sth->execute([$_SESSION['uid']]); } - } } -- cgit v1.2.3