Created remanants of a challenge page (loaded completely from the database). Kept the old challenge page, because Snap will probably want to reuse the Javascript.

1 files changed, 56 insertions, 1 deletions

diff --git a/includes/datas.php b/includes/datas.php
index 61c8b93..170f74e 100644
--- a/includes/datas.php
+++ b/includes/datas.php
@@ -723,7 +723,62 @@ function getScores($mapid, $pageNumber = 1, $pageDivide = 10) {
 }
 
 
+/**
+ * Returns true if the given user has completed the tutorial, false otherwise
+ */
+function hasCompletedTutorial($userID) {
+	$sql = "SELECT * FROM `achievements` 
+	WHERE `type` = 32 AND `userID` = '$userID'";
+	$result = mysql_query($sql);
+	return (mysql_num_rows($result) >= 1);
+}
 
+/**
+ * Returns a MySQL resultset for all challenges for the given mapID
+ * @param $mapIdUnsanitized The mapID to load.  Assumed to be unsanitized.
+ * @param $userID The userID.  Assumed to be unsanitized
+ * @return Returns a MySQL resultset with the columns listed in the code, or NULL if nothing found
+ */
+function loadChallengesForMap($mapIdUnsanitized, $userIdUnsanitized)
+{
+	$mapID = mysql_escape_string($mapIdUnsanitized);
+	$userID = mysql_escape_string($userIdUnsanitized);
+	$sql = "
+	SELECT challenges.ID AS challengeID, challenges.inequality, challenges.goal, challenges.hint,
+		challenges.restrictWallCount, challenges.restrictWallPlacement, challenges.restrictTeleportCount,
+		challenges.restrictTeleportsUsed, challenges.restrictStartPoint, challenges.restrictEndPoint,
+		challengeSolutions.dateSolved
+	FROM challenges
+	LEFT JOIN challengeSolutions ON challenges.ID = challengeSolutions.challengeID AND challengeSolutions.userID = '$userID'
+	WHERE challenges.mapID = '$mapID' AND challenges.enabled = 1
+	";
+	
+	$result = mysql_query($sql);
+	echo mysql_error();
+	if (mysql_num_rows($result) >= 1)
+		return $result;
+	return NULL;
+}
 
-
+/**
+ * Returns the map "code" for the given mapId
+ */
+function loadMapCode($mapIdUnsanitized)
+{
+	$mapID = mysql_escape_string($mapIdUnsanitized);
+	$sql = "
+	SELECT maps.code as code
+	FROM maps
+	WHERE ID = '$mapID' AND isChallenge = 1
+	LIMIT 1
+	";
+	
+	$result = mysql_query($sql);
+	if (mysql_num_rows($result) >= 1)
+	{
+		$temp = mysql_fetch_row($result);
+		return $temp[0];
+	}
+	return NULL;
+}
 ?>