path: root/includes/datas.php

<?PHP
// For interaction with the SQL database.
//

include_once('db.inc.php');

//Select Stats/Scores.
function topScores($mapid, $top = 5, $bottom = 0) {
	$sql = "
	SELECT 
		timediff(solutions.dateModified, TIMESTAMP(CURDATE())) as diff,
		users.displayName as display,
		solutions.moves as m,
		users.ID as ID,
		userData.displayColor,
		userData.wallColor,
		userData.wallEmblem,
		solutions.dateModified as cdate
	FROM 
		`users`
		JOIN `solutions`
			ON users.ID = solutions.userID
		LEFT JOIN `userData`
			ON users.ID = userData.userID
	WHERE solutions.mapID = '$mapid'
	ORDER BY solutions.moves DESC, solutions.dateModified ASC
	LIMIT $bottom, $top
	";
	$result = mysql_query($sql) or die(mysql_error());
	$utime = date("g:i A (T)");
	$output  = "<table class='score'>";
	$output .= "<tr title='Updated $utime'>";
	$output .= "<th>Rank</th>";
	$output .= "<th>Badge</th>";
	$output .= "<th>Name</th>";
	$output .= "<th>Moves</th>";
	//$output .= "<th title='Time since map generation'>Time</th>";
	$output .= "</tr>";
	while (list($diff, $display, $moves, $userID, $displayColor, $wallColor, $wallEmblem, $cdate) = mysql_fetch_row($result)) {
		$i++;
		if (!isset($displayColor)) {
				$sql = "INSERT INTO `userData` (`userID`, `displayColor`, `wallColor`)
				VALUES ('$userID', '#cccccc', '#666666')";
				mysql_query($sql);
				$displayColor = '#cccccc';
				$wallColor = '#666666';
				$wallEmblem = 'blank.png';
		}
		if ($wallEmblem == '')
			$wallEmblem = 'blank.png';
		
		//$cdate = date("g:i A (T)", strtotime($cdate));
		$cdate = relativeTime(strtotime($cdate));
		
		$background = '#262631';
		if ($i % 2 == 1)
			$background = '#20202a';
		
		if ($_SESSION['userID'] == $userID)
			$background = '#343c57';
			//$background = '#356';
		
		$output .= "<tr style='background-color: $background; color:$displayColor;' ";
		$output .= "title='Scored $cdate'>";
		
		$output .= "<td>$i</td>
<td>
	<div class='grid_td' style='width:35px; height:35px; background:$wallColor url(images/marks/$wallEmblem);'>
		<div style='background-color:transparent;' class='grid_td_inner grid_td_rocks'>
		</div>
	</div>
</td>
<td><span title='UserID: $userID'><a href='achievements?id=$userID' style='color:$displayColor'>$display</a></span></td>
<td>$moves</td>\n";
		//$output .= "<td >$diff</td>";
		$output .= "</tr>";
	}
	$output .= "</table>";
	return $output;
}

