From cc9450c309dbeedadaf23a8140520ab3726e3206 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 1 Dec 2017 19:42:02 +0300 Subject: ccache, misc: fixes feeds: start PDO transition --- classes/ccache.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'classes/ccache.php') diff --git a/classes/ccache.php b/classes/ccache.php index 0562c888c..9a6f14f3d 100644 --- 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]); -- cgit v1.2.3-54-g00ecf