From 3990b65956331263b0963f695ddc88b4c3356af0 Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Tue, 15 Jan 2013 22:36:27 -0600 Subject: Added totalMoves and totalMazes to users; and isTiedForHighScore to solutions (for convenience) --- pages/achievements.php | 4 ++-- pages/memberlist.php | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) (limited to 'pages') 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, -- cgit v1.2.3