//Returns text refering to any notifications.
function getNotified($userID) {


	$r = '';

	$sql = "SELECT `ID`, `type`, `level`
	FROM `achievements`
	WHERE `notified` = false
	AND userID = '$userID'
	LIMIT 25";
	
	$resultA = mysql_query($sql);
	if (mysql_num_rows($resultA) <= 0) 
		return false;
	
	// --------- We found an achievement they don't know they got!
	while (list($aID, $aType, $aLevel) = mysql_fetch_row($resultA)) {
		
		if ($r != '')
			$r .= '<br /><hr />';
		
		$aTypeNames[1] = "Path Career Level $aLevel!";
		$aTypeNames[2] = "Mazes Career Level $aLevel!";
		$aTypeNames[3] = "Maze Mastery Level $aLevel!";
		$aTypeNames[4] = "Champion Level $aLevel!";
		$aTypeNames[32] = 'Tutorial Complete!';
		
		$aTypeCurrency[1] = "total moves mazed";
		$aTypeCurrency[2] = "mazes played";
		$aTypeCurrency[3] = "mazes with (tied) top score";
		$aTypeCurrency[4] = "maze wins";
	
		$aName = $aTypeNames[$aType];
		$currency = $aTypeCurrency[$aType];
		
		// --------- Any unlocks for this achievement?
		$sql = "SELECT `type`, `name`, `value`
		FROM `unlocks`
		WHERE `achievementID` = '$aID'";
		$result = mysql_query($sql);
		$unlocked = '';
		if (mysql_num_rows($result) >= 1) {
			$unlocked = "You've unlocked: ";
			while (list($uType, $uName, $uValue) = mysql_fetch_row($result)) {
				switch ($uType) {
				case 1:
					$unlocked .= "$uName Wall Color!";
					$unlocked .= "<table><tr><td onclick='changeWallColor(\"$uValue\")' style='background-color:$uValue;' class='grid_td_rocks'></td></tr></table>";
					break;
				case 2:
					$unlocked .= "$uName Emblem!";
					$unlocked .= "<div class='grid_td_rocks' title='' onClick='emblemclick(this,\"$uValue\", \"0\")' style='background: #999 url(../images/marks/$uValue);' >";
					$unlocked .= "<div class='grid_inner grid_td_walls'></div></div>";
					break;
				case 3:
					$unlocked .= "<br /><span style='color:$uValue;'>$uName Username color!</span><br />";
					break;
				}
			}
		}
		// ---------- Prepare response
		
		$r .= "<strong>$aName</strong>";
		if ($unlocked !== '') {
			$r .= "<center>$unlocked";
			//$r .= "<div style='width:300px;height:75px;overflow:auto;'>";
			$r .= "</center>";
		}
		$aAry = getAchievementsArray($aType);
		$nextLevelRequired = $aAry[($aLevel + 1)][0];
		$currentLevelRequired = $aAry[($aLevel)][0];
		
		if ($currency) {
			$currentLevelRequired = number_format($currentLevelRequired);
			$r .= "You have $currentLevelRequired $currency <br />";
		}
		if ($nextLevelRequired >= 1) {
			$nextLevelRequired = number_format($nextLevelRequired);
			$r .= "Next level at $nextLevelRequired <br />";
		}
		
		
		
		
		// Item ID List
		$aIDList[] = "'$aID'";
	}
	$r .= "<br /><a href='achievements?id=$userID'>Go select unlocks now</a>";
	
		// ---------- Mark that we have notified the user
		$aIDListStr = implode(',', $aIDList);
		$sql = "UPDATE `achievements` 
		SET `notified` = 1
		WHERE `ID` IN ($aIDListStr)";
		mysql_query($sql);
	
	return $r;
	// ---------- Done!
}

//Returns true when an achievement is applied.
// Usage example: applyCareerAchievement($userID);
// TODO: DEPRECIATED
function applyCareerPathAchievements($userID) {
	$sql = "SELECT 
	SUM(solutions.moves) as totalMoves
	FROM `solutions`
	WHERE userID = '$userID'";
	$result = mysql_query($sql);
	
	// --------- User hasn't played yet.
	if (mysql_num_rows($result) != 1)
		return false;
	
	list($uTotalMoves) = mysql_fetch_row($result);

	// ------- Select the highest level they've achieved.
	$sql = "SELECT `level`
	FROM `achievements`
	WHERE `userID` = '$userID'
	AND `type` = 1
	ORDER BY `level` DESC
	LIMIT 1";
	$result = mysql_query($sql);
	// --------- No achievements yet?
	if (mysql_num_rows($result) == 1)
		list($aLevel) = mysql_fetch_row($result);
	else
		$aLevel = 0;
	
	$cp = getCareerPathArray();

	//Is there a next level for this?
	$aNextLevel = $aLevel + 1;
	if (!isset($cp[$aNextLevel]))
		return false;
	list($required, $unlockType, $unlockValue, $unlockName) = $cp[$aNextLevel];
	
	if ($uTotalMoves < $required)
		return false;

	$sql = "INSERT INTO `achievements`
	(`userID`, `type`, `level`)
	VALUES ('$userID', 1, '$aNextLevel')";
	mysql_query($sql);
	$aID = mysql_insert_id();
	
	// ------- User gets unlock.  (unlocks plural is possible here)
	$sql = "INSERT INTO `unlocks`
	(`userID`, `achievementID`, `type`, `subtype`, `name`, `value`)
	VALUES ('$userID', '$aID', '$unlockType', NULL, '$unlockName', '$unlockValue')";
	mysql_query($sql);
	return true;
}

