X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fautopurge%2Fpurge-mails.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=96979cf66a4fc49fda5842e59f475af377821cf9;hp=982795f103247d9d585c98bc8b7a2c208dcee5d9;hpb=da85b1427a16026d201df189494c1497368a2043;p=mailer.git diff --git a/inc/autopurge/purge-mails.php b/inc/autopurge/purge-mails.php index 982795f103..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... - $fount = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1", - array(bigintval($content['sender'])), __FILE__, __LINE__)); - if ($found == 0) { - // Okay we found some mails! - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_pool` WHERE `sender`=%s", - array(bigintval($content['sender'])), __FILE__, __LINE__); - $DELETED += 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__); - } - } -} - -// 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... - $found = SQL_NUMROWS(SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1", - array(bigintval($content['sender'])), __FILE__, __LINE__)); - if ($found == 0) { - // 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__); - $DELETED += 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__); - } - } -} - -// Free memory -SQL_FREERESULT($result_mails); - -// Do we have deleted mails and the admin want's to receive a notification -if (($DELETED > 0) && (getConfig('ap_dm_notify') == 'Y')) { - // Send out email to admin - sendAdminNotification(getMessage('AUTOPURGE_ADMIN_DEL_MAILS_SUBJECT'), 'admin_autopurge_del_mails', $DELETED, ''); -} // END - if - -// +// @DEPRECATED ?>