usermeta} WHERE meta_key IN ( 'total_friend_count' );";
if ( is_wp_error( $wpdb->query( $sql_delete ) ) ) {
return array( 1, sprintf( $statement, $result ) );
}
$bp = buddypress();
// Walk through all users on the site
$total_users = $wpdb->get_row( "SELECT count(ID) as c FROM {$wpdb->users}" )->c;
$updated = array();
if ( $total_users > 0 ) {
$per_query = 500;
$offset = 0;
while ( $offset < $total_users ) {
// Only bother updating counts for users who actually have friendships
$friendships = $wpdb->get_results( $wpdb->prepare( "SELECT initiator_user_id, friend_user_id FROM {$bp->friends->table_name} WHERE is_confirmed = 1 AND ( ( initiator_user_id > %d AND initiator_user_id <= %d ) OR ( friend_user_id > %d AND friend_user_id <= %d ) )", $offset, $offset + $per_query, $offset, $offset + $per_query ) );
// The previous query will turn up duplicates, so we
// filter them here
foreach ( $friendships as $friendship ) {
if ( ! isset( $updated[ $friendship->initiator_user_id ] ) ) {
BP_Friends_Friendship::total_friend_count( $friendship->initiator_user_id );
$updated[ $friendship->initiator_user_id ] = 1;
}
if ( ! isset( $updated[ $friendship->friend_user_id ] ) ) {
BP_Friends_Friendship::total_friend_count( $friendship->friend_user_id );
$updated[ $friendship->friend_user_id ] = 1;
}
}
$offset += $per_query;
}
} else {
return array( 2, sprintf( $statement, $result ) );
}
return array( 0, sprintf( $statement, __( 'Complete!', 'buddypress' ) ) );
}
/**
* Recalculate group counts for each user.
*
* @since BuddyPress (2.0.0)
*
* @return array
*/
function bp_admin_repair_group_count() {
global $wpdb;
if ( ! bp_is_active( 'groups' ) ) {
return;
}
$statement = __( 'Counting the number of groups for each user… %s', 'buddypress' );
$result = __( 'Failed!', 'buddypress' );
$sql_delete = "DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ( 'total_group_count' );";
if ( is_wp_error( $wpdb->query( $sql_delete ) ) ) {
return array( 1, sprintf( $statement, $result ) );
}
$bp = buddypress();
// Walk through all users on the site
$total_users = $wpdb->get_row( "SELECT count(ID) as c FROM {$wpdb->users}" )->c;
if ( $total_users > 0 ) {
$per_query = 500;
$offset = 0;
while ( $offset < $total_users ) {
// But only bother to update counts for users that have groups
$users = $wpdb->get_col( $wpdb->prepare( "SELECT user_id FROM {$bp->groups->table_name_members} WHERE is_confirmed = 1 AND is_banned = 0 AND user_id > %d AND user_id <= %d", $offset, $offset + $per_query ) );
foreach ( $users as $user ) {
BP_Groups_Member::refresh_total_group_count_for_user( $user );
}
$offset += $per_query;
}
} else {
return array( 2, sprintf( $statement, $result ) );
}
return array( 0, sprintf( $statement, __( 'Complete!', 'buddypress' ) ) );
}
/**
* Recalculate user-to-blog relationships and useful blog meta data
*
* @since BuddyPress (2.1.0)
*
* @return array
*/
function bp_admin_repair_blog_records() {
// Description of this tool, displayed to the user
$statement = __( 'Repopulating Blogs records… %s', 'buddypress' );
// Default to failure text
$result = __( 'Failed!', 'buddypress' );
// Default to unrepaired
$repair = false;
// Run function if blogs component is active
if ( bp_is_active( 'blogs' ) ) {
$repair = bp_blogs_record_existing_blogs();
}
// Setup success/fail messaging
if ( true === $repair ) {
$result = __( 'Complete!', 'buddypress' );
}
// All done!
return array( 0, sprintf( $statement, $result ) );
}
/**
* Recalculate the total number of active site members.
*
* @since BuddyPress (2.0.0)
*/
function bp_admin_repair_count_members() {
$statement = __( 'Counting the number of active members on the site… %s', 'buddypress' );
delete_transient( 'bp_active_member_count' );
bp_core_get_active_member_count();
return array( 0, sprintf( $statement, __( 'Complete!', 'buddypress' ) ) );
}
/**
* Repair user last_activity data.
*
* Re-runs the migration from usermeta introduced in BP 2.0.
*
* @since BuddyPress (2.0.0)
*/
function bp_admin_repair_last_activity() {
$statement = __( 'Determining last activity dates for each user… %s', 'buddypress' );
bp_last_activity_migrate();
return array( 0, sprintf( $statement, __( 'Complete!', 'buddypress' ) ) );
}
/**
* Assemble admin notices relating success/failure of repair processes.
*
* @since BuddyPress (2.0.0)
*
* @param string $message Feedback message.
* @param unknown $class Unused.
*/
function bp_admin_tools_feedback( $message, $class = false ) {
if ( is_string( $message ) ) {
$message = '' . $message . '
';
$class = $class ? $class : 'updated';
} elseif ( is_wp_error( $message ) ) {
$errors = $message->get_error_messages();
switch ( count( $errors ) ) {
case 0:
return false;
case 1:
$message = '' . $errors[0] . '
';
break;
default:
$message = '' . "\n\t" . '- ' . implode( '
' . "\n\t" . '- ', $errors ) . '
' . "\n" . '
';
break;
}
$class = $class ? $class : 'error';
} else {
return false;
}
$message = '' . $message . '
';
$message = str_replace( "'", "\'", $message );
$lambda = create_function( '', "echo '$message';" );
add_action( bp_core_do_network_admin() ? 'network_admin_notices' : 'admin_notices', $lambda );
return $lambda;
}
/**
* Render the Available Tools page.
*
* We register this page on Network Admin as a top-level home for our
* BuddyPress tools. This displays the default content.
*
* @since BuddyPress (2.0.0)
*/
function bp_core_admin_available_tools_page() {
?>
'bp-tools'
);
$page = bp_core_do_network_admin() ? 'admin.php' : 'tools.php' ;
$url = add_query_arg( $query_arg, bp_get_admin_url( $page ) );
?>