Hi!

I'm working on a dynamic condition that should show an image if a user has booked a specific Amelia event. It seems that data from Amelia gets stored in 'wp_amelia_users'.  How can i get a shortcode that pulls an array of all the events booked by the user?

Chatgpt gave me the code blow, but its not working.

// Define your shortcode function
function amelia_user_booked_events_shortcode( $atts ) {
    // Extract attributes
    $atts = shortcode_atts( array(
        'user_id' => get_current_user_id(), // Default to current user if not provided
    ), $atts );

    // Retrieve booked events for the specified user
    global $wpdb;
    $user_id = intval( $atts['user_id'] );
    $booked_events = $wpdb->get_results( $wpdb->prepare(
        "SELECT * FROM {$wpdb->prefix}amelia_users WHERE user_id = %d",
        $user_id
    ) );

    // Initialize an array to hold the booked events data
    $events_data = array();

    // Loop through booked events and construct array
    foreach ( $booked_events as $event ) {
        $event_data = array(
            'event_name' => $event->event_name, // Assuming 'event_name' is the column name
            // Add more details about the event here as needed
        );
        $events_data[] = $event_data;
    }

    return $events_data;
}
add_shortcode( 'amelia_user_booked_events', 'amelia_user_booked_events_shortcode' );

Hi Marko,

Thank you for your reply!

I will explain what I'm trying to build:

I'm building a portal for a company that sells cosmetic training events. Some of their events are only open for people that have followed a specific pre-training event. Within Amelia it's not possible to add criteria that disallow users to book a training if they have not booked another 'pre-training' before.

I want to solve this with a workaround. I'm working with the plugins Elementor, Woocommerce and DynamicConditions (from RTO). 

In a container (with the Elementor page builder) i will place the Amelia event display widget. In this widget i will only display follow-up events. With the DynamicConditions plugin i want to set a condition that the container only becomes visible when a user has bought a 'pre-training' in the past. In that way a user is not able to see the follow-up events if they have not followed the pre-training.

So somehow i need to retreive the event names, or ID's of the events a user has bought/followed. Then i can set a dynamic condition that either hides of shows the container with follow-up events.

Ive added an image of what I've tried to set up. Instead of hiding an Amelia event widget, I've tried it first with an image. It should work the same. In the image you will see that I've tried to search for the products in the WooCommerce database. But i want to set it up by searching in the 'wp_amelia_users' table for the products.

Link to the image: https://ibb.co/Kh6c166

Can't seem to attach it to the post