X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Freset%2Freset_profile.php;h=825023575e0247f0ce57a3e4a34d8818fdcc8500;hp=dd31930b0ed36cc77cc638f0f188428153aca833;hb=6914ebaaae909093df86d010e4c754a43d1a1aed;hpb=19188207e6802b82a134b340408cfa34b9b3a80f diff --git a/inc/reset/reset_profile.php b/inc/reset/reset_profile.php index dd31930b0e..825023575e 100644 --- a/inc/reset/reset_profile.php +++ b/inc/reset/reset_profile.php @@ -51,17 +51,24 @@ if (!defined('__SECURITY')) { 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 +79,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",