function mc_increment_event($id, $post = array(), $test = false) { global $wpdb; $event = mc_get_event_core($id); $data = array(); if (empty($post)) { $orig_begin = $event->event_begin . ' ' . $event->event_time; $orig_end = $event->event_end . ' ' . $event->event_endtime; } else { $orig_begin = @$post['event_begin'] . ' ' . @$post['event_time']; $orig_end = @$post['event_end'] . ' ' . @$post['event_endtime']; } $group_id = $event->event_group_id; $format = array('%d', '%s', '%s', '%d'); $recurs = str_split($event->event_recur, 1); $recur = $recurs[0]; $every = isset($recurs[1]) ? $recurs[1] : 1; if ($recur != "S") { // if this event had a rep of 0, translate that. $event_repetition = $event->event_repeats != 0 ? $event->event_repeats : _mc_increment_values($recur); $numforward = (int) $event_repetition; if ($recur != 'S') { switch ($recur) { case "D": case "E": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, $i * $every, 0, 0); $end = my_calendar_add_date($orig_end, $i * $every, 0, 0); if ($recur == 'E' && (date('w', $begin) != 0 && date('w', $begin) != 6) || $recur == 'D') { $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } } else { $numforward++; } } break; case "W": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, $i * 7 * $every, 0, 0); $end = my_calendar_add_date($orig_end, $i * 7 * $every, 0, 0); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; case "B": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, $i * 14, 0, 0); $end = my_calendar_add_date($orig_end, $i * 14, 0, 0); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; case "M": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, 0, $i * $every, 0); $end = my_calendar_add_date($orig_end, 0, $i * $every, 0); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; case "U": //important to keep track of which date variables are strings and which are timestamps $week_of_event = week_of_month(date('d', strtotime($event->event_begin))); $newbegin = my_calendar_add_date($orig_begin, 28, 0, 0); $newend = my_calendar_add_date($orig_end, 28, 0, 0); $fifth_week = $event->event_fifth_week; $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', strtotime($orig_begin)), 'occur_end' => date('Y-m-d H:i:s', strtotime($orig_end)), 'occur_group_id' => $group_id); if ($test == 'test') { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } $numforward = $numforward - 1; for ($i = 0; $i <= $numforward; $i++) { $next_week_diff = date('m', $newbegin) == date('m', my_calendar_add_date(date('Y-m-d', $newbegin), 7, 0, 0)) ? false : true; $move_event = $fifth_week == 1 && $week_of_event == week_of_month(date('d', $newbegin)) + 1 && $next_week_diff == true ? true : false; if ($week_of_event == week_of_month(date('d', $newbegin)) || $move_event == true) { // continue; } else { $newbegin = my_calendar_add_date(date('Y-m-d H:i:s', $newbegin), 7, 0, 0); $newend = my_calendar_add_date(date('Y-m-d H:i:s', $newend), 7, 0, 0); $move_event = $fifth_week == 1 && $week_of_event == week_of_month(date('d', $newbegin)) + 1 ? true : false; if ($week_of_event == week_of_month(date('d', $newbegin)) || $move_event == true) { // continue; } else { $newbegin = my_calendar_add_date(date('Y-m-d H:i:s', $newbegin), 14, 0, 0); $newend = my_calendar_add_date(date('Y-m-d H:i:s', $newend), 14, 0, 0); } } $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $newbegin), 'occur_end' => date('Y-m-d H:i:s', $newend), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } $newbegin = my_calendar_add_date(date('Y-m-d H:i:s', $newbegin), 28, 0, 0); $newend = my_calendar_add_date(date('Y-m-d H:i:s', $newend), 28, 0, 0); } break; case "Y": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, 0, 0, $i * $every); $end = my_calendar_add_date($orig_end, 0, 0, $i * $every); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; } } } else { $begin = strtotime($orig_begin); $end = strtotime($orig_end); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); // Logic shift -- should not have any need to verify occurrences. //$occurs = $wpdb->get_results("SELECT * FROM ".my_calendar_event_table()." WHERE occur_event_id = $id ORDER BY occur_begin DESC"); if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } } return $data; }
function mc_increment_event($id, $post = array(), $test = false) { global $wpdb; $event = mc_get_event_core($id); $data = array(); if (empty($post)) { $orig_begin = $event->event_begin . ' ' . $event->event_time; $orig_end = $event->event_end . ' ' . $event->event_endtime; } else { $orig_begin = @$post['event_begin'] . ' ' . @$post['event_time']; $orig_end = @$post['event_end'] . ' ' . @$post['event_endtime']; } $group_id = $event->event_group_id; $format = array('%d', '%s', '%s', '%d'); $recurs = str_split($event->event_recur, 1); $recur = $recurs[0]; $every = isset($recurs[1]) ? $recurs[1] : 1; if ($recur != "S") { // if this event had a rep of 0, translate that. $event_repetition = $event->event_repeats != 0 ? $event->event_repeats : _mc_increment_values($recur); $numforward = (int) $event_repetition; if ($recur != 'S') { switch ($recur) { case "D": case "E": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, $i * $every, 0, 0); $end = my_calendar_add_date($orig_end, $i * $every, 0, 0); if ($recur == 'E' && (date('w', $begin) != 0 && date('w', $begin) != 6) || $recur == 'D') { $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $wpdb->insert(my_calendar_event_table(), $data, $format); } } else { $numforward++; } } break; case "W": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, $i * 7 * $every, 0, 0); $end = my_calendar_add_date($orig_end, $i * 7 * $every, 0, 0); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $sql = $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; case "B": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, $i * 14, 0, 0); $end = my_calendar_add_date($orig_end, $i * 14, 0, 0); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; case "M": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, 0, $i * $every, 0); $end = my_calendar_add_date($orig_end, 0, $i * $every, 0); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; case "U": //important to keep track of which date variables are strings and which are timestamps // This pattern handles monthly events by day. //if ( $every != 1 ) { // return an error? // handle patterns that are something *other* than every month /* Idea: use mod to identify which months need to be checked. Check which date in each month. */ //} else { $week_of_event = week_of_month(date('d', strtotime($event->event_begin))); $newbegin = my_calendar_add_date($orig_begin, 28, 0, 0); $newend = my_calendar_add_date($orig_end, 28, 0, 0); $fifth_week = $event->event_fifth_week; $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', strtotime($orig_begin)), 'occur_end' => date('Y-m-d H:i:s', strtotime($orig_end)), 'occur_group_id' => $group_id); /* if ( $test == 'test' && $i > 0 ) { return $data; } */ if (!$test) { $wpdb->insert(my_calendar_event_table(), $data, $format); } $numforward = $numforward - 1; for ($i = 0; $i <= $numforward; $i++) { $next_week_diff = date('m', $newbegin) == date('m', my_calendar_add_date(date('Y-m-d', $newbegin), 7, 0, 0)) ? false : true; $move_event = $fifth_week == 1 && $week_of_event == week_of_month(date('d', $newbegin)) + 1 && $next_week_diff == true ? true : false; if ($week_of_event == week_of_month(date('d', $newbegin)) || $move_event == true) { // continue; } else { $newbegin = my_calendar_add_date(date('Y-m-d H:i:s', $newbegin), 7, 0, 0); $newend = my_calendar_add_date(date('Y-m-d H:i:s', $newend), 7, 0, 0); $move_event = $fifth_week == 1 && $week_of_event == week_of_month(date('d', $newbegin)) + 1 ? true : false; if ($week_of_event == week_of_month(date('d', $newbegin)) || $move_event == true) { // continue; } else { $newbegin = my_calendar_add_date(date('Y-m-d H:i:s', $newbegin), 14, 0, 0); $newend = my_calendar_add_date(date('Y-m-d H:i:s', $newend), 14, 0, 0); } } $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $newbegin), 'occur_end' => date('Y-m-d H:i:s', $newend), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $wpdb->insert(my_calendar_event_table(), $data, $format); } $newbegin = my_calendar_add_date(date('Y-m-d H:i:s', $newbegin), 28, 0, 0); $newend = my_calendar_add_date(date('Y-m-d H:i:s', $newend), 28, 0, 0); //} } break; case "Y": for ($i = 0; $i <= $numforward; $i++) { $begin = my_calendar_add_date($orig_begin, 0, 0, $i * $every); $end = my_calendar_add_date($orig_end, 0, 0, $i * $every); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if ($test == 'test' && $i > 0) { return $data; } if (!$test) { $wpdb->insert(my_calendar_event_table(), $data, $format); } } break; } } } else { $begin = strtotime($orig_begin); $end = strtotime($orig_end); $data = array('occur_event_id' => $id, 'occur_begin' => date('Y-m-d H:i:s', $begin), 'occur_end' => date('Y-m-d H:i:s', $end), 'occur_group_id' => $group_id); if (!$test) { $wpdb->insert(my_calendar_event_table(), $data, $format); } } return $data; }
function mc_list_events() { global $wpdb; $mcdb = $wpdb; if (current_user_can('mc_approve_events') || current_user_can('mc_manage_events') || current_user_can('mc_add_events')) { $action = !empty($_POST['event_action']) ? $_POST['event_action'] : ''; $event_id = !empty($_POST['event_id']) ? $_POST['event_id'] : ''; if ($action == 'delete') { $message = mc_delete_event($event_id); echo $message; } if (isset($_GET['order'])) { $sortdir = isset($_GET['order']) && $_GET['order'] == 'ASC' ? 'ASC' : 'default'; $sortdir = isset($_GET['order']) && $_GET['order'] == 'DESC' ? 'DESC' : $sortdir; } else { $sortdir = 'default'; } $default_direction = get_option('mc_default_direction') == '' ? 'ASC' : get_option('mc_default_direction'); $sortbydirection = $sortdir == 'default' ? $default_direction : $sortdir; $sortby = isset($_GET['sort']) ? $_GET['sort'] : get_option('mc_default_sort'); if (empty($sortby)) { $sortbyvalue = 'event_begin'; } else { switch ($sortby) { case 1: $sortbyvalue = 'event_ID'; break; case 2: $sortbyvalue = 'event_title'; break; case 3: $sortbyvalue = 'event_desc'; break; case 4: $sortbyvalue = "event_begin {$sortbydirection}, event_time"; break; case 5: $sortbyvalue = 'event_author'; break; case 6: $sortbyvalue = 'event_category'; break; case 7: $sortbyvalue = 'event_label'; break; default: $sortbyvalue = "event_begin {$sortbydirection}, event_time"; } } $sorting = $sortbydirection == 'DESC' ? "&order=ASC" : '&order=DESC'; $allow_filters = true; $status = isset($_GET['limit']) ? $_GET['limit'] : 'all'; $restrict = isset($_GET['restrict']) ? $_GET['restrict'] : 'all'; switch ($status) { case 'all': $limit = ''; break; case 'reserved': $limit = 'WHERE event_approved <> 1'; break; case 'published': $limit = 'WHERE event_approved = 1'; break; default: $limit = ''; } switch ($restrict) { case 'all': $filter = ''; break; case 'where': $filter = isset($_GET['filter']) ? $_GET['filter'] : ''; $restrict = "event_label"; break; case 'author': $filter = isset($_GET['filter']) ? (int) $_GET['filter'] : ''; $restrict = "event_author"; break; case 'category': $filter = isset($_GET['filter']) ? (int) $_GET['filter'] : ''; $restrict = "event_category"; break; case 'flagged': $filter = isset($_GET['filter']) ? (int) $_GET['filter'] : ''; $restrict = "event_flagged"; break; default: $filter = ''; } if (!current_user_can('mc_manage_events') && !current_user_can('mc_approve_events')) { $restrict = 'event_author'; $filter = get_current_user_id(); $allow_filters = false; } $filter = esc_sql(urldecode($filter)); if ($restrict == "event_label") { $filter = "'{$filter}'"; } if ($limit == '' && $filter != '') { $limit = "WHERE {$restrict} = {$filter}"; } else { if ($limit != '' && $filter != '') { $limit .= "AND {$restrict} = {$filter}"; } } if ($filter == '' || !$allow_filters) { $filtered = ""; } else { $filtered = "<span class='dashicons dashicons-no'></span><a href='" . admin_url('admin.php?page=my-calendar-manage') . "'>" . __('Clear filters', 'my-calendar') . "</a>"; } $current = empty($_GET['paged']) ? 1 : intval($_GET['paged']); $user = get_current_user_id(); $screen = get_current_screen(); $option = $screen->get_option('per_page', 'option'); $items_per_page = get_user_meta($user, $option, true); if (empty($items_per_page) || $items_per_page < 1) { $items_per_page = $screen->get_option('per_page', 'default'); } // default limits if ($limit == '') { $limit .= $restrict != 'event_flagged' ? " WHERE event_flagged = 0" : ''; } else { $limit .= $restrict != 'event_flagged' ? " AND event_flagged = 0" : ''; } if (isset($_POST['mcs'])) { $query = $_POST['mcs']; $limit .= mc_prepare_search_query($query); } $limit .= $restrict != 'archived' ? " AND event_status = 1" : ' AND event_status = 0'; $events = $mcdb->get_results("SELECT SQL_CALC_FOUND_ROWS event_id FROM " . my_calendar_table() . " {$limit} ORDER BY {$sortbyvalue} {$sortbydirection} LIMIT " . ($current - 1) * $items_per_page . ", " . $items_per_page); $found_rows = $wpdb->get_col("SELECT FOUND_ROWS();"); $items = $found_rows[0]; if ((function_exists('akismet_http_post') || function_exists('bs_checker')) && $allow_filters) { ?> <ul class="links"> <li> <a <?php echo isset($_GET['restrict']) && $_GET['restrict'] == 'flagged' ? 'class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-manage&restrict=flagged&filter=1'); ?> "><?php _e('Spam', 'my-calendar'); ?> </a> </li> </ul><?php } ?> <div class='mc-search'> <form action="<?php echo esc_url(add_query_arg($_GET, admin_url('admin.php'))); ?> " method="post"> <div><input type="hidden" name="_wpnonce" value="<?php echo wp_create_nonce('my-calendar-nonce'); ?> "/> </div> <div> <label for="mc_search" class='screen-reader-text'><?php _e('Search', 'my-calendar'); ?> </label> <input type='text' role='search' name='mcs' id='mc_search' value='<?php if (isset($_POST['mcs'])) { esc_attr_e($_POST['mcs']); } ?> '/> <input type='submit' value='<?php _e('Search Events', 'my-calendar'); ?> ' class='button-secondary'/> </div> </form> </div> <?php if (get_option('mc_event_approve') == 'true') { ?> <ul class="links"> <li> <a <?php echo isset($_GET['limit']) && $_GET['limit'] == 'published' ? 'class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-manage&limit=published'); ?> "><?php _e('Published', 'my-calendar'); ?> </a> </li> <li> <a <?php echo isset($_GET['limit']) && $_GET['limit'] == 'reserved' ? 'class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-manage&limit=reserved'); ?> "><?php _e('Reserved', 'my-calendar'); ?> </a> </li> <li> <a <?php echo isset($_GET['limit']) && $_GET['limit'] == 'all' || !isset($_GET['limit']) ? 'class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-manage&restrict=archived'); ?> "><?php _e('Archived', 'my-calendar'); ?> </a> </li> <li> <a <?php echo isset($_GET['limit']) && $_GET['limit'] == 'all' || !isset($_GET['limit']) ? 'class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-manage&limit=all'); ?> "><?php _e('All', 'my-calendar'); ?> </a> </li> </ul><?php } echo $filtered; $num_pages = ceil($items / $items_per_page); if ($num_pages > 1) { $page_links = paginate_links(array('base' => add_query_arg('paged', '%#%'), 'format' => '', 'prev_text' => __('« Previous<span class="screen-reader-text"> Events</span>', 'my-calendar'), 'next_text' => __('Next<span class="screen-reader-text"> Events</span> »', 'my-calendar'), 'total' => $num_pages, 'current' => $current, 'mid_size' => 1)); printf("<div class='tablenav'><div class='tablenav-pages'>%s</div></div>", $page_links); } if (!empty($events)) { ?> <form action="<?php echo esc_url(add_query_arg($_GET, admin_url('admin.php'))); ?> " method="post"> <div><input type="hidden" name="_wpnonce" value="<?php echo wp_create_nonce('my-calendar-nonce'); ?> "/> </div> <div class='mc-actions'> <input type="submit" class="button-secondary delete" name="mass_delete" value="<?php _e('Delete events', 'my-calendar'); ?> "/> <?php if (current_user_can('mc_approve_events')) { ?> <input type="submit" class="button-secondary mc-approve" name="mass_approve" value="<?php _e('Approve events', 'my-calendar'); ?> "/> <?php } ?> <?php if (!(isset($_GET['restrict']) && $_GET['restrict'] == 'archived')) { ?> <input type="submit" class="button-secondary mc-archive" name="mass_archive" value="<?php _e('Archive events', 'my-calendar'); ?> "/> <?php } else { ?> <input type="submit" class="button-secondary mc-archive" name="mass_undo_archive" value="<?php _e('Remove from archive', 'my-calendar'); ?> "/> <?php } ?> </div> <table class="widefat wp-list-table" id="my-calendar-admin-table"> <thead> <tr> <th scope="col" style="width: 50px;"><input type='checkbox' class='selectall' id='mass_edit'/> <label for='mass_edit' class="screen-reader-text"><?php _e('Check/Uncheck all', 'my-calendar'); ?> </label> <a href="<?php echo admin_url("admin.php?page=my-calendar-manage&sort=1{$sorting}"); ?> "><?php _e('ID', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-manage&sort=2{$sorting}"); ?> "><?php _e('Title', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-manage&sort=7{$sorting}"); ?> "><?php _e('Location', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-manage&sort=4{$sorting}"); ?> "><?php _e('Date/Time', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-manage&sort=5{$sorting}"); ?> "><?php _e('Author', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-manage&sort=6{$sorting}"); ?> "><?php _e('Category', 'my-calendar'); ?> </a> </th> </tr> </thead> <?php $class = ''; $sql = "SELECT * FROM " . my_calendar_categories_table(); $categories = $mcdb->get_results($sql); foreach (array_keys($events) as $key) { $event =& $events[$key]; $event = mc_get_event_core($event->event_id); if (!is_object($event)) { continue; } $class = $class == 'alternate' ? 'even' : 'alternate'; $pending = $event->event_approved == 0 ? 'pending' : ''; $author = $event->event_author != 0 ? get_userdata($event->event_author) : 'Public Submitter'; if ($event->event_flagged == 1 && (isset($_GET['restrict']) && $_GET['restrict'] == 'flagged')) { $spam = 'spam'; $pending = ''; $spam_label = '<strong>' . __('Possible spam', 'my-calendar') . ':</strong> '; } else { $spam = ''; $spam_label = ''; } $edit_url = admin_url("admin.php?page=my-calendar&mode=edit&event_id={$event->event_id}"); $copy_url = admin_url("admin.php?page=my-calendar&mode=copy&event_id={$event->event_id}"); $view_url = mc_get_details_link($event); $group_url = admin_url("admin.php?page=my-calendar-groups&mode=edit&event_id={$event->event_id}&group_id={$event->event_group_id}"); $delete_url = admin_url("admin.php?page=my-calendar-manage&mode=delete&event_id={$event->event_id}"); $check = mc_test_occurrence_overlap($event, true); $problem = $check != '' ? 'problem' : ''; if (current_user_can('mc_manage_events') || current_user_can('mc_approve_events') || mc_can_edit_event($event->event_id)) { ?> <tr class="<?php echo "{$class} {$spam} {$pending} {$problem}"; ?> "> <th scope="row"> <input type="checkbox" value="<?php echo $event->event_id; ?> " name="mass_edit[]" id="mc<?php echo $event->event_id; ?> " <?php echo $event->event_flagged == 1 ? 'checked="checked"' : ''; ?> /> <label for="mc<?php echo $event->event_id; ?> "><?php echo $event->event_id; ?> </label> </th> <td title="<?php echo esc_attr(substr(strip_tags(stripslashes($event->event_desc)), 0, 240)); ?> "> <strong><?php if (mc_can_edit_event($event->event_id)) { ?> <a href="<?php echo $edit_url; ?> " class='edit'> <?php } ?> <?php echo $spam_label; echo strip_tags(stripslashes($event->event_title)); ?> <?php if (mc_can_edit_event($event->event_id)) { echo "</a>"; if ($check != '') { echo '<br /><strong class="error">' . sprintf(__('There is a problem with this event. <a href="%s">View</a>', 'my-calendar'), $edit_url) . '</strong>'; } } ?> </strong> <div class='row-actions' style="visibility:visible;"> <?php if (mc_event_published($event)) { ?> <a href="<?php echo $view_url; ?> " class='view'><?php _e('View', 'my-calendar'); ?> </a> | <?php } ?> <a href="<?php echo $copy_url; ?> " class='copy'><?php _e('Copy', 'my-calendar'); ?> </a> | <?php if (mc_can_edit_event($event->event_id)) { ?> <a href="<?php echo $edit_url; ?> " class='edit'><?php _e('Edit', 'my-calendar'); ?> </a> <?php if (mc_event_is_grouped($event->event_group_id)) { ?> | <a href="<?php echo $group_url; ?> " class='edit group'><?php _e('Edit Group', 'my-calendar'); ?> </a> <?php } ?> | <a href="<?php echo $delete_url; ?> " class="delete"><?php _e('Delete', 'my-calendar'); ?> </a> <?php } else { _e("Not editable.", 'my-calendar'); } if (get_option('mc_event_approve') == 'true') { ?> | <?php if (current_user_can('mc_approve_events')) { // Added by Roland P. if ($event->event_approved == '1') { $mo = 'reject'; $te = __('Reject', 'my-calendar'); } else { $mo = 'publish'; $te = __('Approve', 'my-calendar'); } ?> <a href="<?php echo admin_url("admin.php?page=my-calendar-manage&mode={$mo}&event_id={$event->event_id}"); ?> " class='<?php echo $mo; ?> '><?php echo $te; ?> </a> <?php } else { switch ($event->event_approved) { case 1: _e('Approved', 'my-calendar'); break; case 2: _e('Rejected', 'my-calendar'); break; default: _e('Awaiting Approval', 'my-calendar'); } } } ?> </div> </td> <td> <?php if ($event->event_label != '') { ?> <a class='mc_filter' href='<?php $elabel = urlencode($event->event_label); echo admin_url("admin.php?page=my-calendar-manage&filter={$elabel}&restrict=where"); ?> ' title="<?php _e('Filter by location', 'my-calendar'); ?> "><span class="screen-reader-text"><?php _e('Show only: ', 'my-calendar'); ?> </span><?php echo strip_tags(stripslashes($event->event_label)); ?> </a><?php } ?> </td> <?php if ($event->event_endtime != "23:59:59") { $eventTime = date_i18n(get_option('mc_time_format'), strtotime($event->event_time)); } else { $eventTime = mc_notime_label($event); } ?> <td><?php $date_format = get_option('mc_date_format') == '' ? get_option('date_format') : get_option('mc_date_format'); $begin = date_i18n($date_format, strtotime($event->event_begin)); echo "{$begin}, {$eventTime}"; ?> <div class="recurs"> <strong><?php _e('Recurs', 'my-calendar'); ?> </strong> <?php $recurs = str_split($event->event_recur, 1); $recur = $recurs[0]; $every = isset($recurs[1]) ? $recurs[1] : 1; // Interpret the DB values into something human readable switch ($recur) { case 'S': _e('Never', 'my-calendar'); break; case 'D': $every == 1 ? _e('Daily', 'my-calendar') : printf(__('Every %d days', 'my-calendar'), $every); break; case 'E': $every == 1 ? _e('Weekdays', 'my-calendar') : printf(__('Every %d weekdays', 'my-calendar'), $every); break; case 'W': $every == 1 ? _e('Weekly', 'my-calendar') : printf(__('Every %d weeks', 'my-calendar'), $every); break; case 'B': _e('Bi-Weekly', 'my-calendar'); break; case 'M': $every == 1 ? _e('Monthly (by date)', 'my-calendar') : printf(__('Every %d months (by date)', 'my-calendar'), $every); break; case 'U': _e('Monthly (by day)', 'my-calendar'); break; case 'Y': $every == 1 ? _e('Yearly', 'my-calendar') : printf(__('Every %d years', 'my-calendar'), $every); break; } $eternity = _mc_increment_values($recur); if ($recur == 'S') { } else { if ($event->event_repeats > 0) { printf(__('– %d Times', 'my-calendar'), $event->event_repeats); } else { if ($eternity) { printf(__('– %d Times', 'my-calendar'), $eternity); } } } ?> </div> </td> <td><a class='mc_filter' href="<?php $auth = is_object($author) ? $author->ID : 0; echo admin_url("admin.php?page=my-calendar-manage&filter={$auth}&restrict=author"); ?> " title="<?php _e('Filter by author', 'my-calendar'); ?> "><span class="screen-reader-text"><?php _e('Show only: ', 'my-calendar'); ?> </span><?php echo is_object($author) ? $author->display_name : $author; ?> </a></td> <?php if (!$event->event_category) { // events *must* have a category mc_update_event('event_category', 1, $event->event_id, '%d'); } $color = strip_tags(mc_get_category_detail($event->event_category, 'category_color')); ?> <td> <div class="category-color" style="background-color:<?php echo strpos($color, '#') !== 0 ? '#' : ''; echo $color; ?> ;"> </div> <a class='mc_filter' href='<?php echo admin_url("admin.php?page=my-calendar-manage&filter={$event->event_category}&restrict=category"); ?> ' title="<?php _e('Filter by category', 'my-calendar'); ?> "><span class="screen-reader-text"><?php _e('Show only: ', 'my-calendar'); ?> </span><?php echo mc_kses_post(mc_get_category_detail($event->event_category, 'category_name')); ?> </a></td> </tr> <?php } } ?> </table> <p> <input type="submit" class="button-secondary delete" name="mass_delete" value="<?php _e('Delete events', 'my-calendar'); ?> "/> <?php if (current_user_can('mc_approve_events')) { ?> <input type="submit" class="button-secondary mc-approve" name="mass_approve" value="<?php _e('Approve events', 'my-calendar'); ?> "/> <?php } ?> <?php if (!(isset($_GET['restrict']) && $_GET['restrict'] == 'archived')) { ?> <input type="submit" class="button-secondary mc-archive" name="mass_archive" value="<?php _e('Archive events', 'my-calendar'); ?> "/> <?php } ?> </p> <p> <?php if (!(isset($_GET['restrict']) && $_GET['restrict'] == 'archived')) { ?> <a class='mc_filter' href='<?php echo admin_url("admin.php?page=my-calendar-manage&restrict=archived"); ?> '><?php _e('View Archived Events', 'my-calendar'); ?> </a> <?php } else { ?> <a class='mc_filter' href='<?php echo admin_url("admin.php?page=my-calendar-manage"); ?> '><?php _e('Return to Manage Events', 'my-calendar'); ?> </a> <?php } ?> </p> </form> <?php } else { ?> <p class='mc-none'><?php _e("There are no events in the database meeting your current criteria.", 'my-calendar'); ?> </p><?php } } }
function mc_list_groups() { global $wpdb; $mcdb = $wpdb; $current_user = wp_get_current_user(); $user = $current_user->ID; $sortby = isset($_GET['sort']) ? (int) $_GET['sort'] : get_option('mc_default_sort'); if (isset($_GET['order'])) { $sortdir = isset($_GET['order']) && $_GET['order'] == 'ASC' ? 'ASC' : 'default'; } else { $sortdir = 'default'; } if (empty($sortby)) { $sortbyvalue = 'event_begin'; } else { switch ($sortby) { case 1: $sortbyvalue = 'event_ID'; break; case 2: $sortbyvalue = 'event_title'; break; case 3: $sortbyvalue = 'event_desc'; break; case 4: $sortbyvalue = 'event_begin'; break; case 5: $sortbyvalue = 'event_author'; break; case 6: $sortbyvalue = 'event_category'; break; case 7: $sortbyvalue = 'event_label'; break; case 8: $sortbyvalue = 'group_id'; break; default: $sortbyvalue = 'event_begin'; } } $sortbydirection = $sortdir == 'default' ? 'DESC' : $sortdir; $sorting = $sortbydirection == 'DESC' ? "&order=ASC" : ''; $current = empty($_GET['paged']) ? 1 : intval($_GET['paged']); $screen = get_current_screen(); $option = $screen->get_option('per_page', 'option'); $items_per_page = get_user_meta($user, $option, true); if (empty($items_per_page) || $items_per_page < 1) { $items_per_page = $screen->get_option('per_page', 'default'); } $limit = isset($_GET['limit']) ? $_GET['limit'] : 'all'; switch ($limit) { case 'all': $limit = ''; break; case 'grouped': $limit = 'WHERE event_group_id <> 0'; break; case 'ungrouped': $limit = 'WHERE event_group_id = 0'; break; default: $limit = ''; } $events = $mcdb->get_results("SELECT SQL_CALC_FOUND_ROWS * FROM " . my_calendar_table() . " {$limit} ORDER BY {$sortbyvalue} {$sortbydirection} LIMIT " . ($current - 1) * $items_per_page . ", " . $items_per_page); $found_rows = $wpdb->get_col("SELECT FOUND_ROWS();"); $items = $found_rows[0]; ?> <div class='inside'><?php if (get_option('mc_event_approve') == 'true') { ?> <ul class="links"> <li> <a <?php echo isset($_GET['limit']) && $_GET['limit'] == 'groupeed' ? ' class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-groups&limit=grouped#my-calendar-admin-table'); ?> "><?php _e('Grouped Events', 'my-calendar'); ?> </a> </li> <li> <a <?php echo isset($_GET['limit']) && $_GET['limit'] == 'ungrouped' ? ' class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-groups&limit=ungrouped#my-calendar-admin-table'); ?> "><?php _e('Ungrouped Events', 'my-calendar'); ?> </a> </li> <li> <a <?php echo isset($_GET['limit']) && $_GET['limit'] == 'all' || !isset($_GET['limit']) ? ' class="active-link"' : ''; ?> href="<?php echo admin_url('admin.php?page=my-calendar-groups#my-calendar-admin-table'); ?> "><?php _e('All', 'my-calendar'); ?> </a> </li> </ul> <?php } ?> <p><?php _e('Check a set of events to group them for mass editing.', 'my-calendar'); ?> </p><?php $num_pages = ceil($items / $items_per_page); if ($num_pages > 1) { $page_links = paginate_links(array('base' => add_query_arg('paged', '%#%'), 'format' => '', 'prev_text' => __('« Previous<span class="screen-reader-text"> Events</span>', 'my-calendar'), 'next_text' => __('Next<span class="screen-reader-text"> Events</span> »', 'my-calendar'), 'total' => $num_pages, 'current' => $current, 'mid_size' => 1)); printf("<div class='tablenav'><div class='tablenav-pages'>%s</div></div>", $page_links); } if (!empty($events)) { ?> <form action="<?php echo admin_url("admin.php?page=my-calendar-groups"); ?> " method="post"> <div> <input type="hidden" name="_wpnonce" value="<?php echo wp_create_nonce('my-calendar-nonce'); ?> "/> <input type="hidden" name="event_action" value="group"/> </div> <p style="position:relative;display:inline-block;"> <input type="submit" class="button-primary group" value="<?php _e('Group checked events for mass editing', 'my-calendar'); ?> "/> </p> </div> <table class="widefat wp-list-table" id="my-calendar-admin-table"> <thead> <tr> <th scope="col" style="width: 50px;"><a href="<?php echo admin_url("admin.php?page=my-calendar-groups&sort=1{$sorting}"); ?> "><?php _e('ID', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-groups&sort=8{$sorting}"); ?> "><?php _e('Group', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-groups&sort=2{$sorting}"); ?> "><?php _e('Title', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-groups&sort=7{$sorting}"); ?> "><?php _e('Where', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-groups&sort=4{$sorting}"); ?> "><?php _e('Date/Time', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-groups&sort=5{$sorting}"); ?> "><?php _e('Author', 'my-calendar'); ?> </a> </th> <th scope="col"><a href="<?php echo admin_url("admin.php?page=my-calendar-groups&sort=6{$sorting}"); ?> "><?php _e('Category', 'my-calendar'); ?> </a> </th> </tr> </thead> <?php $class = ''; $sql = "SELECT * FROM " . my_calendar_categories_table(); $categories = $mcdb->get_results($sql); foreach ($events as $event) { $class = $class == 'alternate' ? '' : 'alternate'; $spam = $event->event_flagged == 1 ? ' spam' : ''; $spam_label = $event->event_flagged == 1 ? '<strong>Possible spam:</strong> ' : ''; $author = $event->event_author != 0 ? get_userdata($event->event_author) : 'Public Submitter'; if ($event->event_link != '') { $title = "<a href='" . esc_attr($event->event_link) . "'>" . mc_kses_post($event->event_title) . "</a>"; } else { $title = $event->event_title; } ?> <tr class="<?php echo $class; echo $spam; ?> " id="event<?php echo $event->event_id; ?> "> <th scope="row"><input type="checkbox" value="<?php echo $event->event_id; ?> " name="group[]" id="mc<?php echo $event->event_id; ?> " <?php echo mc_event_is_grouped($event->event_group_id) ? ' disabled="disabled"' : ''; ?> /> <label for="mc<?php echo $event->event_id; ?> "><?php echo $event->event_id; ?> </label></th> <th scope="row"><?php echo $event->event_group_id == 0 ? '-' : $event->event_group_id; ?> </th> <td title="<?php echo esc_attr(substr(strip_tags(stripslashes($event->event_desc)), 0, 240)); ?> "> <strong><?php if (mc_can_edit_event($event->event_id)) { ?> <a href="<?php echo admin_url("admin.php?page=my-calendar&mode=edit&event_id={$event->event_id}"); ?> " class='edit'> <?php } echo $spam_label; echo strip_tags(stripslashes($title)); ?> <?php if (mc_can_edit_event($event->event_id)) { echo "</a>"; } ?> </strong> <div class='row-actions' style="visibility:visible;"> <?php if (mc_can_edit_event($event->event_id)) { ?> <a href="<?php echo admin_url("admin.php?page=my-calendar&mode=edit&event_id={$event->event_id}"); ?> " class='edit'><?php _e('Edit Event', 'my-calendar'); ?> </a> | <?php if (mc_event_is_grouped($event->event_group_id)) { ?> <a href="<?php echo admin_url("admin.php?page=my-calendar-groups&mode=edit&event_id={$event->event_id}&group_id={$event->event_group_id}"); ?> " class='edit group'><?php _e('Edit Group', 'my-calendar'); ?> </a> <?php } else { ?> <em><?php _e('Ungrouped', 'my-calendar'); ?> </em> <?php } } else { _e("Not editable.", 'my-calendar'); } ?> </div> </td> <td><?php echo strip_tags(stripslashes($event->event_label)); ?> </td> <?php if ($event->event_endtime != "23:59:59") { $eventTime = date_i18n(get_option('mc_time_format'), strtotime($event->event_time)); } else { $eventTime = mc_notime_label($event); } ?> <td><?php $date_format = get_option('mc_date_format') == '' ? get_option('date_format') : get_option('mc_date_format'); $begin = date_i18n($date_format, strtotime($event->event_begin)); echo "{$begin}, {$eventTime}"; ?> <div class="recurs"> <strong><?php _e('Recurs', 'my-calendar'); ?> </strong> <?php $recurs = str_split($event->event_recur, 1); $recur = $recurs[0]; $every = isset($recurs[1]) ? $recurs[1] : 1; // Interpret the DB values into something human readable switch ($recur) { case 'S': _e('Never', 'my-calendar'); break; case 'D': $every == 1 ? _e('Daily', 'my-calendar') : printf(__('Every %d days', 'my-calendar'), $every); break; case 'E': $every == 1 ? _e('Weekdays', 'my-calendar') : printf(__('Every %d weekdays', 'my-calendar'), $every); break; case 'W': $every == 1 ? _e('Weekly', 'my-calendar') : printf(__('Every %d weeks', 'my-calendar'), $every); break; case 'B': _e('Bi-Weekly', 'my-calendar'); break; case 'M': $every == 1 ? _e('Monthly (by date)', 'my-calendar') : printf(__('Every %d months (by date)', 'my-calendar'), $every); break; case 'U': _e('Monthly (by day)', 'my-calendar'); break; case 'Y': $every == 1 ? _e('Yearly', 'my-calendar') : printf(__('Every %d years', 'my-calendar'), $every); break; } $eternity = _mc_increment_values($recur); if ($recur == 'S') { } else { if ($event->event_repeats > 0) { printf(__('– %d Times', 'my-calendar'), $event->event_repeats); } else { if ($eternity) { printf(__('– %d Times', 'my-calendar'), $eternity); } } } ?> </div> </td> <td><?php echo is_object($author) ? $author->display_name : $author; ?> </td> <?php $this_category = $event->event_category; foreach ($categories as $key => $value) { if ($value->category_id == $this_category) { $this_cat = $categories[$key]; } } ?> <td> <div class="category-color" style="background-color:<?php echo strip_tags(strpos($this_cat->category_color, '#') !== 0 ? '#' : ''); echo $this_cat->category_color; ?> ;"></div> <?php echo mc_kses_post(stripslashes($this_cat->category_name)); ?> </td> <?php unset($this_cat); ?> </tr><?php } ?> </table> <div class="inside"> <p> <input type="submit" class="button-secondary group" value="<?php _e('Group checked events for mass editing', 'my-calendar'); ?> "/> </p> </div> </form><?php } else { ?> <div class="inside"><p><?php _e("There are no events in the database!", 'my-calendar'); ?> </p></div><?php } }