function espresso_list_builder($sql, $template_file, $before, $after) { global $wpdb, $org_options; //echo 'This page is located in ' . get_option( 'upload_path' ); $event_page_id = $org_options['event_page_id']; $currency_symbol = $org_options['currency_symbol']; $events = $wpdb->get_results($sql); $category_id = $wpdb->last_result[0]->id; $category_name = $wpdb->last_result[0]->category_name; $category_desc = html_entity_decode(wpautop($wpdb->last_result[0]->category_desc)); $display_desc = $wpdb->last_result[0]->display_desc; if ($display_desc == 'Y') { echo '<p id="events_category_name-' . $category_id . '" class="events_category_name">' . stripslashes_deep($category_name) . '</p>'; echo wpautop($category_desc); } foreach ($events as $event) { $event_id = $event->id; $event_name = $event->event_name; $event_identifier = $event->event_identifier; $active = $event->is_active; $registration_start = $event->registration_start; $registration_end = $event->registration_end; $start_date = $event->start_date; $end_date = $event->end_date; $reg_limit = $event->reg_limit; $event_address = $event->address; $event_address2 = $event->address2; $event_city = $event->city; $event_state = $event->state; $event_zip = $event->zip; $event_country = $event->country; $member_only = $event->member_only; $externalURL = $event->externalURL; $recurrence_id = $event->recurrence_id; $allow_overflow = $event->allow_overflow; $overflow_event_id = $event->overflow_event_id; //Address formatting $location = ($event_address != '' ? $event_address : '') . ($event_address2 != '' ? '<br />' . $event_address2 : '') . ($event_city != '' ? '<br />' . $event_city : '') . ($event_state != '' ? ', ' . $event_state : '') . ($event_zip != '' ? '<br />' . $event_zip : '') . ($event_country != '' ? '<br />' . $event_country : ''); //Google map link creation $google_map_link = espresso_google_map_link(array('address' => $event_address, 'city' => $event_city, 'state' => $event_state, 'zip' => $event_zip, 'country' => $event_country, 'text' => 'Map and Directions', 'type' => 'text')); //These variables can be used with other the espresso_countdown, espresso_countup, and espresso_duration functions and/or any javascript based functions. $start_timestamp = espresso_event_time($event_id, 'start_timestamp', get_option('time_format')); $end_timestamp = espresso_event_time($event_id, 'end_timestamp', get_option('time_format')); //This can be used in place of the registration link if you are usign the external URL feature $registration_url = $externalURL != '' ? $externalURL : get_option('siteurl') . '/?page_id=' . $event_page_id . '®event_action=register&event_id=' . $event_id; if (!is_user_logged_in() && get_option('events_members_active') == 'true' && $member_only == 'Y') { //Display a message if the user is not logged in. //_e('Member Only Event. Please ','event_espresso') . event_espresso_user_login_link() . '.'; } else { //Serve up the event list //As of version 3.0.17 the event lsit details have been moved to event_list_display.php echo $before = $before == '' ? '' : $before; include 'templates/' . $template_file; echo $after = $after == '' ? '' : $after; } } //Check to see how many database queries were performed //echo '<p>Database Queries: ' . get_num_queries() .'</p>'; }
function espresso_event_list_attendee_title($event_id = NULL) { global $wpdb; $events = $wpdb->get_results("SELECT event_name FROM " . EVENTS_DETAIL_TABLE . " WHERE id = '" . $event_id . "' "); foreach ($events as $event) { $title_event_name = stripslashes_deep($event->event_name); } $content = $title_event_name; $content .= ' | '; $content .= 'ID: ' . $event_id; $content .= ' | '; $content .= espresso_event_time($event_id, 'start_date_time'); return $content; }
function espresso_get_table($sql) { global $wpdb, $org_options; //echo 'This page is located in ' . get_option( 'upload_path' ); $event_page_id = $org_options['event_page_id']; $currency_symbol = $org_options['currency_symbol']; $events = $wpdb->get_results($sql); $category_name = $wpdb->last_result[0]->category_name; $category_desc = $wpdb->last_result[0]->category_desc; $display_desc = $wpdb->last_result[0]->display_desc; if ($display_desc == 'Y') { echo '<p>' . stripslashes_deep($category_name) . '</p>'; echo '<p>' . stripslashes_deep($category_desc) . '</p>'; } ?> <table class="espresso-table" width="100%"> <thead class="espresso-table-header-row"> <tr> <th class="th-group"><?php _e('Course', 'event_espresso'); ?> </th> <th class="th-group"><?php _e('Location', 'event_espresso'); ?> </th> <th class="th-group"><?php _e('City', 'event_espresso'); ?> </th> <th class="th-group"><?php _e('State', 'event_espresso'); ?> </th> <th class="th-group"><?php _e('Date', 'event_espresso'); ?> </th> <th class="th-group"><?php _e('Time', 'event_espresso'); ?> </th> <th class="th-group"><?php _e('', 'event_espresso'); ?> </th> </tr> </thead> <tbody> <?php foreach ($events as $event) { $reg_limit = $event->reg_limit; $event_desc = wpautop($event->event_desc); $register_button = '<a id="a_register_link-' . $event->id . '" href="' . get_option('siteurl') . '/?page_id=' . $event_page_id . '®event_action=register&event_id=' . $event->id . '&name_of_event=' . stripslashes_deep($event->event_name) . '">Register</a>'; //Check to see how many open spots are available $open_spots = get_number_of_attendees_reg_limit($event->id, 'available_spaces') == 'Unlimited' ? 999 : get_number_of_attendees_reg_limit($event->id, 'available_spaces'); //echo $open_spots; if ($open_spots < 1) { $live_button = 'Closed'; } ?> <tr class="espresso-table-row"> <td class="td-group"> <?php echo $event->event_name; ?> </td> <td class="td-group"> <?php echo $event->address; ?> </td> <td class="td-group"> <?php echo $event->city; ?> </td> <td class="td-group"> <?php echo $event->state; ?> </td> <td class="td-group"> <?php echo event_date_display($event->start_date, $format = 'l, M d, Y'); ?> </td> <td class="td-group"> <?php echo espresso_event_time($event->id, 'start_time', get_option('time_format')); ?> </td> <td class="td-group"> <?php echo $register_button; ?> </td> </tr> <?php } //close foreach ?> </tbody> </table> <?php }
function event_espresso_get_event_details($sql, $css_class = NULL, $allow_override = 0) { global $wpdb, $org_options; //echo 'This page is located in ' . get_option( 'upload_path' ); $event_page_id = $org_options['event_page_id']; $currency_symbol = isset($org_options['currency_symbol']) ? $org_options['currency_symbol'] : ''; $events = $wpdb->get_results($sql); $category_id = isset($wpdb->last_result[0]->id) ? $wpdb->last_result[0]->id : ''; $category_name = isset($wpdb->last_result[0]->category_name) ? $wpdb->last_result[0]->category_name : ''; $category_identifier = isset($wpdb->last_result[0]->category_identifier) ? $wpdb->last_result[0]->category_identifier : ''; $category_desc = isset($wpdb->last_result[0]->category_desc) ? html_entity_decode(wpautop($wpdb->last_result[0]->category_desc)) : ''; $display_desc = isset($wpdb->last_result[0]->display_desc) ? $wpdb->last_result[0]->display_desc : ''; /* group recuring events */ $events_type_index = -1; $events_of_same_type = array(); $last_recurrence_id = null; /* end group recuring events */ if ($display_desc == 'Y') { echo '<p id="events_category_name-' . $category_id . '" class="events_category_name">' . stripslashes_deep($category_name) . '</p>'; echo wpautop($category_desc); } foreach ($events as $event) { $event_id = $event->id; $event_name = $event->event_name; $event_desc = $event->event_desc; $event_identifier = $event->event_identifier; $active = $event->is_active; $registration_start = $event->registration_start; $registration_end = $event->registration_end; $start_date = $event->start_date; $end_date = $event->end_date; $reg_limit = $event->reg_limit; $event_address = $event->address; $event_address2 = $event->address2; $event_city = $event->city; $event_state = $event->state; $event_zip = $event->zip; $event_country = $event->country; $member_only = $event->member_only; $externalURL = $event->externalURL; $recurrence_id = $event->recurrence_id; $allow_overflow = $event->allow_overflow; $overflow_event_id = $event->overflow_event_id; //Address formatting $location = ($event_address != '' ? $event_address : '') . ($event_address2 != '' ? '<br />' . $event_address2 : '') . ($event_city != '' ? '<br />' . $event_city : '') . ($event_state != '' ? ', ' . $event_state : '') . ($event_zip != '' ? '<br />' . $event_zip : '') . ($event_country != '' ? '<br />' . $event_country : ''); //Google map link creation $google_map_link = espresso_google_map_link(array('address' => $event_address, 'city' => $event_city, 'state' => $event_state, 'zip' => $event_zip, 'country' => $event_country, 'text' => 'Map and Directions', 'type' => 'text')); //These variables can be used with other the espresso_countdown, espresso_countup, and espresso_duration functions and/or any javascript based functions. $start_timestamp = espresso_event_time($event_id, 'start_timestamp'); $end_timestamp = espresso_event_time($event_id, 'end_timestamp'); //This can be used in place of the registration link if you are usign the external URL feature $registration_url = $externalURL != '' ? $externalURL : get_option('siteurl') . '/?page_id=' . $event_page_id . '®event_action=register&event_id=' . $event_id . '&name_of_event=' . stripslashes_deep($event_name); if (!is_user_logged_in() && get_option('events_members_active') == 'true' && $member_only == 'Y') { //Display a message if the user is not logged in. //_e('Member Only Event. Please ','event_espresso') . event_espresso_user_login_link() . '.'; } else { //Serve up the event list //As of version 3.0.17 the event lsit details have been moved to event_list_display.php switch (event_espresso_get_status($event_id)) { case 'NOT_ACTIVE': //Don't show the event if any of the above are true break; default: /* skip secondary (waitlist) events */ $event_status = event_espresso_get_is_active($event_id); if ($event_status['status'] == 'SECONDARY') { break; } /* group recuring events */ $is_new_event_type = $last_recurrence_id == 0 || $last_recurrence_id != $recurrence_id; if ($is_new_event_type) { $events_type_index++; $events_of_same_type[$events_type_index] = array(); } $event_data = array('event_id' => $event_id, 'event_page_id' => $event_page_id, 'event_name' => $event_name, 'event_desc' => $event_desc, 'start_date' => $start_date, 'end_date' => $end_date, 'reg_limit' => $reg_limit, 'registration_url' => $registration_url, 'overflow_event_id' => $overflow_event_id); array_push($events_of_same_type[$events_type_index], $event_data); $last_recurrence_id = $recurrence_id; // include('event_list_display.php'); break; } } } /* group recuring events */ foreach ($events_of_same_type as $events_group) { include 'event_list_display.php'; } /* end group recuring events */ //Check to see how many database queries were performed //echo '<p>Database Queries: ' . get_num_queries() .'</p>'; }
function espresso_event_time_sc($atts) { global $this_event_id; extract(shortcode_atts(array('event_id' => '0', 'type' => '', 'format' => ''), $atts)); $event_id = isset($this_event_id) && !empty($this_event_id) ? $this_event_id : $event_id; if (empty($event_id)) { return; } ob_start(); echo espresso_event_time($event_id, $type, $format); $buffer = ob_get_contents(); ob_end_clean(); return $buffer; }
function espresso_event_time_sc($atts) { extract(shortcode_atts(array('event_id' => '0', 'type' => '', 'format' => ''), $atts)); $event_id = "{$event_id}"; $type = "{$type}"; $format = "{$format}"; return espresso_event_time($event_id, $type, $format); }