public function delete($nonce = 0)
{
global $wpdb;
$event_id = $this->id;
if (parent::validate($nonce, self::NONCE_DELETE)) {
$this->retrieve();
if ($this->data) {
$event_id = $this->id;
$meta_id = $this->data["event_meta_id"];
$wpdb->query("DELETE FROM " . WORDTOUR_EVENTS . " WHERE event_id = {$event_id} AND event_meta_id = {$meta_id}");
if ($wpdb->result) {
$wpdb->query("DELETE FROM " . WORDTOUR_EVENTS_META . " WHERE meta_id = {$meta_id}");
if ($wpdb->result) {
$wpdb->query("DELETE FROM " . WORDTOUR_COMMENTS . " WHERE comment_event_id = {$event_id}");
$wpdb->query("DELETE FROM " . WORDTOUR_ATTENDING . " WHERE rsvp_event_id = {$event_id}");
$wpdb->query("DELETE FROM " . WORDTOUR_SOCIAL . " WHERE social_parent_id = {$event_id} AND social_parent_type = 'event'");
$attachments = new WT_Attachment();
parent::delete_attachments($event_id, "event");
$this->db_result("success", $wpdb, array("msg" => "Event permanently deleted."));
return true;
}
}
$this->db_result("error", $wpdb, array("msg" => "Can't delete event, Error as occured, please try again(<i>" . $wpdb->last_error . "</i>)"));
}
$this->db_result("error", $wpdb, array("msg" => "Can't delete event, Event doesn't exist"));
}
return false;
}
public function delete($nonce = "", $id = 0, $validate = 1)
{
global $wpdb;
# When using delete_all no need to check every time nonce. nd add id
$is_valid = 1;
if ($validate) {
$is_valid = $this->validate($nonce, self::NONCE_DELETE);
}
if ($is_valid) {
$track_id = $id ? $id : $this->id;
// Check if artist assigned to event
$wpdb->query($wpdb->prepare("DELETE FROM " . WORDTOUR_TRACKS . " WHERE track_id={$track_id}"));
$delete_wpdb = clone $wpdb;
if ($wpdb->result) {
parent::delete_attachments($track_id, "track");
$this->db_result("success", $delete_wpdb);
} else {
$this->db_result("error", $delete_wpdb, array("msg" => "Error delete track, please try again<br>" . $wpdb->last_error));
}
return $wpdb->result;
}
return false;
}