//Almost a duplicate of applyCareerPathAchievements
// TODO: DEPRECIATED
function applyCareerMazesAchievements($userID) {
	$sql = "SELECT 
	COUNT(*) as totalSolutions
	FROM `solutions`
	WHERE userID = '$userID'";
	$result = mysql_query($sql);
	
	// --------- User hasn't played yet.
	if (mysql_num_rows($result) != 1)
		return false;
	
	list($uTotalSolutions) = mysql_fetch_row($result);

	// ------- Select the highest level they've achieved.
	$sql = "SELECT `level`
	FROM `achievements`
	WHERE `userID` = '$userID'
	AND `type` = 2
	ORDER BY `level` DESC
	LIMIT 1";
	$result = mysql_query($sql);
	// --------- No achievements yet?
	if (mysql_num_rows($result) == 1)
		list($aLevel) = mysql_fetch_row($result);
	else
		$aLevel = 0;
	
	$cm = getCareerMazesArray();

	//Is there a next level for this?
	$aNextLevel = $aLevel + 1;
	if (!isset($cm[$aNextLevel]))
		return false;
	list($required, $unlockType, $unlockValue, $unlockName) = $cm[$aNextLevel];
	
	if ($uTotalSolutions < $required)
		return false;

	$sql = "INSERT INTO `achievements`
	(`userID`, `type`, `level`)
	VALUES ('$userID', 2, '$aNextLevel')";
	mysql_query($sql);
	$aID = mysql_insert_id();
	
	// ------- User gets unlock.  (unlocks plural is possible here)
	$sql = "INSERT INTO `unlocks`
	(`userID`, `achievementID`, `type`, `subtype`, `name`, `value`)
	VALUES ('$userID', '$aID', '$unlockType', NULL, '$unlockName', '$unlockValue')";
	mysql_query($sql);
	return true;
}

//Challenges including the Tutorial.
function applyChallengeAchievements($userID, $challengeID, $mapID, $solution, $moves) {
	if ($challengeID == '1') {
		//echo 'challengeID'.$mapID;
		//echo 'moves'.$moves;
		if ($moves == 75 AND $mapID == 5) {
			//echo 'true story';
			// -------- Completed the tutorial!
			
			//have they already completed he tutorial?
			$sql = "SELECT `level`
			FROM `achievements`
			WHERE `userID` = '$userID'
			AND `type` = 32
			ORDER BY `level` DESC
			LIMIT 1";
			$result = mysql_query($sql);
			if (mysql_num_rows($result) == 1)
				return false;
				
			// -------- This is the first time they've completed the tutorial!
			$sql = "INSERT INTO `achievements`
			(`userID`, `type`, `level`)
			VALUES ('$userID', 32, '1')";
			mysql_query($sql);
			$aID = mysql_insert_id();
			
			// ------- User gets unlock.  (unlocks plural is possible here)
			$sql = "INSERT INTO `unlocks`
			(`userID`, `achievementID`, `type`, `subtype`, `name`, `value`)
			VALUES ('$userID', '$aID', '1', 0, 'Blue', '#4444ff')";
			mysql_query($sql);
			return true;
		}
	}
}

