// 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
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__);
}
}