Changeset 2951 for trunk/bp-core/bp-core-classes.php
- Timestamp:
- 04/24/2010 05:14:47 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/bp-core/bp-core-classes.php
r2925 r2951 125 125 $sql['from'] = "FROM " . CUSTOM_USER_TABLE . " u LEFT JOIN " . CUSTOM_USER_META_TABLE . " um ON um.user_id = u.ID"; 126 126 127 if ( $search_terms && bp_is_active( 'xprofile' ) || 'alphabetical' == $type )128 $sql['join_profiledata'] = "LEFT JOIN {$bp->profile->table_name_data} pd ON u.ID = pd.user_id";129 130 127 $sql['where'] = 'WHERE ' . bp_core_get_status_sql( 'u.' ); 131 128 … … 164 161 } 165 162 166 if ( $search_terms && bp_is_active( 'xprofile' )) {163 if ( $search_terms ) { 167 164 $search_terms = like_escape( $wpdb->escape( $search_terms ) ); 168 $sql['where_searchterms'] = "AND pd.value LIKE '%%$search_terms%%'";165 $sql['where_searchterms'] = "AND u.display_name LIKE '%%$search_terms%%'"; 169 166 } 170 167 … … 177 174 break; 178 175 case 'alphabetical': 179 $sql[] = "ORDER BY pd.value ASC";176 $sql[] = "ORDER BY u.display_name ASC"; 180 177 break; 181 178 case 'random':
Note: See TracChangeset
for help on using the changeset viewer.