publish all events

publish all events.php

function forcefully_publish_all_events() {
    global $wpdb;

    // Get all event IDs directly from the database
    $event_ids = $wpdb->get_col("
        SELECT ID 
        FROM {$wpdb->posts}
        WHERE post_type = 'tribe_events'
          AND post_status NOT IN ('publish')
    ");

    if (!empty($event_ids)) {
        foreach ($event_ids as $event_id) {
            // Update the post status to publish
            wp_update_post([
                'ID'          => $event_id,
                'post_status' => 'publish',
            ]);
        }

        echo count($event_ids) . " events have been forcefully published.";
    } else {
        echo "No unpublished events found.";
}
}
// Hook this function to an admin action or trigger it manually
add_action('admin_init', 'forcefully_publish_all_events');