Hi guys,

I hope you are doing well.

I have to clean up the BP User database because it slows down the website and I have about 100’000 spam users to clean.

Could you provide any good plugin or technique to delete such spam users? The Bulk Delete Plugin https://wordpress.org/plugins/bulk-delete/ is in the meanwhile outdated and I wanted to ask if there is any better plugin you could recommend?

The other option would be to use AI generated code to implement it in the functions.php file. Would you recommend to run this code or better not?

// Schedule the custom event on plugin/theme load
function schedule_avatarless_user_cleanup() {
    if (!wp_next_scheduled('delete_avatarless_users_event')) {
        wp_schedule_event(time(), 'every_three_minutes', 'delete_avatarless_users_event');
    }
}
add_action('wp', 'schedule_avatarless_user_cleanup');

// Custom interval: every 3 minutes
function custom_cron_schedule($schedules) {
    $schedules['every_three_minutes'] = array(
        'interval' => 180, // 3 minutes in seconds
        'display'  => esc_html__('Every 3 Minutes'),
    );
    return $schedules;
}
add_filter('cron_schedules', 'custom_cron_schedule');

// Deletion logic: delete 25 users without avatars
function delete_avatarless_users_batch() {
    $args = array(
        'meta_key'   => '_has_avatar',
        'meta_value' => '0',
        'number'     => 25,
        'fields'     => 'ID',
    );
    $users = get_users($args);

    foreach ($users as $user_id) {
        wp_delete_user($user_id);
    }

    if (empty($users)) {
        // All done – clear the event
        wp_clear_scheduled_hook('delete_avatarless_users_event');
    }
}
add_action('delete_avatarless_users_event', 'delete_avatarless_users_batch');

Thank you for your feedback.

Regards
Daniel