X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmonthly%2Fmonthly_newsletter.php;h=0ada8ed09feced1157a76f38ef9c76cda4bd8bc2;hb=4ac856c74ab07fc19ab64039904f2075c8f35b40;hp=4083cae8a010a97a6196c019930ff57c3acb0957;hpb=2408c1599f73859fe4a2938e87bc080b9dcb9cca;p=mailer.git diff --git a/0.2.1/inc/monthly/monthly_newsletter.php b/0.2.1/inc/monthly/monthly_newsletter.php index 4083cae8a0..0ada8ed09f 100644 --- a/0.2.1/inc/monthly/monthly_newsletter.php +++ b/0.2.1/inc/monthly/monthly_newsletter.php @@ -1,93 +1,93 @@ - 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=%d LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); - - // Send email to him - $msg = LOAD_EMAIL_TEMPLATE("member_newsletter_reset", true, bigintval($uid)); - SEND_EMAIL($uid, NL_MEMBER_RESET_SUBJECT, $msg); - - // Send email to admin - if (GET_EXT_VERSION("admins") >= "0.4.1") - { - SEND_ADMIN_EMAILS_PRO(NL_ADMIN_SUBJECT, "admin_newsletter_reset", "", $GLOBALS['userid']); - } - else - { - $msg = LOAD_EMAIL_TEMPLATE("admin_newsletter_reset", true, bigintval($uid)); - SEND_ADMIN_EMAILS(NL_ADMIN_SUBJECT, $msg); - } - } - - // Free memory - SQL_FREERESULT($result); - - // Update last month - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET nl_month='%s' WHERE config='0' LIMIT 1", - array($curr), __FILE__, __LINE__); - - // Destroy cache - } -} - -// -?> + 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=%d LIMIT 1", + array(bigintval($uid)), __FILE__, __LINE__); + + // Send email to him + $msg = LOAD_EMAIL_TEMPLATE("member_newsletter_reset", true, bigintval($uid)); + SEND_EMAIL($uid, NL_MEMBER_RESET_SUBJECT, $msg); + + // Send email to admin + if (GET_EXT_VERSION("admins") >= "0.4.1") + { + SEND_ADMIN_EMAILS_PRO(NL_ADMIN_SUBJECT, "admin_newsletter_reset", "", $GLOBALS['userid']); + } + else + { + $msg = LOAD_EMAIL_TEMPLATE("admin_newsletter_reset", true, bigintval($uid)); + SEND_ADMIN_EMAILS(NL_ADMIN_SUBJECT, $msg); + } + } + + // Free memory + SQL_FREERESULT($result); + + // Update last month + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET nl_month='%s' WHERE config='0' LIMIT 1", + array($curr), __FILE__, __LINE__); + + // Destroy cache + } +} + +// +?>