Changeset 28712 for trunk/src/wp-includes/query.php
- Timestamp:
- 06/10/2014 12:43:32 AM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/wp-includes/query.php
r28668 r28712 1984 1984 $q['search_orderby_title'] = array(); 1985 1985 foreach ( $q['search_terms'] as $term ) { 1986 $term = like_escape( esc_sql( $term ) ); 1987 if ( $n ) 1988 $q['search_orderby_title'][] = "$wpdb->posts.post_title LIKE '%$term%'"; 1989 1990 $search .= "{$searchand}(($wpdb->posts.post_title LIKE '{$n}{$term}{$n}') OR ($wpdb->posts.post_content LIKE '{$n}{$term}{$n}'))"; 1986 if ( $n ) { 1987 $like = '%' . $wpdb->esc_like( $term ) . '%'; 1988 $q['search_orderby_title'][] = $wpdb->prepare( "$wpdb->posts.post_title LIKE %s", $like ); 1989 } 1990 1991 $like = $n . $wpdb->esc_like( $term ) . $n; 1992 $search .= $wpdb->prepare( "{$searchand}(($wpdb->posts.post_title LIKE %s) OR ($wpdb->posts.post_content LIKE %s))", $like, $like ); 1991 1993 $searchand = ' AND '; 1992 1994 } … … 2087 2089 if ( $q['search_terms_count'] > 1 ) { 2088 2090 $num_terms = count( $q['search_orderby_title'] ); 2089 $ search_orderby_s = like_escape( esc_sql( $q['s'] ) );2091 $like = '%' . $wpdb->esc_like( $q['s'] ) . '%'; 2090 2092 2091 2093 $search_orderby = '(CASE '; 2092 2094 // sentence match in 'post_title' 2093 $search_orderby .= "WHEN $wpdb->posts.post_title LIKE '%{$search_orderby_s}%' THEN 1 ";2095 $search_orderby .= $wpdb->prepare( "WHEN $wpdb->posts.post_title LIKE %s THEN 1 ", $like ); 2094 2096 2095 2097 // sanity limit, sort as sentence when more than 6 terms … … 2104 2106 2105 2107 // sentence match in 'post_content' 2106 $search_orderby .= "WHEN $wpdb->posts.post_content LIKE '%{$search_orderby_s}%' THEN 4 ";2108 $search_orderby .= $wpdb->prepare( "WHEN $wpdb->posts.post_content LIKE %s THEN 4 ", $like ); 2107 2109 $search_orderby .= 'ELSE 5 END)'; 2108 2110 } else {
Note: See TracChangeset
for help on using the changeset viewer.