function applyAchievements($userID, $aType) {

	$amount = getAchievementCurrency($userID, $aType);
	
	$aLevel = getAchievementLevel($userID, $aType);
	
	$aArray = getAchievementsArray($aType);
	
	//Is there a next level for this?
	$aNextLevel = $aLevel + 1;
	if (!isset($aArray[$aNextLevel]))
		return false;
	list($required, $unlockType, $unlockValue, $unlockName, $unlockSubtype) = $aArray[$aNextLevel];
	if ($amount < $required)
		return false;

	$sql = "INSERT INTO `achievements`
	(`userID`, `type`, `level`)
	VALUES ('$userID', $aType, '$aNextLevel')";
	mysql_query($sql);
	$aID = mysql_insert_id();
	
	// ------- User gets unlock.  (TODO: unlocks plural is possible here)
	$sql = "INSERT INTO `unlocks`
	(`userID`, `achievementID`, `type`, `subtype`, `name`, `value`)
	VALUES ('$userID', '$aID', '$unlockType', '$unlockSubtype', '$unlockName', '$unlockValue')";
	mysql_query($sql);
	return true;

}

function getAchievementCurrency($userID, $aType) {

// 1, Total Moves										"Path Career"		//Backdated
// 2, Total Solutions (Total maps played)		"Mazes Career"		//Backdated
// 3, Tie Top-Score on a map						"Maze Mastery"		//Tracked (no backdate)
// 4, Rank#1 Win Top-Score on a map				"Wins"				//Tracked
	$r = 0;
	$sql = '';
	switch ($aType) {
		case 1:
			$sql = "SELECT 
			SUM(solutions.moves) as t
			FROM `solutions`
			WHERE userID = '$userID'";
		break;
		case 2:
			$sql = "SELECT 
			COUNT(*) as t
			FROM `solutions`
			WHERE userID = '$userID'";
		break;
		case 3:
			$sql = "SELECT 
			SUM(`value`) as t
			FROM `statistics`
			WHERE `userID` = '$userID'
			AND `type` IN (1, 2, 3, 4)";
		break;
		case 4:
			$sql = "SELECT 
			SUM(`value`) as t
			FROM `statistics`
			WHERE `userID` = '$userID'
			AND `type` IN (32, 33, 34, 35)";
		break;
	}
	if ($sql == '')
		return false;
	$result = mysql_query($sql);
	if (mysql_num_rows($result) == 1)
		list($r) = mysql_fetch_row($result);

	return $r;
}

function getAchievementLevel($userID, $aType) {
	// ------- Select the highest level they've achieved.
	$r = 0;
	$sql = "SELECT `level`
	FROM `achievements`
	WHERE `userID` = '$userID'
	AND `type` = '$aType'
	ORDER BY `level` DESC
	LIMIT 1";
	$result = mysql_query($sql);
	if (mysql_num_rows($result) == 1)
		list($r) = mysql_fetch_row($result);
	return $r;
}

function getAchievementsArray($type) {
	if ($type == 1)
		return getCareerPathArray();
	if ($type == 2)
		return getCareerMazesArray();
	if ($type == 3)
		return getMazeMasteryArray();	
	if ($type == 4)
		return getWinsArray();
	//Tutorial
	if ($type == 32) {
		$r[1] = array(1, 1, '#4444ff', 'Blue');
		return $r;
	}
	return array();
}

//TYPE 1
function getCareerPathArray() {
	//$cp[0] = array(requiredmoves, type, 'value', 'name');
	
	// Note that the description is followed by " wall color"
	$cp[1] = array(100, 1, '#229922', 'Green');
	$cp[2] = array(1000, 1, '#9922ff', 'Purple');
	$cp[3] = array(5000, 2, 'CircleSmall_W.png', 'Light Small Circle', 0);
	$cp[4] = array(10000, 2, 'DiamondSmall_B.png', 'Dark Small Diamond', 0);
	$cp[5] = array(20000, 3, '#a9b1f6', 'Steel Blue');
	$cp[6] = array(32000, 2, 'DiagonalCover_W.png', 'Light Diagonal Cover', 0);
	$cp[7] = array(50000, 2, 'DiamondLargeDonut_B_I.png', 'Inverted Dark Annulated Diamond', 0);
	$cp[8] = array(75000, 3, '#ffffaa', 'Yellow');
	$cp[9] = array(100000, 3, '#ffbb77', 'Orange');	
	$cp[10] = array(130000, 2, 'OffsetStripesVertical_W.png', 'Light Vertical Stripes', 0);
	$cp[11] = array(165000, 2, 'CircleSmall_B.png', 'Dark Small Circle', 0);
	$cp[12] = array(200000, 3, '#ee77ff', 'Purple');
	$cp[13] = array(250000, 1, '#ffff22', 'Yellow', 1);
	$cp[14] = array(300000, 2, 'DiagonalCover_B_I.png', 'Inverted Dark Diagonal Cover', 0);
	$cp[15] = array(350000, 1, '#333377', 'Navy Blue', 0);
	$cp[16] = array(400000, 2, 'RacingStripes_W.png', 'Light Racing Stripes', 0);

	return $cp;
}

