diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-15 22:36:27 -0600 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-15 22:36:27 -0600 |
| commit | 3990b65956331263b0963f695ddc88b4c3356af0 (patch) | |
| tree | 5a6c3c84f201c054437f056c6b13372becea260f /pages | |
| parent | c7d671712a9d5f90752475960c3a602aeb0da8d0 (diff) | |
| download | pathery-3990b65956331263b0963f695ddc88b4c3356af0.tar.xz | |
Added totalMoves and totalMazes to users; and isTiedForHighScore to solutions (for convenience)
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,
|