X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_refs.php;h=596cd56b2cb0efee8ca830ab34b11572e7fe3169;hb=116747e4dba29e9e2e4daa82c45d8bbb302e9378;hp=6803a04aecbc5cd3f4a4eabb21d763b55e44b593;hpb=1cf72a9c1a5e737509af79d49f0731da2eb6a218;p=mailer.git

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index 6803a04aec..596cd56b2c 100644
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -39,16 +39,16 @@
 
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
 	require($INC);
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", __FILE__);
+ADD_DESCR('admin', __FILE__);
 
-if (!empty($_GET['u_id'])) {
+if (REQUEST_ISSET_GET('uid')) {
 	// Secure userid
-	$uid = bigintval($_GET['u_id']);
+	$uid = bigintval(REQUEST_GET('uid'));
 
 	// Check if the user already exists
 	$result_user = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
@@ -57,7 +57,7 @@ if (!empty($_GET['u_id'])) {
 	// User found?
 	if (SQL_NUMROWS($result_user) == 1) {
 		// Is the refback extension installed?
-		if (EXT_IS_ACTIVE("refback")) {
+		if (EXT_IS_ACTIVE('refback')) {
 			// Load all referal levels
 			$result_levels = SQL_QUERY("SELECT level, percents
 FROM `{!_MYSQL_PREFIX!}_refdepths`
@@ -81,19 +81,19 @@ ORDER BY level ASC", __FILE__, __LINE__);
 				array($uid), __FILE__, __LINE__);
 
 			// Output info message
-			LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($_GET['u_id']), $menge, $menge_lck));
+			LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK(REQUEST_GET('uid')), $menge, $menge_lck));
 		}
 
 		// Are there some levels (VERY BAD IF NONE!)
 		if (SQL_NUMROWS($result_levels) > 0) {
 			// List all ref levels or entries if no refback is installed
-			$OUT = ""; $SW = 2;
+			$OUT = ''; $SW = 2;
 			while ($levels = SQL_FETCHARRAY($result_levels)) {
 				// Insert more data
 				$levels['sw']    = $SW;
 
 				// Is the refback still active? ;-)
-				if (EXT_IS_ACTIVE("refback")) {
+				if (EXT_IS_ACTIVE('refback')) {
 					// Load all refs of this user
 					$result_refs = SQL_QUERY_ESC("SELECT refid FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE userid=%s AND level='%s' ORDER BY refid ASC",
 						array($uid, $levels['level']), __FILE__, __LINE__);
@@ -116,12 +116,14 @@ ORDER BY level ASC", __FILE__, __LINE__);
 						// Output info message
 						$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($uid), $menge, $menge_lck);
 
+						// Init variables
+						$OUT_REFS = ''; $SW = 2;
+
 						// Load all refs
-						$OUT_REFS = ""; $SW = 2;
-						while (list($refid) = SQL_FETCHROW($result_refs)) {
+						while ($content = SQL_FETCHARRAY($result_refs)) {
 							// Query for data
 							$result_user = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-								array($refid), __FILE__, __LINE__);
+								array($content['refid']), __FILE__, __LINE__);
 
 							// Is the data there?
 							if (SQL_NUMROWS($result_user) == 1) {
@@ -130,7 +132,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
 
 								// Check for referals
 								$result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
-									array($refid), __FILE__, __LINE__);
+									array($content['refid']), __FILE__, __LINE__);
 
 								// Load refs
 								$refs_cnt = SQL_RESULT($result_cnt, 0, 0);
@@ -158,7 +160,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
 								$OUT_REFS .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);
 							} else {
 								// No refs found
-								$OUT_REFS = LOAD_TEMPLATE("admin_list_refs_nodata", true, $refid);
+								$OUT_REFS = LOAD_TEMPLATE("admin_list_refs_nodata", true, $content['refid']);
 							}
 
 							// Free result
@@ -217,28 +219,28 @@ ORDER BY level ASC", __FILE__, __LINE__);
 			// Prepare content
 			$content = array(
 				'rows' => $OUT,
-				'uid'  => ADMIN_USER_PROFILE_LINK($_GET['u_id'])
+				'uid'  => ADMIN_USER_PROFILE_LINK(REQUEST_GET('uid'))
 			);
 
 			// Load main template
-			if (EXT_IS_ACTIVE("refback")) {
+			if (EXT_IS_ACTIVE('refback')) {
 				LOAD_TEMPLATE("admin_list_refs2", false, $content);
 			} else {
 				LOAD_TEMPLATE("admin_list_refs", false, $content);
 			}
-		} elseif (EXT_IS_ACTIVE("refback")) {
+		} elseif (EXT_IS_ACTIVE('refback')) {
 			// No levels found, very bad!
-			LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_NO_REF_LEVELS'));
+			LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NO_REF_LEVELS'));
 		} else {
 			// No refs made so far
-			LOAD_TEMPLATE("admin_settings_saved", false, getMessage('USER_REF_404'));
+			LOAD_TEMPLATE('admin_settings_saved', false, getMessage('USER_REF_404'));
 		}
 
 		// Free result
 		SQL_FREERESULT($result_levels);
 	} else {
 		// User not found
-		LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_MEMBER_404'), $_GET['u_id']));
+		LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), REQUEST_GET('uid')));
 	}
 
 	// Free memory