X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fprofile-updte.php;h=05ce24ce5bcc07494b7f11e1d27a681a1f09a250;hp=417ad61d3084f87314af7c00673aabc3f398ac1b;hb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;hpb=f9a9c09e1ae257449bfd98f8854e321efba1dc3c diff --git a/inc/profile-updte.php b/inc/profile-updte.php index 417ad61d30..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,8 +70,8 @@ ORDER BY userid", array(getConfig('profile_update'), getConfig('resend_profile_u 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__); + 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__); } }