public function delete_newsletter($newsletter_id) { $newsletter_id = (int) $newsletter_id; $sql = "DELETE FROM " . _DB_PREFIX . "newsletter WHERE newsletter_id = '" . $newsletter_id . "' LIMIT 1"; query($sql); $sql = "DELETE FROM `" . _DB_PREFIX . "newsletter_send` WHERE newsletter_id = '" . $newsletter_id . "' LIMIT 1"; query($sql); // todo - empty the newsletter_send_member newsletter_link and newsletter_image and newsletter_link_open tables based on the newsletter_send ids. $sql = "DELETE FROM `" . _DB_PREFIX . "newsletter_campaign_newsletter` WHERE newsletter_id = '" . $newsletter_id . "' LIMIT 1"; query($sql); module_file::delete_files('newsletter', $newsletter_id); module_file::delete_files('newsletter_files', $newsletter_id); }