//TYPE 2
function getCareerMazesArray() {
	//$cp[0] = array(requiredmazes, type, 'value', 'name');
	
	$cm[1] = array(5, 1, '#eeeeee', 'Silver', 1);
	$cm[2] = array(15, 1, '#ff9922', 'Orange', 1);
	$cm[3] = array(30, 2, 'DiamondLargeDonut_W.png', 'Light Annulated Diamond', 0);
	$cm[4] = array(50, 1, '#aaaa22', 'Chartreuse');
	$cm[5] = array(85, 2, 'CrossXL_W.png', 'Light Large Present', 0);
	$cm[6] = array(150, 1, '#cc22aa', 'Magenta', 0);
	$cm[7] = array(250, 1, '#ff3344', 'Red');
	$cm[8] = array(375, 1, '#ffdd88', 'Gold', 1);
	$cm[9] = array(550, 2, 'ConvexCover_W.png', 'Light Dome Cover', 0);
	$cm[10] = array(750, 2, 'OffsetStripesVertical_B.png', 'Dark Vertical Stripes', 0);
	$cm[11] = array(1000, 3, '#ff95b0', 'Pink');
	$cm[12] = array(1400, 1, '#ff95b0', 'Pink', 1);
	$cm[13] = array(2000, 2, 'StarsR_W.png', 'Bright Stars', 0);
	$cm[14] = array(2750, 2, 'Stars1_B.png', 'Dark Single Star', 0);
	$cm[15] = array(3500, 2, 'CircleSmall_B_I.png', 'Inverted Dark Small Circle', 0);
	
	return $cm;
}

//TYPE 3
function getMazeMasteryArray() {
	//$cp[0] = array(requiredmazestied, type, 'value', 'name');
	$r[1] = array(1, 2, 'OffsetStripesDiagonal_W.png', 'Light Diagonal Stripes', 0);
	$r[2] = array(5, 2, 'OffsetStripesVertical_B_I.png', 'Inverted Dark Vertical Stripes', 0);
	$r[3] = array(15, 2, 'DiagonalCover_W_I.png', 'Inverted Light Diagonal Cover', 0);
	$r[4] = array(30, 3, '#aafcbb', 'Green');
	$r[5] = array(50, 2, 'DiamondLarge_W.png', 'Light Large Diamond', 0);
	$r[6] = array(75, 2, 'CrossXL_B.png', 'Dark Large Present', 0);
	$r[7] = array(100, 2, 'CircleLargeDonut_W.png', 'Light Annulated Circle', 0);
	$r[8] = array(150, 2, 'CrossXL_W_I.png', 'Inverted Bright Large Present', 0);
	$r[9] = array(225, 2, 'CircleLarge_W_I.png', 'Inverted Bright Large Circle', 0);
	$r[10] = array(300, 2, 'DiamondSmall_B_I.png', 'Inverted Dark Small Diamond', 0);
	$r[11] = array(400, 2, 'CircleLargeDonut_B.png', 'Dark Annulated Circle', 0);
	$r[12] = array(550, 2, 'CrossXL_B_I.png', 'Inverted Dark Large Present', 0);
	
		//$cp[4] = array(10000, 2, 'DiamondSmall_B.png', 'Dark Small Diamond', 0);
	
	return $r;
}

