From c16f64c46dca50d0c66e52f6d2ecb70f91bdd65e Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Tue, 15 Jan 2013 01:05:08 -0600
Subject: BUGFIX: Ties not displaying correctly on the achievements page

---
 includes/datas.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/includes/datas.php b/includes/datas.php
index 66c816b..cdaf0c8 100644
--- a/includes/datas.php
+++ b/includes/datas.php
@@ -574,7 +574,7 @@ function getAchievementCurrency($userID, $aType) {
 		case 3:
 			$sql = "SELECT totalTies
 			FROM `users`
-			WHERE `userID` = '$userID'";
+			WHERE `ID` = '$userID'";
 		break;
 		case 4:
 			$sql = "SELECT championPoints
-- 
cgit v1.2.3


From a6dd38b8debc789769fffd5c053d04bc888dcbbb Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Tue, 15 Jan 2013 01:05:26 -0600
Subject: BUGFIX: Updating high scores going super SUPER slow

---
 includes/playerStats.php | 25 ++++++++++---------------
 1 file changed, 10 insertions(+), 15 deletions(-)

diff --git a/includes/playerStats.php b/includes/playerStats.php
index b302812..ec9a616 100644
--- a/includes/playerStats.php
+++ b/includes/playerStats.php
@@ -18,22 +18,17 @@ function setIsHighScoreFlag($fromDate)
 	$fromDate =  mysql_escape_string($fromDate);
 	
 	$sql = "
-	UPDATE solutions
-	SET solutions.isHighScore = 1
-	WHERE solutions.ID IN
+	UPDATE solutions AS s1
+	SET s1.isHighScore = 1
+	WHERE s1.dateModified < CURDATE()
+	AND s1.dateModified >= '$fromDate'
+	AND s1.ID =
 	(
 		SELECT s2.ID
-		FROM (SELECT * FROM solutions) AS s2
-		INNER JOIN mapOfTheDay ON s2.mapID = mapOfTheDay.mapID
-		WHERE s2.ID =
-		(
-			SELECT s3.ID
-			FROM (SELECT * FROM solutions) AS s3
-			WHERE s3.mapID = s2.mapID
-			ORDER BY moves DESC, dateModified ASC
-			LIMIT 1
-		)
-		AND mapOfTheDay.mapDate >= '$fromDate'
+		FROM (SELECT ID, mapID, moves, dateModified FROM solutions) AS s2
+		WHERE s2.mapID = s1.mapID
+		ORDER BY moves DESC, dateModified ASC
+		LIMIT 1
 	)
 	";
 	
@@ -150,7 +145,7 @@ function addPlayerChampionPointsForMapsOfTheDay($fromDate)
 		AND mapOfTheDay.mapDate < CURDATE()
 	)
 	WHERE solutions.dateModified >= $fromDate;
-	AND mapOfTheDay.mapDate < CURDATE()
+	AND solutions.dateModified < CURDATE()
 	";
 	
 	$sql4 = "
-- 
cgit v1.2.3


From 4617f928718883862000aedc6c915e9161bfb35f Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Tue, 15 Jan 2013 01:06:04 -0600
Subject: Adding a file containing all database changes made (since copying
 Snap's DB)

---
 db updates.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 db updates.sql

diff --git a/db updates.sql b/db updates.sql
new file mode 100644
index 0000000..e038771
--- /dev/null
+++ b/db updates.sql	
@@ -0,0 +1,5 @@
+ALTER TABLE `db428221563`.`mapOfTheDay` DROP INDEX `UniqueTypeDate` ,
+ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` ) 
+
+ALTER TABLE `mapOfTheDay` ADD `championPointsWorth` INT NOT NULL DEFAULT '0'
+
-- 
cgit v1.2.3