Achievements fixes.

 Fixed bug where userData row didn't exist for the user;
 Added image for the achievements.

5 files changed, 38 insertions, 21 deletions

diff --git a/images/Achievement_MazeCareer.png b/images/Achievement_MazeCareer.png
new file mode 100644
index 0000000..b04fefa
--- /dev/null
+++ b/images/Achievement_MazeCareer.png
diff --git a/images/Achievement_PathCareer.png b/images/Achievement_PathCareer.png
new file mode 100644
index 0000000..37559f0
--- /dev/null
+++ b/images/Achievement_PathCareer.png
diff --git a/images/MedalGoldCAR.png b/images/MedalGoldCAR.png
new file mode 100644
index 0000000..75e7f26
--- /dev/null
+++ b/images/MedalGoldCAR.png
diff --git a/images/MedalSilverCAR.png b/images/MedalSilverCAR.png
new file mode 100644
index 0000000..daf46ff
--- /dev/null
+++ b/images/MedalSilverCAR.png
diff --git a/pages/achievements.php b/pages/achievements.php
index 76d993d..1d81220 100644
--- a/pages/achievements.php
+++ b/pages/achievements.php
@@ -224,6 +224,17 @@ if ($result) {
 

 //Validate selection and then update.

 if (isset($_POST['doupdate']) AND !$viewer) {

+

+	// Ensure the user is located in userData.

+	$sql = "SELECT * FROM `userData`

+	WHERE `userID` = '$userID'";

+	$result = mysql_query($sql);

+	if (mysql_num_rows($result) == 0) {

+		$sql = "INSERT INTO `userData` (`userID`, `displayColor`, `wallColor`)

+		VALUES ('$userID', '#cccccc', '#666666')";

+		mysql_query($sql);

+	}

+

 	//print_R($unlocks);

 	$unlockIDC = $_POST['selectColorID'];

 	$unlockColor = $unlocks[1][$unlockIDC]['value'];

@@ -246,41 +257,48 @@ if (isset($_POST['doupdate']) AND !$viewer) {
 		SET `wallColor` = '$unlockColor'

 		WHERE `userID` = '$userID'";

 		$result = mysql_query($sql);

-		if (!$result) 

+		if (!$result) {

 			echo "Error updating wall color";

+			$data = array();

+			$data['error'] = "Error when updating wall color";

+			$data['session'] = print_r($_SESSION, true);

+			$data['post'] = print_r($_POST, true);

+			EmailError($data);

+		}

 	} 

 	if ($unlockEmblem == $_POST['selectEmblem']) {

 		$sql = "UPDATE `userData` 

 		SET `wallEmblem` = '$unlockEmblem'

 		WHERE `userID` = '$userID'";

 		$result = mysql_query($sql);

-		if (!$result) 

-			echo "Error updating Emblem";

+		if (!$result) {

+			echo "Error updating wall color";

+			$data = array();

+			$data['error'] = "Error when updating wall color";

+			$data['session'] = print_r($_SESSION, true);

+			$data['post'] = print_r($_POST, true);

+			EmailError($data);

+		}

+			

 	} 

 	if ($unlockNameColor == $_POST['selectNameColor']) {

 		$sql = "UPDATE `userData` 

 		SET `displayColor` = '$unlockNameColor'

 		WHERE `userID` = '$userID'";

 		$result = mysql_query($sql);

-		if (!$result) 

-			echo "Error updating Username Display Color";

+		if (!$result) {

+			echo "Error updating wall color";

+			$data = array();

+			$data['error'] = "Error when updating wall color";

+			$data['session'] = print_r($_SESSION, true);

+			$data['post'] = print_r($_POST, true);

+			EmailError($data);

+		}

 	} 

-

 }

 

-

 $achievements = array();

 

-//Depreciated

-$sql = "

-SELECT 

-	type,

-	MAX(level) as level,

-	 MAX(dateCompleted)

-FROM `achievements` 

-WHERE userID = '$userID' 

-GROUP BY `type`";

-

 

 //Fetch data

 

@@ -478,8 +496,8 @@ foreach($achievements as $aType => $a) {
 	$uCurrent = $uStats[$aType];

 	$nUCurrent = number_format($uCurrent);

 	

-	$aTypeNames[1] = "Path Career Level $aLevel!";

-	$aTypeNames[2] = "Mazes Career Level $aLevel!";

+	$aTypeNames[1] = "<img src='../images/Achievement_PathCareer.png' style='width:36px;height:36px;vertical-align:middle'>Path Career Level $aLevel!";

+	$aTypeNames[2] = "<img src='../images/Achievement_MazeCareer.png' style='width:36px;height:36px;vertical-align:middle'>Mazes Career Level $aLevel!";

 	$aTypeNames[3] = "<img src='../images/MedalSilverCAR.png' style='width:36px;height:36px;vertical-align:middle'>Maze Mastery Level $aLevel!";

 	$aTypeNames[4] = "<img src='../images/MedalGoldCAR.png' style='width:36px;height:36px;vertical-align:middle'>Champion Level $aLevel!";

 	$aTypeNames[32] = 'Tutorial Complete!';

@@ -500,11 +518,10 @@ foreach($achievements as $aType => $a) {
 	$lastlevel = true;

 	foreach ($CPD as $item) {

 		list($required, $unlockType, $unlockValue, $unlockName) = $item;

-		

 

 		if ($debug)

 			echo "At $required: <table>".displayUnlock($unlockType, $unlockValue, $unlockName)."</table>";

-		

+

 		$nRequired = number_format($required);

 		if ($required > $uCurrent) {

 			$lastlevel = false;