X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fautopurge%2Fpurge-mails.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=9f30db83eedcaf1d265d973e4bffcd3fa7df9bde;hp=5236d22c07c913ac24479ab30a96c4d2f5a93388;hpb=d92a340159ca45047eafc111fcac64933a7babeb;p=mailer.git diff --git a/inc/autopurge/purge-mails.php b/inc/autopurge/purge-mails.php index 5236d22c07..f551ef47b7 100644 --- a/inc/autopurge/purge-mails.php +++ b/inc/autopurge/purge-mails.php @@ -1,138 +1,3 @@ 0) { - // Okay, check for their sender's - while ($content = SQL_FETCHARRAY($result_mails)) { - // Check now... - if (!fetchUserData($content['sender'])) { - // Okay we found some mails! - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_pool` WHERE `sender`=%s", - array(bigintval($content['sender'])), __FILE__, __LINE__); - - // Get all affected (deleted) rows - $deletedStats += SQL_AFFECTEDROWS(); - - // Reset query (to prevent possible errors) ...; - $result_mails = SQL_QUERY("SELECT - `sender` -FROM - `{?_MYSQL_PREFIX?}_pool` -WHERE - `data_type`='DELETED' AND timestamp <= (UNIX_TIMESTAMP() - {?ap_dm_timeout?}) -ORDER BY - `sender` ASC", __FILE__, __LINE__); - } // END - if - } // END - while -} // END - if - -// Free memory -SQL_FREERESULT($result_mails); - -// Now let's check for stats entries as well; -$result_mails = SQL_QUERY("SELECT - `userid` AS sender -FROM - `{?_MYSQL_PREFIX?}_user_stats` -WHERE - `timestamp_send` <= (UNIX_TIMESTAMP() - {?ap_dm_timeout?}) -ORDER BY - `sender` ASC", __FILE__, __LINE__); - -// Do we have "purged" mails? -if (SQL_NUMROWS($result_mails) > 0) { - // Okay, check for their sender's - while ($content = SQL_FETCHARRAY($result_mails)) { - // 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__); - - // Get all affected (deleted) rows - $deletedStats += SQL_AFFECTEDROWS(); - - // Reset query (to prevent possible errors) ... - $result_mails = SQL_QUERY("SELECT - `userid` AS sender -FROM - `{?_MYSQL_PREFIX?}_user_stats` -WHERE - `timestamp_send` <= (UNIX_TIMESTAMP() - {?ap_dm_timeout?}) -ORDER BY - `sender` ASC", __FILE__, __LINE__); - } // END - if - } // END - while -} // END - if - -// Free memory -SQL_FREERESULT($result_mails); - -// Do we have deleted mails and the admin want's to receive a notification -if (($deletedStats > 0) && (getConfig('ap_dm_notify') == 'Y')) { - // Send out email to admin - sendAdminNotification(getMessage('AUTOPURGE_ADMIN_DEL_MAILS_SUBJECT'), 'admin_autopurge_del_mails', $deletedStats); -} // END - if - -// +// @DEPRECATED ?>