plugin_dir . 'bp-core/' ); } // Define overrides - only applicable to those running trunk if ( ! defined( 'BP_DEFAULT_DATA_URL' ) ) { define( 'BP_DEFAULT_DATA_URL', buddypress()->plugin_url . 'bp-core/' ); } require_once BP_DEFAULT_DATA_DIR . 'bp-core-tools-default-data.php'; bp_admin_tools_default_data_save(); $users_data = require_once BP_DEFAULT_DATA_DIR . 'data/users.php'; ?>

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( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } /** * 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 = __( 'Repairing total groups count for each member … %s', 'buddyboss' ); $result = __( 'Failed!', 'buddyboss' ); $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( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } /** * 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', 'buddyboss' ); // Default to failure text. $result = __( 'Failed!', 'buddyboss' ); // 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!', 'buddyboss' ); } // All done! return array( 'status' => 1, 'message' => sprintf( $statement, $result ), ); } /** * Recalculate the total number of active site members. * * @since BuddyPress 2.0.0 */ function bp_admin_repair_count_members() { $statement = __( 'Repairing total members count … %s', 'buddyboss' ); delete_transient( 'bp_active_member_count' ); bp_core_get_active_member_count(); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } /** * 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 = __( 'Repairing member "last activity" data … %s', 'buddyboss' ); bp_last_activity_migrate(); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } /** * Repair default profile fields. * * @since BuddyBoss 1.0.0 */ function repair_default_profiles_fields() { global $wpdb; $bp_prefix = bp_core_get_table_prefix(); require_once ABSPATH . 'wp-admin/includes/upgrade.php'; require_once buddypress()->plugin_dir . '/bp-core/admin/bp-core-admin-schema.php'; bp_core_install_default_profiles_fields(); if ( ! bp_get_option( 'bp-xprofile-base-group-id' ) ) { bp_update_option( 'bp-xprofile-base-group-id', 1 ); } if ( ! bp_get_option( 'bp-xprofile-firstname-field-id' ) ) { bp_update_option( 'bp-xprofile-firstname-field-id', 1 ); } // First name field id. $first_name_id = bp_xprofile_firstname_field_id(); // Last name field id. $last_name_id = bp_xprofile_lastname_field_id(); // Nickname field id. $nickname_id = bp_xprofile_nickname_field_id(); // Query to remove all duplicate first name fields. $first_name = $wpdb->prepare( "DELETE FROM {$bp_prefix}bp_xprofile_fields WHERE can_delete = %d AND parent_id = %d AND is_required = %d AND name = %s AND type = %s AND id != %d", 0, 0, 1, 'First Name', 'textbox', $first_name_id ); // Query to remove all duplicate last name fields. $last_name = $wpdb->prepare( "DELETE FROM {$bp_prefix}bp_xprofile_fields WHERE can_delete = %d AND parent_id = %d AND is_required = %d AND name = %s AND type = %s AND id != %d", 0, 0, 1, 'Last Name', 'textbox', $last_name_id ); // Query to remove all duplicate nick name fields. $nick_name = $wpdb->prepare( "DELETE FROM {$bp_prefix}bp_xprofile_fields WHERE can_delete = %d AND parent_id = %d AND is_required = %d AND name = %s AND type = %s AND id != %d", 0, 0, 1, 'Nickname', 'textbox', $nickname_id ); // Remove all duplicate first name fields. $wpdb->query( $first_name ); // Remove all duplicate last name fields. $wpdb->query( $last_name ); // Remove all duplicate nick name fields. $wpdb->query( $nick_name ); // Clear profile completion data bp_core_xprofile_clear_all_user_progress_cache(); $statement = __( 'Repairing default profile set and fields … %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } /** * Resync BuddyBoss profile data to WordPress. * * @since BuddyBoss 1.0.0 */ function resync_xprofile_wordpress_fields() { $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; $args = array( 'number' => 50, 'fields' => array( 'ID' ), 'offset' => $offset, ); $users = get_users( $args ); if ( ! empty( $users ) ) { array_map( 'xprofile_sync_wp_profile', wp_list_pluck( $users, 'ID' ) ); foreach ( $users as $user ) { $offset++; } $records_updated = sprintf( __( '%s members updated successfully.', 'buddyboss' ), bp_core_number_format( $offset ) ); return array( 'status' => 'running', 'offset' => $offset, 'records' => $records_updated, ); } else { $statement = __( 'Re-syncing BuddyBoss profile fields to WordPress profile fields … %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } } /** * Resync WordPress profile data to BuddyBoss. * * @since BuddyBoss 1.0.0 */ function resync_wordpress_xprofile_fields() { $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; $args = array( 'number' => 50, 'fields' => array( 'ID', 'user_nicename' ), 'offset' => $offset, ); $users = get_users( $args ); if ( ! empty( $users ) ) { foreach ( $users as $user ) { xprofile_set_field_data( bp_xprofile_firstname_field_id(), $user->ID, get_user_meta( $user->ID, 'first_name', true ) ); xprofile_set_field_data( bp_xprofile_lastname_field_id(), $user->ID, get_user_meta( $user->ID, 'last_name', true ) ); // make sure nickname is valid $nickname = get_user_meta( $user->ID, 'nickname', true ); $nickname = sanitize_title( $nickname ); $invalid = bp_xprofile_validate_nickname_value( '', bp_xprofile_nickname_field_id(), $nickname, $user->ID ); // or use the user_nicename if ( ! $nickname || $invalid ) { $nickname = $user->user_nicename; } bp_update_user_meta( $user->ID, 'nickname', $nickname ); xprofile_set_field_data( bp_xprofile_nickname_field_id(), $user->ID, $nickname ); $offset++; } $records_updated = sprintf( __( '%s members updated successfully.', 'buddyboss' ), bp_core_number_format( $offset ) ); return array( 'status' => 'running', 'offset' => $offset, 'records' => $records_updated, ); } else { $statement = __( 'Re-syncing WordPress profile fields to BuddyBoss profile fields … %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } } /** * Update member display names. * * @since BuddyBoss 1.0.0 */ function xprofile_update_display_names() { $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; $args = array( 'number' => 50, 'fields' => array( 'ID', 'display_name' ), 'offset' => $offset, ); $users = get_users( $args ); if ( ! empty( $users ) ) { foreach ( $users as $user ) { $display_name = bp_core_get_user_displayname( $user->ID ); wp_update_user( $args = array( 'ID' => $user->ID, 'display_name' => $display_name, ) ); $offset++; } $records_updated = sprintf( __( '%s members updated successfully.', 'buddyboss' ), bp_core_number_format( $offset ) ); return array( 'status' => 'running', 'offset' => $offset, 'records' => $records_updated, ); } else { $statement = __( 'Updating display name to selected format in profile settings … %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } } /** * Assemble admin notices relating success/failure of repair processes. * * @since BuddyPress 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 = ''; 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 BuddyPress 2.0.0 */ function bp_core_admin_available_tools_page() { ?>

'bp-tools', ); $page = bp_core_do_network_admin() ? 'admin.php' : 'admin.php'; $url = add_query_arg( $query_arg, bp_get_admin_url( $page ) ); ?>

