function eme_delete_location($location_id)
{
global $wpdb;
$table_name = $wpdb->prefix . LOCATIONS_TBNAME;
$sql = $wpdb->prepare("DELETE FROM {$table_name} where location_id=%d", $location_id);
$wpdb->query($sql);
$events_table = $wpdb->prefix . EVENTS_TBNAME;
$sql = $wpdb->prepare("UPDATE {$events_table} SET location_id=0 WHERE location_id = %d", $location_id);
$wpdb->query($sql);
$image_basename = IMAGE_UPLOAD_DIR . "/location-" . $location_id;
eme_delete_image_files($image_basename);
}
function eme_db_delete_recurrence($event, $recurrence)
{
global $wpdb;
$recurrence_table = $wpdb->prefix . RECURRENCE_TBNAME;
$recurrence_id = $recurrence['recurrence_id'];
$sql = $wpdb->prepare("DELETE FROM {$recurrence_table} WHERE recurrence_id = %d", $recurrence_id);
$wpdb->query($sql);
eme_remove_events_for_recurrence_id($recurrence_id);
$image_basename = IMAGE_UPLOAD_DIR . "/recurrence-" . $recurrence_id;
eme_delete_image_files($image_basename);
if (has_action('eme_delete_recurrence_action')) {
do_action('eme_delete_recurrence_action', $event, $recurrence);
}
}
function eme_db_delete_event($event, $event_is_part_of_recurrence = 0)
{
global $wpdb;
$table_name = $wpdb->prefix . EVENTS_TBNAME;
$wpdb->show_errors(false);
$sql = $wpdb->prepare("DELETE FROM {$table_name} WHERE event_id = %d", $event['event_id']);
// also delete associated image
$image_basename = IMAGE_UPLOAD_DIR . "/event-" . $event['event_id'];
eme_delete_image_files($image_basename);
if ($wpdb->query($sql)) {
eme_delete_all_bookings_for_event_id($event['event_id']);
// the eme_delete_event_action is only executed for single events, not those part of a recurrence
if (!$event_is_part_of_recurrence && has_action('eme_delete_event_action')) {
do_action('eme_delete_event_action', $event);
}
}
}
