More improved SQL queries

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

diff --git a/inc/modules/admin/what-list_newsletter.php b/inc/modules/admin/what-list_newsletter.php
index ae6054fcbcae3234e88406fc9d92bcadab8eb754..201c52a67e4eb0025c1ce306a94865825fc6d744 100644 (file)
--- a/inc/modules/admin/what-list_newsletter.php
+++ b/inc/modules/admin/what-list_newsletter.php
@@ -38,29 +38,27 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
 
-if ((!empty($_POST['uid'])) && (!empty($_POST['id'])))
-{
+if ((!empty($_POST['uid'])) && (!empty($_POST['id']))) {
        // Update database...
        // First user's account
-       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET nl_until='".time()."+nl_timespan', nl_receive='N', nl_timespan='0' WHERE userid=%s LIMIT 1",
-        array(bigintval($_POST['uid'])), __FILE__, __LINE__);
+       SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET nl_until=(UNIX_TIMESTAMP() + nl_timespan), nl_receive='N', nl_timespan=0 WHERE userid=%s LIMIT 1",
+               array(bigintval($_POST['uid'])), __FILE__, __LINE__);
 
        // Next the task system...
-       ADMIN_SOLVE_TASK($_POST['id']);
+       RUN_FILTER('solve_task', bigintval($_POST['id']));
 
        // Send mail to user
        $msg = LOAD_EMAIL_TEMPLATE("member_newsletter_done", true, bigintval($_POST['uid']));
        SEND_EMAIL(bigintval($_POST['uid']), NL_MEMBER_DONE_SUBJECT, $msg);
 
        // Output message to admin
-       LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NL_MEMBER_DONE);
-}
- else
-{
-       // Currently under construction!
-       LOAD_TEMPLATE("admin_settings_saved", false, UNDER_CONSTRUCTION);
+       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_NL_MEMBER_DONE'));
+} else {
+       // @TODO Currently under construction!
+       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('UNDER_CONSTRUCTION'));
 }
+
 //
 ?>