From 3261ca582066ea7f88e1a7745e4e8ccdf83056ab Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Fri, 5 Aug 2011 14:16:06 +0400
Subject: [PATCH] add ccache_cleanup(), invoke on login

---
 functions.php | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

diff --git a/functions.php b/functions.php
index 7cd509ae..0c581965 100644
--- a/functions.php
+++ b/functions.php
@@ -2149,6 +2149,9 @@
 					setcookie("ttrss_lang", $_SESSION["language"],
 						time() + SESSION_COOKIE_LIFETIME);
 				}
+
+				// try to remove possible duplicates from feed counter cache
+				ccache_cleanup($link, $_SESSION["uid"]);
 			}
 
 		} else {
@@ -6120,6 +6123,19 @@
 		return $unread;
 	}
 
+	function ccache_cleanup($link, $owner_uid) {
+
+		db_query($link, "DELETE FROM ttrss_counters_cache AS c1 WHERE
+			(SELECT count(*) FROM ttrss_counters_cache AS c2
+				WHERE c1.feed_id = c2.feed_id AND c2.owner_uid = c1.owner_uid) > 1
+				AND owner_uid = '$owner_uid'");
+
+		db_query($link, "DELETE FROM ttrss_cat_counters_cache AS c1 WHERE
+			(SELECT count(*) FROM ttrss_cat_counters_cache AS c2
+				WHERE c1.feed_id = c2.feed_id AND c2.owner_uid = c1.owner_uid) > 1
+					AND owner_uid = '$owner_uid'");
+	}
+
 	function label_find_id($link, $label, $owner_uid) {
 		$result = db_query($link,
 			"SELECT id FROM ttrss_labels2 WHERE caption = '$label'
-- 
2.39.5