diff options
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 2fa2cdc..038b023 100644 --- a/pages/memberlist.php +++ b/pages/memberlist.php @@ -110,11 +110,11 @@ exit; $sql = "SELECT
users.ID,
users.displayName,
- (SELECT SUM(moves) FROM solutions WHERE solutions.userID = users.ID AND solutions.dateModified < CURRENT_DATE) AS totalMoves,
+ users.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 AND solutions.dateModified < CURRENT_DATE) AS totalMazes,
+ users.totalMazes,
users.totalWins,
users.totalTies,
IfNull(userData.wallColor, '#666666') as wallColor,
|