X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmonthly%2Fmonthly_newsletter.php;h=1dcbdc51bafe27f4649dc34bbe1a20b11c922280;hb=6c763653e88b9d10627e651ca59c7201d4b7d62b;hp=3e1ab6618ee18977e1c1563bea03c5117ddab1c8;hpb=143e78d4231adddd9e706cbf55ec5dd8c1651890;p=mailer.git diff --git a/inc/monthly/monthly_newsletter.php b/inc/monthly/monthly_newsletter.php index 3e1ab6618e..1dcbdc51ba 100644 --- a/inc/monthly/monthly_newsletter.php +++ b/inc/monthly/monthly_newsletter.php @@ -35,13 +35,13 @@ if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); -} elseif ((!EXT_IS_ACTIVE("newsletter")) && (!IS_ADMIN())) { - ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "newsletter"); +} elseif (!EXT_IS_ACTIVE("newsletter")) { return; } // Do not execute when script is in CSS mode or no daily reset if (($CSS == 1) || (!defined('__DAILY_RESET'))) return; +//* DEBUG: */ echo basename(__FILE__)."
\n"; // Get current month (2 digits) $curr = date("m", time()); @@ -49,14 +49,14 @@ $curr = date("m", time()); if ($_CONFIG['last_month'] != $curr) { // Check for unsubscribed members - $result = SQL_QUERY("SELECT userid, nl_until FROM "._MYSQL_PREFIX."_user_data WHERE nl_receive='N' ORDER BY userid", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT userid, nl_until FROM `"._MYSQL_PREFIX."_user_data` WHERE nl_receive='N' ORDER BY userid", __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Some unsubscriptions are found so we reset them to receive newsletters while(list($uid, $until) = SQL_FETCHROW($result)) { // Update account - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET nl_receive='Y', nl_until='0' WHERE userid=%s LIMIT 1", + $result = SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET nl_receive='Y', nl_until='0' WHERE userid=%s LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__); // Send email to him