//TYPE 4
function getWinsArray() {
	//$cp[0] = array(requiredmazewins, type, 'value', 'name');
	$r[1] = array(1, 2, 'DiagonalCover_B.png', 'Light Diagnol Cover', 0);
	$r[2] = array(5, 1, '#22aaaa', 'Teal');
	$r[3] = array(15, 2, 'OffsetStripesDiagonal_B.png', 'Dark Diagonal Stripes', 0);
	$r[4] = array(30, 2, 'DiamondLargeDonut_W_I.png', 'Inverted Light Annulated Diamond', 0);
	$r[5] = array(50, 2, 'StarsR_B.png', 'Dark Stars', 0);
	$r[6] = array(75, 2, 'OffsetStripesHorizontal_B_I.png', 'Inverted Dark Horizontal Stripes', 0);
	$r[7] = array(100, 2, 'CrossXLDonut_B_I.png', 'Inverted Dark Large Intersection', 0);
	$r[8] = array(150, 2, 'DiamondLarge_B.png', 'Dark Large Diamond', 0);
	$r[9] = array(225, 1, '#22ff22', 'Neon Lime', 1);
	//$r[7] = array(75, 2, 'CircleSmall_W_I.png', 'Inverted Bright Small Circle', 0);
		
	return $r;
}

//Used to track statistics on who wins or ties maps at the end of a day.
function trackMOTDstats($mapType) {
	// Our rather massive query to get the data we need.
	$sql = "SELECT 
		users.ID as userID,
		SUM(solutions.moves) as Moves,
		timediff(MAX(dateModified), maps.dateCreated) as Timetaken
	FROM `maps` 
	JOIN `solutions`
		ON maps.ID = solutions.mapID
	JOIN `users`
		ON solutions.userID = users.ID
	JOIN `mapOfTheDay`
		ON maps.ID = mapOfTheDay.mapID
	WHERE
		DATE_ADD(CURDATE(), INTERVAL -1 DAY) =	
		DATE_FORMAT(solutions.dateModified,'%Y-%m-%d')
		AND DATE_ADD(CURDATE(), INTERVAL -1 DAY) =	
		DATE_FORMAT(maps.dateCreated,'%Y-%m-%d')
		AND `mapType` = '$mapType'
	GROUP BY solutions.userID
	ORDER BY Moves DESC, MAX(dateModified) ASC
	";
	
	$mainResult = mysql_query($sql);
	if ($mainResult) {
		$first = true;
		while (list($userID, $uMoves, $uTimeTaken) = mysql_fetch_row($mainResult)) {
			//echo "$first : userID: $userID uMoves: $uMoves uTimeTaken: $uTimeTaken mapType: $mapType<br >";
			do {
				//If it's the rank #1 user, we need to repeat to also award him the tie stat.
				$repeatThis = false;
				$sType = $mapType;
				if ($first) {
					$bestMoves = $uMoves;
					$sType = 31 + $mapType;
					$repeatThis = true;
				}
				if ($uMoves == $bestMoves) {
					$sql = "SELECT `ID` FROM `statistics`
					WHERE `userID` = '$userID' AND `type` = '$sType'";
					$result = mysql_query($sql);
					
					if (mysql_num_rows($result) == 0) {
						$sql = "INSERT INTO `statistics` (`userID`, `type`, `value`)
						VALUES ('$userID', '$sType', 1)";
						$result = mysql_query($sql);
						if (!$result)
							return false;
					} else {
						$sql = "UPDATE `statistics` 
						SET `value` = `value` + 1
						WHERE `userID` = '$userID' AND `type` = '$sType'";
						$result = mysql_query($sql);
						if (!$result)
							return false;
					}
					
				} else {
					break 2;
				}
				$first = false;
			} while ($repeatThis);
		}
	}
	return true;
}



