X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=0.2.1%2Finc%2Fprofile-updte.php;fp=0.2.1%2Finc%2Fprofile-updte.php;h=0000000000000000000000000000000000000000;hp=216e46fe2e641bd465edb5d9a404a2dde6e72b87;hb=ab9c0550b44bdb6bbb930b4553f687702963801e;hpb=50646cc7b05cf5ff93e9b1e36ab03047cc0cd6bf diff --git a/0.2.1/inc/profile-updte.php b/0.2.1/inc/profile-updte.php deleted file mode 100644 index 216e46fe2e..0000000000 --- a/0.2.1/inc/profile-updte.php +++ /dev/null @@ -1,84 +0,0 @@ - 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, sex, 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=%d LIMIT 1", - array(bigintval($DATA[0])), __FILE__, __LINE__); - } - } - - // Free result - SQL_FREERESULT($result); -} -// -?>