\WP_Stager_Integration\Event::get_event_by_id(int $event_id): array|null

Full Code

/**
 * Gets a single Stager event by its event ID.
 *
 * @param int $event_id The Stager event ID.
 *
 * @return array|null   The raw Stager event array, or null if not found.
 */
public static function get_event_by_id( $event_id ) {

    global $wpdb;

    // Type casting
    $event_id = (int) $event_id;

    if ( ! $event_id ) {
        return null;
    }

    $sql = "
        SELECT pm_raw.meta_value
        FROM {$wpdb->posts} p
        JOIN {$wpdb->postmeta} pm_id
          ON p.ID = pm_id.post_id
         AND pm_id.meta_key = %s
        JOIN {$wpdb->postmeta} pm_raw
          ON p.ID = pm_raw.post_id
         AND pm_raw.meta_key = %s
        WHERE p.post_type = %s
          AND p.post_status = 'publish'
          AND pm_id.meta_value = %d
        LIMIT 1
    ";

    $row = $wpdb->get_var( $wpdb->prepare(
                    $sql,
                    self::get_meta_key( 'id' ),
                    self::get_meta_key( self::META_KEY_RAW_DATA ),
                    self::CPT_SLUG,
                    $event_id
            ) );

    if ( ! $row ) {
        return null;
    }

    return maybe_unserialize( $row );
}