Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php ?>
- <ol class="<?php espresso_template_css_class('attendee_list','attendee_list'); ?>">
- <?php
- $a_sql = "SELECT * FROM " . EVENTS_ATTENDEE_TABLE . " WHERE event_id='" . $event_id . "'";
- $a_sql .= $paid_only == 'true'? " AND (payment_status='Completed' OR payment_status='Pending' OR payment_status='Refund') ":'';
- $a_sql .= $sort;
- //echo $a_sql;
- $attendees = $wpdb->get_results($a_sql);
- foreach ($attendees as $attendee){
- /* GET THE USER BASED ON EMAIL */
- $the_user = get_user_by( 'email', $attendee->email );
- //var_dump($the_user);
- $id = $attendee->id;
- $lname = $attendee->lname;
- $fname = $attendee->fname;
- $city = $attendee->city;
- $state = $attendee->state;
- $country = $attendee->state;
- $email = $attendee->email;
- $gravatar = $show_gravatar == 'true'? get_avatar( $email, $size = '100', $default = 'http://www.gravatar.com/avatar/' ) : '';
- $city_state = $city != '' || $state != '' ? '<br />' . ($city != '' ? $city :'') . ($state != '' ? ', ' . $state :' ') :'';
- //These are example variables to show answers to questions
- //$custom_question_1 = '<br />'.do_shortcode('[EE_ANSWER q="12" a="'.$id.'"]');
- //$custom_question_2 = '<br />'.do_shortcode('[EE_ANSWER q="13" a="'.$id.'"]');
- ?>
- <li class="<?php espresso_template_css_class('attendee_details','attendee_details'); ?>"> (<?php echo $the_user->ID; ?>) <span class="<?php espresso_template_css_class('espresso_attendee','espresso_attendee'); ?>"><?php echo $gravatar ?><?php echo stripslashes_deep($fname . ' ' . $lname) . $city_state .'</p>'; ?> </span>
- <div class="clear"></div>
- </li>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement