add ccache_cleanup(), invoke on login

1 files changed, 16 insertions, 0 deletions

diff --git a/functions.php b/functions.php
index 7cd509ae7..0c5819656 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'