// Both extensions must be there
if ((isExtensionActive('autopurge')) && (isExtensionActive('user'))) {
// Start finding them...
- $EXCLUDE_LIST = ' ';
+ $userExclusionSql = ' ';
+
+ // Exclude test accounts
+ $userExclusionSql = runFilterChain('user_exclusion_sql', ' ');
// Check for more extensions
// @TODO These can be rewritten to filter
- if (isValidUserId(getDefRefid())) $EXCLUDE_LIST .= ' AND d.`userid` != {?def_refid?}';
- if (isExtensionActive('beg')) $EXCLUDE_LIST .= ' AND d.`userid` != {?beg_userid?}';
- if (isExtensionActive('bonus')) $EXCLUDE_LIST .= ' AND d.`userid` != {?bonus_userid?}';
- if (isExtensionActive('doubler')) $EXCLUDE_LIST .= ' AND d.`userid` != {?doubler_userid?}';
+ if (isValidUserId(getDefRefid())) $userExclusionSql .= ' AND d.`userid` != {?def_refid?}';
+ if (isExtensionActive('beg')) $userExclusionSql .= ' AND d.`userid` != {?beg_userid?}';
+ if (isExtensionActive('bonus')) $userExclusionSql .= ' AND d.`userid` != {?bonus_userid?}';
+ if (isExtensionActive('doubler')) $userExclusionSql .= ' AND d.`userid` != {?doubler_userid?}';
if (isExtensionInstalledAndNewer('holiday', '0.1.3')) {
// Recent ext-holiday found
- $EXCLUDE_LIST .= " AND d.`holiday_active`='N'";
- } // END - if
- if (isExtensionInstalledAndNewer('user', '0.5.0')) {
- // Exclude test accounts
- $EXCLUDE_LIST = runFilterChain('user_exclusion_sql', $EXCLUDE_LIST);
+ $userExclusionSql .= " AND d.`holiday_active`='N'";
} // END - if
// Check for all accounts
d.`email`,
d.`last_online`
FROM
- `{?_MYSQL_PREFIX?}_user_data` AS d
+ `{?_MYSQL_PREFIX?}_user_data` AS `d`
WHERE
- d.`status`='CONFIRMED'
- " . runFilterChain('user_exclusion_sql', ' ') . " AND
+ d.`status`='CONFIRMED' AND
(UNIX_TIMESTAMP() - d.`joined`) >= {?ap_inactive_since?} AND
(UNIX_TIMESTAMP() - d.`last_online`) >= {?ap_inactive_since?} AND
(UNIX_TIMESTAMP() - d.`ap_notified`) >= {?ap_inactive_since?}
-".$EXCLUDE_LIST."
+" . $userExclusionSql . "
ORDER BY
d.`userid` ASC");
$WHATs[] = 'list_autopurge';