From 33373eca49e900a6bda23c45698ac2f1d4200f47 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 7 Apr 2013 08:43:51 +0400 Subject: [PATCH] getLabelCounters: properly check for user_entry uid (closes #671) --- include/functions.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/include/functions.php b/include/functions.php index 0469c512..f2d25db0 100644 --- a/include/functions.php +++ b/include/functions.php @@ -317,7 +317,7 @@ global $fetch_last_error; global $fetch_last_error_code; - + $url = str_replace(' ', '%20', $url); if (!defined('NO_CURL') && function_exists('curl_init') && !ini_get("open_basedir")) { @@ -1469,7 +1469,8 @@ $result = db_query($link, "SELECT id,caption,COUNT(unread) AS unread FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON (ttrss_labels2.id = label_id) - LEFT JOIN ttrss_user_entries ON (ref_id = article_id AND unread = true) + LEFT JOIN ttrss_user_entries ON (ref_id = article_id AND unread = true + AND ttrss_user_entries.owner_uid = $owner_uid) WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id, ttrss_labels2.caption"); -- 2.39.5