Support

April 16, 2015 at 11:04 am

Basically im using this to get all attandees to an event :

$sql = "SELECT * ";
$sql .= "FROM {$wpdb->prefix}esp_attendee_meta ";
$sql .= "INNER JOIN {$wpdb->prefix}esp_registration ";
$sql .= "ON {$wpdb->prefix}esp_attendee_meta.ATT_ID = {$wpdb->prefix}esp_registration.ATT_ID ";
$sql .= "WHERE {$wpdb->prefix}esp_registration.EVT_ID = %d";

$attendees = $wpdb->get_results( $wpdb->prepare( $sql, $event_id ));

but i need an additional ID which is saying Which User ID bought the ticket (which is the member).

a code snippet would be great, dont know what table needs to be joined.

Best regards

April 17, 2015 at 2:24 am

Yea, all above is per order basis.

So for example my Member decides to come back (after the first purchase, and member always logged in, must be, purchase is login restricted), and buy more tickets for other guest, friends, users, (as a second round), there is nothing common in the two purchases, no object parameter that could be a base of grouping different transactions / attendees by the same member (buyer), who bought the tickets.

Im trying to explain it very well.
I need to make queries, where im able to group attendees based on the Member, who bought the ticket per Event. Thats should be a Buyer ID; which is simply the same User ID for every different purchase.

This is good for checking, IF the user bought tickets already. Then i can hide Ticket Types.

Also good for a very good looking CSV Export Where all the attendees related to the Buyer.

April 21, 2015 at 6:25 am

Hey josh,

thanks for useful reply, we already using something similar. Which is working, my problem is that If im coming back and book tickets for someone else. That is always updating my profile. As i see the regsitration forms’s First entry always updating the logged in users profile.

Can i turn that off somehow?

many thanks