X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fautopurge%2Fpurge-unconfirmed.php;h=0ef7d7ef076f4be944d909190634f9704862de8f;hb=255696fe065d35b951f66168c35296b10fdde060;hp=617a5903a79d501fca44431a887fd11846e95a5b;hpb=98e388b809fe0f6d5dbe2a02273a11e6816fb333;p=mailer.git diff --git a/inc/autopurge/purge-unconfirmed.php b/inc/autopurge/purge-unconfirmed.php index 617a5903a7..0ef7d7ef07 100644 --- a/inc/autopurge/purge-unconfirmed.php +++ b/inc/autopurge/purge-unconfirmed.php @@ -1,7 +1,7 @@ 0) { + $result_uncon = SQL_QUERY("SELECT + `userid`, `email`, `joined` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `status`='UNCONFIRMED' AND `joined` < (UNIX_TIMESTAMP() - {?ap_unconfirmed_time?}) +ORDER BY + `userid` ASC", __FILE__, __LINE__); + if (!SQL_HASZERONUMS($result_uncon)) { // Prepare variable... - $UIDs = ''; - define('__UNCONFIRMED_TIME' , (getConfig('ap_un_time') / 60 / 60)); + $userids = ''; + $content['time'] = (getApUnconfirmedTime() / 60 / 60); // Delete inactive accounts - while ($content = SQL_FETCHARRAY($result_uncon)) { + while ($row = SQL_FETCHARRAY($result_uncon)) { + // Merge both arrays + $content = merge_array($content, $row); + // Remember userids for the admin - $UIDs .= $content['userid'] . ', '; + $userids .= $content['userid'] . ', '; // Get date/time from timestamp - $content['joined'] = generateDateTime($content['joined'], '0'); + $content['joined'] = generateDateTime($content['joined'], 0); // Finnaly delete this inactive account - deleteUserAccount($content['userid'], LOAD_EMAIL_TEMPLATE('member_autopurge_unconfirmed', $content['joined'], '')); + deleteUserAccount($content['userid'], loadEmailTemplate('member_autopurge_unconfirmed', $content, '')); } // END - while // Remove last comma - $UIDs = str_replace(", ", "\n", substr($UIDs, 0, -2)); + $userids = str_replace(', ', "\n", substr($userids, 0, -2)); // Send mail notification to admin if (getConfig('ap_un_notify') == 'Y') { - sendAdminNotification(getMessage('AUTOPURGE_ADMIN_UNCONFIRMED_SUBJECT'), 'admin_autopurge_unconfirmed', $UIDs, ''); + sendAdminNotification('{--ADMIN_AUTOPURGE_UNCONFIRMED_SUBJECT--}', 'admin_autopurge_unconfirmed', $userids); } // END - if } // END - if // Free memory SQL_FREERESULT($result_uncon); -} +} // END - if -// +// [EOF] ?>