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; } /* translators: %s: the result of the action performed by the repair tool */ $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() { /* translators: %s: the result of the action performed by the repair tool */ $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 ) ); } /** * Repair site icons/blog avatars synchronization. * * @since 7.0.0 * * @return array */ function bp_admin_repair_blog_site_icons() { /* translators: %s: the result of the action performed by the repair tool */ $statement = __( 'Repairing site icons/blog avatars synchronization… %s', 'buddypress' ); if ( ! is_multisite() ) { return array( 0, sprintf( $statement, __( 'Failed!', 'buddypress' ) ) ); } // Run function if blogs component is active. if ( bp_is_active( 'blogs', 'site-icon' ) ) { $blog_ids = get_sites( array( 'fields' => 'ids', 'archived' => 0, 'mature' => 0, 'spam' => 0, 'deleted' => 0, ) ); $sizes = array( array( 'key' => 'site_icon_url_full', 'size' => bp_core_avatar_full_width(), ), array( 'key' => 'site_icon_url_thumb', 'size' => bp_core_avatar_thumb_width(), ), ); foreach ( $blog_ids as $blog_id ) { $site_icon = 0; foreach ( $sizes as $size ) { $site_icon = bp_blogs_get_site_icon_url( $blog_id, $size['size'] ); if ( ! $site_icon ) { $site_icon = 0; } bp_blogs_update_blogmeta( $blog_id, $size['key'], $site_icon ); } } } // All done! return array( 0, sprintf( $statement, __( 'Complete!', 'buddypress' ) ) ); } /** * Recalculate the total number of active site members. * * @since 2.0.0 */ function bp_admin_repair_count_members() { /* translators: %s: the result of the action performed by the repair tool */ $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() { /* translators: %s: the result of the action performed by the repair tool */ $statement = __( 'Determining last activity dates for each user… %s', 'buddypress' ); bp_last_activity_migrate(); return array( 0, sprintf( $statement, __( 'Complete!', 'buddypress' ) ) ); } /** * Create the invitations database table if it does not exist. * Migrate outstanding group invitations if needed. * * @since 6.0.0 * * @return array */ function bp_admin_invitations_table() { global $wpdb; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); require_once( buddypress()->plugin_dir . '/bp-core/admin/bp-core-admin-schema.php' ); /* translators: %s: the result of the action performed by the repair tool */ $statement = __( 'Creating the Invitations database table if it does not exist… %s', 'buddypress' ); $result = __( 'Failed to create table!', 'buddypress' ); bp_core_install_invitations(); // Check for existence of invitations table. $table_name = BP_Invitation_Manager::get_table_name(); $query = $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table_name ) ); if ( ! $wpdb->get_var( $query ) == $table_name ) { // Early return if table creation failed. return array( 2, sprintf( $statement, $result ) ); } else { $result = __( 'Created invitations table!', 'buddypress' ); } // Migrate group invitations if needed. if ( bp_is_active( 'groups' ) ) { $bp = buddypress(); /* translators: %s: the result of the action performed by the repair tool */ $migrate_statement = __( 'Migrating group invitations… %s', 'buddypress' ); $migrate_result = __( 'Failed to migrate invitations!', 'buddypress' ); bp_groups_migrate_invitations(); // Check that there are no outstanding group invites in the group_members table. $records = $wpdb->get_results( "SELECT id FROM {$bp->groups->table_name_members} WHERE is_confirmed = 0 AND is_banned = 0" ); if ( empty( $records ) ) { $migrate_result = __( 'Migrated invitations!', 'buddypress' ); return array( 0, sprintf( $statement . ' ' . $migrate_statement , $result, $migrate_result ) ); } else { return array( 2, sprintf( $statement . ' ' . $migrate_statement , $result, $migrate_result ) ); } } // Return a "create-only" success message. return array( 0, sprintf( $statement, $result ) ); } /** * 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 Repair Tools', 'buddypress' ) . '' ); ?>
: ' . esc_html__( 'Invitations', 'buddypress' ) . '' ); ?>
: ' . esc_html__( 'Nonmember Opt-outs', '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' ); /** * Add BuddyPress debug info to the WordPress Site Health info screen. * * @since 5.0.0 * * @param array $debug_info The Site's debug info. * @return array The Site's debug info, including the BuddyPress specific ones. */ function bp_core_admin_debug_information( $debug_info = array() ) { global $wp_settings_fields; $active_components = array_intersect_key( bp_core_get_components(), buddypress()->active_components ); $bp_settings = array(); foreach ( $wp_settings_fields['buddypress'] as $section => $settings ) { $prefix = ''; $component_id = str_replace( 'bp_', '', $section ); if ( isset( $active_components[ $component_id ]['title'] ) ) { $prefix = $active_components[ $component_id ]['title'] .': '; } foreach( $settings as $bp_setting ) { $reverse = ( strpos( $bp_setting['id'], 'hide' ) !== false || strpos( $bp_setting['id'], 'restrict' ) !== false || strpos( $bp_setting['id'], 'disable' ) !== false ); if ( ! isset( $bp_setting['id'] ) || '_bp_theme_package_id' === $bp_setting['id'] ) { continue; } $bp_setting_value = bp_get_option( $bp_setting['id'] ); if ( '0' === $bp_setting_value || '1' === $bp_setting_value ) { if ( ( $reverse && '0' === $bp_setting_value ) || ( ! $reverse && '1' === $bp_setting_value ) ) { $bp_setting_value = __( 'Yes', 'buddypress' ); } else { $bp_setting_value = __( 'No', 'buddypress' ); } } // Make sure to show the setting is reversed when site info is copied to clipboard. $bp_settings_id = $bp_setting['id']; if ( $reverse ) { $bp_settings_id = '! ' . $bp_settings_id; } $bp_settings[ $bp_settings_id ] = array( 'label' => $prefix . $bp_setting['title'], 'value' => $bp_setting_value, ); } } $debug_info['buddypress'] = array( 'label' => __( 'BuddyPress', 'buddypress' ), 'fields' => array_merge( array( 'version' => array( 'label' => __( 'Version', 'buddypress' ), 'value' => bp_get_version(), ), 'active_components' => array( 'label' => __( 'Active components', 'buddypress' ), 'value' => implode( ', ', wp_list_pluck( $active_components, 'title' ) ), ), 'template_pack' => array( 'label' => __( 'Active template pack', 'buddypress' ), 'value' => bp_get_theme_compat_name() . ' ' . bp_get_theme_compat_version(), ), ), $bp_settings ) ); return $debug_info; } add_filter( 'debug_information', 'bp_core_admin_debug_information' );