From b1bd222cd5e89c1c77d671e20f14f8ff0e66b863 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 18 Dec 2009 11:47:47 +0300 Subject: [PATCH] mobile: implement flat list browsing mode --- mobile/functions.php | 62 +++++++++++++++++++++++++++++++++++++++++--- mobile/home.php | 8 +++++- mobile/index.php | 12 +++++++-- 3 files changed, 75 insertions(+), 7 deletions(-) diff --git a/mobile/functions.php b/mobile/functions.php index 790cf547..1806e0ed 100644 --- a/mobile/functions.php +++ b/mobile/functions.php @@ -1,5 +1,4 @@ 0; } + function render_flat_feed_list($link) { + $owner_uid = $_SESSION["uid"]; + + $result = db_query($link, "SELECT id, + title, + (SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries + WHERE feed_id = ttrss_feeds.id AND unread = true + AND ttrss_user_entries.ref_id = ttrss_entries.id + AND owner_uid = '$owner_uid') as unread + FROM ttrss_feeds + WHERE + ttrss_feeds.hidden = false AND + ttrss_feeds.owner_uid = '$owner_uid' AND + parent_feed IS NULL + ORDER BY unread DESC,title"); + + print '"; + + + + } + function render_category($link, $cat_id) { $owner_uid = $_SESSION["uid"]; @@ -223,10 +272,15 @@ $result = $qfh_ret[0]; $feed_title = $qfh_ret[1]; - $cat_title = getCategoryTitle($link, $cat_id); + if ($cat_id) { + $cat_title = getCategoryTitle($link, $cat_id); - print "