Support

July 28, 2014 at 10:47 pm

Thanks Tony,

This is the output I receive when i use the method of creating a plugin and adding a page with shortcode [display_those_attendees eventid=”1774″]. see here http://burtongarran50th.org/?page_id=1855

I have a multiticket setup and wish to show the names of people attending each of the ticketed events within the ticket.

Below is the code I used to make the widget.
Ideally it would show the name of the individual sub ticket and who is attending.

<?php
/*
Plugin Name: Site plugin for EE4plugin home made
Description: Site specific code for burtongarran50th.org
*/
/* Begin Adding Functions Below This Line */

add_shortcode(‘display_those_attendees’, ‘ee_attendee_list’ );

function ee_attendee_list($atts){
global $wpdb, $post;

$EVT_ID = $atts[‘eventid’];
$post = get_post( $EVT_ID );

echo ‘<ul class=”attendee-list”>’;

$sql = “SELECT ATT_fname, ATT_lname, ATT_email “;
$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, $post->ID ));

foreach($attendees as $attendee){
$fname = $attendee->ATT_fname;
$lname = $attendee->ATT_lname;
$email = $attendee->ATT_email;
$gravatar = get_avatar( $email, ’64’, ‘identicon’ );
$html = ‘

‘;
echo $html;
}

echo ‘‘;

return;

}
/* Stop Adding Functions */