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

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index a1de804b17..02431f9d58 100644
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -51,7 +51,7 @@ if (!empty($_GET['u_id'])) {
 	$uid = bigintval($_GET['u_id']);
 
 	// 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?
@@ -60,14 +60,14 @@ if (!empty($_GET['u_id'])) {
 		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,7 +77,7 @@ 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
@@ -95,16 +95,16 @@ ORDER BY level ASC", __FILE__, __LINE__);
 				// Is the refback still active? ;-)
 				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);
@@ -120,7 +120,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
 						$OUT_REFS = ""; $SW = 2;
 						while (list($refid) = SQL_FETCHROW($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",
+							$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__);
 
 							// Is the data there?
@@ -129,7 +129,7 @@ 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",
+								$result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
 									array($refid), __FILE__, __LINE__);
 
 								// Load refs
@@ -185,7 +185,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);
@@ -228,10 +228,10 @@ ORDER BY level ASC", __FILE__, __LINE__);
 			}
 		} 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