X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fmember%2Fwhat-newsletter.php;h=9ec4bd6cc6d824a0be4923949755ea2908700ee1;hb=452578b5bf17d14099ee44956deb4e4dc0832874;hp=a427d96a2fb8c7d15d3ff3207913223eb50fc0c2;hpb=357b2ca133fc1f89db74097955c366cb4bee6996;p=mailer.git diff --git a/inc/modules/member/what-newsletter.php b/inc/modules/member/what-newsletter.php index a427d96a2f..9ec4bd6cc6 100644 --- a/inc/modules/member/what-newsletter.php +++ b/inc/modules/member/what-newsletter.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : * * -------------------------------------------------------------------- * - * * + * $Revision:: 856 $ * + * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: stelzi $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -37,8 +42,8 @@ if (!defined('__SECURITY')) { require($INC); } elseif (!IS_MEMBER()) { LOAD_URL("modules.php?module=index"); -} elseif (!EXT_IS_ACTIVE("newsletter")) { - ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "newsletter"); +} elseif ((!EXT_IS_ACTIVE("newsletter")) && (!IS_ADMIN())) { + addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "newsletter"); return; } @@ -46,66 +51,62 @@ if (!defined('__SECURITY')) { ADD_DESCR("member", __FILE__); // Load status -$result = SQL_QUERY_ESC("SELECT nl_receive, nl_until, nl_timespan FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", - array($GLOBALS['userid']), __FILE__, __LINE__); +$result = SQL_QUERY_ESC("SELECT nl_receive, nl_until, nl_timespan FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", + array(getUserId()), __FILE__, __LINE__); list($status, $until, $span) = SQL_FETCHROW($result); SQL_FREERESULT($result); // Remember charge value -define('__CHARGE_VALUE', TRANSLATE_COMMA($_CONFIG['nl_charge'])); +define('__CHARGE_VALUE', TRANSLATE_COMMA(getConfig('nl_charge'))); -if ((isset($_POST['ok'])) && ($status == "Y") && ($span == "0")) -{ +if ((IS_FORM_SENT()) && ($status == "Y") && ($span == "0")) { // Save request - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET nl_timespan='".($_CONFIG['one_day'] * 30)."' WHERE userid=%s LIMIT 1", - array($GLOBALS['userid']), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET nl_timespan='".(getConfig('one_day') * 30)."' WHERE userid=%s LIMIT 1", + array(getUserId()), __FILE__, __LINE__); // Load admin message - $admin_msg = LOAD_EMAIL_TEMPLATE("admin_newsletter_request", array(), $GLOBALS['userid']); + $admin_msg = LOAD_EMAIL_TEMPLATE("admin_newsletter_request", array(), getUserId()); // Add task - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, status, task_type, subject, text, task_created, userid) -VALUES ('0','NEW','NL_UNSUBSCRIBE','".ADMIN_NL_SUBJECT."','".addslashes($admin_msg)."', UNIX_TIMESTAMP(),'%s')", array($GLOBALS['userid']), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_task_system` (assigned_admin, status, task_type, subject, text, task_created, userid) +VALUES ('0','NEW','NL_UNSUBSCRIBE','{--ADMIN_NL_SUBJECT--}','".$admin_msg."', UNIX_TIMESTAMP(),'%s')", array(getUserId()), __FILE__, __LINE__); // Send mail to member - $msg = LOAD_EMAIL_TEMPLATE("member_newsletter_request", array(), $GLOBALS['userid']); - SEND_EMAIL($GLOBALS['userid'], NL_MEMBER_SUBJECT, $msg); + $msg = LOAD_EMAIL_TEMPLATE("member_newsletter_request", array(), getUserId()); + SEND_EMAIL(getUserId(), getMessage('NL_MEMBER_SUBJECT'), $msg); // Send mail to all admins - SEND_ADMIN_NOTIFICATION(NL_ADMIN_SUBJECT, "admin_newsletter_request", array(), $GLOBALS['userid']); + SEND_ADMIN_NOTIFICATION(getMessage('NL_ADMIN_SUBJECT'), "admin_newsletter_request", array(), getUserId()); // Display message - LOAD_TEMPLATE("admin_settings_saved", false, NL_MEMBER_REQUEST_DONE); -} - elseif ($span > 0) -{ + LOAD_TEMPLATE("admin_settings_saved", false, getMessage('NL_MEMBER_REQUEST_DONE')); +} elseif ($span > 0) { // Already ordered - LOAD_TEMPLATE("admin_settings_saved", false, NL_MEMBER_REQUEST_ALREADY); -} - else -{ + LOAD_TEMPLATE("admin_settings_saved", false, getMessage('NL_MEMBER_REQUEST_ALREADY')); +} else { // Load template for the note define('NL_MEMBER_NOTE', LOAD_TEMPLATE("member_newsletter_note", true)); // Set status message and submit button switch ($status) { - case 'Y': // Receives the newsletter - define('__STATUS_VALUE', NL_MEMBER_ON); - define('__UNTIL_VALUE', ""); - define('NL_SUBMIT', NL_MEMBER_SUBMIT_OFF); + case "Y": // Receives the newsletter + define('__STATUS_VALUE', getMessage('NL_MEMBER_ON')); + define('__UNTIL_VALUE' , ""); + define('NL_SUBMIT' , getMessage('NL_MEMBER_SUBMIT_OFF')); break; - case 'N': // Does not receive the newsletter - define('__STATUS_VALUE', NL_MEMBER_OFF); - define('__UNTIL_VALUE', MAKE_DATETIME($until, "2")); - define('NL_SUBMIT', NL_MEMBER_SUBMIT_ON); + case "N": // Does not receive the newsletter + define('__STATUS_VALUE', getMessage('NL_MEMBER_OFF')); + define('__UNTIL_VALUE' , MAKE_DATETIME($until, "2")); + define('NL_SUBMIT' , getMessage('NL_MEMBER_SUBMIT_ON')); break; } // Load template and member settings LOAD_TEMPLATE("member_newsletter"); } + // ?>