X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fautopurge%2Fpurge-mails.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=5b63f5d4e70796f656c21c2a371254034255a394;hp=d605fc33a99c83386ff1cb87355d6fc63a952e11;hpb=ffe213c8e3f85119ddd5544214d0de9ecb833d98;p=mailer.git diff --git a/inc/autopurge/purge-mails.php b/inc/autopurge/purge-mails.php index d605fc33a9..f551ef47b7 100644 --- a/inc/autopurge/purge-mails.php +++ b/inc/autopurge/purge-mails.php @@ -1,139 +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 - `userid` 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 `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 userid -FROM - `{?_MYSQL_PREFIX?}_user_stats` -WHERE - `timestamp_send` <= (UNIX_TIMESTAMP() - {?ap_dm_timeout?}) -ORDER BY - `userid` 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('{--ADMIN_AUTOPURGE_DEL_MAILS_SUBJECT--}', 'admin_autopurge_del_mails', $deletedStats); -} // END - if - -// +// @DEPRECATED ?>