X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_refs.php;h=3989f940b8edc4ebf7c1e3b65a476123b3ba9dfd;hb=62220d980d8f0d189e7ebe8d1a1335af590133d3;hp=2c410a5e8af5954a446d4af0a4f0abd04323e441;hpb=3161d70d2c3a86649dd16a7909ec16f801f16e4e;p=mailer.git

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index 2c410a5e8a..3989f940b8 100644
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -11,7 +11,7 @@
  * Kurzbeschreibung  : Alle generierten Refs eines Mitgliedes anzeigen  *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -43,20 +43,21 @@ if (isGetRequestElementSet('userid')) {
 	$userid = bigintval(getRequestElement('userid'));
 
 	// Fix missing variable
-	$result_levels = false;
+	$result_levels = FALSE;
 
 	// User found?
 	if (fetchUserData($userid)) {
 		// Get total refs
-		$menge =     countSumTotalData($userid, 'user_data', 'userid', 'refid', true);
-		$menge_lck = countSumTotalData($userid, 'user_data', 'userid', 'refid', true, " AND `status` != 'CONFIRMED'");
+		$totalReferrals       = getUsersTotalReferrals($userid);
+		$totalLockedReferrals = getUsersTotalLockedReferrals($userid);
 
 		// Output info message
-		displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $menge, $menge_lck));
+		displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $totalReferrals, $totalLockedReferrals));
 
 		// Load all referral levels
 		$result_levels = SQL_QUERY("SELECT
-	`level`,`percents`
+	`level`,
+	`percents`
 FROM
 	`{?_MYSQL_PREFIX?}_refdepths`
 WHERE
@@ -77,14 +78,14 @@ ORDER BY
 					), __FILE__, __LINE__);
 				//* DEBUG: */ debugOutput($userid.'/'.$levels['level'].'/'.SQL_NUMROWS($result_refs));
 
-				// Do we have levels?
+				// Is there levels?
 				if (!SQL_HASZERONUMS($result_refs)) {
 					// Count entries
-					$menge =     countSumTotalData($userid, 'user_data', 'userid', 'refid', true);
-					$menge_lck = countSumTotalData($userid, 'user_data', 'userid', 'refid', true, " AND `status` != 'CONFIRMED'");
+					$totalReferrals       = getUsersTotalReferrals($userid, $levels['level']);
+					$totalLockedReferrals = getUsersTotalLockedReferrals($userid, $levels['level']);
 
 					// Output info message
-					$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), $menge, $menge_lck);
+					$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), $totalReferrals, $totalLockedReferrals);
 
 					// Init variables
 					$OUT_REFS = '';
@@ -94,18 +95,14 @@ ORDER BY
 						// Is the data there?
 						if (fetchUserData($content['refid'])) {
 							// Check for referrals
-							$refs_cnt = countSumTotalData(getUserData('userid'), 'user_refs', 'id', 'userid', true);
+							$refs_cnt = countSumTotalData(getUserData('userid'), 'user_refs', 'id', 'userid', TRUE);
 
 							// Prepare data for the template
 							// @TODO Try to rewrite some to EL
 							$content = array(
 								'userid'     => getUserData('userid'),
-								'gender'     => getUserData('gender'),
-								'refs_link'  => 0,
-								'surname'    => getUserData('surname'),
-								'family'     => getUserData('family'),
+								'refs_link'  => '0',
 								'email'      => '[<a href="' . generateEmailLink(getUserData('email'), 'user_data') . '">' . getUserData('email') . '</a>]',
-								'status'     => getUserData('status'),
 								'registered' => generateDateTime(getUserData('joined'), 3),
 							);
 
@@ -115,10 +112,10 @@ ORDER BY
 							} // END - if
 
 							// Load template for level one
-							$OUT_REFS .= loadTemplate('admin_list_refs_row', true, $content);
+							$OUT_REFS .= loadTemplate('admin_list_refs_row', TRUE, $content);
 						} else {
 							// No refs found
-							$OUT_REFS = loadTemplate('admin_list_refs_nodata', true, $content);
+							$OUT_REFS = loadTemplate('admin_list_refs_nodata', TRUE, $content);
 						}
 
 						// Add content
@@ -129,14 +126,14 @@ ORDER BY
 					$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), 0, 0);
 
 					// No refs found
-					$levels['rows'] = loadTemplate('admin_list_refs_norefs', true, array('userid' => $userid));
+					$levels['rows'] = loadTemplate('admin_list_refs_norefs', TRUE, array('userid' => $userid));
 				}
 
 				// Free result
 				SQL_FREERESULT($result_refs);
 
 				// Load level template
-				$OUT .= loadTemplate('admin_list_refs_level', true, $levels);
+				$OUT .= loadTemplate('admin_list_refs_level', TRUE, $levels);
 			} // END - while
 
 			// Prepare content
@@ -146,7 +143,7 @@ ORDER BY
 			);
 
 			// Load main template
-			loadTemplate('admin_list_refs', false, $content);
+			loadTemplate('admin_list_refs', FALSE, $content);
 		} else {
 			// No refs made so far
 			displayMessage('{--USER_REFERRAL_404--}');