From 9b0b31db4eb2eddd674366cc79228cd66fb0b1bb Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Wed, 13 Mar 2013 17:41:35 -0700 Subject: Fix 'Perfect Days' SUM not COUNT isTiedForHighScore --- includes/datas.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/datas.php b/includes/datas.php index 83399c7..d79e3ae 100644 --- a/includes/datas.php +++ b/includes/datas.php @@ -553,7 +553,7 @@ function getAchievementCurrency($userID, $aType) { IN ( 1, 2, 3, 4 ) AND solutions.userID = '$userID' GROUP BY solutions.userID, mapOfTheDay.mapDate - HAVING COUNT( isTiedForHighScore ) = 4"; + HAVING SUM( isTiedForHighScore ) = 4"; $result = mysql_query($sql) OR die("SQL query failed; $sql"); return mysql_num_rows($result); break; -- cgit v1.2.3