Changeset 8675 for trunk/src/bp-xprofile/bp-xprofile-functions.php
- Timestamp:
- 07/23/2014 05:56:57 PM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/bp-xprofile/bp-xprofile-functions.php
r8672 r8675 596 596 $search_terms_clean = esc_sql( esc_sql( $query->query_vars['search_terms'] ) ); 597 597 598 if ( $query->query_vars['search_wildcard'] === 'left' ) { 599 $search_terms_clean = '%' . $search_terms_clean; 600 } elseif ( $query->query_vars['search_wildcard'] === 'right' ) { 601 $search_terms_clean = $search_terms_clean . '%'; 602 } else { 603 $search_terms_clean = '%' . $search_terms_clean . '%'; 604 } 605 598 606 // Combine the core search (against wp_users) into a single OR clause 599 607 // with the xprofile_data search 600 608 $search_core = $sql['where']['search']; 601 $search_xprofile = "u.{$query->uid_name} IN ( SELECT user_id FROM {$bp->profile->table_name_data} WHERE value LIKE ' %{$search_terms_clean}%' )";609 $search_xprofile = "u.{$query->uid_name} IN ( SELECT user_id FROM {$bp->profile->table_name_data} WHERE value LIKE '{$search_terms_clean}' )"; 602 610 $search_combined = "( {$search_xprofile} OR {$search_core} )"; 603 611
Note: See TracChangeset
for help on using the changeset viewer.