X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_profile.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=8fad776382e63b3f73f8dbe289f229d79cfc2c22;hp=1dfe8c6aed02cf30a1734dc231425ae7d802bde6;hpb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8;p=mailer.git diff --git a/inc/reset/reset_profile.php b/inc/reset/reset_profile.php index 1dfe8c6aed..f551ef47b7 100644 --- a/inc/reset/reset_profile.php +++ b/inc/reset/reset_profile.php @@ -1,101 +1,3 @@ 0) && (getResendProfileUpdate() > 0)) { - // Load personal data - $result = SQL_QUERY("SELECT - `userid`, `email`, `last_update`, `joined` -FROM - `{?_MYSQL_PREFIX?}_user_data` -WHERE - `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__); - - // Do we have some notifications to sent? - if (!SQL_HASZERONUMS($result)) { - // We need to send-out notifications... - while ($content = SQL_FETCHARRAY($result)) { - // Translate timestamp - $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); - } - - // Load email template and send mail away - $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", - array(bigintval($content['userid'])), __FILE__, __LINE__); - } // END - while - } // END - if - - // Free result - SQL_FREERESULT($result); -} // END - if - -// [EOF] +// @DEPRECATED ?>