X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fprofile-updte.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hp=17f56d3d866d49272e6024794423638af54455a4;hb=b5e396d81912f97a5752b4a4e61ae08f7c1efbd5;hpb=f01652b7b8efac92d97889e312402c4a845c2f14 diff --git a/inc/profile-updte.php b/inc/profile-updte.php index 17f56d3d86..f551ef47b7 100644 --- a/inc/profile-updte.php +++ b/inc/profile-updte.php @@ -1,84 +1,3 @@ 0) && ($_CONFIG['resend_profile_update'])) -{ - // Ok, we shall send update notifications... - $TIMEOUT = bigintval(time() - $_CONFIG['profile_update']); - $TIMEOUT2 = bigintval(time() - $_CONFIG['resend_profile_update']); - - // Load personal data 0 1 2 3 4 5 6 - $result = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, last_update, joined - FROM "._MYSQL_PREFIX."_user_data - WHERE (last_update < %s AND last_update != '0' AND last_profile_sent < %s) OR (last_update='0' AND last_profile_sent='0' AND joined < %s) - ORDER BY userid", array($TIMEOUT, $TIMEOUT2, $TIMEOUT), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { - // We need to send-out notifications... - while ($DATA = SQL_FETCHROW($result)) - { - $DATA[6] = MAKE_DATETIME($DATA[6], "0"); - if (round($DATA[5]) == "0") - { - // Has never changed his accont - $DATA[5] = PROFILE_NEVER_CHANGED; - } - else - { - // Has changed his account - $DATA[5] = MAKE_DATETIME($DATA[5], "0"); - } - - // Load email template and send mail away - $msg = LOAD_EMAIL_TEMPLATE("profile-updte", "", bigintval($DATA[0])); - SEND_EMAIL($DATA[1], PROFILE_OUTDATED, $msg); - - // Update profile data - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET last_profile_sent=UNIX_TIMESTAMP(), notified='Y' WHERE userid=%s LIMIT 1", - array(bigintval($DATA[0])), __FILE__, __LINE__); - } - } - - // Free result - SQL_FREERESULT($result); -} -// +// @DEPRECATED ?>