Changeset 2052 for branches/1.1/bp-core/bp-core-classes.php

Timestamp:

10/22/2009 05:06:04 PM (15 years ago)

Author:

apeatling

Message:

Fixes #1223 props DJPaul

File:

• branches/1.1/bp-core/bp-core-classes.php (modified) (2 diffs)

branches/1.1/bp-core/bp-core-classes.php

@@ -220 +220 @@
             return false;
         
-        like_escape( $wpdb->escape( $letter ) );
+        $letter = like_escape( $wpdb->escape( $letter ) );
 
         $total_users_sql = apply_filters( 'bp_core_users_by_letter_count_sql', $wpdb->prepare( "SELECT DISTINCT count(u.ID) FROM " . CUSTOM_USER_TABLE . " u LEFT JOIN {$bp->profile->table_name_data} pd ON u.ID = pd.user_id LEFT JOIN {$bp->profile->table_name_fields} pf ON pd.field_id = pf.id WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND pf.name = %s AND pd.value LIKE '$letter%%' ORDER BY pd.value ASC", BP_XPROFILE_FULLNAME_FIELD_NAME ), $letter );
@@ -240 +240 @@
             $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) );
         
-        like_escape( $wpdb->escape( $search_terms ) );  
+        $search_terms = like_escape( $wpdb->escape( $search_terms ) );  
 
         $total_users_sql = apply_filters( 'bp_core_search_users_count_sql', "SELECT DISTINCT count(u.ID) as user_id FROM " . CUSTOM_USER_TABLE . " u LEFT JOIN {$bp->profile->table_name_data} pd ON u.ID = pd.user_id WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND pd.value LIKE '%%$search_terms%%' ORDER BY pd.value ASC", $search_terms );