X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fautopurge%2Fpurge-mails.php;h=79fbe434ebf88462189903c3c15915bc5f028923;hb=e81bae12c3ed998e5dce877f5baff1bd3c7bf597;hp=9126d81632e0c35aa403d159849d64c2a211cc99;hpb=09f5758c42a33a56bdd461c946ffe759a59c54aa;p=mailer.git diff --git a/inc/autopurge/purge-mails.php b/inc/autopurge/purge-mails.php index 9126d81632..79fbe434eb 100644 --- a/inc/autopurge/purge-mails.php +++ b/inc/autopurge/purge-mails.php @@ -98,7 +98,7 @@ FROM WHERE `timestamp_send` <= (UNIX_TIMESTAMP() - {?ap_dm_timeout?}) ORDER BY - `sender` ASC", __FILE__, __LINE__); + `userid` ASC", __FILE__, __LINE__); // Do we have "purged" mails? if (SQL_NUMROWS($result_mails) > 0) { @@ -107,21 +107,21 @@ if (SQL_NUMROWS($result_mails) > 0) { // Check now... if (!fetchUserData($content['sender'])) { // Okay we found some mails! - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `sender`=%s", - array(bigintval($content['sender'])), __FILE__, __LINE__); + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `userid`=%s", + array(bigintval($content['userid'])), __FILE__, __LINE__); // Get all affected (deleted) rows $deletedStats += SQL_AFFECTEDROWS(); // Reset query (to prevent possible errors) ... $result_mails = SQL_QUERY("SELECT - `userid` AS sender + `userid` AS userid FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `timestamp_send` <= (UNIX_TIMESTAMP() - {?ap_dm_timeout?}) ORDER BY - `sender` ASC", __FILE__, __LINE__); + `userid` ASC", __FILE__, __LINE__); } // END - if } // END - while } // END - if