diff options
author | Andrew Dolgov <[email protected]> | 2005-12-29 15:10:03 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-12-29 15:10:03 +0100 |
commit | 11de82c37d385a85033d21f239a8865171405403 (patch) | |
tree | d5e417f190155e56831619443f95e4a8b85adb1f /backend.php | |
parent | 798f722b017aea45da7ecf14b266884ad838840e (diff) |
cache db-prefs (reset on preferences -> save), misc query optimizations
Diffstat (limited to 'backend.php')
-rw-r--r-- | backend.php | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/backend.php b/backend.php index ca31162dc..0efb48273 100644 --- a/backend.php +++ b/backend.php @@ -1914,8 +1914,8 @@ $_SESSION["pref_sort_feeds"] = $feeds_sort; if ($feed_search) { - $search_qpart = "(UPPER(title) LIKE UPPER('%$feed_search%') OR - UPPER(feed_url) LIKE UPPER('%$feed_search%')) AND"; + $search_qpart = "(UPPER(F1.title) LIKE UPPER('%$feed_search%') OR + UPPER(F1.feed_url) LIKE UPPER('%$feed_search%')) AND"; } else { $search_qpart = ""; } @@ -2363,9 +2363,10 @@ ttrss_filter_types.description AS filter_type_descr, feed_id, ttrss_filter_actions.description AS action_description, - (SELECT title FROM ttrss_feeds WHERE id = feed_id) AS feed_title + ttrss_feeds.title AS feed_title FROM - ttrss_filters,ttrss_filter_types,ttrss_filter_actions + ttrss_filters,ttrss_filter_types,ttrss_filter_actions LEFT JOIN + ttrss_feeds ON (feed_id = ttrss_feeds.id) WHERE filter_type = ttrss_filter_types.id AND ttrss_filter_actions.id = action_id AND @@ -2995,6 +2996,8 @@ $_SESSION["prefs_op_result"] = "save-config"; + $_SESSION["prefs_cache"] = false; + foreach (array_keys($_POST) as $pref_name) { $pref_name = db_escape_string($pref_name); |