Querying Events Calendar with $wpdb

[wfaa]

We are building a new website that includes two WP installs (on the same host) – one of which will include The Event Calendar (site A). From the site without The Event Calendar (site B), we want to query site A and grab all upcoming Events in the Event Calendar based on a particular category.

I’ve set up a new wpdb in Site B and I’ve successfully connected to Site A and returned the titles of all posts with a post_type of ‘tribe_events’.

http://pastebin.com/z7rnmsLU

What I’m trying to figure out is what I would write to return upcoming events based on a category (and return the Event Title / Event Date / Event Time / URL to Event).

If the solution to this issue doesn’t include wpdb, let me know.

[Casey]

wfaa,
Thanks for getting in touch! Unfortunately, we can’t recommend querying the database directly, as it’s possible that the plugin’s data structure might change in a future version and break your code. Your best bet is to use the tribe_get_events() function to correctly query events in a supported fashion.

Take a look at the docs there and hopefully that points you in the right direction. Thanks! 🙂

-Casey-

[wfaa]

Thanks, but correct me if I’m wrong – but we won’t be able to use tribe_get_events() from site B since it’s a different WP install. Or you aware of a way that we could do this using tribe_get_events?

[Casey]

Thanks, but correct me if I’m wrong – but we won’t be able to use tribe_get_events() from site B since it’s a different WP install. Or you aware of a way that we could do this using tribe_get_events?

Unfortunately that’s correct, since you’re trying to query events from a different site, and as such, we wouldn’t be able to provide support for this custom functionality. Our Events are stored in the database as standard Custom Post Types with post meta, so hopefully that points you in the right direction.

Good luck and thanks! 🙂

-Casey-

[Casey]

I just wanted to follow up and see if you’re all set here or if you still have further questions. Just let me know if you have further questions or if I should go ahead and close out this thread. Thanks! 🙂

-Casey-

[wfaa]

I was able to make it work with a new wpdb variable and then writing sql statements to query the database. We’ll just have to read the plug-in notes before any upgrades in case the structure does change.

[Casey]

Awesome! Thanks for confirming that this got you sorted. Since it looks like you’re all set, I’m going to mark this thread “Answered” and close it out.

By the way, if you have a minute or two, we would love it if you’d write a few words for us here: http://m.tri.be/lo

Thanks in advance. 🙂

Cheers,
Casey

[Author]

Posts