Changeset 8675 for trunk/src/bp-xprofile/bp-xprofile-functions.php

Timestamp:

07/23/2014 05:56:57 PM (12 years ago)

Author:

djpaul

Message:

Core: add new search_wildcard parameter to BP_User_Query.

This new parameter controls where BuddyPress places MySQL wildcard characters around the search term (when it's set).
Prior to this change, BuddyPress added a wildcard character to both ends of the search term, but for some use cases, a more restrictive search pattern is required; you can specify "left", "right", or "both" (the default) to pick where the wildcard is added.

Fixes #5769

File:

• trunk/src/bp-xprofile/bp-xprofile-functions.php (modified) (1 diff)

trunk/src/bp-xprofile/bp-xprofile-functions.php

@@ -596 +596 @@
         $search_terms_clean = esc_sql( esc_sql( $query->query_vars['search_terms'] ) );
 
+        if ( $query->query_vars['search_wildcard'] === 'left' ) {
+                $search_terms_clean = '%' . $search_terms_clean;
+        } elseif ( $query->query_vars['search_wildcard'] === 'right' ) {
+                $search_terms_clean = $search_terms_clean . '%';
+        } else {
+                $search_terms_clean = '%' . $search_terms_clean . '%';
+        }
+
         // Combine the core search (against wp_users) into a single OR clause
         // with the xprofile_data search
         $search_core     = $sql['where']['search'];
-        $search_xprofile = "u.{$query->uid_name} IN ( SELECT user_id FROM {$bp->profile->table_name_data} WHERE value LIKE '%{$search_terms_clean}%' )";
+        $search_xprofile = "u.{$query->uid_name} IN ( SELECT user_id FROM {$bp->profile->table_name_data} WHERE value LIKE '{$search_terms_clean}' )";
         $search_combined = "( {$search_xprofile} OR {$search_core} )";