From: Arun Persaud Date: Thu, 18 Sep 2008 05:46:05 +0000 (-0700) Subject: BUGFIX: solo statistics didn't include silent solo X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=commitdiff_plain;h=3951e6e5eb8e8960dad01e5acb14a9c83aca1dce BUGFIX: solo statistics didn't include silent solo include silent solo in the solo statistics (number of solo/game) Signed-off-by: Arun Persaud --- diff --git a/include/stats.php b/include/stats.php index d372e4a..095296e 100644 --- a/include/stats.php +++ b/include/stats.php @@ -189,7 +189,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) " FROM Game ". " LEFT JOIN Hand ON Hand.position=startplayer AND Game.id=Hand.game_id ". " LEFT JOIN User ON User.id=Hand.user_id ". - " WHERE type='solo' AND Game.solo<>'silent' AND Game.status='gameover' ". + " WHERE type='solo' AND Game.status='gameover' ". " GROUP BY user_id ". " ORDER BY c DESC;"); array_unshift($result,array("Name","Number of solos","Solos/game"));