WHERE
(`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))
+ (`last_update` = '0' AND `last_profile_sent` = '0' AND `joined` < (UNIX_TIMESTAMP() - %s))
ORDER BY
`userid` ASC",
array(
// We need to send-out notifications...
while ($content = SQL_FETCHARRAY($result)) {
// Translate timestamp
- $content['joined'] = generateDateTime($content['joined'], '0');
+ $content['joined'] = generateDateTime($content['joined'], 0);
if (round($content['last_update']) == '0') {
// Has never changed his accont
$content['last_update'] = getMessage('PROFILE_NEVER_CHANGED');
} else {
// Has changed his account
- $content['last_update'] = generateDateTime($content['last_update'], '0');
+ $content['last_update'] = generateDateTime($content['last_update'], 0);
}
// Load email template and send mail away
- $message = loadEmailTemplate('profile-updte', '', bigintval($content['userid']));
+ $message = loadEmailTemplate('profile-updte', $content, bigintval($content['userid']));
sendEmail($content['email'], getMessage('PROFILE_OUTDATED'), $message);
// Update profile data