diff options
| author | Patrick Davison <snapwilliam@gmail.com> | 2012-08-18 00:24:38 -0700 |
|---|---|---|
| committer | Patrick Davison <snapwilliam@gmail.com> | 2012-08-18 00:24:38 -0700 |
| commit | 6206e6f71133e1266275c7309134bb7f876ea85e (patch) | |
| tree | ba75d3f1ff427dabf6a4e40383668e04ea76b1d0 /pages/memberlist.php | |
| parent | 748a984d7e914d2211175d95e564c6f56e566f6e (diff) | |
| parent | 02f4ef27a6fbe478588cedae28f9d9001756ab38 (diff) | |
| download | pathery-6206e6f71133e1266275c7309134bb7f876ea85e.tar.xz | |
Merge branch 'HEAD' of ssh://git@git.raylu.net/pathery
Diffstat (limited to 'pages/memberlist.php')
| -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)';
|