NEW FEATURE: provide an RSS feed for each user showing in which games it's his turn

[e-DoKo.git] / include / stats.php

diff --git a/include/stats.php b/include/stats.php
index 1e6a033ea5986fca7bd4a11610cdb7b2118aef33..f450880afde6ae302592b4b44b30330d413916a0 100644 (file)
--- a/include/stats.php
+++ b/include/stats.php
@@ -190,7 +190,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) )
                               " FROM Hand".
                               " LEFT JOIN User ON User.id=user_id".
                               " LEFT JOIN Game ON Game.id=game_id".
-                              " WHERE Game.status<>'gameover'".
+                              " WHERE Game.status IN ('pre','play')".
                               " GROUP BY user_id".
                               " ORDER BY c DESC LIMIT 7" );
   array_unshift($result,array("Name","Number of active games"));