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