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 d75982e..6eef960 100644 --- a/pages/memberlist.php +++ b/pages/memberlist.php @@ -54,11 +54,11 @@ if (isset($_GET['o'])) { $sql = "SELECT
users.ID,
users.displayName,
- (SELECT SUM(moves) FROM solutions WHERE solutions.userID = users.ID) AS totalMoves,
+ (SELECT SUM(moves) FROM solutions WHERE solutions.userID = users.ID AND solutions.dateModified < CURRENT_DATE) AS totalMoves,
(SELECT SUM(moves) FROM solutions
WHERE solutions.userID = users.ID AND
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,
+ (SELECT COUNT(*) FROM solutions WHERE solutions.userID = users.ID AND solutions.dateModified < CURRENT_DATE) 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,
IfNull(userData.wallColor, '#666666') as wallColor,
|