echo "<p>The contra party wins in ";
$result = DB_query("SELECT COUNT(*) from Score".
- " LEFT JOIN Game ON Game.id=game_id".
- " WHERE score='againstqueens'".
- " AND Game.status='gameover'");
+ " WHERE score='againstqueens'");
while( $r = DB_fetch_array($result))
echo $r[0];
echo " games.</p>\n";
array_unshift($result,array("Position","Number of tricks"));
echo output_table($result,"Tricks at the table","stats");
- /* most games */
- $result = DB_query_array_all("SELECT fullname, COUNT(*) as c " .
- " FROM Hand".
- " LEFT JOIN User ON User.id=user_id".
- " GROUP BY user_id".
- " ORDER BY c DESC LIMIT 7" );
- array_unshift($result,array("Name","Number of games"));
- echo output_table($result,"Most games","stats");
-
/* most solos */
$result = DB_query_array_all("SELECT fullname as fname,".
" COUNT(*), ".
" 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"));
echo output_table($result,"Active games","stats");
+ /* 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, ".
+ " 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 response","trick count"));
+ echo output_table($result,"Response","stats");
+
/*
does the party win more often if they start
echo " games</p>\n";
*/
$result = generate_global_score_table();
- array_unshift($result,array("Name","Average score per game"));
- echo output_table($result,"Points per game","stats");
+ array_unshift($result,array("Name","Average score per game","Total Points","Number of games"));
+ echo output_table($result,"Points per game (need more than 10 games)","stats","ScoreTable");
/*
- how often is the last trick a non-trump trick
- */
+ * how often is the last trick a non-trump trick
+ */
/* needs this so that all tables are within the div and don't float around */
echo "<p style=\"clear:both;\"> </p>\n";