function _wpr_newsletter_delete() { global $wpdb; $prefix = $wpdb->prefix; $nid = $_GET['nid']; try { $newsletter = new Newsletter($nid); } catch (Exception $excp) { _wpr_set("_wpr_view", "newsletter_delete_not_found"); return; } if (isset($_GET['confirmed']) && $_GET['confirmed'] == 'true') { $newsletter->delete(); $newsletter_home = Routing::newsletterHome(); wp_redirect($newsletter_home); } $getEmailsPendingDeliveryQuery = sprintf("SELECT COUNT(*) number FROM %swpr_queue WHERE sid=(SELECT id FROM %swpr_subscribers WHERE nid=%d) AND sent=0;", $prefix, $prefix, $nid); $emails_pending_count_result = $wpdb->get_results($getEmailsPendingDeliveryQuery); $number_pending = $emails_pending_count_result[0]->number; _wpr_set("newsletter_name", $newsletter->getNewsletterName()); _wpr_set("subscriber_count", $newsletter->getNumberOfActiveSubscribers()); _wpr_set("_wpr_view", "newsletter_delete"); _wpr_set("nid", $nid); _wpr_set("emailsPendingDelivery", $number_pending); }