function event_espresso_show_attendess($sql, $show_gravatar, $paid_only, $sort = '')
    {
        //echo $sql;
        global $wpdb, $this_is_a_reg_page;
        $events = $wpdb->get_results($sql);
        foreach ($events as $event) {
            $event_id = $event->id;
            $event_name = stripslashes_deep($event->event_name);
            if ($this_is_a_reg_page != TRUE) {
                $event_desc = do_shortcode(stripslashes_deep($event->event_desc));
            }
            //This variable is only available using the espresso_event_status function which is loacted in the Custom Files Addon (http://eventespresso.com/download/plugins-and-addons/custom-files-addon/)
            $event_status = function_exists('espresso_event_status') ? espresso_event_status($event_id) : '';
            //Example usage in the event title:
            /*<h2><?php _e('Attendee Listing For: ','event_espresso'); ?><?php echo $event_name . ' - ' . $event_status?> </h2>*/
            ?>
				<h2 class="espresso_al_title"><?php 
            _e('Attendee Listing For: ', 'event_espresso');
            echo $event_name . ' - ' . $event_status;
            ?>
 </h2>
					<?php 
            echo wpautop($event_desc);
            ?>
					<ol class="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') " : '';
            $a_sql .= $sort;
            //echo $a_sql;
            $attendees = $wpdb->get_results($a_sql);
            foreach ($attendees as $attendee) {
                $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/') : '';
                ?>
					  <li class="attendee_details">
						<div class="espresso_attendee"><?php 
                echo $gravatar;
                echo '<p><strong>' . stripslashes_deep($fname . ' ' . $lname) . '</strong><br />' . ($city != '' ? $city : '') . ($state != '' ? ', ' . $state : ' ') . '</p>';
                ?>
 </div>
						<div class="clear"></div>
					  </li>
					  <?php 
            }
            ?>
					</ol>
	<?php 
        }
    }
 */
?>
<p><?php 
_e('Event Organizer: ', 'event_espresso') . espresso_organization_name($EVT_ID);
?>
<br/>
<?php 
_e('Organizer Email: ', 'event_espresso') . espresso_organization_email($EVT_ID);
?>
<br/>
<?php 
_e('Event Phone: ', 'event_espresso') . espresso_event_phone($EVT_ID);
?>
</p>
<p><?php 
_e('Event Status: ', 'event_espresso') . espresso_event_status($EVT_ID);
?>
</p>
<p><?php 
_e('Categories: ', 'event_espresso') . espresso_event_categories($EVT_ID);
?>
</p>
<?php 
_e('Dates and Times: ', 'event_espresso') . espresso_list_of_event_dates($EVT_ID);
_e('Available Tickets: ', 'event_espresso') . espresso_event_tickets_available($EVT_ID);
?>
<p><?php 
_e('Event Venue: ', 'event_espresso') . espresso_venue_name(NULL, FALSE);
?>
</p>
<p><?php 
예제 #3
0
    function event_espresso_show_attendess($sql, $show_gravatar, $paid_only, $sort = '')
    {
        //echo $sql;
        global $wpdb, $this_is_a_reg_page;
        $events = $wpdb->get_results($sql);
        foreach ($events as $event) {
            $event_id = $event->id;
            $event_name = stripslashes_deep($event->event_name);
            if (!$this_is_a_reg_page) {
                $event_desc = do_shortcode(stripslashes_deep($event->event_desc));
            }
            //This variable is only available using the espresso_event_status function which is loacted in the Custom Files Addon (http://eventespresso.com/download/plugins-and-addons/custom-files-addon/)
            $event_status = function_exists('espresso_event_status') ? ' - ' . espresso_event_status($event_id) : '';
            //Example usage in the event title:
            /*<h2><?php _e('Attendee Listing For: ','event_espresso'); ?><?php echo $event_name . ' - ' . $event_status?> </h2>*/
            ?>

<div class="event-display-boxes ui-widget">

		<h2 class="event_title ui-widget-header ui-corner-top">
	<?php 
            _e('Attendee Listing For: ', 'event_espresso');
            ?>
	<?php 
            echo $event_name . $event_status;
            ?>
</h2>

		<div class="event-data-display ui-widget-content ui-corner-bottom">

		<?php 
            //echo wpautop($event_desc);
            ?>
			<ol class="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') " : '';
            $a_sql .= $sort;
            //echo $a_sql;
            $attendees = $wpdb->get_results($a_sql);
            foreach ($attendees as $attendee) {
                $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="attendee_details"> <span class="espresso_attendee"><?php 
                echo $gravatar;
                echo stripslashes_deep($fname . ' ' . $lname) . $city_state . '</p>';
                ?>
 </span>
							<div class="clear"></div>
						</li>
				<?php 
            }
            ?>
			</ol>
	</div>
</div>
<?php 
        }
    }