function mc_create_tags($event, $context = 'filters') { $event = mc_clean_location($event, 'event'); $e = array(); $e['post'] = $event->event_post; $date_format = get_option('mc_date_format') != '' ? get_option('mc_date_format') : get_option('date_format'); $e = apply_filters('mc_insert_author_data', $e, $event); $e = apply_filters('mc_filter_image_data', $e, $event); $map = mc_maplink($event); $map_url = mc_maplink($event, 'url'); $sitelink_html = "<div class='url link'><a href='{$event->event_url}' class='location-link external'>" . sprintf(__('Visit web site<span class="screen-reader-text">: %s</span>', 'my-calendar'), $event->event_label) . "</a></div>"; $e['sitelink_html'] = $sitelink_html; $e['sitelink'] = $event->event_url; $e['access'] = mc_expand(get_post_meta($event->event_post, '_mc_event_access', true)); // date & time fields $real_end_date = $event->occur_end; $dtstart = mc_format_timestamp(strtotime($event->occur_begin)); $dtend = mc_format_timestamp(strtotime($real_end_date)); $e['date_utc'] = date_i18n(apply_filters('mc_date_format', $date_format, 'template_begin_ts'), $event->ts_occur_begin); $e['date_end_utc'] = date_i18n(apply_filters('mc_date_format', $date_format, 'template_end_ts'), $event->ts_occur_end); $notime = mc_notime_label($event); $e['time'] = date('H:i:s', strtotime($event->occur_begin)) == '00:00:00' ? $notime : date(get_option('mc_time_format'), strtotime($event->occur_begin)); $e['time24'] = date('G:i', strtotime($event->occur_begin)) == '00:00:00' ? $notime : date(get_option('mc_time_format'), strtotime($event->occur_begin)); $endtime = $event->event_end == '23:59:59' ? '00:00:00' : date('H:i:s', strtotime($real_end_date)); $e['endtime'] = $real_end_date == $event->occur_begin || $event->event_hide_end == 1 || date('H:i:s', strtotime($real_end_date)) == '23:59:59' ? '' : date_i18n(get_option('mc_time_format'), strtotime($endtime)); $e['runtime'] = mc_runtime($event->ts_occur_begin, $event->ts_occur_end, $event); $e['dtstart'] = date('Y-m-d\\TH:i:s', strtotime($event->occur_begin)); // hcal formatted $e['dtend'] = date('Y-m-d\\TH:i:s', strtotime($real_end_date)); //hcal formatted end $e['rssdate'] = date('D, d M Y H:i:s +0000', strtotime($event->event_added)); $date = date_i18n(apply_filters('mc_date_format', $date_format, 'template_begin'), strtotime($event->occur_begin)); $date_end = date_i18n(apply_filters('mc_date_format', $date_format, 'template_end'), strtotime($real_end_date)); $date_arr = array('occur_begin' => $event->occur_begin, 'occur_end' => $real_end_date); $date_obj = (object) $date_arr; if ($event->event_span == 1) { $dates = mc_event_date_span($event->event_group_id, $event->event_span, array(0 => $date_obj)); } else { $dates = array(); } $e['date'] = $event->event_span != 1 ? $date : mc_format_date_span($dates, 'simple', $date); $e['enddate'] = $date_end; $e['daterange'] = $date == $date_end ? $date : "<span class='mc_db'>{$date}</span> <span>–</span> <span class='mc_de'>{$date_end}</span>"; $e['timerange'] = $e['time'] == $e['endtime'] || $event->event_hide_end == 1 || date('H:i:s', strtotime($real_end_date)) == '23:59:59' ? $e['time'] : "<span class='mc_tb'>" . $e['time'] . "</span> <span>–</span> <span class='mc_te'>" . $e['endtime'] . "</span>"; $e['datespan'] = $event->event_span == 1 || $e['date'] != $e['enddate'] ? mc_format_date_span($dates) : $date; $e['multidate'] = mc_format_date_span($dates, 'complex', "<span class='fallback-date'>{$date}</span><span class='separator'>,</span> <span class='fallback-time'>{$e['time']}</span>–<span class='fallback-endtime'>{$e['endtime']}</span>"); $e['began'] = $event->event_begin; // returns date of first occurrence of an event. $e['recurs'] = mc_event_recur_string($event); $e['repeats'] = $event->event_repeats; // category fields $e['cat_id'] = $event->event_category; $e['category'] = stripslashes($event->category_name); $e['icon'] = mc_category_icon($event, 'img'); $e['icon_html'] = "<img src='{$e['icon']}' class='mc-category-icon' alt='" . __('Category', 'my-calendar') . ": " . esc_attr($event->category_name) . "' />"; $e['color'] = $event->category_color; $e['color_css'] = "<span style='background-color: {$event->category_color}'>"; // this is because widgets now strip out style attributes. $e['close_color_css'] = "</span>"; // special $e['skip_holiday'] = $event->event_holiday == 0 ? 'false' : 'true'; $e['event_status'] = $event->event_approved == 1 ? __('Published', 'my-calendar') : __('Reserved', 'my-calendar'); // general text fields $e['title'] = stripslashes($event->event_title); $e['description'] = wpautop(stripslashes($event->event_desc)); $e['description_raw'] = stripslashes($event->event_desc); $e['description_stripped'] = strip_tags(stripslashes($event->event_desc)); $e['shortdesc'] = wpautop(stripslashes($event->event_short)); $e['shortdesc_raw'] = stripslashes($event->event_short); $e['shortdesc_stripped'] = strip_tags(stripslashes($event->event_short)); // registration fields $e['event_open'] = mc_event_open($event); $e['event_tickets'] = $event->event_tickets; $e['event_registration'] = stripslashes(wp_kses_data($event->event_registration)); // links $templates = get_option('mc_templates'); $e_template = !empty($templates['label']) ? stripcslashes($templates['label']) : __('Details about', 'my-calendar') . ' {title}'; $tags = array("{title}", "{location}", "{color}", "{icon}", "{date}", "{time}"); $replacements = array(stripslashes($event->event_title), stripslashes($event->event_label), $event->category_color, $event->category_icon, $e['date'], $e['time']); $e_label = str_replace($tags, $replacements, $e_template); //$e_label = mc_get_details_label( $event, $e ); // recursive...hmmmm. $e_link = mc_get_details_link($event); $e['link'] = mc_event_link($event); if ($e['link']) { $e['link_image'] = str_replace("alt=''", "alt='" . esc_attr($e['title']) . "'", "<a href='" . $e['link'] . "'>" . $e['image'] . "</a>"); $e['link_title'] = "<a href='" . $event->event_link . "'>" . $e['title'] . "</a>"; } else { $e['link_image'] = $e['image']; $e['link_title'] = $e['title']; } $e['details_link'] = get_option('mc_uri') != '' && !is_numeric(get_option('mc_uri')) ? $e_link : ''; $e['details'] = get_option('mc_uri') != '' && !is_numeric(get_option('mc_uri')) ? "<a href='{$e_link}' class='mc-details'>{$e_label}</a>" : ''; $e['linking'] = $e['link'] != '' ? $event->event_link : $e_link; $e['linking_title'] = $e['linking'] != '' ? "<a href='" . $e['linking'] . "'>" . $e['title'] . "</a>" : $e['title']; // location fields $strip_desc = mc_newline_replace(strip_tags($event->event_desc)); $e['location'] = stripslashes($event->event_label); $e['street'] = stripslashes($event->event_street); $e['street2'] = stripslashes($event->event_street2); $e['phone'] = apply_filters('mc_phone_format', stripslashes($event->event_phone)); $e['phone2'] = apply_filters('mc_phone_format', stripslashes($event->event_phone2)); $e['city'] = stripslashes($event->event_city); $e['state'] = stripslashes($event->event_state); $e['postcode'] = stripslashes($event->event_postcode); $e['country'] = stripslashes($event->event_country); $e['hcard'] = stripslashes(mc_hcard($event)); $e['link_map'] = $map; $e['map_url'] = $map_url; $e['map'] = mc_generate_map($event); $url = get_option('mc_uri') != '' && !is_numeric(get_option('mc_uri')) ? $e_link : $event->event_url; $e['gcal'] = mc_google_cal($dtstart, $dtend, $url, stripcslashes($event->event_title), mc_maplink($event, 'gcal'), $strip_desc); $e['gcal_link'] = "<a href='" . mc_google_cal($dtstart, $dtend, $url, stripcslashes($event->event_title), mc_maplink($event, 'gcal'), $strip_desc) . "' class='gcal external'>" . sprintf(__('Send <span class="screen-reader-text">%1$s </span>to Google Calendar', 'my-calendar'), stripcslashes($event->event_title)) . "</a>"; $e['location_access'] = mc_expand(unserialize(mc_location_data('location_access', $event->event_location))); $e['location_source'] = $event->event_location; // IDs $e['dateid'] = $event->occur_id; // unique ID for this date of this event $e['id'] = $event->event_id; $e['group'] = $event->event_group_id; $e['event_span'] = $event->event_span; // RSS guid $e['region'] = $event->event_region; $e['guid'] = get_option('mc_uri') != '' && !is_numeric(get_option('mc_uri')) ? "<guid isPermaLink='true'>{$e_link}</guid>" : "<guid isPermalink='false'>{$e_link}</guid>"; // iCAL $e['ical_location'] = $event->event_label . ' ' . $event->event_street . ' ' . $event->event_street2 . ' ' . $event->event_city . ' ' . $event->event_state . ' ' . $event->event_postcode; $e['ical_description'] = str_replace("\r", "=0D=0A=", $event->event_desc); $e['ical_desc'] = $strip_desc; $e['ical_start'] = $dtstart; $e['ical_end'] = $dtend; $ical_link = mc_build_url(array('vcal' => $event->occur_id), array('month', 'dy', 'yr', 'ltype', 'loc', 'mcat', 'format'), get_option('mc_uri')); $e['ical'] = $ical_link; $e['ical_html'] = "<a class='ical' rel='nofollow' href='{$ical_link}'>" . __('iCal', 'my-calendar') . "</a>"; $e = apply_filters('mc_filter_shortcodes', $e, $event); return $e; }
function my_calendar_locations_list($show = 'list', $type = 'saved', $datatype = 'name', $group = 'single') { global $wpdb; $mcdb = $wpdb; if (get_option('mc_remote') == 'true' && function_exists('mc_remote_db')) { $mcdb = mc_remote_db(); } $output = ''; if (isset($_GET['mc_id'])) { return; } if ($type == 'saved') { switch ($datatype) { case "name": $data = "location_label"; break; case "city": $data = "location_city"; break; case "state": $data = "location_state"; break; case "zip": $data = "location_postcode"; break; case "country": $data = "location_country"; break; case "region": $data = "location_region"; break; default: $data = "location_label"; } } else { $data = $datatype; } $current_url = mc_get_current_url(); if ($type == 'saved') { $locations = $mcdb->get_results("SELECT DISTINCT {$data} FROM " . MY_CALENDAR_LOCATIONS_TABLE . " ORDER BY {$data} ASC", ARRAY_A); } else { $data = get_option('mc_user_settings'); $locations = $data['my_calendar_location_default']['values']; $datatype = str_replace('event_', '', get_option('mc_location_type')); $datatype = $datatype == 'label' ? 'name' : $datatype; $datatype = $datatype == 'postcode' ? 'zip' : $datatype; } if (count($locations) > 1) { if ($show == 'list') { $url = mc_build_url(array('loc' => 'all', 'ltype' => 'all'), array()); $output .= "<ul id='mc-locations-list'>\n\t\t\t<li><a href='{$url}'>" . __('Show all', 'my-calendar') . "</a></li>\n"; } else { $ltype = !isset($_GET['ltype']) ? $datatype : $_GET['ltype']; $output .= "<div id='mc_locations'>"; $output .= $group == 'single' ? "\n\t\t<form action='" . $current_url . "' method='get'>\n\t\t<div>" : ''; $output .= "<input type='hidden' name='ltype' value='{$ltype}' />"; if ($group == 'single') { $qsa = array(); parse_str($_SERVER['QUERY_STRING'], $qsa); if (!isset($_GET['cid'])) { $output .= '<input type="hidden" name="cid" value="all" />'; } foreach ($qsa as $name => $argument) { $name = esc_attr(strip_tags($name)); $argument = esc_attr(strip_tags($argument)); if ($name != 'loc' && $name != 'ltype') { $output .= "\n\t\t" . '<input type="hidden" name="' . $name . '" value="' . $argument . '" />'; } } } $output .= "\n\t\t\t<label for='mc-locations-list'>" . __('Location', 'my-calendar') . "</label>\n\t\t\t<select name='loc' id='mc-locations-list'>\n\t\t\t<option value='all'>" . __('Show all', 'my-calendar') . "</option>\n"; } foreach ($locations as $key => $location) { if ($type == 'saved') { foreach ($location as $key => $value) { $vt = urlencode(trim($value)); $value = stripcslashes($value); if ($value == '') { continue; } if (empty($_GET['loc'])) { $loc = ''; } else { $loc = $_GET['loc']; } if ($show == 'list') { $selected = $vt == $loc ? " class='selected'" : ''; $this_url = mc_build_url(array('loc' => $vt, 'ltype' => $datatype), array()); $output .= "\t\t\t<li{$selected}><a rel='nofollow' href='{$this_url}'>{$value}</a></li>\n"; } else { $selected = $vt == $loc ? " selected='selected'" : ''; if ($value != '') { $output .= "\t\t\t<option value='{$vt}'{$selected}>{$value}</option>\n"; } } } } else { $vk = urlencode(trim($key)); $location = trim($location); if ($location == '') { continue; } if ($show == 'list') { $selected = $vk == $_GET['loc'] ? " class='selected'" : ''; $this_url = mc_build_url(array('loc' => $vk, 'ltype' => $datatype), array()); $output .= "\t\t\t<li{$selected}><a rel='nofollow' href='{$this_url}'>{$location}</a></li>\n"; } else { $selected = $vk == $_GET['loc'] ? " selected='selected'" : ''; $output .= "\t\t\t<option value='{$vk}'{$selected}>{$location}</option>\n"; } } } if ($show == 'list') { $output .= "</ul>"; } else { $output .= "</select>"; $output .= $group == 'single' ? "<input type='submit' value=" . __('Submit', 'my-calendar') . " />\n\t\t\t\t\t</div>\n\t\t\t\t</form>" : ''; $output .= "\n\t\t\t</div>"; } $output = apply_filters('mc_location_selector', $output, $locations); return $output; } else { return; } }
function mc_get_details_link($event) { // if available, and not querying remotely, use permalink. $permalinks = apply_filters('mc_use_permalinks', get_option('mc_use_permalinks')); $permalinks = $permalinks === 1 || $permalinks === true || $permalinks === 'true' ? true : false; $details_link = $event->event_link; if ($event->event_post != 0 && get_option('mc_remote') != 'true' && $permalinks) { $details_link = add_query_arg('mc_id', $event->occur_id, get_permalink($event->event_post)); } else { if (get_option('mc_uri') != '' && !is_numeric(get_option('mc_uri'))) { $details_link = mc_build_url(array('mc_id' => $event->occur_id), array('month', 'dy', 'yr', 'ltype', 'loc', 'mcat', 'format', 'feed', 'page_id', 'p', 'mcs', 'time'), get_option('mc_uri')); } } return $details_link; }
function my_calendar_save($action, $output, $event_id = false) { global $wpdb, $event_author; $mcdb = $wpdb; $proceed = $output[0]; $message = ''; $formats = array('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%f', '%f'); if (($action == 'add' || $action == 'copy') && $proceed == true) { $add = $output[2]; // add format here $add = apply_filters('mc_before_save_insert', $add); $result = $mcdb->insert(my_calendar_table(), $add, $formats); $event_id = $mcdb->insert_id; mc_increment_event($event_id); if (!$result) { $message = "<div class='error notice'><p><strong>" . __('Error', 'my-calendar') . ":</strong> " . __('I\'m sorry! I couldn\'t add that event to the database.', 'my-calendar') . "</p></div>"; } else { // do an action using the $action and processed event data $data = $add; do_action('mc_save_event', $action, $data, $event_id, $result); // Call mail function if (get_option('mc_event_mail') == 'true') { $event = mc_get_first_event($event_id); // insert_id is last occurrence inserted in the db my_calendar_send_email($event); } if ($add['event_approved'] == 0) { $message = "<div class='updated notice'><p>" . __('Event saved. An administrator will review and approve your event.', 'my-calendar') . "</p></div>"; } else { if (function_exists('jd_doTwitterAPIPost') && isset($_POST['mc_twitter']) && trim($_POST['mc_twitter']) != '') { jd_doTwitterAPIPost(stripslashes($_POST['mc_twitter'])); } if (get_option('mc_uri') != '') { $event_ids = mc_get_occurrences($event_id); $event_link = mc_build_url(array('mc_id' => $event_ids[0]->occur_id), array('page'), get_option('mc_uri')); } else { $event_link = false; } $message = "<div class='updated notice'><p>" . __('Event added. It will now show on the calendar.', 'my-calendar'); if ($event_link !== false) { $message .= sprintf(__(' <a href="%s">View Event</a>', 'my-calendar'), $event_link); } $message .= "</p></div>"; } mc_delete_cache(); } } if ($action == 'edit' && $proceed == true) { $result = true; $url = get_option('mc_uri') != '' && !is_numeric(get_option('mc_uri')) ? '' . sprintf(__('View <a href="%s">your calendar</a>.', 'my-calendar'), get_option('mc_uri')) : ''; $event_author = (int) $_POST['event_author']; if (mc_can_edit_event($event_author)) { $update = $output[2]; $update = apply_filters('mc_before_save_update', $update, $event_id); $date_changed = $update['event_begin'] != $_POST['prev_event_begin'] || date("H:i:00", strtotime($update['event_time'])) != $_POST['prev_event_time'] || $update['event_end'] != $_POST['prev_event_end'] || date("H:i:00", strtotime($update['event_endtime'])) != $_POST['prev_event_endtime'] && ($_POST['prev_event_endtime'] != '' && date("H:i:00", strtotime($update['event_endtime'])) != '00:00:00') ? true : false; if (isset($_POST['event_instance'])) { $is_changed = mc_compare($update, $event_id); // compares the information sent to the information saved for a given event. $event_instance = (int) $_POST['event_instance']; if ($is_changed) { // if changed, create new event, match group id, update instance to reflect event connection, same group id. // if group ID == 0, need to add group ID to both records. if ($update['event_group_id'] == 0) { $update['event_group_id'] = $event_id; mc_update_data($event_id, 'event_group_id', $event_id); } $mcdb->insert(my_calendar_table(), $update, $formats); $new_event = $mcdb->insert_id; // need to get this variable into URL for form submit $result = mc_update_instance($event_instance, $new_event, $update); mc_delete_cache(); } else { if ($update['event_begin'][0] == $_POST['prev_event_begin'] && $update['event_end'][0] == $_POST['prev_event_end']) { // There were no changes at all. } else { $result = mc_update_instance($event_instance, $event_id, $update); // Only dates were changed $message = "<div class='updated notice'><p>" . __('Date/time information for this event has been updated.', 'my-calendar') . "{$url}</p></div>"; mc_delete_cache(); } } } else { $result = $mcdb->update(my_calendar_table(), $update, array('event_id' => $event_id), $formats, '%d'); $recur_changed = $update['event_repeats'] != $_POST['prev_event_repeats'] || $update['event_recur'] != $_POST['prev_event_recur'] ? true : false; if ($date_changed || $recur_changed) { mc_delete_instances($event_id); mc_increment_event($event_id); mc_delete_cache(); } } $data = $update; do_action('mc_save_event', $action, $data, $event_id, $result); if ($result === false) { $message = "<div class='error'><p><strong>" . __('Error', 'my-calendar') . ":</strong>" . __('Your event was not updated.', 'my-calendar') . "{$url}</p></div>"; } else { // do an action using the $action and processed event data do_action('mc_transition_event', (int) $_POST['prev_event_status'], (int) $_POST['event_approved']); $message = "<div class='updated'><p>" . __('Event updated successfully', 'my-calendar') . ".{$url}</p></div>"; mc_delete_cache(); } } else { $message = "<div class='error'><p><strong>" . __('You do not have sufficient permissions to edit that event.', 'my-calendar') . "</strong></p></div>"; } } if ($action == 'delete') { // Deal with deleting an event from the database if (empty($event_id)) { $message = "<div class='error'><p><strong>" . __('Error', 'my-calendar') . ":</strong>" . __("You can't delete an event if you haven't submitted an event id", 'my-calendar') . "</p></div>"; } else { $post_id = mc_get_data('event_post', $event_id); if (empty($_POST['event_instance'])) { $sql = "DELETE FROM " . my_calendar_table() . " WHERE event_id='" . (int) $event_id . "'"; $delete_occurrences = "DELETE FROM " . my_calendar_event_table() . " WHERE occur_event_id = " . (int) $event_id; $mcdb->query($delete_occurrences); $mcdb->query($sql); $sql = "SELECT event_id FROM " . my_calendar_table() . " WHERE event_id='" . (int) $event_id . "'"; $result = $mcdb->get_results($sql); } else { $delete = "DELETE FROM " . my_calendar_event_table() . " WHERE occur_id = " . (int) $_POST['event_instance']; $result = $mcdb->get_results($delete); } if (empty($result) || empty($result[0]->event_id)) { mc_delete_cache(); // do an action using the event_id do_action('mc_delete_event', $event_id, $post_id); $message = "<div class='updated'><p>" . __('Event deleted successfully', 'my-calendar') . "</p></div>"; } else { $message = "<div class='error'><p><strong>" . __('Error', 'my-calendar') . ":</strong>" . __('Despite issuing a request to delete, the event still remains in the database. Please investigate.', 'my-calendar') . "</p></div>"; } } } $message = $message . "\n" . $output[3]; return array('event_id' => $event_id, 'message' => $message); }