' . esc_html__( 'BuddyBoss Tools', 'buddyboss' ) . '' ); ?>

'publish', 'post_type' => bp_get_email_post_type(), ); $emails = bp_email_get_schema(); $descriptions = bp_email_get_type_schema(); $installed_email = 0; // Add these emails to the database. foreach ( $emails as $id => $email ) { if ( term_exists( $id, bp_get_email_tax_type() ) && get_terms( array( 'taxonomy' => bp_get_email_tax_type(), 'slug' => $id, 'fields' => 'count', ) ) > 0 ) { continue; } // Some emails are multisite-only. if ( ! is_multisite() && isset( $email['args'] ) && ! empty( $email['args']['multisite'] ) ) { continue; } $args = bp_parse_args( $email, $defaults, 'install_email_' . $id ); $page_exist = post_exists( $args['post_title'], '', '', bp_get_email_post_type() ); if ( ! empty( $page_exist ) && 'publish' === get_post_status( $page_exist ) ) { continue; } $post_id = wp_insert_post( $args ); if ( ! $post_id ) { continue; } $tt_ids = wp_set_object_terms( $post_id, $id, bp_get_email_tax_type() ); foreach ( $tt_ids as $tt_id ) { $term = get_term_by( 'term_taxonomy_id', (int) $tt_id, bp_get_email_tax_type() ); wp_update_term( (int) $term->term_id, bp_get_email_tax_type(), array( 'description' => $descriptions[ $id ], ) ); } $installed_email ++; } if ( $switched ) { restore_current_blog(); } return array( 'status' => 1, 'records' => sprintf( /* translators: %1$s for counts missing emails. */ __( '%1$s missing emails have been installed.', 'buddyboss' ), $installed_email, ), 'message' => sprintf( /* translators: %1$s for view emails url. */ __( 'Installing missing emails … Complete! %1$s', 'buddyboss' ), '' . esc_html__( 'View Emails.', 'buddyboss' ) . '' ), ); } /** * Delete emails and restore from defaults. * * @since BuddyPress 2.5.0 * * @return array */ function bp_admin_reinstall_emails() { $switched = false; // Switch to the root blog, where the email posts live. if ( ! bp_is_root_blog() ) { switch_to_blog( bp_get_root_blog_id() ); bp_register_taxonomies(); $switched = true; } $emails = get_posts( array( 'fields' => 'ids', 'post_status' => 'publish', 'post_type' => bp_get_email_post_type(), 'posts_per_page' => 200, 'suppress_filters' => false, 'update_post_meta_cache' => false, 'update_post_term_cache' => 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( 'status' => 1, 'message' => sprintf( /* translators: %1$s for view emails url. */ __( 'Reseting emails … Complete! %1$s', 'buddyboss' ), '' . esc_html__( 'View Emails.', 'buddyboss' ) . '' ), ); } /** * Add notice on the "Tools > BuddyPress" page if more sites need recording. * * This notice only shows up in the network admin dashboard. * * @since BuddyPress 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.', 'buddyboss' ) . '

