From 2666bb58429c385b716d2ffd5d5fe9a9e7af4f45 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Mon, 20 Oct 2008 19:54:13 -0700 Subject: BUGFIX: make user menu and personal notes appear again had them only shown when player was logged in, but there is really no reason to not show them to players who are not logged in in an ongoing game (only the correct player should get to a page with an ongoing game) Signed-off-by: Arun Persaud --- include/stats.php | 60 +++++++++++++++++++++++++++---------------------------- 1 file changed, 30 insertions(+), 30 deletions(-) (limited to 'include/stats.php') diff --git a/include/stats.php b/include/stats.php index 095296e..83c11ad 100644 --- a/include/stats.php +++ b/include/stats.php @@ -1,5 +1,5 @@ \n"; - + echo "

Generated ".date("Y-m-d H:i:s")." (server time)

"; - + /* total number of games */ echo "

The number of finished games on this server is: "; $r = DB_query_array("SELECT COUNT(*) from Game". " WHERE status='gameover'"); $GameN = $r[0]; echo " $GameN

\n"; - + echo "

The contra party wins in "; $result = DB_query("SELECT COUNT(*) from Score". " LEFT JOIN Game ON Game.id=game_id". @@ -44,19 +44,19 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) while( $r = DB_fetch_array($result)) echo $r[0]; echo " games.

\n"; - + /* longest and shortest game */ $r=DB_query("SELECT timediff(mod_date,create_date) ,session,id". " FROM Game WHERE status='gameover'". " ORDER BY time_to_sec(timediff(mod_date,create_date)) ASC LIMIT 1"); - + if($r) { $short= DB_fetch_array($r); $names = DB_get_all_names_by_gameid($short[2]); echo "

The shortest game took only ".$short[0]." hours and was played by ".join(", ",$names).".
\n"; } - + $r=DB_query("SELECT datediff(mod_date,create_date) ,session,id". " FROM Game WHERE status='gameover'". " ORDER BY time_to_sec(timediff(mod_date,create_date)) DESC LIMIT 1"); @@ -65,7 +65,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) $long= DB_fetch_array($r); echo "The longest game took ".$long[0]." days.

\n"; } - + $r=DB_query("SELECT COUNT(*) as c, session, id FROM Game ". " GROUP BY session ORDER BY c DESC LIMIT 1"); if($r) @@ -75,8 +75,8 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) echo "

The longest session is session ".$long[1]." with ".$long[0]. " games played by ".join(", ",$names).".

\n"; } - - + + /* number of solos */ $result = DB_query_array_all("SELECT type,COUNT(*) as c from Game". " WHERE status='gameover'". @@ -84,7 +84,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) " ORDER BY c DESC"); array_unshift($result,array("Type","Frequency")); echo output_table($result,"Game types","stats"); - + /* break up solos in types */ $result = DB_query_array_all("SELECT solo,COUNT(*) as c from Game". " WHERE status='gameover'". @@ -93,12 +93,12 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) " ORDER BY c DESC"); array_unshift($result,array("Type","Frequency")); echo output_table($result,"Kind of solos","stats"); - + /* 2 top user mit maximaler quote an solo (min 10 games) - + top scoring game: winning players - + game with the same cards: show 3 at random: player who won, points, what kind of game select g1.id, g2.id from game g1 left join game g2 on g1.randomnumbers=g2.randomnumbers where g1.idThe party playing first wins in"; $result = mysql_query("SELECT COUNT(*) from Score". " LEFT JOIN Game ON Game.id=game_id". @@ -223,11 +223,11 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) $result = generate_global_score_table(); array_unshift($result,array("Name","Average score per game")); echo output_table($result,"Points per game","stats"); - + /* 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