@@ -53,9+53,6 @@ if (getConfig('autopurge_inactive') == 'Y') {
// Init SQLs
INIT_SQLS();
// Init SQLs
INIT_SQLS();
- // Ok, let's have a look...
- $since = getConfig(('ap_inactive_since'));
-
// Init exclusion list
$EXCLUDE_LIST = '';
if (getConfig('def_refid') > 0) {
// Init exclusion list
$EXCLUDE_LIST = '';
if (getConfig('def_refid') > 0) {
@@ -70,7+67,7 @@ if (getConfig('autopurge_inactive') == 'Y') {
// Check for new holiday extension
if (GET_EXT_VERSION('holiday') >= '0.1.3') {
// Include only users with no active holiday
// Check for new holiday extension
if (GET_EXT_VERSION('holiday') >= '0.1.3') {
// Include only users with no active holiday
- $EXCLUDE_LIST .= " AND d.holiday_active='N'";
+ $EXCLUDE_LIST .= " AND d.`holiday_active`='N'";
} // END - if
// Check for all accounts
} // END - if
// Check for all accounts
@@ -78,7+75,12 @@ if (getConfig('autopurge_inactive') == 'Y') {
FROM `{!_MYSQL_PREFIX!}_user_data` AS d
WHERE d.`status`='CONFIRMED' AND d.joined < (UNIX_TIMESTAMP() - %s) AND d.last_online < (UNIX_TIMESTAMP() - %s) AND d.ap_notified < (UNIX_TIMESTAMP() - %s)
".$EXCLUDE_LIST."
FROM `{!_MYSQL_PREFIX!}_user_data` AS d
WHERE d.`status`='CONFIRMED' AND d.joined < (UNIX_TIMESTAMP() - %s) AND d.last_online < (UNIX_TIMESTAMP() - %s) AND d.ap_notified < (UNIX_TIMESTAMP() - %s)
".$EXCLUDE_LIST."
-ORDER BY d.userid", array($since, $since, $since), __FILE__, __LINE__);
+ORDER BY d.userid",
+ array(,
+ getConfig('ap_inactive_since'),
+ getConfig('ap_inactive_since'),
+ getConfig('ap_inactive_since')
+ ), __FILE__, __LINE__);
if (SQL_NUMROWS($result_inactive) > 0) {
// Prepare variables and constants...
if (SQL_NUMROWS($result_inactive) > 0) {
// Prepare variables and constants...
@@ -92,14+94,14 @@ ORDER BY d.userid", array($since, $since, $since), __FILE__, __LINE__);