From 48b59dd1be231cc8c1ac94b9fd51193cef270970 Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Sat, 23 Mar 2013 21:05:44 -0500
Subject: BUGFIX: Dates before the first Ultra Complex show the first Ultra
 Complex on the scores page

---
 ajax/maps.ajax.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'ajax')

diff --git a/ajax/maps.ajax.php b/ajax/maps.ajax.php
index 8ceade5..25fbbf8 100644
--- a/ajax/maps.ajax.php
+++ b/ajax/maps.ajax.php
@@ -60,12 +60,13 @@ function getMapIDsByDate($date) {
 		SELECT mapType, MIN(mapExpireTime) AS mapExpireTime
 		FROM mapOfTheDay
 		WHERE mapExpireTime > ?
+		AND mapDate <= ?
 		GROUP BY mapType
 	) AS expireTimes ON mapOfTheDay.mapType = expireTimes.mapType
 							AND mapOfTheDay.mapExpireTime = expireTimes.mapExpireTime
 	GROUP BY mapOfTheDay.mapType";
 	$stmt = $mysqli->prepare($sql);
-	$stmt->bind_param("s", $date);
+	$stmt->bind_param("ss", $date, $date);
 	$stmt->execute();
 	$stmt->bind_result($mapID);
 	while ($stmt->fetch()) {
-- 
cgit v1.2.3