From 5edd63b115fe7712c6e220fc6a0b78dbace4f3cd Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Thu, 12 Feb 2009 22:12:23 -0800 Subject: NEW FEATURE + CLEANUP: added some table sorting to the statistics page via jquery using jquery to add table sorting, might also use it for other things later. Also optimized some DB-queries and cleaned up some code. --- include/stats.php | 21 +++++---------------- 1 file changed, 5 insertions(+), 16 deletions(-) (limited to 'include/stats.php') diff --git a/include/stats.php b/include/stats.php index 8c83b6d..1e6a033 100644 --- a/include/stats.php +++ b/include/stats.php @@ -38,9 +38,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) echo "

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.

\n"; @@ -173,15 +171,6 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) 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(*), ". @@ -236,12 +225,12 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) echo " games

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

 

\n"; -- cgit v1.2.3-18-g5258