* @subpackage Parser

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

diff --git a/includes/SpecialStatistics.php b/includes/SpecialStatistics.php
index b842e52..1a0ad99 100644 (file)
--- a/includes/SpecialStatistics.php
+++ b/includes/SpecialStatistics.php
@@ -1,55 +1,62 @@
 <?php
-
-function wfSpecialStatistics()
-{
-       global $wgUser, $wgOut, $wgLang, $wgIsPg;
-       $fname = "wfSpecialStatistics";
-
-       $wgOut->addHTML( "<h2>" . wfMsg( "sitestats" ) . "</h2>\n" );
-
-       $sql = "SELECT COUNT(cur_id) AS total FROM cur";
-       $res = wfQuery( $sql, DB_READ, $fname );
-       $row = wfFetchObject( $res );
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
+
+/**
+ * constructor
+ */
+function wfSpecialStatistics() {
+       global $wgUser, $wgOut, $wgLang;
+       $fname = 'wfSpecialStatistics';
+
+       $wgOut->addHTML( '<h2>' . wfMsg( 'sitestats' ) . "</h2>\n" );
+       
+       $dbr =& wfGetDB( DB_SLAVE );
+       extract( $dbr->tableNames( 'page', 'site_stats', 'user', 'user_rights' ) );
+
+       $sql = "SELECT COUNT(page_namespace) AS total FROM $page";
+       $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;
 
-       $text = wfMsg( "sitestatstext",
+       $text = wfMsg( 'sitestatstext',
                $wgLang->formatNum( $total ),
                $wgLang->formatNum( $good ),
                $wgLang->formatNum( $views ),
                $wgLang->formatNum( $edits ),
-               $wgLang->formatNum( sprintf( "%.2f", $total ? $edits / $total : 0 ) ),
-               $wgLang->formatNum( sprintf( "%.2f", $edits ? $views / $edits : 0 ) ) );
+               $wgLang->formatNum( sprintf( '%.2f', $total ? $edits / $total : 0 ) ),
+               $wgLang->formatNum( sprintf( '%.2f', $edits ? $views / $edits : 0 ) ) );
 
        $wgOut->addWikiText( $text );
-       $wgOut->addHTML( "<h2>" . wfMsg( "userstats" ) . "</h2>\n" );
+       $wgOut->addHTML( '<h2>' . wfMsg( 'userstats' ) . "</h2>\n" );
 
-       $usertable=$wgIsPg?'"user"':'user';
-       $sql = "SELECT COUNT(user_id) AS total FROM $usertable";
-       $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 $usertable " .
-         "WHERE user_rights LIKE '%sysop%'";
-       $res = wfQuery( $sql, DB_READ, $fname );
-       $row = wfFetchObject( $res );
+       $sql = "SELECT COUNT(ur_user) AS total FROM $user_rights WHERE ur_rights LIKE '%sysop%'";
+       $res = $dbr->query( $sql, $fname );
+       $row = $dbr->fetchObject( $res );
        $admins = $row->total;
 
        $sk = $wgUser->getSkin();
-       $ap = "[[" . wfMsg( "administrators" ) . "]]";
+       $ap = '[[' . wfMsg( 'administrators' ) . ']]';
 
-       $text = wfMsg( "userstatstext",
+       $text = wfMsg( 'userstatstext',
                $wgLang->formatNum( $total ),
                $wgLang->formatNum( $admins ), $ap );
        $wgOut->addWikiText( $text );
 }
-
 ?>