[Plugin: The Events Calendar] Where is The Event Calendar Data stored?

Hi snomo.

The events in 2.0 are stored as custom post types. Which means they are stored in the posts, posts meta and taxonomies table. You can’t really change that as it is default WordPress behavior (nor would you want really).

Why do you ask?

Hmm. So I have 2.0 installed and am still pretty new to WP, figuring out as I go. I take it custom post types do not show up in the regular posts? I’d like to have the same functionality/features that some other plug ins add to regular posts, access the same categories, nav menus etc that the regular posts offer but using the Events Calendar as the posting mechanism.

I was asking the question of table name/location so that I can access the back end database tables of data I store using The Events Calendar. This would allow us to created back end reports, analysis and such from the Events data from The Events Calendar posts table outside of the word press environment for managing posts, doing a bulk import into the right format etc. Any ideas?

Can you direct me to the location of the custom post data table?

=)

wp_posts, wp_postsmeta and wp_terms_taxonomy tables mixed in with every post type that wordpress has. You might want to do some quick reading on how WordPress architectures their data. Posts, Pages, Attachments & Custom Post Types all live in the same tables.

Justin Tadlock has some really nice articles in his archive that should help you. Start with this one https://justintadlock.com/archives/2010/04/29/custom-post-types-in-wordpress.

snomo, for what it’s worth, the versions immediately prior to this 2.0 upgrade did treat events as regular posts and not custom posts, making it a bit easier to do “posts” things with them. Shane’s already looked into getting us some of that back functionality (e.g., including custom posts in the main loop).