}
if ((getConfig('send_prof_update') == 'Y') && (getConfig('profile_update') > 0) && (getConfig('resend_profile_update'))) {
- // Load personal data 0 1 2 3
- $result = SQL_QUERY_ESC("SELECT userid, email, last_update, joined
+ // Load personal data
+ $result = SQL_QUERY_ESC("SELECT `userid`, `email`, `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))
+ (`last_update` < (UNIX_TIMESTAMP() - %s) AND `last_update` != 0 AND `last_profile_sent` < (UNIX_TIMESTAMP() - %s))
OR
- (last_update=0 AND last_profile_sent=0 AND joined < (UNIX_TIMESTAMP() - %s))
-ORDER BY `userid` ASC", array(getConfig('profile_update'), getConfig('resend_profile_update'), getConfig('profile_update')), __FILE__, __LINE__);
+ (`last_update` = 0 AND `last_profile_sent` = 0 AND `joined` < (UNIX_TIMESTAMP() - %s))
+ORDER BY
+ `userid` ASC",
+ array(
+ getConfig('profile_update'),
+ getConfig('resend_profile_update'),
+ getConfig('profile_update')
+ ), __FILE__, __LINE__);
// Do we have some notifications to sent?
if (SQL_NUMROWS($result) > 0) {
}
// Load email template and send mail away
- $msg = LOAD_EMAIL_TEMPLATE("profile-updte", '', bigintval($content['userid']));
- sendEmail($content['email'], getMessage('PROFILE_OUTDATED'), $msg);
+ $message = LOAD_EMAIL_TEMPLATE('profile-updte', '', bigintval($content['userid']));
+ sendEmail($content['email'], getMessage('PROFILE_OUTDATED'), $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__);
+ 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