X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fstats.php;h=fb56df8243413c0f4768789c0e133d03301a6328;hp=1e6a033ea5986fca7bd4a11610cdb7b2118aef33;hb=76ce476d3c48709bf6a69b3cc5bd333c4593d66b;hpb=5edd63b115fe7712c6e220fc6a0b78dbace4f3cd diff --git a/include/stats.php b/include/stats.php index 1e6a033..fb56df8 100644 --- a/include/stats.php +++ b/include/stats.php @@ -1,4 +1,23 @@ + * + * This file is part of e-DoKo. + * + * e-DoKo is free software: you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * e-DoKo is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with e-DoKo. If not, see . + * + */ + /* make sure that we are not called from outside the scripts, * use a variable defined in config.php to check this */ @@ -190,7 +209,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"));