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