From e51b9cb098592e48146d00b481abe4c6c51b8629 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 20 Jan 2009 10:48:10 +0100 Subject: [PATCH] disable searching by title --- modules/pref-feed-browser.php | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/modules/pref-feed-browser.php b/modules/pref-feed-browser.php index b73516ef..97fcda8f 100644 --- a/modules/pref-feed-browser.php +++ b/modules/pref-feed-browser.php @@ -127,18 +127,16 @@ if ($browser_search) { $search_qpart = " AND ( - UPPER(ttrss_feedbrowser_cache.feed_url) LIKE UPPER('%$browser_search%') OR - UPPER(title) LIKE UPPER('%$browser_search%'))"; + UPPER(ttrss_feedbrowser_cache.feed_url) LIKE UPPER('%$browser_search%'))"; + //UPPER(title) LIKE UPPER('%$browser_search%'))"; } else { $search_qpart = ""; } $result = db_query($link, "SELECT ttrss_feedbrowser_cache.feed_url, - subscribers, - title + subscribers FROM - ttrss_feedbrowser_cache LEFT JOIN ttrss_feeds - ON (ttrss_feedbrowser_cache.feed_url = ttrss_feeds.feed_url) + ttrss_feedbrowser_cache WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf WHERE tf.feed_url = ttrss_feedbrowser_cache.feed_url -- 2.39.5