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 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 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 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 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 2.0.0 * * @param string $message Feedback message. * @param string|bool $class Unused. * @return false|Closure */ 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 = '

' . implode( '
', $errors ) . '

'; break; } $class = $class ? $class : 'error'; } else { return false; } $message = '

' . $message . '

'; $message = str_replace( "'", "\'", $message ); $lambda = function() use ( $message ) { 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 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 ) ); ?>

' . esc_html__( 'BuddyPress Tools', 'buddypress' ) . '' ); ?>

'ids', 'post_status' => 'publish', 'post_type' => bp_get_email_post_type(), 'posts_per_page' => 200, 'suppress_filters' => false, ) ); if ( $emails ) { foreach ( $emails as $email_id ) { wp_trash_post( $email_id ); } } // Make sure we have no orphaned email type terms. $email_types = get_terms( bp_get_email_tax_type(), array( 'fields' => 'ids', 'hide_empty' => false, 'update_term_meta_cache' => false, ) ); if ( $email_types ) { foreach ( $email_types as $term_id ) { wp_delete_term( (int) $term_id, bp_get_email_tax_type() ); } } require_once( buddypress()->plugin_dir . '/bp-core/admin/bp-core-admin-schema.php' ); bp_core_install_emails(); if ( $switched ) { restore_current_blog(); } return array( 0, __( 'Emails have been successfully reinstalled.', 'buddypress' ) ); } /** * Add notice on the "Tools > BuddyPress" page if more sites need recording. * * This notice only shows up in the network admin dashboard. * * @since 2.6.0 */ function bp_core_admin_notice_repopulate_blogs_resume() { $screen = get_current_screen(); if ( 'tools_page_bp-tools-network' !== $screen->id ) { return; } if ( '' === bp_get_option( '_bp_record_blogs_offset' ) ) { return; } echo '

' . __( 'It looks like you have more sites to record. Resume recording by checking the "Repopulate site tracking records" option.', 'buddypress' ) . '

'; } add_action( 'network_admin_notices', 'bp_core_admin_notice_repopulate_blogs_resume' );