// Now let's have a look for inactive accounts we want to delete we newly use the same exclude list
// here for e.g. excluding holiday users
- $result_inactive = SQL_QUERY_ESC("SELECT
+ $result_inactive = SQL_QUERY("SELECT
d.userid, d.email, d.last_online
FROM
`{?_MYSQL_PREFIX?}_user_data` AS d
WHERE
`status`='CONFIRMED' AND
- `joined` < (UNIX_TIMESTAMP() - %s) AND
- `last_online` < (UNIX_TIMESTAMP() - %s) AND
- `ap_notified` < (UNIX_TIMESTAMP() - %s)
+ `joined` < (UNIX_TIMESTAMP() - {?ap_inactive_since?}) AND
+ `last_online` < (UNIX_TIMESTAMP() - {?ap_inactive_since?}) AND
+ `ap_notified` < (UNIX_TIMESTAMP() - {?ap_inactive_time?})
".$EXCLUDE_LIST."
ORDER BY
- `userid` ASC",
- array(
- getConfig('ap_inactive_since'),
- getConfig('ap_inactive_since'),
- getConfig('ap_inactive_time')
- ), __FILE__, __LINE__);
+ `userid` ASC", __FILE__, __LINE__);
if (SQL_NUMROWS($result_inactive) > 0) {
// Prepare variable...