summaryrefslogtreecommitdiff
path: root/backend.php
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-11-18 14:37:16 +0100
committerAndrew Dolgov <[email protected]>2005-11-18 14:37:16 +0100
commitb88917afd43c2ea34554f00128e0d5ece9f4d4cc (patch)
tree8dc4bda7e543fb13522ee3b23d9627129c31b7ee /backend.php
parent69919a243e5ead1e86f975627c3f63deffd64837 (diff)
misc uid-awareness bugfixes in getFeedCounters and outputFeedList
Diffstat (limited to 'backend.php')
-rw-r--r--backend.php7
1 files changed, 4 insertions, 3 deletions
diff --git a/backend.php b/backend.php
index 36d1a66ee..4b10cbdbf 100644
--- a/backend.php
+++ b/backend.php
@@ -125,7 +125,7 @@
$result = db_query($link, "SELECT id,
(SELECT count(id) FROM ttrss_entries WHERE feed_id = ttrss_feeds.id
- AND unread = true) as count
+ AND unread = true AND owner_uid = ".$_SESSION["uid"].") as count
FROM ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"]);
while ($line = db_fetch_assoc($result)) {
@@ -212,9 +212,10 @@
$result = db_query($link, "SELECT *,
(SELECT count(id) FROM ttrss_entries
- WHERE feed_id = ttrss_feeds.id) AS total,
+ WHERE feed_id = ttrss_feeds.id AND owner_uid = '$owner_uid') AS total,
(SELECT count(id) FROM ttrss_entries
- WHERE feed_id = ttrss_feeds.id AND unread = true) as unread
+ WHERE feed_id = ttrss_feeds.id AND unread = true
+ AND owner_uid = '$owner_uid') as unread
FROM ttrss_feeds WHERE owner_uid = '$owner_uid' ORDER BY title");
$actid = $_GET["actid"];