Support

November 5, 2013 at 6:07 am

Hi,

Unfortunately there’s no easy way of doing this currently.

The wp_events_member_rel table stores information to collate ‘users’ with events. You’d need the event_id, user_id, user_role and attendee_id from various locations and then collate the information together.

Using phpMyAdmin or equivalent you could search the attendees table to find the attendee information, you’ll need the right attendee_id based on a completed transaction and the event ID’s for the attendee (as some attendees will be registered on more than one event) then search the wp_users table to get the user_id (based on email)