$_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;
}
