function eme_cleanup_page()
{
global $wpdb, $eme_timezone;
$bookings_table = $wpdb->prefix . BOOKINGS_TBNAME;
$events_table = $wpdb->prefix . EVENTS_TBNAME;
$recurrence_table = $wpdb->prefix . RECURRENCE_TBNAME;
$message = "";
if (current_user_can(get_option('eme_cap_cleanup'))) {
// do the actions if required
if (isset($_POST['eme_admin_action']) && $_POST['eme_admin_action'] == "eme_cleanup" && isset($_POST['eme_number']) && isset($_POST['eme_period'])) {
$eme_number = intval($_POST['eme_number']);
$eme_period = $_POST['eme_period'];
$eme_date_obj = new ExpressiveDate(null, $eme_timezone);
if (!in_array($eme_period, array('day', 'week', 'month'))) {
$eme_period = "month";
}
switch ($eme_period) {
case 'day':
$eme_date_obj->minusDays($eme_number);
break;
case 'week':
$eme_date_obj->minusWeeks($eme_number);
break;
default:
$eme_date_obj->minusMonths($eme_number);
break;
}
$end_date = $eme_date_obj->getDate();
$wpdb->query("DELETE FROM {$bookings_table} where event_id in (SELECT event_id from {$events_table} where event_end_date<'{$end_date}')");
$wpdb->query("DELETE FROM {$events_table} where event_end_date<'{$end_date}'");
$wpdb->query("DELETE FROM {$recurrence_table} where recurence_freq <> 'specific' AND recurrence_end_date<'{$end_date}'");
$message = sprintf(__("Cleanup done: events (and corresponding booking data) older than %d %s(s) have been removed.", "eme"), $eme_number, $eme_period);
}
}
eme_cleanup_form($message);
}
function eme_replace_placeholders($format, $event, $target = "html", $do_shortcode = 1, $lang = '')
{
global $eme_need_gmap_js, $eme_timezone;
// an initial filter for the format, in case people want to change anything before the placeholders get replaced
if (has_filter('eme_events_format_prefilter')) {
$format = apply_filters('eme_events_format_prefilter', $format, $event);
}
// some variables we'll use further down more than once
$current_userid = get_current_user_id();
$person_id = eme_get_person_id_by_wp_id($current_userid);
$eme_enable_notes_placeholders = get_option('eme_enable_notes_placeholders');
if (isset($event['location_id']) && $event['location_id']) {
$location = eme_get_location($event['location_id']);
} else {
$location = eme_new_location();
}
// first replace the notes sections, since these can contain other placeholders
if ($eme_enable_notes_placeholders) {
$format = eme_replace_notes_placeholders($format, $event, $target);
}
// then we do the custom attributes, since these can contain other placeholders
preg_match_all("/#(ESC|URL)?_ATT\\{.+?\\}(\\{.+?\\})?/", $format, $results);
foreach ($results[0] as $resultKey => $result) {
$need_escape = 0;
$need_urlencode = 0;
$orig_result = $result;
if (strstr($result, '#ESC')) {
$result = str_replace("#ESC", "#", $result);
$need_escape = 1;
} elseif (strstr($result, '#URL')) {
$result = str_replace("#URL", "#", $result);
$need_urlencode = 1;
}
$replacement = "";
//Strip string of placeholder and just leave the reference
$attRef = substr(substr($result, 0, strpos($result, '}')), 6);
if (isset($event['event_attributes'][$attRef])) {
$replacement = $event['event_attributes'][$attRef];
}
if (trim($replacement) == '' && isset($results[2][$resultKey]) && $results[2][$resultKey] != '') {
//Check to see if we have a second set of braces;
$replacement = substr($results[2][$resultKey], 1, strlen(trim($results[2][$resultKey])) - 2);
}
if ($need_escape) {
$replacement = eme_sanitize_request(eme_sanitize_html(preg_replace('/\\n|\\r/', '', $replacement)));
}
if ($need_urlencode) {
$replacement = rawurlencode($replacement);
}
$format = str_replace($orig_result, $replacement, $format);
}
// and now all the other placeholders
$legacy = get_option('eme_legacy');
$deprecated = get_option('eme_deprecated');
if ($legacy) {
preg_match_all("/#(ESC|URL)?@?_?[A-Za-z0-9_]+(\\[.*\\])?(\\[.*\\])?/", $format, $placeholders);
} else {
preg_match_all("/#(ESC|URL)?@?_?[A-Za-z0-9_]+(\\{.*?\\})?(\\{.*?\\})?/", $format, $placeholders);
}
// make sure we set the largest matched placeholders first, otherwise if you found e.g.
// #_LOCATION, part of #_LOCATIONPAGEURL would get replaced as well ...
usort($placeholders[0], 'sort_stringlenth');
// if the add and remove booking form appear on the same page, we need to decide which form shows the "message" upon booking
// the first one wins
$a1 = strpos($format, "ADDBOOKINGFORM");
$a2 = strpos($format, "REMOVEBOOKINGFORM");
$show_message_on_add = 1;
$show_message_on_remove = 1;
if ($a1 !== false && $a2 !== false) {
if ($a1 < $a2) {
$show_message_on_remove = 0;
} else {
$show_message_on_add = 0;
}
}
$eme_date_obj_now = new ExpressiveDate(null, $eme_timezone);
foreach ($placeholders[0] as $result) {
$need_escape = 0;
$need_urlencode = 0;
$orig_result = $result;
$found = 1;
if (strstr($result, '#ESC')) {
$result = str_replace("#ESC", "#", $result);
$need_escape = 1;
} elseif (strstr($result, '#URL')) {
$result = str_replace("#URL", "#", $result);
$need_urlencode = 1;
}
$replacement = "";
// matches all fields placeholder
if ($event && preg_match('/#_EDITEVENTLINK/', $result)) {
if (current_user_can(get_option('eme_cap_edit_events')) || current_user_can(get_option('eme_cap_author_event')) && ($event['event_author'] == $current_userid || $event['event_contactperson_id'] == $current_userid)) {
$replacement = "<a href=' " . admin_url("admin.php?page=events-manager&eme_admin_action=edit_event&event_id=" . $event['event_id']) . "'>" . __('Edit') . "</a>";
}
} elseif ($event && preg_match('/#_EDITEVENTURL/', $result)) {
if (current_user_can(get_option('eme_cap_edit_events')) || current_user_can(get_option('eme_cap_author_event')) && ($event['event_author'] == $current_userid || $event['event_contactperson_id'] == $current_userid)) {
$replacement = admin_url("admin.php?page=events-manager&eme_admin_action=edit_event&event_id=" . $event['event_id']);
}
} elseif ($event && preg_match('/#_EVENTPRINTBOOKINGSLINK/', $result)) {
if (current_user_can(get_option('eme_cap_edit_events')) || current_user_can(get_option('eme_cap_list_events')) || current_user_can(get_option('eme_cap_author_event')) && ($event['event_author'] == $current_userid || $event['event_contactperson_id'] == $current_userid)) {
$replacement = "<a href=' " . admin_url("admin.php?page=eme-people&eme_admin_action=booking_printable&event_id=" . $event['event_id']) . "'>" . __('Printable view of bookings', 'eme') . "</a>";
}
} elseif ($event && preg_match('/#_EVENTPRINTBOOKINGSURL/', $result)) {
if (current_user_can(get_option('eme_cap_edit_events')) || current_user_can(get_option('eme_cap_list_events')) || current_user_can(get_option('eme_cap_author_event')) && ($event['event_author'] == $current_userid || $event['event_contactperson_id'] == $current_userid)) {
$replacement = admin_url("admin.php?page=eme-people&eme_admin_action=booking_printable&event_id=" . $event['event_id']);
}
} elseif ($event && preg_match('/#_EVENTCSVBOOKINGSLINK/', $result)) {
if (current_user_can(get_option('eme_cap_edit_events')) || current_user_can(get_option('eme_cap_list_events')) || current_user_can(get_option('eme_cap_author_event')) && ($event['event_author'] == $current_userid || $event['event_contactperson_id'] == $current_userid)) {
$replacement = "<a href=' " . admin_url("admin.php?page=eme-people&eme_admin_action=booking_csv&event_id=" . $event['event_id']) . "'>" . __('Printable view of bookings', 'eme') . "</a>";
}
} elseif ($event && preg_match('/#_EVENTCSVBOOKINGSURL/', $result)) {
if (current_user_can(get_option('eme_cap_edit_events')) || current_user_can(get_option('eme_cap_list_events')) || current_user_can(get_option('eme_cap_author_event')) && ($event['event_author'] == $current_userid || $event['event_contactperson_id'] == $current_userid)) {
$replacement = admin_url("admin.php?page=eme-people&eme_admin_action=booking_csv&event_id=" . $event['event_id']);
}
} elseif ($event && preg_match('/#_STARTDATE/', $result)) {
$replacement = eme_localised_date($event['event_start_date'] . " " . $event['event_start_time'] . " " . $eme_timezone);
} elseif ($event && preg_match('/#_STARTTIME/', $result)) {
$replacement = eme_localised_time($event['event_start_date'] . " " . $event['event_start_time'] . " " . $eme_timezone);
} elseif ($event && preg_match('/#_ENDDATE/', $result)) {
$replacement = eme_localised_date($event['event_end_date'] . " " . $event['event_end_time'] . " " . $eme_timezone);
} elseif ($event && preg_match('/#_ENDTIME/', $result)) {
$replacement = eme_localised_time($event['event_end_date'] . " " . $event['event_end_time'] . " " . $eme_timezone);
} elseif ($event && preg_match('/#_24HSTARTTIME/', $result)) {
$replacement = substr($event['event_start_time'], 0, 5);
} elseif ($event && preg_match('/#_24HENDTIME$/', $result)) {
$replacement = substr($event['event_end_time'], 0, 5);
} elseif ($event && preg_match('/#_PAST_FUTURE_CLASS/', $result)) {
$eme_start_obj = new ExpressiveDate($event['event_start_date'] . " " . $event['event_start_time'], $eme_timezone);
$eme_end_obj = new ExpressiveDate($event['event_end_date'] . " " . $event['event_end_time'], $eme_timezone);
if ($eme_start_obj->greaterThan($eme_date_obj_now)) {
$replacement = "eme-future-event";
} elseif ($eme_start_obj->lessOrEqualTo($eme_date_obj_now) && $eme_end_obj->greaterOrEqualTo($eme_date_obj_now)) {
$replacement = "eme-ongoing-event";
} else {
$replacement = "eme-past-event";
}
} elseif ($event && preg_match('/#_12HSTARTTIME$/', $result)) {
$replacement = $eme_date_obj_now->copy()->setTimestampFromString($event['event_start_date'] . " " . $event['event_start_time'] . " " . $eme_timezone)->format('h:i A');
} elseif ($event && preg_match('/#_12HENDTIME$/', $result)) {
$replacement = $eme_date_obj_now->copy()->setTimestampFromString($event['event_end_date'] . " " . $event['event_end_time'] . " " . $eme_timezone)->format('h:i A');
} elseif ($event && preg_match('/#_12HSTARTTIME_NOLEADINGZERO/', $result)) {
$replacement = $eme_date_obj_now->copy()->setTimestampFromString($event['event_start_date'] . " " . $event['event_start_time'] . " " . $eme_timezone)->format('g:i A');
if (get_option('eme_time_remove_leading_zeros')) {
$replacement = str_replace(":00", "", $replacement);
$replacement = str_replace(":0", ":", $replacement);
}
} elseif ($event && preg_match('/#_12HENDTIME_NOLEADINGZERO/', $result)) {
$replacement = $eme_date_obj_now->copy()->setTimestampFromString($event['event_end_date'] . " " . $event['event_end_time'] . " " . $eme_timezone)->format('g:i A');
if (get_option('eme_time_remove_leading_zeros')) {
$replacement = str_replace(":00", "", $replacement);
$replacement = str_replace(":0", ":", $replacement);
}
} elseif ($event && preg_match('/#_MAP/', $result)) {
if ($target == "rss" || $target == "text") {
$replacement = "";
} elseif (isset($event['location_id']) && $event['location_id']) {
$replacement = eme_single_location_map($location);
}
} elseif ($event && preg_match('/#_DIRECTIONS/', $result)) {
if ($target == "rss" || $target == "text") {
$replacement = "";
} elseif (isset($event['location_id']) && $event['location_id']) {
$replacement = eme_add_directions_form($location);
}
} elseif ($event && preg_match('/#_EVENTS_FILTERFORM/', $result)) {
if ($target == "rss" || $target == "text" || eme_is_single_event_page()) {
$replacement = "";
} else {
$replacement = eme_filter_form();
}
} elseif ($event && preg_match('/#_ADDBOOKINGFORM$/', $result)) {
if ($target == "rss" || $target == "text") {
$replacement = "";
} else {
$replacement = eme_add_booking_form($event['event_id'], $show_message_on_add);
}
} elseif ($event && preg_match('/#_ADDBOOKINGFORM_IF_NOT_REGISTERED/', $result)) {
if ($target == "rss" || $target == "text") {
$replacement = "";
} else {
$not_registered_only = 1;
$replacement = eme_add_booking_form($event['event_id'], $show_message_on_add, $not_registered_only);
}
} elseif ($event && preg_match('/#_REMOVEBOOKINGFORM$/', $result)) {
if ($target == "rss" || $target == "text") {
$replacement = "";
} else {
// when the booking just happened and the user needs to pay, we don't show the remove booking form
if ($booking_id_done && eme_event_can_pay_online($event)) {
$replacement = "";
} else {
$replacement = eme_delete_booking_form($event['event_id'], $show_message_on_remove);
}
}
} elseif ($event && preg_match('/#_REMOVEBOOKINGFORM_IF_REGISTERED/', $result)) {
if ($target == "rss" || $target == "text") {
$replacement = "";
} elseif (is_user_logged_in()) {
// when the booking just happened and the user needs to pay, we don't show the remove booking form
if ($booking_id_done && eme_event_can_pay_online($event)) {
$replacement = "";
} elseif (eme_get_booking_ids_by_wp_id($current_userid, $event['event_id'])) {
$replacement = eme_delete_booking_form($event['event_id'], $show_message_on_remove);
}
}
} elseif ($event && preg_match('/#_(AVAILABLESPACES|AVAILABLESEATS)$/', $result)) {
$replacement = eme_get_available_seats($event['event_id']);
} elseif ($deprecated && preg_match('/#_(AVAILABLESPACES|AVAILABLESEATS)(\\d+)/', $result, $matches) || preg_match('/#_(AVAILABLESPACES|AVAILABLESEATS)\\{(\\d+)\\}/', $result, $matches)) {
$field_id = intval($matches[2]) - 1;
if (eme_is_multi($event['event_seats'])) {
$seats = eme_get_available_multiseats($event['event_id']);
if (array_key_exists($field_id, $seats)) {
$replacement = $seats[$field_id];
}
}
} elseif ($event && preg_match('/#_(TOTALSPACES|TOTALSEATS)$/', $result)) {
$replacement = $event['event_seats'];
} elseif ($deprecated && preg_match('/#_(TOTALSPACES|TOTALSEATS)(\\d+)/', $result, $matches) || preg_match('/#_(TOTALSPACES|TOTALSEATS)\\{(\\d+)\\}/', $result, $matches)) {
$field_id = intval($matches[2]) - 1;
$replacement = 0;
if (eme_is_multi($event['event_seats'])) {
$seats = eme_convert_multi2array($event['event_seats']);
if (array_key_exists($field_id, $seats)) {
$replacement = $seats[$field_id];
}
}
} elseif ($event && preg_match('/#_(RESERVEDSPACES|BOOKEDSEATS)$/', $result)) {
$replacement = eme_get_booked_seats($event['event_id']);
} elseif ($deprecated && preg_match('/#_(RESERVEDSPACES|BOOKEDSEATS)(\\d+)/', $result, $matches) || preg_match('/#_(RESERVEDSPACES|BOOKEDSEATS)\\{(\\d+)\\}/', $result, $matches)) {
$field_id = intval($matches[2]) - 1;
$replacement = 0;
if (eme_is_multi($event['event_seats'])) {
$seats = eme_get_booked_multiseats($event['event_id']);
if (array_key_exists($field_id, $seats)) {
$replacement = $seats[$field_id];
}
}
} elseif ($event && preg_match('/#_(PENDINGSPACES|PENDINGSEATS)$/', $result)) {
$replacement = eme_get_pending_seats($event['event_id']);
} elseif ($event && preg_match('/#_(PENDINGSPACES|PENDINGSEATS)\\{(\\d+)\\}/', $result, $matches)) {
$field_id = intval($matches[2]) - 1;
$replacement = 0;
if (eme_is_multi($event['event_seats'])) {
$seats = eme_get_pending_multiseats($event['event_id']);
if (array_key_exists($field_id, $seats)) {
$replacement = $seats[$field_id];
}
}
} elseif ($event && preg_match('/#_(APPROVEDSPACES|APPROVEDSEATS)$/', $result)) {
$replacement = eme_get_approved_seats($event['event_id']);
} elseif ($event && preg_match('/#_(APPROVEDSPACES|APPROVEDSEATS)\\{(\\d+)\\}/', $result, $matches)) {
$field_id = intval($matches[2]) - 1;
$replacement = 0;
if (eme_is_multi($event['event_seats'])) {
$seats = eme_get_approved_multiseats($event['event_id']);
if (array_key_exists($field_id, $seats)) {
$replacement = $seats[$field_id];
}
}
} elseif ($event && preg_match('/#_USER_(RESERVEDSPACES|BOOKEDSEATS)$/', $result)) {
if (is_user_logged_in()) {
$replacement = eme_get_booked_seats_by_wp_event_id($current_userid, $event['event_id']);
}
} elseif ($event && preg_match('/#_LINKEDNAME/', $result)) {
$event_link = eme_event_url($event, $lang);
if ($target == "html") {
$replacement = "<a href='{$event_link}' title='" . eme_trans_sanitize_html($event['event_name'], $lang) . "'>" . eme_trans_sanitize_html($event['event_name'], $lang) . "</a>";
} else {
$replacement = eme_translate($event['event_name'], $lang);
}
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_ICALLINK/', $result)) {
$url = site_url("/?eme_ical=public_single&event_id=" . $event['event_id']);
$replacement = "<a href='{$url}'>ICAL</a>";
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_ICALURL/', $result)) {
$replacement = site_url("/?eme_ical=public_single&event_id=" . $event['event_id']);
} elseif ($event && preg_match('/#_EVENTIMAGE$/', $result)) {
if (!empty($event['event_image_id'])) {
$event['event_image_url'] = wp_get_attachment_url($event['event_image_id']);
}
if ($event['event_image_url'] != '') {
$replacement = "<img src='" . $event['event_image_url'] . "' alt='" . eme_trans_sanitize_html($event['event_name'], $lang) . "'/>";
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
} elseif ($event && preg_match('/#_EVENTIMAGEURL$/', $result)) {
if (!empty($event['event_image_id'])) {
$event['event_image_url'] = wp_get_attachment_url($event['event_image_id']);
}
if ($event['event_image_url'] != '') {
$replacement = $event['event_image_url'];
}
} elseif ($event && preg_match('/#_EVENTIMAGETHUMB$/', $result)) {
if (!empty($event['event_image_id'])) {
$thumb_array = image_downsize($event['event_image_id'], get_option('eme_thumbnail_size'));
$thumb_url = $thumb_array[0];
$thumb_width = $thumb_array[1];
$thumb_height = $thumb_array[2];
$replacement = "<img width='{$thumb_width}' height='{$thumb_height}' src='" . $thumb_url . "' alt='" . eme_trans_sanitize_html($event['event_name'], $lang) . "'/>";
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
} elseif ($event && preg_match('/#_EVENTIMAGETHUMBURL$/', $result)) {
if (!empty($event['event_image_id'])) {
$thumb_array = image_downsize($event['event_image_id'], get_option('eme_thumbnail_size'));
$thumb_url = $thumb_array[0];
$replacement = $thumb_url;
}
} elseif ($event && preg_match('/#_EVENTIMAGETHUMB\\{(.+)\\}/', $result, $matches)) {
if (!empty($event['event_image_id'])) {
$thumb_array = image_downsize($event['event_image_id'], $matches[1]);
$thumb_url = $thumb_array[0];
$thumb_width = $thumb_array[1];
$thumb_height = $thumb_array[2];
$replacement = "<img width='{$thumb_width}' height='{$thumb_height}' src='" . $thumb_url . "' alt='" . eme_trans_sanitize_html($event['event_name'], $lang) . "'/>";
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
} elseif ($legacy && $event && preg_match('/#_EVENTIMAGETHUMB\\[(.+)\\]/', $result, $matches)) {
if (!empty($event['event_image_id'])) {
$thumb_array = image_downsize($event['event_image_id'], $matches[1]);
$thumb_url = $thumb_array[0];
$thumb_width = $thumb_array[1];
$thumb_height = $thumb_array[2];
$replacement = "<img width='{$thumb_width}' height='{$thumb_height}' src='" . $thumb_url . "' alt='" . eme_trans_sanitize_html($event['event_name'], $lang) . "'/>";
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
} elseif ($event && preg_match('/#_EVENTIMAGETHUMBURL\\{(.+)\\}/', $result, $matches)) {
if (!empty($event['event_image_id'])) {
$thumb_array = image_downsize($event['event_image_id'], $matches[1]);
$thumb_url = $thumb_array[0];
$replacement = $thumb_url;
}
} elseif ($legacy && $event && preg_match('/#_EVENTIMAGETHUMBURL\\[(.+)\\]/', $result, $matches)) {
if (!empty($event['event_image_id'])) {
$thumb_array = image_downsize($event['event_image_id'], $matches[1]);
$thumb_url = $thumb_array[0];
$replacement = $thumb_url;
}
} elseif ($event && preg_match('/#_EVENTATT\\{(.+)\\}\\{(.+)\\}/', $result, $matches)) {
$tmp_event_id = intval($matches[1]);
$tmp_event_attkey = $matches[2];
$tmp_event = eme_get_event($tmp_event_id);
if (isset($tmp_event['event_attributes'][$tmp_event_attkey])) {
$replacement = $tmp_event['event_attributes'][$tmp_event_attkey];
}
} elseif ($event && preg_match('/#_MYLOCATIONATT\\{(.+)\\}/', $result, $matches)) {
$tmp_attkey = $matches[1];
if (isset($location['location_attributes'][$tmp_attkey])) {
$replacement = $location['location_attributes'][$tmp_attkey];
}
} elseif ($event && preg_match('/#_EVENTPAGEURL\\{(.+)\\}/', $result, $matches)) {
$events_page_link = eme_get_events_page(true, false);
$replacement = add_query_arg(array('event_id' => intval($matches[1])), $events_page_link);
if (!empty($lang)) {
$replacement = add_query_arg(array('lang' => $lang), $replacement);
}
} elseif ($legacy && $event && preg_match('/#_EVENTPAGEURL\\[(.+)\\]/', $result, $matches)) {
$events_page_link = eme_get_events_page(true, false);
$replacement = add_query_arg(array('event_id' => intval($matches[1])), $events_page_link);
if (!empty($lang)) {
$replacement = add_query_arg(array('lang' => $lang), $replacement);
}
} elseif ($event && preg_match('/#_EVENTPAGEURL$/', $result)) {
$replacement = eme_event_url($event, $lang);
} elseif ($event && preg_match('/#_(NAME|EVENTNAME)$/', $result)) {
$field = "event_name";
if (isset($event[$field])) {
$replacement = $event[$field];
}
if ($target == "html") {
$replacement = eme_trans_sanitize_html($replacement, $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate($replacement, $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate($replacement, $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_EVENTID/', $result)) {
$field = "event_id";
$replacement = intval($event[$field]);
} elseif ($event && preg_match('/#_SINGLE_EVENTPAGE_EVENTID/', $result)) {
// returns the event id of the single event page currently shown
if (eme_is_single_event_page()) {
$replacement = intval(get_query_var('event_id'));
}
} elseif ($event && preg_match('/#_DAYS_TILL_START/', $result)) {
$eme_date_obj = new ExpressiveDate($event['event_start_date'] . " " . $event['event_start_time'], $eme_timezone);
$replacement = $eme_date_obj_now->getDifferenceInDays($eme_date_obj);
} elseif ($event && preg_match('/#_DAYS_TILL_END/', $result)) {
$eme_date_obj = new ExpressiveDate($event['event_end_date'] . " " . $event['event_end_time'], $eme_timezone);
$replacement = $eme_date_obj_now->getDifferenceInDays($eme_date_obj);
} elseif ($event && preg_match('/#_HOURS_TILL_START/', $result)) {
$eme_date_obj = new ExpressiveDate($event['event_start_date'] . " " . $event['event_start_time'], $eme_timezone);
$replacement = round($eme_date_obj_now->getDifferenceInHours($eme_date_obj));
} elseif ($event && preg_match('/#_HOURS_TILL_END/', $result)) {
$eme_date_obj = new ExpressiveDate($event['event_end_date'] . " " . $event['event_end_time'], $eme_timezone);
$replacement = round($eme_date_obj_now->getDifferenceInHours($eme_date_obj));
} elseif ($event && preg_match('/#_EVENTPRICE$|#_PRICE$/', $result)) {
$field = "price";
if ($event[$field]) {
$replacement = $event[$field];
}
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($deprecated && $event && preg_match('/#_(EVENT)?PRICE(\\d+)/', $result, $matches) || $event && preg_match('/#_(EVENT)?PRICE\\{(\\d+)\\}/', $result, $matches)) {
$field_id = intval($matches[2] - 1);
if ($event["price"] && eme_is_multi($event["price"])) {
$prices = eme_convert_multi2array($event["price"]);
if (is_array($prices) && array_key_exists($field_id, $prices)) {
$replacement = $prices[$field_id];
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
}
} elseif ($event && preg_match('/#_CURRENCY/', $result)) {
$field = "currency";
// currency is only important if the price is not empty as well
if ($event['price']) {
$replacement = $event[$field];
}
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_ATTENDEES/', $result)) {
$replacement = eme_get_attendees_list_for($event);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_BOOKINGS/', $result)) {
$replacement = eme_get_bookings_list_for_event($event);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_(CONTACTNAME|CONTACTPERSON)/', $result)) {
$contact = eme_get_contact($event);
if ($contact) {
$replacement = $contact->display_name;
}
$replacement = eme_trans_sanitize_html($replacement, $lang);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_(CONTACTEMAIL|PLAIN_CONTACTEMAIL)/', $result)) {
$contact = eme_get_contact($event);
if ($contact) {
$replacement = $contact->user_email;
if ($target == "html") {
// ascii encode for primitive harvesting protection ...
$replacement = eme_ascii_encode($replacement);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
} elseif ($event && preg_match('/#_CONTACTPHONE/', $result)) {
$contact = eme_get_contact($event);
if ($contact) {
$phone = eme_get_user_phone($contact->ID);
// ascii encode for primitive harvesting protection ...
$replacement = eme_ascii_encode($phone);
}
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_AUTHORNAME/', $result)) {
$author = eme_get_author($event);
if ($author) {
$replacement = $author->display_name;
}
$replacement = eme_trans_sanitize_html($replacement, $lang);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_AUTHOREMAIL/', $result)) {
$author = eme_get_author($event);
if ($author) {
$replacement = $author->user_email;
if ($target == "html") {
// ascii encode for primitive harvesting protection ...
$replacement = eme_ascii_encode($replacement);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
} elseif ($event && preg_match('/#_AUTHORPHONE/', $result)) {
$author = eme_get_author($event);
if ($author) {
$phone = eme_get_user_phone($author->ID);
// ascii encode for primitive harvesting protection ...
$replacement = eme_ascii_encode($phone);
}
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif (preg_match('/#_EVENTCREATIONDATE/', $result)) {
$replacement = eme_localised_date($event['creation_date'] . " " . $eme_timezone);
} elseif (preg_match('/#_EVENTMODIFDATE/', $result)) {
$replacement = eme_localised_date($event['modif_date'] . " " . $eme_timezone);
} elseif (preg_match('/#_EVENTCREATIONTIME/', $result)) {
$replacement = eme_localised_time($event['creation_date'] . " " . $eme_timezone);
} elseif (preg_match('/#_EVENTMODIFTIME/', $result)) {
$replacement = eme_localised_time($event['modif_date'] . " " . $eme_timezone);
} elseif ($event && preg_match('/#[A-Za-z]$/', $result)) {
// matches all PHP date placeholders for startdate-time
$replacement = eme_localised_date($event['event_start_date'] . " " . $event['event_start_time'] . " " . $eme_timezone, ltrim($result, "#"));
if (get_option('eme_time_remove_leading_zeros') && $result == "#i") {
$replacement = ltrim($replacement, "0");
}
} elseif ($event && preg_match('/#@[A-Za-z]$/', $result)) {
// matches all PHP time placeholders for enddate-time
$replacement = eme_localised_date($event['event_end_date'] . " " . $event['event_end_time'] . " " . $eme_timezone, ltrim($result, "#@"));
if (get_option('eme_time_remove_leading_zeros') && $result == "#@i") {
$replacement = ltrim($replacement, "0");
}
} elseif ($event && preg_match('/#_EVENTCATEGORYIDS$/', $result) && get_option('eme_categories_enabled')) {
$categories = $event['event_category_ids'];
if ($target == "html") {
$replacement = eme_trans_sanitize_html($categories, $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_trans_sanitize_html($categories, $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_trans_sanitize_html($categories, $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_(EVENT)?CATEGORIES$/', $result) && get_option('eme_categories_enabled')) {
$categories = eme_get_event_category_names($event['event_id']);
if ($target == "html") {
$replacement = eme_trans_sanitize_html(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_EVENTCATEGORIES_CSS$/', $result) && get_option('eme_categories_enabled')) {
$categories = eme_get_event_category_names($event['event_id']);
if ($target == "html") {
$replacement = eme_trans_sanitize_html(join(" ", $categories), $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(" ", $categories), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(" ", $categories), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_EVENTCATEGORYDESCRIPTIONS$/', $result) && get_option('eme_categories_enabled')) {
$categories = eme_get_event_category_descriptions($event['event_id']);
if ($target == "html") {
$replacement = eme_trans_sanitize_html(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_LINKED(EVENT)?CATEGORIES$/', $result) && get_option('eme_categories_enabled')) {
$categories = eme_get_event_categories($event['event_id']);
$cat_links = array();
foreach ($categories as $category) {
$cat_link = eme_category_url($category);
$cat_name = $category['category_name'];
if ($target == "html") {
array_push($cat_links, "<a href='{$cat_link}' title='" . eme_trans_sanitize_html($cat_name, $lang) . "'>" . eme_trans_sanitize_html($cat_name, $lang) . "</a>");
} else {
array_push($cat_links, eme_translate($cat_name, $lang));
}
}
$replacement = join(", ", $cat_links);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(", ", $cat_links), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(", ", $cat_links), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/^#_(EVENT)?CATEGORIES\\{(.*?)\\}\\{(.*?)\\}/', $result, $matches) && get_option('eme_categories_enabled')) {
$include_cats = $matches[2];
$exclude_cats = $matches[3];
$extra_conditions_arr = array();
if (!empty($include_cats)) {
array_push($extra_conditions_arr, "category_id IN ({$include_cats})");
}
if (!empty($exclude_cats)) {
array_push($extra_conditions_arr, "category_id NOT IN ({$exclude_cats})");
}
$extra_conditions = join(" AND ", $extra_conditions_arr);
$categories = eme_get_event_category_names($event['event_id'], $extra_conditions);
if ($target == "html") {
$replacement = eme_trans_sanitize_html(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/^#_EVENTCATEGORIES_CSS\\{(.*?)\\}\\{(.*?)\\}/', $result, $matches) && get_option('eme_categories_enabled')) {
$include_cats = $matches[1];
$exclude_cats = $matches[2];
$extra_conditions_arr = array();
if (!empty($include_cats)) {
array_push($extra_conditions_arr, "category_id IN ({$include_cats})");
}
if (!empty($exclude_cats)) {
array_push($extra_conditions_arr, "category_id NOT IN ({$exclude_cats})");
}
$extra_conditions = join(" AND ", $extra_conditions_arr);
$categories = eme_get_event_category_names($event['event_id'], $extra_conditions);
if ($target == "html") {
$replacement = eme_trans_sanitize_html(join(" ", $categories), $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(" ", $categories), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(" ", $categories), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($legacy && $event && preg_match('/^#_(EVENT)?CATEGORIES\\[(.*?)\\]\\[(.*?)\\]/', $result, $matches) && get_option('eme_categories_enabled')) {
$include_cats = $matches[2];
$exclude_cats = $matches[3];
$extra_conditions_arr = array();
if (!empty($include_cats)) {
array_push($extra_conditions_arr, "category_id IN ({$include_cats})");
}
if (!empty($exclude_cats)) {
array_push($extra_conditions_arr, "category_id NOT IN ({$exclude_cats})");
}
$extra_conditions = join(" AND ", $extra_conditions_arr);
$categories = eme_get_event_category_names($event['event_id'], $extra_conditions);
if ($target == "html") {
$replacement = eme_trans_sanitize_html(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(", ", $categories), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_LINKED(EVENT)?CATEGORIES\\{(.*?)\\}\\{(.*?)\\}/', $result, $matches) && get_option('eme_categories_enabled')) {
$include_cats = $matches[2];
$exclude_cats = $matches[3];
$extra_conditions_arr = array();
if (!empty($include_cats)) {
array_push($extra_conditions_arr, "category_id IN ({$include_cats})");
}
if (!empty($exclude_cats)) {
array_push($extra_conditions_arr, "category_id NOT IN ({$exclude_cats})");
}
$extra_conditions = join(" AND ", $extra_conditions_arr);
$categories = eme_get_event_categories($event['event_id'], $extra_conditions);
$cat_links = array();
foreach ($categories as $category) {
$cat_link = eme_category_url($category);
$cat_name = $category['category_name'];
if ($target == "html") {
array_push($cat_links, "<a href='{$cat_link}' title='" . eme_trans_sanitize_html($cat_name, $lang) . "'>" . eme_trans_sanitize_html($cat_name, $lang) . "</a>");
} else {
array_push($cat_links, eme_translate($cat_name, $lang));
}
}
$replacement = join(", ", $cat_links);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(", ", $cat_links), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(", ", $cat_links), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($legacy && $event && preg_match('/#_LINKED(EVENT)?CATEGORIES\\[(.*?)\\]\\[(.*?)\\]/', $result, $matches) && get_option('eme_categories_enabled')) {
$include_cats = $matches[2];
$exclude_cats = $matches[3];
$extra_conditions_arr = array();
if (!empty($include_cats)) {
array_push($extra_conditions_arr, "category_id IN ({$include_cats})");
}
if (!empty($exclude_cats)) {
array_push($extra_conditions_arr, "category_id NOT IN ({$exclude_cats})");
}
$extra_conditions = join(" AND ", $extra_conditions_arr);
$categories = eme_get_event_categories($event['event_id'], $extra_conditions);
$cat_links = array();
foreach ($categories as $category) {
$cat_link = eme_category_url($category);
$cat_name = $category['category_name'];
if ($target == "html") {
array_push($cat_links, "<a href='{$cat_link}' title='" . eme_trans_sanitize_html($cat_name, $lang) . "'>" . eme_trans_sanitize_html($cat_name, $lang) . "</a>");
} else {
array_push($cat_links, eme_translate($cat_name, $lang));
}
}
$replacement = join(", ", $cat_links);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = eme_translate(join(", ", $cat_links), $lang);
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = eme_translate(join(", ", $cat_links), $lang);
$replacement = apply_filters('eme_text', $replacement);
}
} elseif (preg_match('/#_CALENDAR_DAY/', $result)) {
$day_key = get_query_var('calendar_day');
$replacement = eme_localised_date($day_key . " " . $eme_timezone);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif ($event && preg_match('/#_RECURRENCE_DESC|#_RECURRENCEDESC/', $result)) {
if ($event['recurrence_id']) {
$replacement = eme_get_recurrence_desc($event['recurrence_id']);
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
}
} elseif ($event && preg_match('/#_RECURRENCE_NBR/', $result)) {
// returns the sequence number of an event in a recurrence series
if ($event['recurrence_id']) {
$events = eme_get_recurrence_eventids($event['recurrence_id']);
$nbr = array_search($event['event_id'], $events);
if ($nbr !== false) {
$replacement = $nbr + 1;
}
}
} elseif ($event && preg_match('/#_RSVPEND/', $result)) {
// show the end date+time for which a user can rsvp for an event
if (eme_is_event_rsvp($event)) {
$rsvp_number_days = $event['rsvp_number_days'];
$rsvp_number_hours = $event['rsvp_number_hours'];
$rsvp_end_obj = new ExpressiveDate($event['event_start_date'] . " " . $event['event_start_time'], $eme_timezone);
$rsvp_end_obj->minusDays($rsvp_number_days);
$rsvp_end_obj->minusHours($rsvp_number_hours);
$rsvp_end_date = eme_localised_date($rsvp_end_obj->getDateTime() . " " . $eme_timezone);
$rsvp_end_time = eme_localised_time($rsvp_end_obj->getDateTime() . " " . $eme_timezone);
$replacement = $rsvp_end_date . " " . $rsvp_end_time;
}
} elseif ($event && preg_match('/#_IS_RSVP_ENDED/', $result)) {
if (eme_is_event_rsvp($event)) {
$rsvp_number_days = $event['rsvp_number_days'];
$rsvp_number_hours = $event['rsvp_number_hours'];
$rsvp_end_obj = new ExpressiveDate($event['event_start_date'] . " " . $event['event_start_time'], $eme_timezone);
$rsvp_end_obj->minusDays($rsvp_number_days);
$rsvp_end_obj->minusHours($rsvp_number_hours);
if ($rsvp_end_obj->lessThan($eme_date_obj_now)) {
$replacement = 1;
} else {
$replacement = 0;
}
}
} elseif ($event && preg_match('/#_EVENT_EXTERNAL_REF/', $result)) {
$replacement = $event['event_external_ref'];
if ($target == "html") {
$replacement = apply_filters('eme_general', $replacement);
} elseif ($target == "rss") {
$replacement = apply_filters('eme_general_rss', $replacement);
} else {
$replacement = apply_filters('eme_text', $replacement);
}
} elseif (preg_match('/#_IS_SINGLE_DAY/', $result)) {
if (eme_is_single_day_page()) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif (preg_match('/#_IS_SINGLE_EVENT/', $result)) {
if (eme_is_single_event_page()) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif (preg_match('/#_IS_LOGGED_IN/', $result)) {
if (is_user_logged_in()) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif (preg_match('/#_IS_ADMIN_PAGE/', $result)) {
if (is_admin()) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_RSVP_ENABLED/', $result)) {
if (eme_is_event_rsvp($event)) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_PRIVATE_EVENT/', $result)) {
if ($event['event_status'] == STATUS_PRIVATE) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_RECURRENT_EVENT/', $result)) {
if ($event['recurrence_id']) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_ONGOING_EVENT/', $result)) {
$eme_start_obj = new ExpressiveDate($event['event_start_date'] . " " . $event['event_start_time'], $eme_timezone);
$eme_end_obj = new ExpressiveDate($event['event_end_date'] . " " . $event['event_end_time'], $eme_timezone);
if ($eme_start_obj->lessOrEqualTo($eme_date_obj_now) && $eme_end_obj->greaterOrEqualTo($eme_date_obj_now)) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_REGISTERED/', $result)) {
if (is_user_logged_in() && eme_get_booking_ids_by_wp_id($current_userid, $event['event_id'])) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_MULTIPRICE/', $result)) {
if (eme_is_multi($event['price'])) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_MULTISEAT/', $result)) {
if (eme_is_multi($event['event_seats'])) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_ALLDAY/', $result)) {
if ($event['event_properties']['all_day']) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_ATTENDANCE/', $result)) {
if ($event['event_properties']['take_attendance']) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_AUTHOR$/', $result)) {
if ($event['event_author'] == $current_userid) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_CONTACTPERSON/', $result)) {
if ($event['event_contactperson_id'] == $current_userid) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_AUTHOR_OR_CONTACTPERSON/', $result)) {
if ($event['event_author'] == $current_userid || $event['event_contactperson_id'] == $current_userid) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_MULTIDAY/', $result)) {
if ($event['event_start_date'] != $event['event_end_date']) {
$replacement = 1;
} else {
$replacement = 0;
}
} elseif ($event && preg_match('/#_IS_FIRST_RECURRENCE/', $result)) {
// returns 1 if the event is the first event in a recurrence series
if ($event['recurrence_id']) {
$events = eme_get_recurrence_eventids($event['recurrence_id']);
$nbr = array_search($event['event_id'], $events);
if ($nbr !== false && $nbr == 0) {
$replacement = 1;
}
}
} elseif ($event && preg_match('/#_IS_LAST_RECURRENCE/', $result)) {
// returns 1 if the event is the last event in a recurrence series
if ($event['recurrence_id']) {
$events = eme_get_recurrence_eventids($event['recurrence_id']);
$nbr = array_search($event['event_id'], $events);
$last_index = count($events) - 1;
if ($nbr !== false && $nbr == $last_index) {
$replacement = 1;
}
}
} elseif (preg_match('/#_LOCALE/', $result)) {
$replacement = get_locale();
} else {
$found = 0;
}
if ($found) {
if ($need_escape) {
$replacement = eme_sanitize_request(eme_sanitize_html(preg_replace('/\\n|\\r/', '', $replacement)));
}
if ($need_urlencode) {
$replacement = rawurlencode($replacement);
}
$format = str_replace($orig_result, $replacement, $format);
}
}
# now handle all possible location placeholders
# but the eme_replace_locations_placeholders can't do "do_shortcode" at the end, because
# this would cause [eme_if] tags to be replaced here already, while some placeholders of the
# event haven't been replaced yet (like time placeholders, and event details)
$format = eme_replace_locations_placeholders($format, $location, $target, 0, $lang);
// for extra date formatting, eg. #_{d/m/Y}
preg_match_all("/#(ESC|URL)?@?_\\{.*?\\}/", $format, $results);
// make sure we set the largest matched placeholders first, otherwise if you found e.g.
// #_LOCATION, part of #_LOCATIONPAGEURL would get replaced as well ...
usort($results[0], 'sort_stringlenth');
foreach ($results[0] as $result) {
$need_escape = 0;
$need_urlencode = 0;
$orig_result = $result;
if (strstr($result, '#ESC')) {
$result = str_replace("#ESC", "#", $result);
$need_escape = 1;
} elseif (strstr($result, '#URL')) {
$result = str_replace("#URL", "#", $result);
$need_urlencode = 1;
}
$replacement = '';
if (substr($result, 0, 3) == "#@_") {
$my_date = "event_end_date";
$my_time = "event_end_time";
$offset = 4;
} else {
$my_date = "event_start_date";
$my_time = "event_start_time";
$offset = 3;
}
$replacement = eme_localised_date($event[$my_date] . " " . $event[$my_time] . " " . $eme_timezone, substr($result, $offset, strlen($result) - ($offset + 1)));
if ($need_escape) {
$replacement = eme_sanitize_request(eme_sanitize_html(preg_replace('/\\n|\\r/', '', $replacement)));
}
if ($need_urlencode) {
$replacement = rawurlencode($replacement);
}
$format = str_replace($orig_result, $replacement, $format);
}
# we handle NOTES the last, this used to be the default behavior
# so no placeholder replacement happened accidentaly in possible shortcodes inside #_NOTES
# but since we have templates to aid in all that ...
if (!$eme_enable_notes_placeholders) {
$format = eme_replace_notes_placeholders($format, $event, $target);
}
// now, replace any language tags found in the format itself
$format = eme_translate($format, $lang);
if ($do_shortcode) {
return do_shortcode($format);
} else {
return $format;
}
}
function eme_get_events($o_limit = 0, $scope = "future", $order = "ASC", $o_offset = 0, $location_id = "", $category = "", $author = "", $contact_person = "", $show_ongoing = 1, $notcategory = "", $show_recurrent_events_once = 0, $extra_conditions = "")
{
global $wpdb, $eme_timezone;
$events_table = $wpdb->prefix . EVENTS_TBNAME;
$bookings_table = $wpdb->prefix . BOOKINGS_TBNAME;
if (strpos($o_limit, "=")) {
// allows the use of arguments
$defaults = array('o_limit' => 0, 'scope' => 'future', 'order' => 'ASC', 'o_offset' => 0, 'location_id' => '', 'category' => '', 'author' => '', 'contact_person' => '', 'show_ongoing' => 1, 'notcategory' => '', 'show_recurrent_events_once' => 0, 'extra_conditions' => '');
$r = wp_parse_args($o_limit, $defaults);
extract($r);
}
if ($o_limit === "") {
$o_limit = get_option('eme_event_list_number_items');
}
if ($o_limit > 0) {
$limit = "LIMIT " . intval($o_limit);
} else {
$limit = "";
}
if ($o_offset > 0) {
if ($o_limit == 0) {
$limit = "LIMIT " . intval($o_offset);
}
$offset = "OFFSET " . intval($o_offset);
} else {
$offset = "";
}
if ($order != "DESC") {
$order = "ASC";
}
$eme_date_obj = new ExpressiveDate(null, $eme_timezone);
$start_of_week = get_option('start_of_week');
$eme_date_obj->setWeekStartDay($start_of_week);
$today = $eme_date_obj->getDate();
$this_time = $eme_date_obj->getTime();
$this_datetime = $eme_date_obj->getDateTime();
$conditions = array();
// extra sql conditions we put in front, most of the time this is the most
// effective place
if ($extra_conditions != "") {
$conditions[] = $extra_conditions;
}
// if we're not in the admin itf, we don't want draft events
if (!is_admin()) {
if (is_user_logged_in()) {
$conditions[] = "event_status IN (" . STATUS_PUBLIC . "," . STATUS_PRIVATE . ")";
} else {
$conditions[] = "event_status=" . STATUS_PUBLIC;
}
if (get_option('eme_rsvp_hide_full_events')) {
// COALESCE is used in case the SUM returns NULL
// this is a correlated subquery, so the FROM clause should specify events_table again, so it will search in the outer query for events_table.event_id
$conditions[] = "(event_rsvp=0 OR (event_rsvp=1 AND event_seats > (SELECT COALESCE(SUM(booking_seats),0) AS booked_seats FROM {$bookings_table} WHERE {$bookings_table}.event_id = {$events_table}.event_id)))";
}
if (get_option('eme_rsvp_hide_rsvp_ended_events')) {
$conditions[] = "(event_rsvp=0 OR (event_rsvp=1 AND (event_end_date < '{$today}' OR UNIX_TIMESTAMP(CONCAT(event_start_date,' ',event_start_time))-rsvp_number_days*60*60*24-rsvp_number_hours*60*60 > UNIX_TIMESTAMP()) ))";
}
}
if (preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}\$/", $scope)) {
//$conditions[] = " event_start_date like '$scope'";
if ($show_ongoing) {
$conditions[] = " ((event_start_date LIKE '{$scope}') OR (event_start_date <= '{$scope}' AND event_end_date >= '{$scope}'))";
} else {
$conditions[] = " (event_start_date LIKE '{$scope}') ";
}
} elseif (preg_match("/^--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) {
$limit_start = $matches[1];
if ($show_ongoing) {
$conditions[] = " (event_start_date < '{$limit_start}') ";
} else {
$conditions[] = " (event_end_date < '{$limit_start}') ";
}
} elseif (preg_match("/^\\+\\+([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) {
$limit_start = $matches[1];
$conditions[] = " (event_start_date > '{$limit_start}') ";
} elseif (preg_match("/^0000-([0-9]{2})\$/", $scope, $matches)) {
$month = $matches[1];
$eme_date_obj->setMonth($month);
$number_of_days_month = $eme_date_obj->getDaysInMonth();
$limit_start = "{$year}-{$month}-01";
$limit_end = "{$year}-{$month}-{$number_of_days_month}";
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "this_week") {
// this comes from global wordpress preferences
$start_of_week = get_option('start_of_week');
$eme_date_obj->setWeekStartDay($start_of_week);
$limit_start = $eme_date_obj->startOfWeek()->format('Y-m-d');
$limit_end = $eme_date_obj->endOfWeek()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "next_week") {
// this comes from global wordpress preferences
$start_of_week = get_option('start_of_week');
$eme_date_obj->setWeekStartDay($start_of_week);
$eme_date_obj->addOneWeek();
$limit_start = $eme_date_obj->startOfWeek()->format('Y-m-d');
$limit_end = $eme_date_obj->endOfWeek()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "this_month") {
$limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d');
$limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "this_year") {
$year = $eme_date_obj->getYear();
$limit_start = "{$year}-01-01";
$limit_end = "{$year}-12-31";
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "next_month") {
$eme_date_obj->addOneMonth();
$limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d');
$limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^([0-9]{4}-[0-9]{2}-[0-9]{2})--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) {
$limit_start = $matches[1];
$limit_end = $matches[2];
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^([0-9]{4}-[0-9]{2}-[0-9]{2})--today\$/", $scope, $matches)) {
$limit_start = $matches[1];
$limit_end = $today;
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^today--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) {
$limit_start = $today;
$limit_end = $matches[1];
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^\\+(\\d+)d\$/", $scope, $matches)) {
$days = $matches[1];
$limit_start = $today;
$limit_end = $eme_date_obj->addDays($days)->getDate();
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^\\-(\\d+)d\$/", $scope, $matches)) {
$days = $matches[1];
$limit_start = $eme_date_obj->minusDays($days)->getDate();
$limit_end = $today;
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^(\\-?\\+?\\d+)d--(\\-?\\+?\\d+)d\$/", $scope, $matches)) {
$day1 = $matches[1];
$day2 = $matches[2];
$limit_start = $eme_date_obj->copy()->modifyDays($day1)->getDate();
$limit_end = $eme_date_obj->copy()->modifyDays($day2)->getDate();
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^relative\\-(\\d+)d--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) {
$days = $matches[1];
$limit_end = $matches[2];
$eme_date_obj->setTimestampFromString($limit_end . " " . $eme_timezone);
$limit_start = $eme_date_obj->minusDays($days)->getDate() . " " . $eme_timezone;
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^([0-9]{4}-[0-9]{2}-[0-9]{2})--relative\\+(\\d+)d\$/", $scope, $matches)) {
$limit_start = $matches[1];
$days = $matches[2];
$eme_date_obj->setTimestampFromString($limit_start . " " . $eme_timezone);
$limit_end = $eme_date_obj->addDays($days)->getDate() . " " . $eme_timezone;
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^\\+(\\d+)m\$/", $scope, $matches)) {
$months_in_future = $matches[1]++;
$limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d');
$eme_date_obj->addMonths($months_in_future);
$limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^\\-(\\d+)m\$/", $scope, $matches)) {
$months_in_past = $matches[1]++;
$limit_start = $eme_date_obj->copy()->minusMonths($months_in_past)->startOfMonth()->format('Y-m-d');
$limit_end = $eme_date_obj->copy()->minusOneMonth()->endOfMonth()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif (preg_match("/^(\\-?\\+?\\d+)m--(\\-?\\+?\\d+)m\$/", $scope, $matches)) {
$months1 = $matches[1];
$months2 = $matches[2];
$limit_start = $eme_date_obj->copy()->modifyMonths($months1)->startOfMonth()->format('Y-m-d');
$limit_end = $eme_date_obj->copy()->modifyMonths($months2)->endOfMonth()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "today--this_week") {
$limit_start = $today;
$limit_end = $eme_date_obj->endOfWeek()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "today--this_week_plus_one") {
$limit_start = $today;
$limit_end = $eme_date_obj->endOfWeek()->addOneDay()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "today--this_month") {
$limit_start = $today;
$limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d');
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "today--this_year") {
$limit_start = $today;
$limit_end = "{$year}-12-31";
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "this_week--today") {
$limit_start = $eme_date_obj->startOfWeek()->format('Y-m-d');
$limit_end = $today;
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "this_month--today") {
$limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d');
$limit_end = $today;
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "this_year--today") {
$limit_start = "{$year}-01-01";
$limit_end = $today;
if ($show_ongoing) {
$conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))";
} else {
$conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')";
}
} elseif ($scope == "tomorrow--future") {
if ($show_ongoing) {
$conditions[] = " (event_start_date > '{$today}' OR (event_end_date > '{$today}' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL))";
} else {
$conditions[] = " (event_start_date > '{$today}')";
}
} elseif ($scope == "past") {
//$conditions[] = " (event_end_date < '$today' OR (event_end_date = '$today' and event_end_time < '$this_time' )) ";
// not taking the hour into account until we can enter timezone info as well
if ($show_ongoing) {
$conditions[] = " event_end_date < '{$today}'";
} else {
$conditions[] = " event_start_date < '{$today}'";
}
} elseif ($scope == "today") {
if ($show_ongoing) {
$conditions[] = " (event_start_date = '{$today}' OR (event_start_date <= '{$today}' AND event_end_date >= '{$today}'))";
} else {
$conditions[] = " (event_start_date = '{$today}')";
}
} elseif ($scope == "tomorrow") {
$tomorrow = $eme_date_obj->addOneDay()->getDate();
if ($show_ongoing) {
$conditions[] = " (event_start_date = '{$tomorrow}' OR (event_start_date <= '{$tomorrow}' AND event_end_date >= '{$tomorrow}'))";
} else {
$conditions[] = " (event_start_date = '{$tomorrow}')";
}
} elseif ($scope == "ongoing") {
// only shows ongoing events, for this we try to use the date and time, but it might be incorrect since there's no user timezone info
$conditions[] = " (CONCAT(event_start_date,' ',event_start_time)<='{$this_datetime}' AND CONCAT(event_end_date,' ',event_end_time)>= '{$this_datetime}')";
} else {
if ($scope != "all") {
$scope = "future";
}
if ($scope == "future") {
//$conditions[] = " ((event_start_date = '$today' AND event_start_time >= '$this_time') OR (event_start_date > '$today') OR (event_end_date > '$today' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL) OR (event_end_date = '$today' AND event_end_time >= '$this_time'))";
// not taking the hour into account until we can enter timezone info as well
if ($show_ongoing) {
$conditions[] = " (event_start_date >= '{$today}' OR (event_end_date >= '{$today}' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL))";
} else {
$conditions[] = " (event_start_date >= '{$today}')";
}
}
}
// when used inside a location description, you can use this_location to indicate the current location being viewed
if ($location_id == "this_location" && get_query_var('location_id')) {
$location_id = get_query_var('location_id');
}
if (is_numeric($location_id)) {
if ($location_id > 0) {
$conditions[] = " location_id = {$location_id}";
}
} elseif ($location_id == "none") {
$conditions[] = " location_id = ''";
} elseif (preg_match('/,/', $location_id)) {
$location_ids = explode(',', $location_id);
$location_conditions = array();
foreach ($location_ids as $loc) {
if (is_numeric($loc) && $loc > 0) {
$location_conditions[] = " location_id = {$loc}";
} elseif ($loc == "none") {
$location_conditions[] = " location_id = ''";
}
}
$conditions[] = "(" . implode(' OR', $location_conditions) . ")";
} elseif (preg_match('/\\+/', $location_id)) {
$location_ids = explode('+', $location_id);
$location_conditions = array();
foreach ($location_ids as $loc) {
if (is_numeric($loc) && $loc > 0) {
$location_conditions[] = " location_id = {$loc}";
}
}
$conditions[] = "(" . implode(' AND', $location_conditions) . ")";
} elseif (preg_match('/ /', $location_id)) {
// url decoding of '+' is ' '
$location_ids = explode(' ', $location_id);
$location_conditions = array();
foreach ($location_ids as $loc) {
if (is_numeric($loc) && $loc > 0) {
$location_conditions[] = " location_id = {$loc}";
}
}
$conditions[] = "(" . implode(' AND', $location_conditions) . ")";
}
if (get_option('eme_categories_enabled')) {
if (is_numeric($category)) {
if ($category > 0) {
$conditions[] = " FIND_IN_SET({$category},event_category_ids)";
}
} elseif ($category == "none") {
$conditions[] = "event_category_ids = ''";
} elseif (preg_match('/,/', $category)) {
$category = explode(',', $category);
$category_conditions = array();
foreach ($category as $cat) {
if (is_numeric($cat) && $cat > 0) {
$category_conditions[] = " FIND_IN_SET({$cat},event_category_ids)";
} elseif ($cat == "none") {
$category_conditions[] = " event_category_ids = ''";
}
}
$conditions[] = "(" . implode(' OR', $category_conditions) . ")";
} elseif (preg_match('/\\+/', $category)) {
$category = explode('+', $category);
$category_conditions = array();
foreach ($category as $cat) {
if (is_numeric($cat) && $cat > 0) {
$category_conditions[] = " FIND_IN_SET({$cat},event_category_ids)";
}
}
$conditions[] = "(" . implode(' AND ', $category_conditions) . ")";
} elseif (preg_match('/ /', $category)) {
// url decoding of '+' is ' '
$category = explode(' ', $category);
$category_conditions = array();
foreach ($category as $cat) {
if (is_numeric($cat) && $cat > 0) {
$category_conditions[] = " FIND_IN_SET({$cat},event_category_ids)";
}
}
$conditions[] = "(" . implode(' AND ', $category_conditions) . ")";
}
}
if (get_option('eme_categories_enabled')) {
if (is_numeric($notcategory)) {
if ($notcategory > 0) {
$conditions[] = " NOT FIND_IN_SET({$notcategory},event_category_ids)";
}
} elseif ($notcategory == "none") {
$conditions[] = "event_category_ids != ''";
} elseif (preg_match('/,/', $notcategory)) {
$notcategory = explode(',', $notcategory);
$category_conditions = array();
foreach ($notcategory as $cat) {
if (is_numeric($cat) && $cat > 0) {
$category_conditions[] = " NOT FIND_IN_SET({$cat},event_category_ids)";
} elseif ($cat == "none") {
$category_conditions[] = " event_category_ids != ''";
}
}
$conditions[] = "(" . implode(' OR', $category_conditions) . ")";
} elseif (preg_match('/\\+/', $notcategory)) {
$notcategory = explode('+', $notcategory);
$category_conditions = array();
foreach ($notcategory as $cat) {
if (is_numeric($cat) && $cat > 0) {
$category_conditions[] = " NOT FIND_IN_SET({$cat},event_category_ids)";
}
}
$conditions[] = "(" . implode(' AND ', $category_conditions) . ")";
} elseif (preg_match('/ /', $notcategory)) {
// url decoding of '+' is ' '
$notcategory = explode(' ', $notcategory);
$category_conditions = array();
foreach ($notcategory as $cat) {
if (is_numeric($cat) && $cat > 0) {
$category_conditions[] = " NOT FIND_IN_SET({$cat},event_category_ids)";
}
}
}
}
// now filter the author ID
if ($author != '' && !preg_match('/,/', $author)) {
$authinfo = get_user_by('login', $author);
$conditions[] = " event_author = " . $authinfo->ID;
} elseif (preg_match('/,/', $author)) {
$authors = explode(',', $author);
$author_conditions = array();
foreach ($authors as $authname) {
$authinfo = get_user_by('login', $authname);
$author_conditions[] = " event_author = " . $authinfo->ID;
}
$conditions[] = "(" . implode(' OR ', $author_conditions) . ")";
}
// now filter the contact ID
if ($contact_person != '' && !preg_match('/,/', $contact_person)) {
$authinfo = get_user_by('login', $contact_person);
$conditions[] = " event_contactperson_id = " . $authinfo->ID;
} elseif (preg_match('/,/', $contact_person)) {
$contact_persons = explode(',', $contact_person);
$contact_person_conditions = array();
foreach ($contact_persons as $authname) {
$authinfo = get_user_by('login', $authname);
$contact_person_conditions[] = " event_contactperson_id = " . $authinfo->ID;
}
$conditions[] = "(" . implode(' OR ', $contact_person_conditions) . ")";
}
// extra conditions for authors: if we're in the admin itf, return only the events for which you have the right to change anything
$current_userid = get_current_user_id();
if (is_admin() && !current_user_can(get_option('eme_cap_edit_events')) && !current_user_can(get_option('eme_cap_list_events')) && current_user_can(get_option('eme_cap_author_event'))) {
$conditions[] = "(event_author = {$current_userid} OR event_contactperson_id= {$current_userid})";
}
$where = implode(" AND ", $conditions);
if ($show_recurrent_events_once) {
if ($where != "") {
$where = " AND " . $where;
}
$sql = "SELECT * FROM {$events_table}\n WHERE (recurrence_id>0 {$where})\n group by recurrence_id union all\n SELECT * FROM {$events_table}\n WHERE (recurrence_id=0 {$where})\n ORDER BY event_start_date {$order} , event_start_time {$order}\n {$limit} \n {$offset}";
} else {
if ($where != "") {
$where = " WHERE " . $where;
}
$sql = "SELECT * FROM {$events_table}\n {$where}\n ORDER BY event_start_date {$order} , event_start_time {$order}\n {$limit} \n {$offset}";
}
$wpdb->show_errors = true;
$events = $wpdb->get_results($sql, ARRAY_A);
$inflated_events = array();
if (!empty($events)) {
//$wpdb->print_error();
foreach ($events as $this_event) {
$this_event = eme_get_event_data($this_event);
array_push($inflated_events, $this_event);
}
if (has_filter('eme_event_list_filter')) {
$inflated_events = apply_filters('eme_event_list_filter', $inflated_events);
}
}
return $inflated_events;
}
