From b4b135a91ee29a31fde39fd6792fe680bf0324d8 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Thu, 11 Dec 2008 19:32:58 -0800 Subject: [PATCH] NEW FEATURE: added a statistic that shows how fast people respond only uses the difference of timesstamps when you don't play the first card of a trick --- include/stats.php | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/include/stats.php b/include/stats.php index 83c11ad..dad254c 100644 --- a/include/stats.php +++ b/include/stats.php @@ -207,6 +207,21 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) array_unshift($result,array("Name","Number of active games")); echo output_table($result,"Active games","stats"); + /* respones by user*/ + $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, ". + " COUNT(*) as na ". + "FROM Play P1 ". + "LEFT JOIN Hand_Card ON P1.hand_card_id=Hand_Card.id ". + "LEFT JOIN Hand ON Hand.id=Hand_Card.hand_id ". + "LEFT JOIN User ON Hand.user_id=User.id ". + "GROUP BY user_id ". + "HAVING na>8 ". + "ORDER BY a " ); + array_unshift($result,array("Name","Average minutes before respond","NR")); + echo output_table($result,"Response","stats"); + /* does the party win more often if they start -- 2.17.1