ccache, misc: fixes

[tt-rss.git] / classes / ccache.php

diff --git a/classes/ccache.php b/classes/ccache.php
index 0562c888c2d1f9e3bfbd56d61de22d4a458feeb0..9a6f14f3d867fad5f65d94fef0a549a339d95a47 100644 (file)
--- a/classes/ccache.php
+++ b/classes/ccache.php
@@ -118,7 +118,8 @@ class CCache {
 
                        if (!$pcat_fast) {
                                $sth = $pdo->prepare("SELECT id FROM ttrss_feeds
-                                               WHERE owner_uid = :uid AND cat_id = :cat OR (:cat = 0 AND cat_id IS NULL)");
+                                               WHERE owner_uid = :uid AND 
+                                                       (cat_id = :cat OR (:cat = 0 AND cat_id IS NULL))");
                                $sth->execute([":uid" => $owner_uid, ":cat" => $feed_id]);
 
                                while ($line = $sth->fetch()) {
@@ -129,7 +130,7 @@ class CCache {
                        $sth = $pdo->prepare("SELECT SUM(value) AS sv
                                FROM ttrss_counters_cache, ttrss_feeds
                                WHERE id = feed_id AND 
-                               cat_id = :cat OR (:cat IS NULL AND cat_id IS NULL) AND
+                               (cat_id = :cat OR (:cat = 0 AND cat_id IS NULL)) AND
                                ttrss_counters_cache.owner_uid = :uid AND
                                ttrss_feeds.owner_uid = :uid");
                        $sth->execute([":uid" => $owner_uid, ":cat" => $feed_id]);