From 2ce5e3800ff764870c93038d0c5ed35181225a52 Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Mon, 10 Sep 2012 17:47:37 -0500 Subject: Doesn't make sense that some of the items don't count today's and others do --- pages/memberlist.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'pages') diff --git a/pages/memberlist.php b/pages/memberlist.php index d75982e..6eef960 100644 --- a/pages/memberlist.php +++ b/pages/memberlist.php @@ -54,11 +54,11 @@ if (isset($_GET['o'])) { $sql = "SELECT users.ID, users.displayName, - (SELECT SUM(moves) FROM solutions WHERE solutions.userID = users.ID) AS totalMoves, + (SELECT SUM(moves) FROM solutions WHERE solutions.userID = users.ID AND solutions.dateModified < CURRENT_DATE) AS 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) AS totalMazes, + (SELECT COUNT(*) FROM solutions WHERE solutions.userID = users.ID AND solutions.dateModified < CURRENT_DATE) AS totalMazes, SUM(CASE WHEN statistics.type IN (32, 33, 34, 35) THEN statistics.value ELSE 0 END) as totalWins, SUM(CASE WHEN statistics.type IN (1, 2, 3, 4) THEN statistics.value ELSE 0 END) as totalTies, IfNull(userData.wallColor, '#666666') as wallColor, -- cgit v1.2.3