'; } add_action( 'network_admin_notices', 'bp_core_admin_notice_repopulate_blogs_resume' ); /** * Assign members without a profile type to the default profile type (excludes admins). * * @since BuddyBoss 1.0.0 * * @return array */ function bp_admin_assign_member_type() { $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; $args = array( 'number' => 50, 'fields' => array( 'ID' ), 'offset' => $offset, ); $users = get_users( $args ); if ( ! empty( $users ) ) { foreach ( $users as $user ) { $member_type = bp_get_member_type( $user->ID ); if ( false === $member_type ) { // Get the user object. $user1 = get_userdata( $user->ID ); if ( ! in_array( 'administrator', $user1->roles, true ) ) { $existing_selected = bp_member_type_default_on_registration(); // Assign the default member type to user. bp_set_member_type( $user->ID, '' ); bp_set_member_type( $user->ID, $existing_selected ); } } $offset++; } $records_updated = sprintf( __( '%s members updated successfully.', 'buddyboss' ), bp_core_number_format( $offset ) ); return array( 'status' => 'running', 'offset' => $offset, 'records' => $records_updated, ); } else { // Description of this tool, displayed to the user. $statement = __( 'Assign users without a profile type to the default profile type records… %s', 'buddyboss' ); $result = __( 'Complete!', 'buddyboss' ); // All done! return array( 'status' => 1, 'message' => sprintf( $statement, $result ), ); } } function bp_admin_repair_nickname_value() { $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; $args = array( 'number' => 50, 'fields' => array( 'ID' ), 'offset' => $offset, ); $users = get_users( $args ); if ( ! empty( $users ) ) { foreach ( $users as $user ) { $nickname = xprofile_get_field_data( bp_xprofile_nickname_field_id(), $user->ID ); if ( preg_match( '/[A-Z]/', $nickname ) ) { xprofile_set_field_data( bp_xprofile_nickname_field_id(), bp_loggedin_user_id(), strtolower( $nickname ) ); } $offset++; } $records_updated = sprintf( __( '%s members updated successfully.', 'buddyboss' ), bp_core_number_format( $offset ) ); return array( 'status' => 'running', 'offset' => $offset, 'records' => $records_updated, ); } else { // Description of this tool, displayed to the user. $statement = __( 'Repair Nickname… %s', 'buddyboss' ); $result = __( 'Complete!', 'buddyboss' ); // All done! return array( 'status' => 1, 'message' => sprintf( $statement, $result ), ); } } /** * Wrapper function to handle Repair Community all the actions. * * @since BuddyBoss 1.1.8 */ function bp_admin_repair_tools_wrapper_function() { $response = array( 'feedback' => sprintf( '

%s

