X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fdaily%2Fdaily_profile.php;h=7801f8e62d0a48288444a4ee5be9706effd273fe;hb=63f159414369b5ea19a8ca75d8cd8033c45d8341;hp=3e8e9a6d6412b4a12a008fea1dedf02f5d95ee7c;hpb=2e394cb5b8a6225a39a6942b1fcc17c37a17a175;p=mailer.git diff --git a/inc/daily/daily_profile.php b/inc/daily/daily_profile.php index 3e8e9a6d64..7801f8e62d 100644 --- a/inc/daily/daily_profile.php +++ b/inc/daily/daily_profile.php @@ -17,8 +17,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -53,11 +53,15 @@ if (!defined('__SECURITY')) { if ((isSendProfileUpdateEnabled()) && (getProfileUpdate() > 0) && (getResendProfileUpdate() > 0)) { // Load personal data $result = SQL_QUERY("SELECT - `userid`, `email`, `last_update`, `joined` + `userid`, + `email`, + `last_update`, + `joined` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE - `status`='CONFIRMED' AND ( + `status`='CONFIRMED' + " . runFilterChain('user_exclusion_sql', ' ') . " AND ( ( (UNIX_TIMESTAMP() - `last_update`) >= {?profile_update?} AND `last_update` > 0 AND @@ -76,19 +80,19 @@ ORDER BY // We need to send-out notifications... while ($content = SQL_FETCHARRAY($result)) { // Translate timestamp - $content['joined'] = generateDateTime($content['joined'], 0); + $content['joined'] = generateDateTime($content['joined'], '0'); if (round($content['last_update']) == '0') { // Has never changed his accont $content['last_update'] = '{--MEMBER_PROFILE_NEVER_CHANGED--}'; } else { // Has changed his account - $content['last_update'] = generateDateTime($content['last_update'], 0); + $content['last_update'] = generateDateTime($content['last_update'], '0'); } // Load email template and send mail away $message = loadEmailTemplate('member_profile', $content, bigintval($content['userid'])); - sendEmail($content['email'], '{--MEMBER_PROFILE_OUTDATED_SUBJECT--}', $message); + sendEmail($content['userid'], '{--MEMBER_PROFILE_OUTDATED_SUBJECT--}', $message); // Update profile data SQL_QUERY_ESC("UPDATE