Support

May 21, 2015 at 6:32 am

Hi Joost,

Sorry for the delay in responding.

Looking at it, it might be a single line of code or a block of code.

You would need to change the SQL command to basically pull in another database table (or two) containing the attendees answers, as these are stored separately.

It might be easier (but slower), the add an SQL request in the foreach to query the esp_answer database for the answers.

Something like:

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 * ";
        $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){
          
            $REG_ID = $attendee->REG_ID;
            $sql2 = "SELECT * FROM {$wpdb->prefix}esp_answer WHERE REG_ID = %d";
            $answers = $wpdb->get_results( $wpdb->prepare( $sql2, $REG_ID ));
            echo "<pre>" . print_r( $answers, 1 ) . "</pre>"; 

            $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;
 
}

That’s just an example that will dump the data, not do anything with it. You could probably make the initial SQL statement better, and avoid the SQL per attendee, but my SQL-fu is not that good.

May 25, 2015 at 9:34 am

Hi, we are actually working on introducing an attendee list shortcode into Event Espresso 4. This should be available within a couple weeks.

—
Lorenzo