Ejemplo n.º 1
0
 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);
 }