X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_refs.php;h=596cd56b2cb0efee8ca830ab34b11572e7fe3169;hp=a1de804b17b5bb09875d460802d02a2195127529;hb=f97a999e0737c0007ae9c3c26dfef49f75a175ac;hpb=cca98f57dff720b174d21d071cee8303462485d7

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index a1de804b17..596cd56b2c 100644
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -39,35 +39,35 @@
 
 // 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",
+	$result_user = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
 		array($uid), __FILE__, __LINE__);
 
 	// 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`
+FROM `{!_MYSQL_PREFIX!}_refdepths`
 WHERE level > 0
 ORDER BY level ASC", __FILE__, __LINE__);
 		} else {
 			// Loads surname, family's name and the email address
-			$result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!MYSQL_PREFIX!}_user_data` WHERE refid=%s",
+			$result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
 				array($uid), __FILE__, __LINE__);
-			$result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
+			$result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
 				array($uid), __FILE__, __LINE__);
 			$menge      = SQL_RESULT($result    , 0, 0);
 			$menge_lck  = SQL_RESULT($result_lck, 0, 0);
@@ -77,34 +77,34 @@ ORDER BY level ASC", __FILE__, __LINE__);
 			SQL_FREERESULT($result_lck);
 
 			// Query for refs
-			$result_levels = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!MYSQL_PREFIX!}_user_data` WHERE refid=%s ORDER BY userid ASC",
+			$result_levels = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s ORDER BY userid ASC",
 				array($uid), __FILE__, __LINE__);
 
 			// Output info message
-			OUTPUT_HTML(ADMIN_TOTAL_REFS_1."".ADMIN_USER_PROFILE_LINK($_GET['u_id'])."".ADMIN_TOTAL_REFS_2.$menge.ADMIN_TOTAL_REFS_3.$menge_lck.ADMIN_TOTAL_REFS_4."<br /><br />");
+			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",
+					$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__);
 					//* DEBUG: */ echo $uid."/".$levels['level']."/".SQL_NUMROWS($result_refs)."<br />\n";
 
 					// Do we have levels?
 					if (SQL_NUMROWS($result_refs) > 0) {
 						// Loads surname, family's name and the email address
-						$result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!MYSQL_PREFIX!}_user_data` WHERE refid=%s",
+						$result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
 							array($uid), __FILE__, __LINE__);
-						$result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
+						$result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
 							array($uid), __FILE__, __LINE__);
 						$menge      = SQL_RESULT($result    , 0, 0);
 						$menge_lck  = SQL_RESULT($result_lck, 0, 0);
@@ -114,14 +114,16 @@ ORDER BY level ASC", __FILE__, __LINE__);
 						SQL_FREERESULT($result_lck);
 
 						// Output info message
-						$levels['info'] = ADMIN_TOTAL_REFS_1."".ADMIN_USER_PROFILE_LINK($uid)."".ADMIN_TOTAL_REFS_2.$menge.ADMIN_TOTAL_REFS_3.$menge_lck.ADMIN_TOTAL_REFS_4;
+						$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__);
+							$result_user = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
+								array($content['refid']), __FILE__, __LINE__);
 
 							// Is the data there?
 							if (SQL_NUMROWS($result_user) == 1) {
@@ -129,8 +131,8 @@ ORDER BY level ASC", __FILE__, __LINE__);
 								$data = SQL_FETCHARRAY($result_user);
 
 								// Check for referals
-								$result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!MYSQL_PREFIX!}_user_data` WHERE refid=%s",
-									array($refid), __FILE__, __LINE__);
+								$result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
+									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
@@ -172,7 +174,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
 						} // END - while
 					} else {
 						// Output info message
-						$levels['info'] = ADMIN_TOTAL_REFS_1."".ADMIN_USER_PROFILE_LINK($uid)."".ADMIN_TOTAL_REFS_2."0".ADMIN_TOTAL_REFS_3."0".ADMIN_TOTAL_REFS_4;
+						$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($uid), "0", "0");
 
 						// No refs found
 						$levels['rows'] = LOAD_TEMPLATE("admin_list_refs_norefs", true, array('uid' => $uid));
@@ -185,7 +187,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
 					$OUT .= LOAD_TEMPLATE("admin_list_refs_level", true, $levels);
 				} else {
 					// Check for referals
-					$result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!MYSQL_PREFIX!}_user_data` WHERE refid=%s",
+					$result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
 					 array(bigintval($levels['userid'])), __FILE__, __LINE__);
 					$refs_cnt = SQL_RESULT($result_refs, 0, 0);
 					SQL_FREERESULT($result_refs);
@@ -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, 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, 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(ADMIN_MEMBER_404, $_GET['u_id']));
+		LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), REQUEST_GET('uid')));
 	}
 
 	// Free memory