X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fstats.php;h=1042c6b2fd2f1e3d91b9210f7554fe054ce512d9;hp=bb6d69319960caad2e601c1b5bb83f990c496d41;hb=14827e2adeee23e03a1223e237faf363b5ce0a3c;hpb=aeb9ef98850e762291bc6a1d39b31d1ac4db4817 diff --git a/include/stats.php b/include/stats.php index bb6d693..1042c6b 100644 --- a/include/stats.php +++ b/include/stats.php @@ -1,5 +1,5 @@ +/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 Arun Persaud * * This file is part of e-DoKo. * @@ -35,7 +35,7 @@ if(!$myid) return; $PREF = DB_get_PREF($myid); -/* set language chosen in preferences, will become active on the next reload (see index.php)*/ +/* set language chosen in preferences*/ $_SESSION['language'] = $PREF['language']; set_language($PREF['language']); @@ -199,13 +199,14 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) /* does the party win more often if they start + global $DB; echo "

The party playing first wins in"; - $result = mysql_query("SELECT COUNT(*) from Score". + $result = $DB->query("SELECT COUNT(*) from Score". " LEFT JOIN Game ON Game.id=game_id". " WHERE score='againstqueens'". " AND Game.status='gameover'". " AND Game.type<>'solo'"); - while( $r = mysql_fetch_array($result,MYSQL_NUM)) + while( $r = $result->fetch_array(MYSQLI_NUM)) echo $r[1]." (".$r[0].")
\n"; echo " games

\n"; */