', esc_html__( 'There was a problem performing this action. Please try again.', 'buddyboss' ) ), ); $type = bb_filter_input_string( INPUT_POST, 'type' ); if ( empty( $type ) ) { wp_send_json_error( $response ); } // Bail if not a POST action. if ( ! bp_is_post_request() ) { wp_send_json_error( $response ); } if ( empty( $_POST['nonce'] ) ) { wp_send_json_error( $response ); } // Use default nonce $nonce = $_POST['nonce']; $check = 'bp-do-counts'; // Nonce check! if ( empty( $nonce ) || ! wp_verify_nonce( $nonce, $check ) ) { wp_send_json_error( $response ); } $repair_list = bp_admin_repair_list(); $status = array(); foreach ( $repair_list as $repair_item ) { if ( $repair_item[0] === $type && is_callable( $repair_item[2] ) ) { $status = call_user_func( $repair_item[2] ); break; } } // if ( 'bp-user-friends' === $type ) { // $status = bp_admin_repair_friend_count(); // } elseif ( 'bp-group-count' === $type ) { // $status = bp_admin_repair_group_count(); // } elseif ( 'bp-total-member-count' === $type ) { // $status = bp_admin_repair_count_members(); // } elseif ( 'bp-last-activity' === $type ) { // $status = bp_admin_repair_last_activity(); // } elseif ( 'bp-xprofile-fields' === $type ) { // $status = repair_default_profiles_fields(); // } elseif ( 'bp-xprofile-wordpress-resync' === $type ) { // $status = resync_xprofile_wordpress_fields(); // } elseif ( 'bp-wordpress-xprofile-resync' === $type ) { // $status = resync_wordpress_xprofile_fields(); // } elseif ( 'bp-wordpress-update-display-name' === $type ) { // $status = xprofile_update_display_names(); // } elseif ( 'bp-blog-records' === $type ) { // $status = bp_admin_repair_blog_records(); // } elseif ( 'bp-reinstall-emails' === $type ) { // $status = bp_admin_reinstall_emails(); // } elseif ( 'bp-assign-member-type' === $type ) { // $status = bp_admin_assign_member_type(); // } elseif ( 'bp-sync-activity-favourite' === $type ) { // $status = bp_admin_update_activity_favourite(); // } elseif ( 'bp-invitations-table' === $type ) { // $status = bp_admin_invitations_table(); // } elseif ( 'bp-media-forum-privacy-repair' === $type ) { // $status = bp_media_forum_privacy_repair(); // } wp_send_json_success( $status ); } add_action( 'wp_ajax_bp_admin_repair_tools_wrapper_function', 'bp_admin_repair_tools_wrapper_function' ); /** * Check if BuddyPress activity favorites data needs upgrade & Update to BuddyBoss activity like data * * @since BuddyBoss 1.3.3 */ function bp_admin_update_activity_favourite() { global $wpdb, $bp; $bp_activity_reactions = bp_get_option( 'bp_activity_reactions', false ); if ( ! $bp_activity_reactions ) { $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; $per_page = (int) apply_filters( 'bb_admin_update_activity_favourite_per_page', 200 ); $items = $wpdb->get_results( $wpdb->prepare( "SELECT a.id AS activity_id, am.meta_value FROM {$bp->activity->table_name} a INNER JOIN {$bp->activity->table_name_meta} am ON a.id = am.activity_id WHERE am.meta_key = 'bp_favorite_users' AND am.meta_value != '' ORDER BY a.id DESC LIMIT %d OFFSET %d", $per_page, $offset ), ARRAY_A ); if ( ! empty( $items ) ) { foreach ( $items as $item ) { $item_id = $item['activity_id']; $fav_user_ids = maybe_unserialize( $item['meta_value'] ); if ( ! is_array( $fav_user_ids ) || empty( $fav_user_ids ) ) { ++$offset; continue; } $migrated_fav_user_ids = $wpdb->get_col( $wpdb->prepare( 'SELECT user_id FROM ' . bb_load_reaction()::$user_reaction_table . ' WHERE item_id = %d AND user_id IN (' . implode( ',', $fav_user_ids ) . ')', $item_id ) ); if ( ! empty( $migrated_fav_user_ids ) ) { $fav_user_ids = array_diff( $fav_user_ids, $migrated_fav_user_ids ); } if ( ! empty( $fav_user_ids ) ) { $chunk_length = (int) apply_filters( 'bb_admin_update_activity_favourite_chunk_length', 500 ); $user_fav_chunks = count( $fav_user_ids ) > $chunk_length ? array_chunk( $fav_user_ids, $chunk_length ) : array( $fav_user_ids ); if ( ! empty( $user_fav_chunks ) ) { foreach ( $user_fav_chunks as $chunk ) { bb_admin_tool_migration_reaction( $item_id, $chunk ); } } } ++$offset; } $records_updated = sprintf( __( '%s activity favorites updated successfully.', 'buddyboss' ), bp_core_number_format( $offset ) ); return array( 'status' => 'running', 'offset' => $offset, 'records' => $records_updated, ); } else { bp_update_option( 'bp_activity_reactions', true ); $statement = __( 'Updating activity favorites data … %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } } else { $statement = __( 'Updating activity favorites data … %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } } /** * Insert reactions for a user in bulk. * * @since 2.5.70 * * @param int $item_id Item ID. * @param array $user_ids Array of user ID. * * @return void */ function bb_admin_tool_migration_reaction( $item_id, $user_ids = array() ) { global $wpdb; if ( empty( $user_ids ) ) { return; } // Validate the user ids. $filtered_user_ids = get_users( array( 'include' => $user_ids, 'fields' => 'ids', 'populate_extras' => false, 'count_total' => false, ) ); if ( empty( $filtered_user_ids ) ) { return; } $user_reaction_tbl = bb_load_reaction()::$user_reaction_table; $reaction_id = bb_load_reaction()->bb_reactions_get_like_reaction_id(); $place_holder_queries = array(); foreach ( $filtered_user_ids as $user_id ) { $place_holder_queries[] = $wpdb->prepare( '(%d, %d, %s, %d, %s)', $user_id, $reaction_id, 'activity', $item_id, bp_core_current_time() ); } if ( ! empty( $place_holder_queries ) ) { $place_holder_queries = implode( ', ', $place_holder_queries ); $wpdb->query( "INSERT INTO {$user_reaction_tbl} ( user_id, reaction_id, item_type, item_id, date_created ) VALUES {$place_holder_queries}" ); // phpcs:ignore bp_core_reset_incrementor( 'bb_reactions' ); bb_load_reaction()->bb_prepare_reaction_summary_data( array( 'reaction_id' => $reaction_id, 'item_id' => $item_id, 'item_type' => 'activity', ) ); } } /** * Create the invitations database table if it does not exist. * Migrate outstanding group invitations if needed. * * @since BuddyBoss 1.3.5 * * @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 database table for Invitations if it does not exist … %s', 'buddyboss' ); $result = __( 'Failed to create table!', 'buddyboss' ); 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 ) { return array( 'status' => 2, 'message' => sprintf( $statement, $result ), ); } else { $result = __( 'Complete!', 'buddyboss' ); } // 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 existing group invitations … %s', 'buddyboss' ); $migrate_result = __( 'Failed to migrate invitations!', 'buddyboss' ); 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 = __( 'Complete!', 'buddyboss' ); return array( 'status' => 0, 'message' => sprintf( $statement . ' ' . $migrate_statement, $result, $migrate_result ), ); } else { return array( 'status' => 2, 'message' => sprintf( $statement . ' ' . $migrate_statement, $result, $migrate_result ), ); } } // Return a "create-only" success message. return array( 'status' => 0, 'message' => sprintf( $statement, $result ), ); } /** * Function will sync profile uploaded photo for profile completion widget data. * * @since BuddyBoss 2.0.9 * * @return array */ function bb_sync_profile_completion_widget() { $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; // Users args. $args = array( 'number' => 50, 'fields' => array( 'ID' ), 'meta_key' => 'bp_profile_completion_widgets', 'offset' => $offset, ); $users = get_users( $args ); if ( ! empty( $users ) ) { foreach ( $users as $user ) { // Get existing user meta who have profile completion widget data in DB. $get_user_data = bp_get_user_meta( $user->ID, 'bp_profile_completion_widgets', true ); if ( ! empty( $get_user_data ) ) { $total_completed_count = isset( $get_user_data['completed_fields'] ) ? $get_user_data['completed_fields'] : 0; if ( isset( $get_user_data['photo_type'] ) && isset( $get_user_data['photo_type']['profile_photo'] ) && isset( $get_user_data['photo_type']['profile_photo']['is_uploaded'] ) ) { $is_profile_photo_uploaded = ( bp_get_user_has_avatar( $user->ID ) ) ? 1 : 0; if ( ! $is_profile_photo_uploaded && bp_enable_profile_gravatar() && 'blank' !== get_option( 'avatar_default', 'mystery' ) ) { /** * There is not any direct way to check gravatar set for user. * Need to check $profile_url is send 200 status or not. */ $profile_url = get_avatar_url( $user->ID, array( 'default' => '404' ) ); $headers = get_headers( $profile_url, 1 ); if ( $headers[0] === 'HTTP/1.1 200 OK' && isset( $headers['Link'] ) ) { $is_profile_photo_uploaded = 1; } } if ( (int) $get_user_data['photo_type']['profile_photo']['is_uploaded'] !== (int) $is_profile_photo_uploaded ) { $get_user_data['photo_type']['profile_photo']['is_uploaded'] = $is_profile_photo_uploaded; if ( 1 === (int) $is_profile_photo_uploaded ) { $total_completed_count = ++ $total_completed_count; } else { $total_completed_count = -- $total_completed_count; } } } $get_user_data['completed_fields'] = $total_completed_count; // Update new response for completion widget. bp_update_user_meta( $user->ID, 'bp_profile_completion_widgets', $get_user_data ); } $offset++; } $records_updated = sprintf( __( 'Profile completion widget, profile photo status updated successfully for %s members.', 'buddyboss' ), bp_core_number_format( $offset ) ); return array( 'status' => 'running', 'offset' => $offset, 'records' => $records_updated, ); } else { $statement = __( 'Profile Completion widget, profile photo status re-sync %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, __( 'Complete!', 'buddyboss' ) ), ); } } /** * Function will recalculate the group total members count * and remove the orphaned group members records. * * @since BuddyBoss 2.3.90 * * @return array */ function bp_admin_repair_group_member_count() { global $wpdb; if ( ! bp_is_active( 'groups' ) ) { return; } // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized, WordPress.Security.ValidatedSanitizedInput.MissingUnslash $offset = isset( $_POST['offset'] ) ? (int) ( $_POST['offset'] ) : 0; $bp = buddypress(); /** * Check and delete orphan group members records from wp_bp_groups_members table * if user doesn't exist in users table. */ if ( 0 === $offset ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $wpdb->query( "DELETE m, mm FROM {$wpdb->prefix}bp_groups_members AS m LEFT JOIN {$wpdb->users} AS u ON u.ID = m.user_id LEFT JOIN {$wpdb->prefix}bp_groups_membermeta AS mm ON m.ID = mm.member_id WHERE u.ID IS NULL" ); } // Fetch all groups. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $group_ids = $wpdb->get_col( $wpdb->prepare( "SELECT DISTINCT id FROM {$wpdb->prefix}bp_groups ORDER BY id DESC LIMIT 20 OFFSET %d", $offset ) ); if ( ! empty( $group_ids ) ) { foreach ( $group_ids as $group_id ) { // Remove cached group member count. $cache_key = 'bp_group_get_total_member_count_' . $group_id; wp_cache_delete( $cache_key, 'bp_groups' ); $select_sql = "SELECT COUNT(u.ID) FROM {$bp->groups->table_name_members} m"; $join_sql = "LEFT JOIN {$wpdb->users} u ON u.ID = m.user_id"; // Where conditions. $where_conditions = array(); $where_conditions['where'] = $wpdb->prepare( 'm.group_id = %d AND m.is_confirmed = 1 AND m.is_banned = 0', $group_id ); /** * Filters the MySQL WHERE conditions for the group members count. * * @since BuddyBoss 2.3.90 * * @param array $where_conditions Current conditions for MySQL WHERE statement. * @param string $ud_name moderation type */ $where_conditions = apply_filters( 'bb_group_member_count_where_sql', $where_conditions, 'user_id' ); // Join the where conditions together. $where_sql = 'WHERE ' . join( ' AND ', $where_conditions ); /** * Filters the MySQL JOIN conditions for the group members count. * * @since BuddyBoss 2.3.90 * * @param array $join_sql Current conditions for MySQL JOIN statement. * @param string $ud_name moderation type */ $join_sql = apply_filters( 'bb_group_member_count_join_sql', $join_sql, 'user_id' ); $sql = "{$select_sql} {$join_sql} {$where_sql}"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared $member_count = $wpdb->get_var( $sql ); groups_update_groupmeta( $group_id, 'total_member_count', absint( $member_count ) ); wp_cache_set( $cache_key, absint( $member_count ), 'bp_groups' ); $offset++; } return array( 'status' => 'running', 'offset' => $offset, 'records' => sprintf( /* translators: %s: number of groups */ esc_html__( '%s groups member count updated successfully.', 'buddyboss' ), bp_core_number_format( $offset ) ), ); } $statement = esc_html__( 'Recalculating the total group members count for each group … %s', 'buddyboss' ); return array( 'status' => 1, 'message' => sprintf( $statement, esc_html__( 'Complete!', 'buddyboss' ) ), ); }