* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
// Some security stuff...
if (!defined('__SECURITY')) {
die();
-} elseif ((!isHtmlOutputMode()) || (!isResetModeEnabled())) {
- // Do not execute when script is in CSS mode or no daily reset
+} elseif ((!isHtmlOutputMode()) || (!isDailyResetEnabled())) {
+ // Do not execute when script is in non-HTML mode or no daily reset
return;
} elseif (!isExtensionActive('profile')) {
- logDebugMessage(__FILE__, __LINE__, 'Not resetting, needed extension disabled.');
+ logDebugMessage(__FILE__, __LINE__, 'Not resetting, needed extension ext-profile disabled.');
return;
}
if ((isSendProfileUpdateEnabled()) && (getProfileUpdate() > 0) && (getResendProfileUpdate() > 0)) {
// Load personal data
- $result = SQL_QUERY("SELECT
+ $result = sqlQuery("SELECT
`userid`,
`email`,
`last_update`,
FROM
`{?_MYSQL_PREFIX?}_user_data`
WHERE
- `status`='CONFIRMED' AND (
+ `status`='CONFIRMED'
+ " . runFilterChain('user_exclusion_sql', ' ') . " AND (
(
(UNIX_TIMESTAMP() - `last_update`) >= {?profile_update?} AND
`last_update` > 0 AND
ORDER BY
`userid` ASC", __FILE__, __LINE__);
- // Do we have some notifications to sent?
- if (!SQL_HASZERONUMS($result)) {
+ // Are there some notifications to sent?
+ 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