//Select Stats/Scores.
function getScores($mapid, $pageNumber = 1, $pageDivide = 10) {
	$top = $pageNumber * $pageDivide;
	$bottom = $top - $pageDivide;
	
	$pageRequest = 'all';
	
	if ($pageRequest == 'all') {
		$pageReqStart = 1;
		$pageReqEnd = 1000;
	} elseif (is_int($pageRequest)) {
		$pageReqStart = $pageRequest;
		$pageReqEnd = $pageRequest;
	} else {
		$tmp = explode($pageRequest, "-");
		$pageReqStart = $tmp[0];
		$pageReqEnd = $tmp[1];
	}
	
	$sql = "
	SELECT 
		timediff(solutions.dateModified, TIMESTAMP(CURDATE())) as diff,
		users.displayName as display,
		solutions.moves as moves,
		users.ID as ID,
		IfNull(userData.displayColor, '#cccccc') as displayColor,
		IfNull(userData.wallColor, '#666666') as wallColor,
		IfNull(userData.wallEmblem, 'blank.png') as wallEmblem,
		solutions.dateModified as cdate
	FROM 
		`users`
		JOIN `solutions`
			ON users.ID = solutions.userID
		LEFT JOIN `userData`
			ON users.ID = userData.userID
	WHERE solutions.mapID = '$mapid'
	ORDER BY solutions.moves DESC, solutions.dateModified ASC
	";
	$result = mysql_query($sql);
	//$utime = date("g:i A (T)");
	
	$output['updateTime'] = date("g:i A (T)");
	
	$i = 0;
	$foundUser = false;
	while ($row = mysql_fetch_assoc($result)) {
		$i++;

		$moves = $row['moves'];
		$userID = $row['ID'];
		if ($i == 1) {
			$bestMoves = $moves;
			$output['bestMoves'] = $bestMoves;
			$output['bestBy'] = $row['display'];
		}
			
		if ($_SESSION['userID'] == $userID) {
			$userPosition = $i;
		} else {
			if ($i > $top)
				continue;
			if ($i <= $bottom)
				continue;
		}

		if ($wallEmblem == '')
			$wallEmblem = 'blank.png';
		
		$cdate = $row['cdate'];
		$cdate = date("g:i A (T)", strtotime($cdate));
		
		$scoredDate = strtotime($row['cdate']);
		$secondsSinceScored = strtotime("now") - $scoredDate ;

		//Alternate background colors
		$background = '#262631';
		if ($i % 2 == 1)
			$background = '#20202a';
		
		if ($userPosition == $i) {
			$background = '#343c57';
			$foundUser = true;
		}
		
		$medal = 'none';
		if ($moves == $bestMoves)
			$medal = 'silver';
		if ($i == 1)
			$medal = 'gold';
		
		$output['users'][$i] = $row;
		$output['users'][$i]['scoredDate'] = $cdate;
		$output['users'][$i]['secondsSinceScored'] = $secondsSinceScored;
		$output['users'][$i]['background'] = $background;
		$output['users'][$i]['medal'] = $medal;
		$output['users'][$i]['isUser'] = $userPosition == $i;
		$output['users'][$i]['debug'] = "Bestmoves: $bestMoves moves: $moves";
	} // END WHILE

	if ($foundUser) {
		$userPage = ceil(($userPosition / $pageDivide));
		$output['userPage'] = $userPage;
		$output['userPosition'] = $userPosition;
	}
	
	$output['pageCount'] = ceil(($i / $pageDivide));
	
	if ($prevPage > 0) {
		$navi .= " <a href='javascript:scoresShowPage($mapid, 1);'>&lt;&lt;</a> ";
		$navi .= " <a href='javascript:scoresShowPage($mapid, $prevPage);'>&lt;</a> ";
	} else {
		$navi .= " &lt;&lt; ";
		$navi .= " &lt;";
	}
	for ($x = 1; $x <= $pageCount; $x++) {
		if ($x < $pageNumber - 3 OR $x > $pageNumber + 3)
			continue;
		if ($x == $pageNumber)
			$navi .= "<strong> $x </strong>";
		elseif ($userPage == $x)
			$navi .= " <a href='javascript:scoresShowPage($mapid, $x)'><i>$x</i></a> ";
		else 
			$navi .= " <a href='javascript:scoresShowPage($mapid, $x)'>$x</a> ";
	}
	if ($nextPage <= $pageCount) {
		$navi .= " <a href='javascript:scoresShowPage($mapid, $nextPage);'>&gt;</a> ";
		$navi .= " <a href='javascript:scoresShowPage($mapid, $pageCount);'>&gt;&gt;</a> ";
	}

	return $output;
}





?>