Functions imported, some dev-scripts added

[mailer.git] / inc / modules / admin / what-send_newsletter.php

diff --git a/inc/modules/admin/what-send_newsletter.php b/inc/modules/admin/what-send_newsletter.php
index 3ad19859d797c08be5b8ea751d4014c219ce19f4..f18caeab52bc8b1655e30476b0564937543ee700 100644 (file)
--- a/inc/modules/admin/what-send_newsletter.php
+++ b/inc/modules/admin/what-send_newsletter.php
@@ -42,8 +42,8 @@ ADD_DESCR("admin", __FILE__);
 
 if (isset($_POST['ok'])) {
        $result = SQL_QUERY("SELECT userid, email
-FROM `{!MYSQL_PREFIX!}_user_data`
-WHERE status='CONFIRMED' AND nl_receive='Y'
+FROM `{!_MYSQL_PREFIX!}_user_data`
+WHERE `status`='CONFIRMED' AND nl_receive='Y'
 ORDER BY userid ASC", __FILE__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
                // Members are available so we can send out the newsletter!
@@ -74,7 +74,7 @@ ORDER BY userid ASC", __FILE__, __LINE__);
                SQL_FREERESULT($result);
 
                // Output message
-               LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NL_SEND_DONE);
+               LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_NL_SEND_DONE'));
        }
 } else {
        // Copy data into constants for the template and load it