0; } function render_flat_feed_list($link, $offset) { $owner_uid = $_SESSION["uid"]; $limit = 30; if (!$offset) $offset = 0; if (mobile_get_pref($link, "SORT_FEEDS_UNREAD")) { $order_by = "unread DESC, title"; } else { $order_by = "title"; } $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 $order_by LIMIT $limit OFFSET $offset"); if (!$offset) print '"; } function render_category($link, $cat_id) { $owner_uid = $_SESSION["uid"]; if ($cat_id >= 0) { if ($cat_id != 0) { $cat_query = "cat_id = '$cat_id'"; } else { $cat_query = "cat_id IS NULL"; } if (mobile_get_pref($link, "SORT_FEEDS_UNREAD")) { $order_by = "unread DESC, title"; } else { $order_by = "title"; } $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 AND $cat_query ORDER BY $order_by"); $title = getCategoryTitle($link, $cat_id); print ""; } else if ($cat_id == -1) { $title = __('Special'); print ""; } else if ($cat_id == -2) { $title = __('Labels'); print ""; } } function render_categories_list($link) { $owner_uid = $_SESSION["uid"]; print '"; } function render_headlines_list($link, $feed_id, $cat_id, $offset, $search) { $feed_id = $feed_id; $limit = 15; $filter = ''; $is_cat = false; $view_mode = 'adaptive'; if ($search) { $search_mode = 'this_feed'; $match_on = 'both'; } else { $search_mode = ''; $match_on = ''; } $qfh_ret = queryFeedHeadlines($link, $feed_id, $limit, $view_mode, $is_cat, $search, $search_mode, $match_on, false, $offset); $result = $qfh_ret[0]; $feed_title = $qfh_ret[1]; if (!$offset) { print "

Search

Cancel Search
"; if ($cat_id) { $cat_title = getCategoryTitle($link, $cat_id); print "