diff options
author | Andrew Dolgov <[email protected]> | 2009-01-20 10:43:45 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-20 10:43:45 +0100 |
commit | 76e9a473d1d2152ef8a3b1ebe905f6f36a73c887 (patch) | |
tree | adee76e6256feb16b64b6fee41402c9dfcd7756e /modules | |
parent | 467ff402100df1b90c9abf443e3e7cf8041bbaae (diff) |
feed browser: search
Diffstat (limited to 'modules')
-rw-r--r-- | modules/pref-feed-browser.php | 44 |
1 files changed, 38 insertions, 6 deletions
diff --git a/modules/pref-feed-browser.php b/modules/pref-feed-browser.php index 91df4264c..b73516ef8 100644 --- a/modules/pref-feed-browser.php +++ b/modules/pref-feed-browser.php @@ -84,6 +84,14 @@ $limit = db_escape_string($_GET["limit"]); + $browser_search = db_escape_string($_GET["search"]); + + if (array_key_exists("search", $_GET)) { + $_SESSION["prefs_browser_search"] = $browser_search; + } else { + $browser_search = $_SESSION["prefs_browser_search"]; + } + if (!$limit) $limit = 25; $owner_uid = $_SESSION["uid"]; @@ -108,12 +116,36 @@ print "<div class=\"insensitive\">".__('This panel shows feeds subscribed by other users of this system, just in case you are interested in them too.')."</div>"; - - $result = db_query($link, "SELECT feed_url, subscribers FROM - ttrss_feedbrowser_cache WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf - WHERE tf.feed_url = ttrss_feedbrowser_cache.feed_url - AND owner_uid = '$owner_uid') ORDER BY subscribers DESC LIMIT $limit"); - + print "<p> + <input id=\"feed_browser_search\" size=\"20\" type=\"search\" + onfocus=\"javascript:disableHotkeys();\" + onblur=\"javascript:enableHotkeys();\" + onchange=\"javascript:updateBigFeedBrowserBtn()\" value=\"$browser_search\"> + <input type=\"submit\" class=\"button\" + onclick=\"javascript:updateBigFeedBrowserBtn()\" value=\"".__('Search')."\"> + </p>"; + + if ($browser_search) { + $search_qpart = " AND ( + UPPER(ttrss_feedbrowser_cache.feed_url) LIKE UPPER('%$browser_search%') OR + UPPER(title) LIKE UPPER('%$browser_search%'))"; + } else { + $search_qpart = ""; + } + + $result = db_query($link, "SELECT ttrss_feedbrowser_cache.feed_url, + subscribers, + title + FROM + ttrss_feedbrowser_cache LEFT JOIN ttrss_feeds + ON (ttrss_feedbrowser_cache.feed_url = ttrss_feeds.feed_url) + WHERE + (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf + WHERE tf.feed_url = ttrss_feedbrowser_cache.feed_url + AND owner_uid = '$owner_uid') + $search_qpart + ORDER BY subscribers DESC LIMIT $limit"); + print "<br/>"; print "<div style=\"float : right\"> |