$_REQUEST['action'] = 'modify'; } else { if ($event_user['is_admin'] == '1' && count($_POST['bookingOptions']) < $_SESSION['MINIMUM_ADMIN_BOOKING_OPIONS'] || $event_user['is_admin'] == '0' && count($_POST['bookingOptions']) < $_SESSION['MINIMUM_USER_BOOKING_OPIONS']) { //not enough options have been selected if ($event_user['is_admin'] == '1') { $page_error_message = "Please select a minimum of " . $_SESSION['MINIMUM_ADMIN_BOOKING_OPIONS'] . " booking options."; } else { $page_error_message = "Please select a minimum of " . $_SESSION['MINIMUM_USER_BOOKING_OPIONS'] . " booking options."; } $event['description'] = stripslashes($_POST['desc']); $event['subject'] = stripslashes($_POST['subject']); $_REQUEST['action'] = 'modify'; } else { if (modify_event($event_username, $event['event_id'], $_POST['subject'], $_POST['desc'], $_POST['bookingOptions'])) { $page_info_message = "Event details modified successfully!"; $event = get_event_details($_REQUEST['event_id']); } else { $page_error_message = "Event details could not be modified. Please try again."; $event['description'] = $_POST['desc']; $event['subject'] = $_POST['subject']; $_REQUEST['action'] = 'modify'; } } } } else { if ($_REQUEST['action'] == 'submit_delete') { if (delete_event_slot($event_username, $event['event_id'], $_REQUEST['date_time'])) { $page_info_message = "Time slot deleted successfully!"; $showEventDetails = false; } else { $page_error_message = "Event time slot could not be deleted. Please try again.";
function delete_event_slot($username, $event_id, $schedule_date_time) { // delete one event date/time slot based on "schedule_date_time" // Use global $location_db_name global $location_db_name; // get user_id based on current $username $user_id = get_user_id($username); if (empty($user_id)) { return false; } // get event data: location id $event = get_event_details($event_id); //echo "location: $event['location'], event_id: $event['event_id'] <br />"; // get user_id based on current $username $user_id = get_user_id($username); // delete any options set for this event_id $query = 'DELETE FROM ' . BOOKING_EVENT_OPTIONS_TABLE . ' WHERE event_id="' . $event_id . '"'; wrap_db_query($query); // delete the event date/time slot, set back to zero $result = wrap_db_query("UPDATE " . DATE_TIME_SCHEDULE_TABLE . "\n\t\tSET " . $location_db_name[$event['location']] . " = 0\n\t\tWHERE " . $location_db_name[$event['location']] . " = " . $event_id . "\n\t\tAND schedule_date_time = '" . $schedule_date_time . "' LIMIT 1"); return $result; }
function delete_event_slot($username, $event_id, $schedule_date_time) { // delete one event date/time slot based on "schedule_date_time" // Use global $location_db_name global $location_db_name; // get user_id based on current $username $user_id = get_user_id($username); if (empty($user_id)) { return false; } // get event data: location id $event = get_event_details($event_id); //echo "location: $event['location'], event_id: $event['event_id'] <br />"; // get user_id based on current $username $user_id = get_user_id($username); // delete the event date/time slot, set back to zero $result = wrap_db_query("UPDATE " . DATE_TIME_SCHEDULE_TABLE . " \r\n\t\tSET " . $location_db_name[$event['location']] . " = 0 \r\n\t\tWHERE " . $location_db_name[$event['location']] . " = '" . wrap_db_escape_string($event_id) . "' \r\n\t\tAND schedule_date_time = '" . wrap_db_escape_string($schedule_date_time) . "' LIMIT 1"); return $result; }