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/memberlist.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'pages/memberlist.php') 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