]>
Commit | Line | Data |
---|---|---|
23f36f75 | 1 | <?php |
a42c55f0 | 2 | function make_feed_browser($search, $limit, $mode = 1) { |
55c7f092 | 3 | |
0e653f75 AK |
4 | if (defined('_DISABLE_FEED_BROWSER') && _DISABLE_FEED_BROWSER) return; |
5 | ||
55c7f092 AD |
6 | $owner_uid = $_SESSION["uid"]; |
7 | $rv = ''; | |
8 | ||
9 | if ($search) { | |
10 | $search_qpart = "AND (UPPER(feed_url) LIKE UPPER('%$search%') OR | |
11 | UPPER(title) LIKE UPPER('%$search%'))"; | |
12 | } else { | |
13 | $search_qpart = ""; | |
14 | } | |
15 | ||
16 | if ($mode == 1) { | |
a42c55f0 | 17 | /* $result = db_query("SELECT feed_url, subscribers FROM |
55c7f092 AD |
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"); */ | |
22 | ||
a42c55f0 | 23 | $result = db_query("SELECT feed_url, site_url, title, SUM(subscribers) AS subscribers FROM |
55c7f092 AD |
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 | |
26 | WHERE | |
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"); | |
31 | ||
32 | } else if ($mode == 2) { | |
a42c55f0 | 33 | $result = db_query("SELECT *, |
55c7f092 AD |
34 | (SELECT COUNT(*) FROM ttrss_user_entries WHERE |
35 | orig_feed_id = ttrss_archived_feeds.id) AS articles_archived | |
36 | FROM | |
37 | ttrss_archived_feeds | |
38 | WHERE | |
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"); | |
44 | } | |
45 | ||
46 | $feedctr = 0; | |
47 | ||
48 | while ($line = db_fetch_assoc($result)) { | |
49 | ||
50 | if ($mode == 1) { | |
51 | ||
52 | $feed_url = htmlspecialchars($line["feed_url"]); | |
53 | $site_url = htmlspecialchars($line["site_url"]); | |
54 | $subscribers = $line["subscribers"]; | |
55 | ||
56 | $check_box = "<input onclick='toggleSelectListRow2(this)' | |
57 | dojoType=\"dijit.form.CheckBox\" | |
58 | type=\"checkbox\" \">"; | |
59 | ||
60 | $class = ($feedctr % 2) ? "even" : "odd"; | |
61 | ||
62 | $site_url = "<a target=\"_blank\" | |
63 | href=\"$site_url\"> | |
64 | <span class=\"fb_feedTitle\">". | |
65 | htmlspecialchars($line["title"])."</span></a>"; | |
66 | ||
67 | $feed_url = "<a target=\"_blank\" class=\"fb_feedUrl\" | |
4a80c57c | 68 | href=\"$feed_url\"><img src='images/pub_set.png' |
55c7f092 AD |
69 | style='vertical-align : middle'></a>"; |
70 | ||
71 | $rv .= "<li>$check_box $feed_url $site_url". | |
72 | " <span class='subscribers'>($subscribers)</span></li>"; | |
73 | ||
74 | } else if ($mode == 2) { | |
75 | $feed_url = htmlspecialchars($line["feed_url"]); | |
76 | $site_url = htmlspecialchars($line["site_url"]); | |
55c7f092 AD |
77 | |
78 | $check_box = "<input onclick='toggleSelectListRow2(this)' dojoType=\"dijit.form.CheckBox\" | |
79 | type=\"checkbox\">"; | |
80 | ||
81 | $class = ($feedctr % 2) ? "even" : "odd"; | |
82 | ||
83 | if ($line['articles_archived'] > 0) { | |
967f0619 | 84 | $archived = sprintf(_ngettext("%d archived article", "%d archived articles", (int) $line['articles_archived']), $line['articles_archived']); |
55c7f092 AD |
85 | $archived = " <span class='subscribers'>($archived)</span>"; |
86 | } else { | |
87 | $archived = ''; | |
88 | } | |
89 | ||
90 | $site_url = "<a target=\"_blank\" | |
91 | href=\"$site_url\"> | |
92 | <span class=\"fb_feedTitle\">". | |
93 | htmlspecialchars($line["title"])."</span></a>"; | |
94 | ||
95 | $feed_url = "<a target=\"_blank\" class=\"fb_feedUrl\" | |
4a80c57c | 96 | href=\"$feed_url\"><img src='images/pub_set.png' |
55c7f092 AD |
97 | style='vertical-align : middle'></a>"; |
98 | ||
99 | ||
100 | $rv .= "<li id=\"FBROW-".$line["id"]."\">". | |
101 | "$check_box $feed_url $site_url $archived</li>"; | |
102 | } | |
103 | ||
104 | ++$feedctr; | |
105 | } | |
106 | ||
107 | if ($feedctr == 0) { | |
108 | $rv .= "<li style=\"text-align : center\"><p>".__('No feeds found.')."</p></li>"; | |
109 | } | |
110 | ||
111 | return $rv; | |
112 | } | |
113 | ?> |