0) { list($map) = mysql_fetch_row($result); return $map; } } function getChallengesByTier($userIdUnsanitized) { include_once('../includes/sqlEmbedded.php'); $userID = mysql_escape_string($userIdUnsanitized); $sql = "SELECT challengeMaps.ID AS challengeMapID, challengeMaps.challengeTier, challengeMaps.name AS name, challengeSolutions.dateSolved, challengeSolutions.challengeID AS challengeID, challengeMaps.challengeSuborder, challenges.ordering, challengeMaps.code as mapCode FROM challenges INNER JOIN challengeMaps ON challenges.mapID = challengeMaps.ID LEFT JOIN challengeSolutions ON challenges.ID = challengeSolutions.challengeID AND challengeSolutions.userID = '$userID' WHERE challenges.enabled = 1 AND challengeMaps.challengeTier <= (SELECT challengeTier FROM users WHERE ID = '$userID' LIMIT 1) OR 1 ORDER BY challengeMaps.challengeTier, challengeMaps.challengeSuborder, challenges.ordering"; $result = mysql_query($sql) OR die(mysql_error()."SQL: $sql"); if (mysql_num_rows($result) >= 1) { while($data = mysql_fetch_array($result)) { //echo $data['challengeMapID']; $tier = $data['challengeTier']; $challengeSuborder = $data['challengeSuborder']; $ordering = $data['ordering']; $challenges[$tier][$challengeSuborder][$ordering] = $data; //$data['mapObject'] = $challenge; $challengeMapID = $data['challengeMapID']; $challengeID = $data['challengeID']; $mapObj = new map($data['mapCode']); $mapObj->ID = $challengeMapID; $layer[$data['challengeMapID']][$challengeID] = $data; $layer[$data['challengeMapID']]['mapObject'] = $mapObj; //$layer[] = $data; } echo json_encode($layer); } return NULL; } ?>