database tables

[Andre Dublin]

Hey I'm back.

I wanted to find out where does eventpress or bpcp store the data in the database.

What I'm doing is writing a function that will email the administrator when an event has been submitted for approval and I will pick up on that post status and send an email.

[Kunal Bhalla]

Have a look at how bpcp/controller.php generates activities for posts
being created/updated. The one in the release is slightly
incorrect—but this has been corrected in the trunk, which you can grab
here: https://github.com/kunalb/BuddyPress-Custom-Posts/blob/master/controller.php
(create_post_activity and edit_post_activity).

One of the advantages (I think) of eventpress is that it doesn't
create any new tables. Registrations are posts of type ep_reg, events
are posts of type ep_event. All registrations for a post are children
of that event, with the author of the registration as the person who
registered.

Kunal

[Andre Dublin]

So the events are a custom post type, awesome thank you so much, I couldn't find the post type by searching the code but with this query I get all the events.

SELECT * FROM wp_posts WHERE post_type = 'ep_event'

[Kunal Bhalla]

Ah. Doesn't `query_posts( Array( 'post_type' => 'ep_event' ) );` work?

Kunal