X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-chk_regs.php;h=db2c6657df0343676f230ef73fd54de4a0ed50b2;hb=b7a1b50bec9d45efcf037db83b7e7c58ba2846dd;hp=8f8ebc36afda6393af5ffde72255137f0d1b6c8c;hpb=963e55ca1ea79e255f235e359cde9f7862191dc5;p=mailer.git

diff --git a/inc/modules/admin/what-chk_regs.php b/inc/modules/admin/what-chk_regs.php
index 8f8ebc36af..db2c6657df 100644
--- a/inc/modules/admin/what-chk_regs.php
+++ b/inc/modules/admin/what-chk_regs.php
@@ -41,12 +41,12 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 ADD_DESCR ("admin", basename(__FILE__));
 
 // Check for accounts
-$query = SQL_QUERY("SELECT userid, gender, surname, family, email, REMOTE_ADDR, refid, user_hash FROM "._MYSQL_PREFIX."_user_data WHERE status='UNCONFIRMED' ORDER BY userid", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT userid, gender, surname, family, email, REMOTE_ADDR, refid, user_hash FROM "._MYSQL_PREFIX."_user_data WHERE status='UNCONFIRMED' ORDER BY userid", __FILE__, __LINE__);
 
-if (SQL_NUMROWS($query) > 0) {
+if (SQL_NUMROWS($result) > 0) {
 	// We have some (new?) registrations!
 	$SW = 2; $OUT = "";
-	while (list($uid, $gender, $sname, $fname, $email, $IP, $ref, $hash) = SQL_FETCHROW($query)) {
+	while (list($uid, $gender, $sname, $fname, $email, $IP, $ref, $hash) = SQL_FETCHROW($result)) {
 		if ($ref > 0) $ref = ADMIN_USER_PROFILE_LINK($ref);
 		// Prepare array for the row template
 		$content = array(
@@ -66,8 +66,7 @@ if (SQL_NUMROWS($query) > 0) {
 		$SW = 3 - $SW;
 	}
 
-	// Free memory
-	SQL_FREERESULT($query);
+	// Remember rows
 	define('__REG_ROWS', $OUT);
 
 	// Load main template
@@ -77,5 +76,8 @@ if (SQL_NUMROWS($query) > 0) {
 	LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_ALL_CONFIRMED_EMAIL);
 }
 
+// Free memory
+SQL_FREERESULT($result);
+
 //
 ?>