wfLimitResult() -> Database::limitResult()

[lhc/web/wiklou.git] / includes / SpecialStatistics.php

diff --git a/includes/SpecialStatistics.php b/includes/SpecialStatistics.php
index a6433aa..6995c03 100644 (file)
--- 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 );
+
 }
 
 ?>