X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_refs.php;h=7c4d99b46210c35ce8adb71bff4bb467ec8592e1;hp=83b1760ceda9d482c048b26ac55c90a120ee923f;hb=8fad776382e63b3f73f8dbe289f229d79cfc2c22;hpb=f7f6e55ee0d90558ad773ce6168767c0af816696

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index 83b1760ced..7c4d99b462 100644
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 01/28/2004 *
- * ================                             Last change: 06/10/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 01/28/2004 *
+ * ===================                          Last change: 06/10/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-list_refs.php                               *
@@ -10,16 +10,9 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Alle generierten Refs eines Mitgliedes anzeigen  *
  * -------------------------------------------------------------------- *
- *                                                                      *
- *    Mod created by : Lars Moehlenbruch ( http://www.surfo.net )       *
- *                                                                      *
- * -------------------------------------------------------------------- *
- *                                                                      *
- *                 Highly modified by Roland Haeder                     *
- *                                                                      *
- * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * 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 *
  * it under the terms of the GNU General Public License as published by *
@@ -38,72 +31,134 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
-	require($INC);
-}
+if ((!defined('__SECURITY')) || (!isAdmin())) {
+	die();
+} // END - if
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
-
-if (!empty($_GET['u_id'])) {
-	// Check if the user already exists
-	$result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
-	 array(bigintval($_GET['u_id'])), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result) == 1) {
-		// Load all referal levels
-		$result_levels = SQL_QUERY_ESC("SELECT d.level, d.percents, r.counter
-FROM "._MYSQL_PREFIX."_refdepths AS d
-LEFT JOIN "._MYSQL_PREFIX."_refsystem AS r
-ON d.level=r.level
-WHERE r.userid=%s
-ORDER BY d.level ASC",
-			array(bigintval($_GET['u_id'])), __FILE__, __LINE__);
+addYouAreHereLink('admin', __FILE__);
+
+if (isGetRequestElementSet('userid')) {
+	// Secure userid
+	$userid = bigintval(getRequestElement('userid'));
+
+	// Fix missing variable
+	$result_levels = false;
+
+	// User found?
+	if (fetchUserData($userid)) {
+		// Get total refs
+		$totalReferrals       = getUsersTotalReferrals($userid);
+		$totalLockedReferrals = getUsersTotalLockedReferrals($userid);
+
+		// Output info message
+		displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $totalReferrals, $totalLockedReferrals));
+
+		// Load all referral levels
+		$result_levels = SQL_QUERY("SELECT
+	`level`,
+	`percents`
+FROM
+	`{?_MYSQL_PREFIX?}_refdepths`
+WHERE
+	`level` > 0
+ORDER BY
+	`level` ASC", __FILE__, __LINE__);
 
 		// Are there some levels (VERY BAD IF NONE!)
-		if (SQL_NUMROWS($result_levels) > 0) {
-			// List all ref levels
-			$OUT = ""; $SW = 2;
+		if (!SQL_HASZERONUMS($result_levels)) {
+			// List all ref levels or entries if no refback is installed
+			$OUT = '';
 			while ($levels = SQL_FETCHARRAY($result_levels)) {
-				// Insert more data
-				$levels['sw']    = $SW;
-				$levels['level'] = ($levels['level'] + 1);
-
 				// Load all refs of this user
-				//$result_refs = SQL_QUERY_ESC("SELECT 
-				// Load level template
-				$OUT .= LOAD_TEMPLATE("admin_list_refs_level", true, $levels);
+				$result_refs = SQL_QUERY_ESC("SELECT `refid` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s ORDER BY `refid` ASC",
+					array(
+						$userid,
+						$levels['level']
+					), __FILE__, __LINE__);
+				//* DEBUG: */ debugOutput($userid.'/'.$levels['level'].'/'.SQL_NUMROWS($result_refs));
+
+				// Is there levels?
+				if (!SQL_HASZERONUMS($result_refs)) {
+					// Count entries
+					$totalReferrals       = getUsersTotalReferrals($userid, $levels['level']);
+					$totalLockedReferrals = getUsersTotalLockedReferrals($userid, $levels['level']);
+
+					// Output info message
+					$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), $totalReferrals, $totalLockedReferrals);
+
+					// Init variables
+					$OUT_REFS = '';
+
+					// Load all refs
+					while ($content = SQL_FETCHARRAY($result_refs)) {
+						// Is the data there?
+						if (fetchUserData($content['refid'])) {
+							// Check for referrals
+							$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'),
+								'refs_link'  => '0',
+								'email'      => '[<a href="' . generateEmailLink(getUserData('email'), 'user_data') . '">' . getUserData('email') . '</a>]',
+								'registered' => generateDateTime(getUserData('joined'), 3),
+							);
+
+							// Check if referral count is larger 0 and update link
+							if ($refs_cnt > 0) {
+								$content['refs_link'] = generateUserProfileLink(getUserData('userid'), $refs_cnt, 'list_refs');
+							} // END - if
 
-				// Switch colors
-				$SW = 3 - $SW;
-			} // END - if
+							// Load template for level one
+							$OUT_REFS .= loadTemplate('admin_list_refs_row', true, $content);
+						} else {
+							// No refs found
+							$OUT_REFS = loadTemplate('admin_list_refs_nodata', true, $content);
+						}
+
+						// Add content
+						$levels['rows'] = $OUT_REFS;
+					} // END - while
+				} else {
+					// Output info message
+					$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));
+				}
+
+				// Free result
+				SQL_FREERESULT($result_refs);
+
+				// Load level template
+				$OUT .= loadTemplate('admin_list_refs_level', true, $levels);
+			} // END - while
 
 			// Prepare content
 			$content = array(
-				'rows' => $OUT,
-				'uid'  => ADMIN_USER_PROFILE_LINK($_GET['u_id'])
+				'rows'   => $OUT,
+				'userid' => getRequestElement('userid')
 			);
 
-			// Load mein template
-			LOAD_TEMPLATE("admin_list_refs", false, $content);
+			// Load main template
+			loadTemplate('admin_list_refs', false, $content);
 		} else {
-			// No levels found, very bad!
-			LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NO_REF_LEVELS);
+			// No refs made so far
+			displayMessage('{--USER_REFERRAL_404--}');
 		}
 
 		// Free result
 		SQL_FREERESULT($result_levels);
 	} else {
 		// User not found
-		LOAD_TEMPLATE("admin_settings_saved", false, sprintf(ADMIN_MEMBER_404, $_GET['u_id']));
+		displayMessage('{%message,ADMIN_MEMBER_404=' . getRequestElement('userid') . '%}');
 	}
-
-	// Free memory
-	SQL_FREERESULT($result);
 } else {
 	// Output selection form with all confirmed user accounts listed
-	ADD_MEMBER_SELECTION_BOX();
+	addMemberSelectionBox();
 }
 
-//
+// [EOF]
 ?>