diff options
Diffstat (limited to 'includes/playerStats.php')
| -rw-r--r-- | includes/playerStats.php | 25 |
1 files 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 = " |