if ((isSendProfileUpdateEnabled()) && (getProfileUpdate() > 0) && (getResendProfileUpdate() > 0)) {
// Load personal data
- $result = SQL_QUERY("SELECT
+ $result = sqlQuery("SELECT
`userid`,
`email`,
`last_update`,
`userid` ASC", __FILE__, __LINE__);
// Are there some notifications to sent?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// We need to send-out notifications...
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Translate timestamp
$content['joined'] = generateDateTime($content['joined'], '0');
sendEmail($content['userid'], '{--MEMBER_PROFILE_OUTDATED_SUBJECT--}', $message);
// Update profile data
- SQL_QUERY_ESC("UPDATE
+ sqlQueryEscaped("UPDATE
`{?_MYSQL_PREFIX?}_user_data`
SET
`last_profile_sent`=UNIX_TIMESTAMP(),
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Debug line