X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Freset%2Freset_profile.php;h=5507e0aa42b391a4287186e17d43949035ff195c;hp=9c112856fa76cb5d5ef07ed1623f0d7e22764b6f;hb=e8ca54fe91872ab95a6ffdc4f1268bf18889021d;hpb=71c07e991fc7f5393317f4d9adf4ecdbc26b9aa3 diff --git a/inc/reset/reset_profile.php b/inc/reset/reset_profile.php index 9c112856fa..5507e0aa42 100644 --- a/inc/reset/reset_profile.php +++ b/inc/reset/reset_profile.php @@ -15,8 +15,6 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009, 2010 by Mailer Developer Team * @@ -49,19 +47,29 @@ if (!defined('__SECURITY')) { return; } -if ((getConfig('send_prof_update') == 'Y') && (getConfig('profile_update') > 0) && (getConfig('resend_profile_update'))) { +// Debug line +//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset started.'); + +if ((isSendProfileUpdateEnabled()) && (getProfileUpdate() > 0) && (getResendProfileUpdate() > 0)) { // Load personal data - $result = SQL_QUERY('SELECT `userid`, `email`, `last_update`, `joined` + $result = SQL_QUERY("SELECT + `userid`, `email`, `last_update`, `joined` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE - (`last_update` < (UNIX_TIMESTAMP() - {?profile_update?}) AND - `last_update` > 0 AND - `last_profile_sent` < (UNIX_TIMESTAMP() - {?resend_profile_update?})) -OR - (`last_update` = 0 AND `last_profile_sent` = 0 AND `joined` < (UNIX_TIMESTAMP() - {?profile_update?})) + `status`='CONFIRMED' AND ( + ( + `last_update` < (UNIX_TIMESTAMP() - {?profile_update?}) AND + `last_update` > 0 AND + `last_profile_sent` < (UNIX_TIMESTAMP() - {?resend_profile_update?}) + ) OR ( + `last_update` = 0 AND + `last_profile_sent` = 0 AND + `joined` < (UNIX_TIMESTAMP() - {?profile_update?}) + ) + ) ORDER BY - `userid` ASC', __FILE__, __LINE__); + `userid` ASC", __FILE__, __LINE__); // Do we have some notifications to sent? if (!SQL_HASZERONUMS($result)) { @@ -72,15 +80,15 @@ ORDER BY if (round($content['last_update']) == '0') { // Has never changed his accont - $content['last_update'] = '{--PROFILE_NEVER_CHANGED--}'; + $content['last_update'] = '{--MEMBER_PROFILE_NEVER_CHANGED--}'; } else { // Has changed his account $content['last_update'] = generateDateTime($content['last_update'], 0); } // Load email template and send mail away - $message = loadEmailTemplate('profile-updte', $content, bigintval($content['userid'])); - sendEmail($content['email'], '{--PROFILE_OUTDATED--}', $message); + $message = loadEmailTemplate('member_profile', $content, bigintval($content['userid'])); + sendEmail($content['email'], '{--MEMBER_PROFILE_OUTDATED_SUBJECT--}', $message); // Update profile data SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `last_profile_sent`=UNIX_TIMESTAMP(), `notified`='Y' WHERE `userid`=%s LIMIT 1", @@ -90,7 +98,10 @@ ORDER BY // Free result SQL_FREERESULT($result); -} +} // END - if + +// Debug line +//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset ended.'); // [EOF] ?>