X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fautopurge%2Fpurge-unconfirmed.php;h=c4eed02a77ac7fc0c926ad38d295ff08bde9d71d;hb=2e394cb5b8a6225a39a6942b1fcc17c37a17a175;hp=a31d7b6ef6fa8f76e79cb949c33f16038cd84ce8;hpb=5071030af40e69ca4284642f44758964e18f5be8;p=mailer.git

diff --git a/inc/autopurge/purge-unconfirmed.php b/inc/autopurge/purge-unconfirmed.php
index a31d7b6ef6..c4eed02a77 100644
--- a/inc/autopurge/purge-unconfirmed.php
+++ b/inc/autopurge/purge-unconfirmed.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 05/29/2004 *
- * ===============                              Last change: 11/26/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 05/29/2004 *
+ * ===================                          Last change: 11/26/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : autopurge.php                                    *
@@ -14,10 +14,9 @@
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -38,54 +37,59 @@
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
-	require($INC);
+	die();
 } // END - if
 
 // Abort if autopurge is not active or disabled by admin
-if ((!EXT_IS_ACTIVE('autopurge')) || (getConfig('auto_purge_active') != 'Y')) {
+if ((!isExtensionActive('autopurge')) || (!isAutoPurgingActive())) {
 	// Abort here
 	return false;
 } // END - if
 
 // Shall I auto-purge unconfirmed accounts?
 if (getConfig('autopurge_unconfirmed') == 'Y') {
-	// Init variables and find unconfirmed accounts which I shall auto-purge
-	$time = getConfig(('ap_un_time'));
-	$result_uncon = SQL_QUERY_ESC("SELECT userid, email, joined
-FROM `{!_MYSQL_PREFIX!}_user_data`
-WHERE `status`='UNCONFIRMED' AND joined < (UNIX_TIMESTAMP() - %s)
-ORDER BY userid ASC",
-	array($time), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result_uncon) > 0) {
+	// Init variables and find unconfirmed accounts which I shall auto-purge;
+	$result_uncon = SQL_QUERY("SELECT
+	`userid`, `email`, `joined`
+FROM
+	`{?_MYSQL_PREFIX?}_user_data`
+WHERE
+	`status`='UNCONFIRMED' AND
+	(UNIX_TIMESTAMP() - `joined`) >= {?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]
 ?>