Changeset 5729 for trunk/bp-core/bp-core-classes.php
- Timestamp:
- 02/11/2012 09:32:04 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/bp-core/bp-core-classes.php
r5708 r5729 258 258 if ( !empty( $include ) ) { 259 259 if ( is_array( $include ) ) { 260 $uids = $wpdb->escape( implode( ',', (array) $include ) );260 $uids = $wpdb->escape( implode( ',', (array) $include ) ); 261 261 } else { 262 262 $uids = $wpdb->escape( $include ); … … 268 268 } elseif ( !empty( $user_id ) && bp_is_active( 'friends' ) ) { 269 269 $friend_ids = friends_get_friend_user_ids( $user_id ); 270 $friend_ids = $wpdb->escape( implode( ',', (array) $friend_ids ) );270 $friend_ids = $wpdb->escape( implode( ',', (array) $friend_ids ) ); 271 271 272 272 if ( !empty( $friend_ids ) ) { … … 316 316 317 317 // Get paginated results 318 $paged_users_sql = apply_filters( 'bp_core_get_paged_users_sql', join( ' ', (array) $sql ), $sql );318 $paged_users_sql = apply_filters( 'bp_core_get_paged_users_sql', join( ' ', (array) $sql ), $sql ); 319 319 $paged_users = $wpdb->get_results( $paged_users_sql ); 320 320 … … 341 341 342 342 // Get total user results 343 $total_users_sql = apply_filters( 'bp_core_get_total_users_sql', join( ' ', (array) $sql ), $sql );343 $total_users_sql = apply_filters( 'bp_core_get_total_users_sql', join( ' ', (array) $sql ), $sql ); 344 344 $total_users = $wpdb->get_var( $total_users_sql ); 345 345 … … 351 351 $user_ids = array(); 352 352 353 foreach ( (array) $paged_users as $user ) {353 foreach ( (array) $paged_users as $user ) { 354 354 $user_ids[] = $user->id; 355 355 } 356 356 357 $user_ids = $wpdb->escape( join( ',', (array) $user_ids ) );357 $user_ids = $wpdb->escape( join( ',', (array) $user_ids ) ); 358 358 359 359 // Add additional data to the returned results … … 416 416 */ 417 417 $user_ids = array(); 418 foreach ( (array) $paged_users as $user )418 foreach ( (array) $paged_users as $user ) 419 419 $user_ids[] = $user->id; 420 420 421 $user_ids = $wpdb->escape( join( ',', (array) $user_ids ) );421 $user_ids = $wpdb->escape( join( ',', (array) $user_ids ) ); 422 422 423 423 // Add additional data to the returned results … … 503 503 * We can't add these to the main query above since only users who have this information will be returned (since the much of the data is in usermeta and won't support any type of directional join) 504 504 */ 505 foreach ( (array) $paged_users as $user )505 foreach ( (array) $paged_users as $user ) 506 506 $user_ids[] = $user->id; 507 507 508 $user_ids = $wpdb->escape( join( ',', (array) $user_ids ) );508 $user_ids = $wpdb->escape( join( ',', (array) $user_ids ) ); 509 509 510 510 // Add additional data to the returned results … … 538 538 $names = $wpdb->get_results( $wpdb->prepare( "SELECT pd.user_id as id, pd.value as fullname FROM {$bp->profile->table_name_fields} pf, {$bp->profile->table_name_data} pd WHERE pf.id = pd.field_id AND pf.name = %s AND pd.user_id IN ( {$user_ids} )", bp_xprofile_fullname_field_name() ) ); 539 539 for ( $i = 0, $count = count( $paged_users ); $i < $count; ++$i ) { 540 foreach ( (array) $names as $name ) {540 foreach ( (array) $names as $name ) { 541 541 if ( $name->id == $paged_users[$i]->id ) 542 542 $paged_users[$i]->fullname = $name->fullname; … … 549 549 $friend_count = $wpdb->get_results( $wpdb->prepare( "SELECT user_id as id, meta_value as total_friend_count FROM {$wpdb->usermeta} WHERE meta_key = %s AND user_id IN ( {$user_ids} )", bp_get_user_meta_key( 'total_friend_count' ) ) ); 550 550 for ( $i = 0, $count = count( $paged_users ); $i < $count; ++$i ) { 551 foreach ( (array) $friend_count as $fcount ) {551 foreach ( (array) $friend_count as $fcount ) { 552 552 if ( $fcount->id == $paged_users[$i]->id ) 553 $paged_users[$i]->total_friend_count = (int) $fcount->total_friend_count;553 $paged_users[$i]->total_friend_count = (int) $fcount->total_friend_count; 554 554 } 555 555 } … … 560 560 $friend_status = $wpdb->get_results( $wpdb->prepare( "SELECT initiator_user_id, friend_user_id, is_confirmed FROM {$bp->friends->table_name} WHERE (initiator_user_id = %d AND friend_user_id IN ( {$user_ids} ) ) OR (initiator_user_id IN ( {$user_ids} ) AND friend_user_id = %d )", bp_loggedin_user_id(), bp_loggedin_user_id() ) ); 561 561 for ( $i = 0, $count = count( $paged_users ); $i < $count; ++$i ) { 562 foreach ( (array) $friend_status as $status ) {562 foreach ( (array) $friend_status as $status ) { 563 563 if ( $status->initiator_user_id == $paged_users[$i]->id || $status->friend_user_id == $paged_users[$i]->id ) 564 564 $paged_users[$i]->is_friend = $status->is_confirmed; … … 570 570 $user_activity = $wpdb->get_results( $wpdb->prepare( "SELECT user_id as id, meta_value as last_activity FROM {$wpdb->usermeta} WHERE meta_key = %s AND user_id IN ( {$user_ids} )", bp_get_user_meta_key( 'last_activity' ) ) ); 571 571 for ( $i = 0, $count = count( $paged_users ); $i < $count; ++$i ) { 572 foreach ( (array) $user_activity as $activity ) {572 foreach ( (array) $user_activity as $activity ) { 573 573 if ( $activity->id == $paged_users[$i]->id ) 574 574 $paged_users[$i]->last_activity = $activity->last_activity; … … 581 581 $user_activity = $wpdb->get_results( $wpdb->prepare( "SELECT user_id as id, meta_value as last_activity FROM {$wpdb->usermeta} WHERE meta_key = %s AND user_id IN ( {$user_ids} )", bp_get_user_meta_key( 'last_activity' ) ) ); 582 582 for ( $i = 0, $count = count( $paged_users ); $i < $count; ++$i ) { 583 foreach ( (array) $user_activity as $activity ) {583 foreach ( (array) $user_activity as $activity ) { 584 584 if ( $activity->id == $paged_users[$i]->id ) 585 585 $paged_users[$i]->last_activity = $activity->last_activity; … … 591 591 $user_update = $wpdb->get_results( $wpdb->prepare( "SELECT user_id as id, meta_value as latest_update FROM {$wpdb->usermeta} WHERE meta_key = %s AND user_id IN ( {$user_ids} )", bp_get_user_meta_key( 'bp_latest_update' ) ) ); 592 592 for ( $i = 0, $count = count( $paged_users ); $i < $count; ++$i ) { 593 foreach ( (array) $user_update as $update ) {593 foreach ( (array) $user_update as $update ) { 594 594 if ( $update->id == $paged_users[$i]->id ) 595 595 $paged_users[$i]->latest_update = $update->latest_update; … … 1208 1208 $is_oembed_link = false; 1209 1209 if ( !$attr['discover'] ) { 1210 foreach ( (array) $oembed_obj->providers as $provider_matchmask => $provider ) {1210 foreach ( (array) $oembed_obj->providers as $provider_matchmask => $provider ) { 1211 1211 $regex = ( $is_regex = $provider[1] ) ? $provider_matchmask : '#' . str_replace( '___wildcard___', '(.+)', preg_quote( str_replace( '*', '___wildcard___', $provider_matchmask ), '#' ) ) . '#i'; 1212 1212
Note: See TracChangeset
for help on using the changeset viewer.