diff options
author | Andrew Dolgov <[email protected]> | 2018-12-09 04:32:51 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2018-12-09 04:32:51 +0300 |
commit | 4743da4638347bdeafa0eb44c86148d129547970 (patch) | |
tree | 2831e5ccebef52c5289fc4685ebddacd13425959 /classes/counters.php | |
parent | c8253f0e64e117c69ef52f140478bbade3ea7c0d (diff) | |
parent | 9545fc6c84ba123a8bb72a1ffb1425c7e5f1d620 (diff) |
Merge branch 'master' of git.tt-rss.org:fox/tt-rss
Diffstat (limited to 'classes/counters.php')
-rw-r--r-- | classes/counters.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/classes/counters.php b/classes/counters.php index 2de7d5a3a..cee901304 100644 --- a/classes/counters.php +++ b/classes/counters.php @@ -24,11 +24,11 @@ class Counters { $pdo = DB::pdo(); - $sth = $pdo->prepare("SELECT id AS cat_id, value AS unread, + $sth = $pdo->prepare("SELECT ttrss_feed_categories.id AS cat_id, value AS unread, (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE c2.parent_cat = ttrss_feed_categories.id) AS num_children FROM ttrss_feed_categories, ttrss_cat_counters_cache - WHERE ttrss_cat_counters_cache.feed_id = id AND + WHERE ttrss_cat_counters_cache.feed_id = ttrss_feed_categories.id AND ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid AND ttrss_feed_categories.owner_uid = ?"); $sth->execute([$_SESSION['uid']]); @@ -172,7 +172,7 @@ class Counters { FROM ttrss_feeds, ttrss_counters_cache WHERE ttrss_feeds.owner_uid = ? AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid - AND ttrss_counters_cache.feed_id = id"); + AND ttrss_counters_cache.feed_id = ttrss_feeds.id"); $sth->execute([$_SESSION['uid']]); while ($line = $sth->fetch()) { |