Filters for configurable userid exclusion added:

[mailer.git] / inc / purge / purge-general.php

diff --git a/inc/purge/purge-general.php b/inc/purge/purge-general.php
index cb33c8799236f2e41ddc98e86fc63eb728a5a449..07205e280fe3bddd5f4838163135208cb45a0dca 100644 (file)
--- a/inc/purge/purge-general.php
+++ b/inc/purge/purge-general.php
@@ -53,17 +53,20 @@ if (getAutoPurge() > 0) {
 
        // Then check for outdated mail order. We don't delete them just the confirmation links will be deleted.
        $result = SQL_QUERY('SELECT
-       s.id, s.userid, s.pool_id, t.price
+       `s`.`id`,
+       `s`.`userid`,
+       `s`.`pool_id`,
+       `t`.`price`
 FROM
-       `{?_MYSQL_PREFIX?}_user_stats` AS s
+       `{?_MYSQL_PREFIX?}_user_stats` AS `s`
 LEFT JOIN
-       `{?_MYSQL_PREFIX?}_payments` AS t
+       `{?_MYSQL_PREFIX?}_payments` AS `t`
 ON
-       s.`payment_id`=t.`id`
+       `s`.`payment_id`=`t`.`id`
 WHERE
-       (UNIX_TIMESTAMP() - s.`timestamp_ordered`) >= {?auto_purge?}
+       (UNIX_TIMESTAMP() - `s`.`timestamp_ordered`) >= {?auto_purge?}
 ORDER BY
-       s.userid ASC', __FILE__, __LINE__);
+       `s`.`userid` ASC', __FILE__, __LINE__);
        if (!SQL_HASZERONUMS($result)) {
                // Start deleting procedure
                $userid = NULL;