From: Arun Persaud <arun@nubati.net>
Date: Mon, 2 Jun 2008 02:34:10 +0000 (-0700)
Subject: NEW FEATURE: statistics of most solos per game
X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=commitdiff_plain;h=bf9a638ffd9b65d18b682e8b3e9bf19f798181cb;hp=077ab356084fa26910200f28a9cd44a954f291eb

NEW FEATURE: statistics of most solos per game

added a new statistic

Signed-off-by: Arun Persaud <arun@nubati.net>
---

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".