X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialStatistics.php;h=6995c033e75acee50f28ca8f7729d2a7399e6b8a;hb=ad871685be342763a32a22fcd5e0ce71a803c204;hp=a6433aaeb6a9854081d67ffaf2208148e43fffb4;hpb=509775a7d010e9ed1c3d43a19282b7e36836b9c0;p=lhc%2Fweb%2Fwiklou.git

diff --git a/includes/SpecialStatistics.php b/includes/SpecialStatistics.php
index a6433aaeb6..6995c033e7 100644
--- a/includes/SpecialStatistics.php
+++ b/includes/SpecialStatistics.php
@@ -6,16 +6,19 @@ function wfSpecialStatistics()
 	$fname = "wfSpecialStatistics";
 
 	$wgOut->addHTML( "<h2>" . wfMsg( "sitestats" ) . "</h2>\n" );
+	
+	$dbr =& wfGetDB( DB_SLAVE );
+	extract( $dbr->tableNames( 'cur', 'site_stats', 'user' ) );
 
-	$sql = "SELECT COUNT(cur_id) AS total FROM cur";
-	$res = wfQuery( $sql, DB_READ, $fname );
-	$row = wfFetchObject( $res );
+	$sql = "SELECT COUNT(cur_id) AS total FROM $cur";
+	$res = $dbr->query( $sql, $fname );
+	$row = $dbr->fetchObject( $res );
 	$total = $row->total;
 
 	$sql = "SELECT ss_total_views, ss_total_edits, ss_good_articles " .
-	  "FROM site_stats WHERE ss_row_id=1";
-	$res = wfQuery( $sql, DB_READ, $fname );
-	$row = wfFetchObject( $res );
+	  "FROM $site_stats WHERE ss_row_id=1";
+	$res = $dbr->query( $sql, $fname );
+	$row = $dbr->fetchObject( $res );
 	$views = $row->ss_total_views;
 	$edits = $row->ss_total_edits;
 	$good = $row->ss_good_articles;
@@ -31,15 +34,15 @@ function wfSpecialStatistics()
 	$wgOut->addWikiText( $text );
 	$wgOut->addHTML( "<h2>" . wfMsg( "userstats" ) . "</h2>\n" );
 
-	$sql = "SELECT COUNT(user_id) AS total FROM user";
-	$res = wfQuery( $sql, DB_READ, $fname );
-	$row = wfFetchObject( $res );
+	$sql = "SELECT COUNT(user_id) AS total FROM $user";
+	$res = $dbr->query( $sql, $fname );
+	$row = $dbr->fetchObject( $res );
 	$total = $row->total;
 
-	$sql = "SELECT COUNT(user_id) AS total FROM user " .
+	$sql = "SELECT COUNT(user_id) AS total FROM $user " .
 	  "WHERE user_rights LIKE '%sysop%'";
-	$res = wfQuery( $sql, DB_READ, $fname );
-	$row = wfFetchObject( $res );
+	$res = $dbr->query( $sql, $fname );
+	$row = $dbr->fetchObject( $res );
 	$admins = $row->total;
 
 	$sk = $wgUser->getSkin();
@@ -49,6 +52,7 @@ function wfSpecialStatistics()
 		$wgLang->formatNum( $total ),
 		$wgLang->formatNum( $admins ), $ap );
 	$wgOut->addWikiText( $text );
+
 }
 
 ?>