diff options
Diffstat (limited to 'pages')
| -rw-r--r-- | pages/achievements.php | 4 | ||||
| -rw-r--r-- | pages/memberlist.php | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/pages/achievements.php b/pages/achievements.php index 6dbabe7..e3f9e8d 100644 --- a/pages/achievements.php +++ b/pages/achievements.php @@ -328,8 +328,8 @@ $sql = " SELECT
users.displayName,
users.isAdmin,
- SUM(solutions.moves) as totalMoves,
- COUNT(*) as totalSolutions,
+ users.totalMoves,
+ users.totalMazes AS totalSolutions,
IfNull(userData.wallColor, '#666666'),
IfNull(userData.displayColor, '#cccccc'),
userData.wallEmblem
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,
|