Extension ext-coupon continued, a lot improvements applied:
[mailer.git] / inc / autopurge / purge-unconfirmed.php
index e5525387b103ba084d69fb68d36a119bf0bd00ce..c4eed02a77ac7fc0c926ad38d295ff08bde9d71d 100644 (file)
@@ -54,7 +54,8 @@ if (getConfig('autopurge_unconfirmed') == 'Y') {
 FROM
        `{?_MYSQL_PREFIX?}_user_data`
 WHERE
-       `status`='UNCONFIRMED' AND `joined` < (UNIX_TIMESTAMP() - {?ap_unconfirmed_time?})
+       `status`='UNCONFIRMED' AND
+       (UNIX_TIMESTAMP() - `joined`) >= {?ap_unconfirmed_time?}
 ORDER BY
        `userid` ASC", __FILE__, __LINE__);
        if (!SQL_HASZERONUMS($result_uncon)) {