<?php
/************************************************************************
 * MXChange v0.2.1                                    Start: 01/28/2004 *
 * ================                             Last change: 06/10/2004 *
 *                                                                      *
 * -------------------------------------------------------------------- *
 * File              : what-list_refs.php                               *
 * -------------------------------------------------------------------- *
 * Short description : Show all referals made by a member               *
 * -------------------------------------------------------------------- *
 * 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                  *
 *                                                                      *
 * 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 *
 * the Free Software Foundation; either version 2 of the License, or    *
 * (at your option) any later version.                                  *
 *                                                                      *
 * This program is distributed in the hope that it will be useful,      *
 * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
 * GNU General Public License for more details.                         *
 *                                                                      *
 * You should have received a copy of the GNU General Public License    *
 * along with this program; if not, write to the Free Software          *
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
 * MA  02110-1301  USA                                                  *
 ************************************************************************/

// Some security stuff...
if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
	require($INC);
}

// Add description as navigation point
ADD_DESCR('admin', __FILE__);

if (REQUEST_ISSET_GET('uid')) {
	// Secure userid
	$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",
	array($uid), __FILE__, __LINE__);

	// User found?
	if (SQL_NUMROWS($result_user) == 1) {
		// Is the refback extension installed?
		if (EXT_IS_ACTIVE('refback')) {
			// Load all referal levels
			$result_levels = SQL_QUERY("SELECT level, percents
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",
			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` ASC",
			array($uid), __FILE__, __LINE__);
			$menge      = SQL_RESULT($result    , 0, 0);
			$menge_lck  = SQL_RESULT($result_lck, 0, 0);

			// Free memory
			SQL_FREERESULT($result);
			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",
			array($uid), __FILE__, __LINE__);

			// Output info message
			LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(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;
			while ($levels = SQL_FETCHARRAY($result_levels)) {
				// Insert more data
				$levels['sw']    = $SW;

				// 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",
					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",
						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` ASC",
						array($uid), __FILE__, __LINE__);
						$menge      = SQL_RESULT($result    , 0, 0);
						$menge_lck  = SQL_RESULT($result_lck, 0, 0);

						// Free memory
						SQL_FREERESULT($result);
						SQL_FREERESULT($result_lck);

						// Output info message
						$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($uid), $menge, $menge_lck);

						// Init variables
						$OUT_REFS = ''; $SW = 2;

						// Load all 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($content['refid']), __FILE__, __LINE__);

							// Is the data there?
							if (SQL_NUMROWS($result_user) == 1) {
								// Load data
								$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($content['refid']), __FILE__, __LINE__);

								// Load refs
								$refs_cnt = SQL_RESULT($result_cnt, 0, 0);

								// Free result
								SQL_FREERESULT($result_cnt);

								// Prepare data for the template
								$content = array(
									'sw'         => $SW,
									'u_link'     => generateUserProfileLink($data['userid']),
									'gender'     => translateGender($data['gender']),
									'refs_link'  => '0',
									'surname'    => $data['surname'],
									'family'     => $data['family'],
									'email'      => "[<a href=\"".generateMemberEmailLink($data['email'], "user_data")."\">".$data['email']."</a>]",
									'status'     => translateUserStatus($data['status']),
									'registered' => generateDateTime($data['joined'], '3'),
								);

								// Check if referal count is larger 0 and update link
								if ($refs_cnt > 0) $content['refs_link'] = generateUserProfileLink($data['userid'], $refs_cnt, "list_refs");

								// Load template for level one
								$OUT_REFS .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);
							} else {
								// No refs found
								$OUT_REFS = LOAD_TEMPLATE("admin_list_refs_nodata", true, $content['refid']);
							}

							// Free result
							SQL_FREERESULT($result_user);

							// Add content
							$levels['rows'] = $OUT_REFS;

							// Switch colors
							$SW = 3 - $SW;
						} // END - while
					} else {
						// Output info message
						$levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($uid), '0', '0');

						// No refs found
						$levels['rows'] = LOAD_TEMPLATE("admin_list_refs_norefs", true, array('uid' => $uid));
					}

					// Free result
					SQL_FREERESULT($result_refs);

					// Load level template
					$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",
					array(bigintval($levels['userid'])), __FILE__, __LINE__);
					$refs_cnt = SQL_RESULT($result_refs, 0, 0);
					SQL_FREERESULT($result_refs);

					// Prepare data for the template
					$content = array(
						'sw'         => $SW,
						'u_link'     => generateUserProfileLink($levels['userid']),
						'gender'     => translateGender($levels['gender']),
						'refs_link'  => '0',
						'surname'    => $levels['surname'],
						'family'     => $levels['family'],
						'email'      => "[<a href=\"".generateMemberEmailLink($levels['email'], "user_data")."\">".$levels['email']."</a>]",
						'status'     => translateUserStatus($levels['status']),
						'registered' => generateDateTime($levels['joined'], '3'),
					);

					// Check if referal count is larger 0 and update link
					if ($refs_cnt > 0) $content['refs_link'] = generateUserProfileLink($levels['userid'], $refs_cnt, "list_refs");

					// Load template for level one
					$OUT .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);

					// Switch colors
					$SW = 3 - $SW;
				}
			} // END - while

			// Prepare content
			$content = array(
				'rows' => $OUT,
				'uid'  => generateUserProfileLink(REQUEST_GET('uid'))
			);

			// Load main template
			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')) {
			// No levels found, very bad!
			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'));
		}

		// Free result
		SQL_FREERESULT($result_levels);
	} else {
		// User not found
		LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), REQUEST_GET('uid')));
	}

	// Free memory
	SQL_FREERESULT($result_user);
} else {
	// Output selection form with all confirmed user accounts listed
	ADD_MEMBER_SELECTION_BOX();
}

//
?>