diff options
| -rw-r--r-- | pages/memberlist.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/pages/memberlist.php b/pages/memberlist.php index a250cb6..9c0f3ce 100644 --- a/pages/memberlist.php +++ b/pages/memberlist.php @@ -57,7 +57,7 @@ $sql = "SELECT (SELECT SUM(moves) FROM solutions WHERE solutions.userID = users.ID) AS totalMoves,
(SELECT SUM(moves) FROM solutions
WHERE solutions.userID = users.ID AND
- YEARweek(solutions.dateModified) = YEARweek(CURRENT_DATE)) AS totalMovesThisWeek,
+ solutions.dateModified BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) AND CURRENT_DATE) AS totalMovesThisWeek,
(SELECT COUNT(*) FROM solutions WHERE solutions.userID = users.ID) AS totalMazes,
SUM(CASE WHEN statistics.type IN (32, 33, 34, 35) THEN statistics.value ELSE 0 END) as totalWins,
SUM(CASE WHEN statistics.type IN (1, 2, 3, 4) THEN statistics.value ELSE 0 END) as totalTies,
@@ -87,7 +87,7 @@ $cat['Moves']['c'] = 'totalMoves'; $cat['Moves']['title'] = 'Total Moves Mazed';
$cat['This Week']['c'] = 'totalMovesThisWeek';
-$cat['This Week']['title'] = 'Total Moves Mazed This Week (Starting Monday)';
+$cat['This Week']['title'] = 'Total Moves In Past 7 Days (Excluding Today)';
$cat['Wins']['c'] = 'totalWins';
$cat['Wins']['title'] = 'Total Wins (Champion)';
|