]>
git.wh0rd.org - tt-rss.git/blob - include/feedbrowser.php
2 function make_feed_browser($search, $limit, $mode = 1) {
4 if (defined('_DISABLE_FEED_BROWSER') && _DISABLE_FEED_BROWSER
) return;
6 $owner_uid = $_SESSION["uid"];
10 $search_qpart = "AND (UPPER(feed_url) LIKE UPPER('%$search%') OR
11 UPPER(title) LIKE UPPER('%$search%'))";
17 /* $result = db_query("SELECT feed_url, subscribers FROM
18 ttrss_feedbrowser_cache WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf
19 WHERE tf.feed_url = ttrss_feedbrowser_cache.feed_url
20 AND owner_uid = '$owner_uid') $search_qpart
21 ORDER BY subscribers DESC LIMIT $limit"); */
23 $result = db_query("SELECT feed_url, site_url, title, SUM(subscribers) AS subscribers FROM
24 (SELECT feed_url, site_url, title, subscribers FROM ttrss_feedbrowser_cache UNION ALL
25 SELECT feed_url, site_url, title, subscribers FROM ttrss_linked_feeds) AS qqq
27 (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf
28 WHERE tf.feed_url = qqq.feed_url
29 AND owner_uid = '$owner_uid') $search_qpart
30 GROUP BY feed_url, site_url, title ORDER BY subscribers DESC LIMIT $limit");
32 } else if ($mode == 2) {
33 $result = db_query("SELECT *,
34 (SELECT COUNT(*) FROM ttrss_user_entries WHERE
35 orig_feed_id = ttrss_archived_feeds.id) AS articles_archived
39 (SELECT COUNT(*) FROM ttrss_feeds
40 WHERE ttrss_feeds.feed_url = ttrss_archived_feeds.feed_url AND
41 owner_uid = '$owner_uid') = 0 AND
42 owner_uid = '$owner_uid' $search_qpart
43 ORDER BY id DESC LIMIT $limit");
48 while ($line = db_fetch_assoc($result)) {
52 $feed_url = htmlspecialchars($line["feed_url"]);
53 $site_url = htmlspecialchars($line["site_url"]);
54 $subscribers = $line["subscribers"];
56 $check_box = "<input onclick='toggleSelectListRow2(this)'
57 dojoType=\"dijit.form.CheckBox\"
58 type=\"checkbox\" \">";
60 $class = ($feedctr %
2) ?
"even" : "odd";
62 $site_url = "<a target=\"_blank\"
64 <span class=\"fb_feedTitle\">".
65 htmlspecialchars($line["title"])."</span></a>";
67 $feed_url = "<a target=\"_blank\" class=\"fb_feedUrl\"
68 href=\"$feed_url\"><img src='images/pub_set.png'
69 style='vertical-align : middle'></a>";
71 $rv .= "<li>$check_box $feed_url $site_url".
72 " <span class='subscribers'>($subscribers)</span></li>";
74 } else if ($mode == 2) {
75 $feed_url = htmlspecialchars($line["feed_url"]);
76 $site_url = htmlspecialchars($line["site_url"]);
78 $check_box = "<input onclick='toggleSelectListRow2(this)' dojoType=\"dijit.form.CheckBox\"
81 $class = ($feedctr %
2) ?
"even" : "odd";
83 if ($line['articles_archived'] > 0) {
84 $archived = sprintf(_ngettext("%d archived article", "%d archived articles", $line['articles_archived']), $line['articles_archived']);
85 $archived = " <span class='subscribers'>($archived)</span>";
90 $site_url = "<a target=\"_blank\"
92 <span class=\"fb_feedTitle\">".
93 htmlspecialchars($line["title"])."</span></a>";
95 $feed_url = "<a target=\"_blank\" class=\"fb_feedUrl\"
96 href=\"$feed_url\"><img src='images/pub_set.png'
97 style='vertical-align : middle'></a>";
100 $rv .= "<li id=\"FBROW-".$line["id"]."\">".
101 "$check_box $feed_url $site_url $archived</li>";
108 $rv .= "<li style=\"text-align : center\"><p>".__('No feeds found.')."</p></li>";