From cf4af138b16da878404cf3319d5d988dacee198a Mon Sep 17 00:00:00 2001
From: raylu <raylu@mixpanel.com>
Date: Sat, 5 Nov 2011 03:04:49 -0700
Subject: new layout

---
 includes/datas.php | 53 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 file changed, 52 insertions(+), 1 deletion(-)

(limited to 'includes/datas.php')

diff --git a/includes/datas.php b/includes/datas.php
index 0d3d0c5..912eea8 100644
--- a/includes/datas.php
+++ b/includes/datas.php
@@ -1 +1,52 @@
-<?PHP
// For interaction with the SQL database.
//

include_once('db.inc.php');

//Select Stats/Scores.
function topScores($mapid, $top = 5) {
	$sql = "
	SELECT 
		timediff(solutions.dateModified, TIMESTAMP(CURDATE())) as diff,
		users.displayName as display,
		solutions.moves as m,
		users.ID as ID
	FROM 
		`users`
		JOIN `solutions`
			ON users.ID = solutions.userID
	WHERE solutions.mapID = '$mapid'
	ORDER BY solutions.moves DESC, solutions.dateModified ASC
	LIMIT $top
	";
	$result = mysql_query($sql);

	if (mysql_num_rows($result) > 0) {
		$output .= "<table style='border:1px solid #FFF'>";
		$output .= "<tr>";
		$output .= "<th style='border:1px solid #ccc'>Rank</th>";
		$output .= "<th style='border:1px solid #ccc'>Name</th>";
		$output .= "<th style='border:1px solid #ccc'>Moves</th>";
		$output .= "<th style='border:1px solid #ccc'>Time taken</th>";
		$output .= "</tr>";
		while (list($diff, $display, $moves, $userID) = mysql_fetch_row($result)) {
			$i++;
			if ($_SESSION['userID'] == $userID)
				$output .= "<tr style='background-color: #338899;'>";
			else
				$output .= "<tr>";
			
			$output .= "<td>$i</td>";
			$output .= "<td><span title='UserID: $userID'>$display</span></td>";
			$output .= "<td>$moves</td>";
			$output .= "<td>$diff</td>";
			//$output .= "<b>$i. <span title='UserID: $userID'>$display</span> with $moves moves. In $diff<br /></b>";
			$output .= "</tr>";
		}
		$output .= "</table>";
	}
	return $output;
}





?>
\ No newline at end of file
+<?PHP
+// For interaction with the SQL database.
+//
+
+include_once('db.inc.php');
+
+//Select Stats/Scores.
+function topScores($mapid, $top = 5) {
+	$sql = "
+	SELECT 
+		timediff(solutions.dateModified, TIMESTAMP(CURDATE())) as diff,
+		users.displayName as display,
+		solutions.moves as m,
+		users.ID as ID
+	FROM 
+		`users`
+		JOIN `solutions`
+			ON users.ID = solutions.userID
+	WHERE solutions.mapID = '$mapid'
+	ORDER BY solutions.moves DESC, solutions.dateModified ASC
+	LIMIT $top
+	";
+	$result = mysql_query($sql);
+
+	if (mysql_num_rows($result) > 0) {
+		$output .= "<table class='score'>";
+		$output .= "<tr>";
+		$output .= "<th>Rank</th>";
+		$output .= "<th>Name</th>";
+		$output .= "<th>Moves</th>";
+		$output .= "<th>Time taken</th>";
+		$output .= "</tr>";
+		while (list($diff, $display, $moves, $userID) = mysql_fetch_row($result)) {
+			$i++;
+			if ($_SESSION['userID'] == $userID)
+				$output .= "<tr style='background-color: #356;'>";
+			else
+				$output .= "<tr>";
+			
+			$output .= "<td>$i</td>";
+			$output .= "<td><span title='UserID: $userID'>$display</span></td>";
+			$output .= "<td>$moves</td>";
+			$output .= "<td>$diff</td>";
+			//$output .= "<b>$i. <span title='UserID: $userID'>$display</span> with $moves moves. In $diff<br /></b>";
+			$output .= "</tr>";
+		}
+		$output .= "</table>";
+	}
+	return $output;
+}
+
+?>
-- 
cgit v1.2.3