diff options
author | Andrew Dolgov <[email protected]> | 2009-01-20 09:21:05 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-20 09:21:05 +0100 |
commit | ddb0a9a80a550019612c4b8ae1dac525c7a7c375 (patch) | |
tree | 67b54f87f71ea227368418365331fd8934fe0d8a | |
parent | 7e19c446bbdc9b4a31889238847bd7c96e766a22 (diff) |
UNDO: tmp fix for label counters calculation being wrong when hidden feeds are present
-rw-r--r-- | functions.php | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/functions.php b/functions.php index f11b91b7d..428d628d9 100644 --- a/functions.php +++ b/functions.php @@ -2644,15 +2644,22 @@ $owner_uid = $_SESSION["uid"]; - $result = db_query($link, "SELECT id, caption FROM ttrss_labels2 - WHERE owner_uid = '$owner_uid'"); + $result = db_query($link, + "SELECT ttrss_labels2.id, caption, COUNT(unread) AS unread FROM ttrss_labels2 + LEFT JOIN ttrss_user_labels2 ON (label_id = ttrss_labels2.id) + LEFT JOIN ttrss_user_entries ON (ref_id = article_id AND + unread = true AND + ttrss_user_entries.owner_uid = '$owner_uid') + LEFT JOIN ttrss_feeds ON (ttrss_feeds.id = feed_id AND hidden = false) + WHERE ttrss_labels2.owner_uid = '$owner_uid' + GROUP BY ttrss_labels2.id, caption"); while ($line = db_fetch_assoc($result)) { $id = -$line["id"] - 11; $label_name = $line["caption"]; - $count = getFeedUnread($link, $id); + $count = $line["unread"]; if (!$smart_mode || $old_counters[$id] != $count) { $old_counters[$id] = $count; |