X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fprofile-updte.php;h=05ce24ce5bcc07494b7f11e1d27a681a1f09a250;hp=b28953ef852278b3cb40863033ca7bc6d65579b4;hb=595124165eb35633520ee0c8e7d5196ba515c00f;hpb=cca98f57dff720b174d21d071cee8303462485d7 diff --git a/inc/profile-updte.php b/inc/profile-updte.php index b28953ef85..05ce24ce5b 100644 --- a/inc/profile-updte.php +++ b/inc/profile-updte.php @@ -42,7 +42,7 @@ if ((getConfig('send_prof_update') == "Y") && (getConfig('profile_update') > 0) // 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 + {!MYSQL_PREFIX!}_user_data WHERE (last_update < (UNIX_TIMESTAMP() - %s) AND last_update != 0 AND last_profile_sent < (UNIX_TIMESTAMP() - %s)) OR @@ -70,7 +70,7 @@ ORDER BY userid", array(getConfig('profile_update'), getConfig('resend_profile_u SEND_EMAIL($DATA[1], PROFILE_OUTDATED, $msg); // Update profile data - SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data` SET last_profile_sent=UNIX_TIMESTAMP(), notified='Y' WHERE userid=%s LIMIT 1", + 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__); } }