getCategoryCounters: fix broken psql syntax

[tt-rss.git] / functions.php

diff --git a/functions.php b/functions.php
index c84a7a7bf607563355dff0b8badbb8750260772a..ebd3cff1ada2dcf36c10252c99d6c23a75127068 100644 (file)
--- a/functions.php
+++ b/functions.php
@@ -2330,12 +2330,10 @@
 
                $age_qpart = getMaxAgeSubquery();
 
-               $result = db_query($link, "SELECT cat_id, value AS unread
-                       FROM ttrss_feeds, ttrss_cat_counters_cache
-                       WHERE 
-                               ttrss_cat_counters_cache.feed_id = cat_id AND
-                               hidden = false AND 
-                               ttrss_feeds.owner_uid = ".$_SESSION["uid"]);
+               $result = db_query($link, "SELECT id AS cat_id, value AS unread 
+                       FROM ttrss_feed_categories, ttrss_cat_counters_cache 
+                       WHERE ttrss_cat_counters_cache.feed_id = id AND 
+                       ttrss_feed_categories.owner_uid = " . $_SESSION["uid"]);
 
                while ($line = db_fetch_assoc($result)) {
                        $line["cat_id"] = sprintf("%d", $line["cat_id"]);