require($INC);
} elseif (!IS_MEMBER()) {
LOAD_URL("modules.php?module=index");
-} elseif (!EXT_IS_ACTIVE("newsletter")) {
+} elseif ((!EXT_IS_ACTIVE("newsletter")) && (!IS_ADMIN())) {
ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "newsletter");
return;
}
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",
+$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__);
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"))
{
// Save request
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET nl_timespan='".($_CONFIG['one_day'] * 30)."' WHERE userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET nl_timespan='".(getConfig('one_day') * 30)."' WHERE userid=%s LIMIT 1",
array($GLOBALS['userid']), __FILE__, __LINE__);
// Load admin message
// Set status message and submit button
switch ($status)
{
- case 'Y': // Receives the newsletter
+ case "Y": // Receives the newsletter
define('__STATUS_VALUE', NL_MEMBER_ON);
define('__UNTIL_VALUE', "");
define('NL_SUBMIT', NL_MEMBER_SUBMIT_OFF);
break;
- case 'N': // Does not receive the newsletter
+ 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);