X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fdb.php;h=2cc94e97497ec2a904de2655f2ef684d4947760a;hp=b7c6f707fd2c8abf786589def567346bc3bc6a01;hb=53d9b086ef0b8a5e210a5713dcd944c16bd39bc8;hpb=1c3c341f53ce5de7e9d4bcc63e43a925faec3f48

diff --git a/include/db.php b/include/db.php
index b7c6f70..2cc94e9 100644
--- a/include/db.php
+++ b/include/db.php
@@ -877,10 +877,9 @@ function DB_format_gameid($gameid)
   $session = DB_get_session_by_gameid($gameid);
 
   /* get number of game */
-  $r = DB_query_array("SELECT COUNT(*),create_date FROM Game".
-		      " WHERE session='$session' ".
-		      " AND TIMEDIFF(create_date, (SELECT create_date FROM Game WHERE id='$gameid'))<=0 ".
-		      " GROUP by session");
+  $r = DB_query_array("SELECT SUM(TIME_TO_SEC(TIMEDIFF(create_date, (SELECT create_date FROM Game WHERE id='$gameid')))<=0) ".
+		      " FROM Game".
+		      " WHERE session='$session' ");
   return $session.".".$r[0];
 }