Huge rewrite:
[mailer.git] / inc / autopurge / purge-mails.php
index 9cdfc62706162c13968225acfe1039cb94b8bc24..a6ab6e20e7b502939f51bddf4e0349c01943e2bd 100644 (file)
@@ -53,7 +53,7 @@ if (getConfig('ap_del_mails') == 'Y') {
        // Okay, let's check for them...
        $result_mails = SQL_QUERY_ESC("SELECT `sender`
 FROM `{!_MYSQL_PREFIX!}_pool`
-WHERE data_type='DELETED' AND `timestamp` <= (UNIX_TIMESTAMP() - %s)
+WHERE `data_type`='DELETED' AND `timestamp` <= (UNIX_TIMESTAMP() - %s)
 ORDER BY `sender` ASC",
                array(getConfig('ap_dm_timeout')), __FILE__, __LINE__);
 
@@ -76,7 +76,7 @@ ORDER BY `sender` ASC",
                                // Reset query (to prevent possible errors) ...;
                                $result_mails = SQL_QUERY_ESC("SELECT `sender`
 FROM `{!_MYSQL_PREFIX!}_pool`
-WHERE data_type='DELETED' AND timestamp <= (UNIX_TIMESTAMP() - %s)
+WHERE `data_type`='DELETED' AND timestamp <= (UNIX_TIMESTAMP() - %s)
 ORDER BY `sender` ASC",
                                        array(getConfig('ap_dm_timeout')), __FILE__, __LINE__);
                        }
@@ -109,7 +109,7 @@ ORDER BY `sender` ASC",
                                // Reset query (to prevent possible errors) ...
                                $result_mails = SQL_QUERY_ESC("SELECT `sender`
 FROM `{!_MYSQL_PREFIX!}_user_stats`
-WHERE data_type='DELETED' AND timestamp_send <= (UNIX_TIMESTAMP() - %s)
+WHERE `data_type`='DELETED' AND timestamp_send <= (UNIX_TIMESTAMP() - %s)
 ORDER BY `sender` ASC",
                                        array(getConfig('ap_dm_timeout')), __FILE__, __LINE__);
                        }