diff options
author | Andrew Dolgov <[email protected]> | 2006-08-13 13:01:10 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-08-13 13:01:10 +0100 |
commit | 0da49badd4ff20af850874539a7dda44fcc79e96 (patch) | |
tree | dddaa5f08fd3668fc07209e0044d21f65c37800e /mobile | |
parent | 7da377ca8b4668d3e21339531b1ba5d8518b9740 (diff) |
handle hidden feed attribute, fix broken mobile version
Diffstat (limited to 'mobile')
-rw-r--r-- | mobile/functions.php | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/mobile/functions.php b/mobile/functions.php index df48456b1..29db101ca 100644 --- a/mobile/functions.php +++ b/mobile/functions.php @@ -68,12 +68,13 @@ error_reporting (0); - $tmp_result = db_query($link, "SELECT count(id) as count - FROM ttrss_entries,ttrss_user_entries + $tmp_result = db_query($link, "SELECT count(ttrss_entries.id) as count + FROM ttrss_entries,ttrss_user_entries,ttrss_feeds WHERE (" . $line["sql_exp"] . ") AND unread = true AND - ttrss_user_entries.ref_id = ttrss_entries.id - AND owner_uid = '$owner_uid'"); - + ttrss_user_entries.ref_id = ttrss_entries.id AND + ttrss_user_entries.feed_id = ttrss_feeds.id + AND ttrss_user_entries.owner_uid = '$owner_uid'"); + $count = db_fetch_result($tmp_result, 0, "count"); $class = "label"; @@ -104,6 +105,7 @@ } $result = db_query($link, "SELECT ttrss_feeds.*, + SUBSTRING(last_updated,1,19) AS last_updated_noms, (SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries WHERE feed_id = ttrss_feeds.id AND ttrss_user_entries.ref_id = ttrss_entries.id AND @@ -118,6 +120,7 @@ FROM ttrss_feeds LEFT JOIN ttrss_feed_categories ON (ttrss_feed_categories.id = cat_id) WHERE + ttrss_feeds.hidden = false AND ttrss_feeds.owner_uid = '$owner_uid' AND parent_feed IS NULL ORDER BY $order_by_qpart"); |