Support

July 4, 2014 at 6:18 am

Hi,

This page contains some code snippets: https://eventespresso.com/wiki/useful-php-code-snippets/

You could use the “Print an attendee list after the content on the event details page” and modify it so that it would work from a shortcode instead of a function.

Something like this could be added to your themes functions.php or a custom files plugin:

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 = '<li>'. $gravatar .'<span>'. $fname .' '. $lname . '</span></li>';
            echo $html;
        }
    
        echo '</ul>';

return;

}

Then add the shortcode [display_those_attendees eventid=”83″] into a password protected page.

July 4, 2014 at 9:12 am

On line 15 of that snippet you’ll find

$sql .= "WHERE {$wpdb->prefix}esp_registration.EVT_ID = %d";

Add a space after %d and then under that add:

$sql .= "AND {$wpdb->prefix}esp_registration.STS_ID = 'RAP'";

That will then only pull Approved registrations from the DB.

Does that help?