summaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
Diffstat (limited to 'include')
-rw-r--r--include/stats.php14
1 files changed, 14 insertions, 0 deletions
diff --git a/include/stats.php b/include/stats.php
index ba2ea6d..c7b0da1 100644
--- a/include/stats.php
+++ b/include/stats.php
@@ -177,6 +177,20 @@ $result = DB_query_array_all("SELECT fullname, COUNT(*) as c " .
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(*), ".
+ " COUNT(*)/(SELECT COUNT(*) FROM Hand LEFT JOIN User ON User.id=Hand.user_id WHERE fullname=fname) as c ".
+ " FROM Game ".
+ " LEFT JOIN Hand ON Hand.position=startplayer AND Game.id=Hand.game_id ".
+ " LEFT JOIN User ON User.id=Hand.user_id ".
+ " WHERE type='solo' AND Game.solo<>'silent' AND Game.status='gameover' ".
+ " GROUP BY user_id ".
+ " ORDER BY c DESC;");
+array_unshift($result,array("Name","Number of solos","Solos/game"));
+echo output_table($result,"Most solos","stats");
+
+
/* most active games */
$result = DB_query_array_all("SELECT fullname, COUNT(*) as c " .
" FROM Hand".