Support

October 6, 2020 at 8:57 am

Hi there,

Is there a way to use the objects and methods of event espresso outside WordPress?

Unless I’m misunderstanding your question, the short answer is no.

Event Espresso is a WordPress plugin, it pulls all of the values from the WP Database and uses a lot of internal WP functions so you can’t load Event Espressos objects/models/etc outside of WordPress.

Depending on the data you are looking to pull, you may be able to use the REST API:

https://github.com/eventespresso/event-espresso-core/tree/master/docs/C–REST-API

October 7, 2020 at 3:51 am

do you have examples of sql queries (e.g. to have a list of all events) or give me a hint, where to find the queries that the methods are using?

They are created dynamically through our model system which handles all of the joins for you.

You can find details on the model system here:

https://github.com/eventespresso/event-espresso-core/tree/master/docs/G–Model-System

You’ll likely find this section helpful:

https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/model-querying.md#inspecting-generated-queries

Which will output the generated SQL queries for you to view when using the modest o pull in data.

EE events in themselves are a custom post type, but pretty much everything other than what you would expect with a standard post is stored in custom tables and we join wp_posts using the post ID. The relationships between the EE tables are more complex than the one to wp_posts so if you have those down the above should be straight forward.

October 7, 2020 at 2:54 pm

Using the models you can do something like:

$templates_for_event = EEM_Message_Template_Group::instance()->get_all_custom_templates_by_event(
    $event_id,
    array(
        'MTP_messenger' => 'email',
        'MTP_is_active' => true
    )
);

Obviously set the $event_id variable for the event in question.

If you output that question you’ll see it uses esp_event_message_template and esp_message_template_group