array_unshift($result,array("Name","Number of active games"));
echo output_table($result,"Active games","stats");
- /* respones by user*/
+ /* response time of users*/
$result = DB_query_array_all("SELECT User.fullname,".
"IFNULL(AVG(if(P1.sequence in (2,3,4),".
"-timestampdiff(MINUTE,mod_date,(select mod_date from Play P2 where P1.trick_id=P2.trick_id and P2.sequence=P1.sequence-1)),NULL )),1e9) as a, ".
"GROUP BY user_id ".
"HAVING na>8 ".
"ORDER BY a " );
- array_unshift($result,array("Name","Average minutes before respond","NR"));
+ array_unshift($result,array("Name","Average minutes before response","trick count"));
echo output_table($result,"Response","stats");
/*