} //------------------------------------------------- require_once e_ADMIN . 'auth.php'; if (!defined('USER_WIDTH')) { define('USER_WIDTH', 'width:auto'); } // Actually delete back events if (isset($_POST['confirmdeleteold']) && $action == 'backdel') { $old_date = intval($ec_qs[1]); $old_string = strftime("%d %B %Y", $old_date); // Check both start and end dates to avoid problems with events originally entered under 0.617 $qry = "event_start < {$old_date} AND event_end < {$old_date} AND event_recurring = 0"; // $message = "Back delete {$back_count} months. Oldest date = {$old_string} Query = {$qry}"; if ($sql->db_Delete('event', $qry)) { // Add in a log event $ecal_class->cal_log(4, "db_Delete - earlier than {$old_string} (past {$back_count} months)", $qry); $message = EC_ADLAN_A146 . $old_string . EC_ADLAN_A147; } else { $message = EC_ADLAN_A149 . " : " . $sql->mySQLresult; } $action = 'maint'; } // Actually empty cache if (isset($_POST['confirmdelcache']) && $action == 'cachedel') { $e107cache->clear('nq_event_cal'); $message = EC_ADLAN_A163; $action = 'maint'; // Re-display maintenance menu } // Prompt to delete back events if ($action == 'confdel') {
$rec_y = ''; } $report_msg = '.m3'; if (isset($_POST['ne_insert'])) { // Bits specific to inserting a new event $qs = preg_replace("/ne./i", "", $_POST['qs']); if ($_POST['ec_gen_multiple']) { $mult_count = $ecal_class->gen_recur($ev_start, $ev_end, $recurring, $ev_start, $ev_end); } if ($mult_count <= 1) { $qry = " 0, '" . intval($ev_start) . "', '" . intval($ev_end) . "', '" . $ev_allday . "', '" . $recurring . "', '" . time() . "', '{$ev_title}', '{$ev_location}', '{$ev_event}', '" . USERID . "." . USERNAME . "', '" . $ev_email . "', '" . $ev_category . "', '" . $ev_thread . "', '" . intval($rec_m) . "', '" . intval($rec_y) . "' "; $sql->db_Insert('event', $qry); $id = mysql_insert_id(); $data = array('method' => 'create', 'table' => 'event', 'id' => $id, 'plugin' => 'calendar_menu', 'function' => 'dbCalendarCreate'); $e_event->triggerHook($data); $ecal_class->cal_log(1, 'db_Insert', $qry, $ev_start); $report_msg = '.m4'; } } if (isset($_POST['ne_update'])) { // Bits specific to updating an existing event $qry = "event_start='" . intval($ev_start) . "', event_end='" . intval($ev_end) . "', event_allday='" . $ev_allday . "', event_recurring='" . $recurring . "', event_datestamp= '" . time() . "', event_title= '{$ev_title}', event_location='{$ev_location}', event_details='{$ev_event}', event_contact='" . $ev_email . "', event_category='" . $ev_category . "', event_thread='" . $ev_thread . "', event_rec_m='" . intval($rec_m) . "', event_rec_y='" . intval($rec_y) . "' WHERE event_id='" . intval($_POST['id']) . "' "; $sql->db_Update("event", $qry); $data = array('method' => 'update', 'table' => 'event', 'id' => intval($_POST['id']), 'plugin' => 'calendar_menu', 'function' => 'dbCalendarUpdate'); $e_event->triggerHook($data); $ecal_class->cal_log(2, 'db_Update', $qry, $ev_start); $qs = preg_replace("/ed./i", "", $_POST['qs']); $report_msg = '.m5'; } if ($mult_count <= 1) { // Now clear cache - just do the lot for now - get clever later