* (bug 6701) Kazakh language variants in MessagesEn.php

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

diff --git a/includes/SpecialStatistics.php b/includes/SpecialStatistics.php
index 67fcc61..4a51efd 100644 (file)
--- a/includes/SpecialStatistics.php
+++ b/includes/SpecialStatistics.php
@@ -1,57 +1,106 @@
 <?php
+/**
+*
+* @package MediaWiki
+* @subpackage SpecialPage
+*/
 
-function wfSpecialStatistics()
-{
-       global $wgUser, $wgOut, $wgLang;
-       $fname = "wfSpecialStatistics";
+/**
+* constructor
+*/
+function wfSpecialStatistics() {
+       global $wgOut, $wgLang, $wgRequest;
+       $fname = 'wfSpecialStatistics';
 
-       $wgOut->addHTML( "<h2>" . wfMsg( "sitestats" ) . "</h2>\n" );
-       
-       $dbr =& wfGetDB( DB_SLAVE );
-       extract( $dbr->tableNames( 'cur', 'site_stats', 'user', 'user_rights' ) );
+       $action = $wgRequest->getVal( 'action' );
 
-       $sql = "SELECT COUNT(cur_id) AS total FROM $cur";
-       $res = $dbr->query( $sql, $fname );
-       $row = $dbr->fetchObject( $res );
-       $total = $row->total;
+       $dbr =& wfGetDB( DB_SLAVE );
+       extract( $dbr->tableNames( 'page', 'site_stats', 'user', 'user_groups' ) );
 
-       $sql = "SELECT ss_total_views, ss_total_edits, ss_good_articles " .
-         "FROM $site_stats WHERE ss_row_id=1";
-       $res = $dbr->query( $sql, $fname );
-       $row = $dbr->fetchObject( $res );
+       $row = $dbr->selectRow( 'site_stats', '*', false, $fname );
        $views = $row->ss_total_views;
        $edits = $row->ss_total_edits;
        $good = $row->ss_good_articles;
+       $images = $row->ss_images;
 
-       $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 ) ) );
+       # This code is somewhat schema-agnostic, because I'm changing it in a minor release -- TS
+       if ( isset( $row->ss_total_pages ) && $row->ss_total_pages == -1 ) {
+               # Update schema
+               $u = new SiteStatsUpdate( 0, 0, 0 );
+               $u->doUpdate();
+               $row = $dbr->selectRow( 'site_stats', '*', false, $fname );
+       }
 
-       $wgOut->addWikiText( $text );
-       $wgOut->addHTML( "<h2>" . wfMsg( "userstats" ) . "</h2>\n" );
+       if ( isset( $row->ss_total_pages ) ) {
+               $total = $row->ss_total_pages;
+       } else {
+               $sql = "SELECT COUNT(page_namespace) AS total FROM $page";
+               $res = $dbr->query( $sql, $fname );
+               $pageRow = $dbr->fetchObject( $res );
+               $total = $pageRow->total;
+       }
 
-       $sql = "SELECT COUNT(user_id) AS total FROM $user";
-       $res = $dbr->query( $sql, $fname );
-       $row = $dbr->fetchObject( $res );
-       $total = $row->total;
+       if ( isset( $row->ss_users ) ) {
+               $users = $row->ss_users;
+       } else {
+               $sql = "SELECT MAX(user_id) AS total FROM $user";
+               $res = $dbr->query( $sql, $fname );
+               $userRow = $dbr->fetchObject( $res );
+               $users = $userRow->total;
+       }
 
-       $sql = "SELECT COUNT(user_id) AS total FROM $user_rights WHERE user_rights LIKE '%sysop%'";
-       $res = $dbr->query( $sql, $fname );
-       $row = $dbr->fetchObject( $res );
-       $admins = $row->total;
+       $admins = $dbr->selectField( 'user_groups', 'COUNT(*)', array( 'ug_group' => 'sysop' ), $fname );
+       $numJobs = $dbr->selectField( 'job', 'COUNT(*)', '', $fname );
 
-       $sk = $wgUser->getSkin();
-       $ap = "[[" . wfMsg( "administrators" ) . "]]";
+       if ($action == 'raw') {
+               $wgOut->disable();
+               header( 'Pragma: nocache' );
+               echo "total=$total;good=$good;views=$views;edits=$edits;users=$users;admins=$admins;images=$images;jobs=$numJobs\n";
+               return;
+       } else {
+               $text = '==' . wfMsg( 'sitestats' ) . "==\n" ;
+               $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( $numJobs ),
+                       $wgLang->formatNum( $images )
+               );
 
-       $text = wfMsg( "userstatstext",
-               $wgLang->formatNum( $total ),
-               $wgLang->formatNum( $admins ), $ap );
-       $wgOut->addWikiText( $text );
+               $text .= "\n==" . wfMsg( 'userstats' ) . "==\n";
 
-}
+               $text .= wfMsg( 'userstatstext',
+                       $wgLang->formatNum( $users ),
+                       $wgLang->formatNum( $admins ),
+                       '[[' . wfMsgForContent( 'grouppage-sysop' ) . ']]', # TODO somehow remove, kept for backwards compatibility
+                       $wgLang->formatNum( sprintf( '%.2f', $admins / $users * 100 ) ),
+                       User::makeGroupLinkWiki( 'sysop' )
+               );
 
+               $wgOut->addWikiText( $text );
+
+               global $wgDisableCounters, $wgMiserMode, $wgUser, $wgLang, $wgContLang;
+               if( !$wgDisableCounters && !$wgMiserMode ) {
+                       $sql = "SELECT page_namespace, page_title, page_counter FROM {$page} WHERE page_is_redirect = 0 AND page_counter > 0 ORDER BY page_counter DESC";
+                       $sql = $dbr->limitResult($sql, 10, 0);
+                       $res = $dbr->query( $sql, $fname );
+                       if( $res ) {
+                               $wgOut->addHtml( '<h2>' . wfMsgHtml( 'statistics-mostpopular' ) . '</h2>' );
+                               $skin =& $wgUser->getSkin();
+                               $wgOut->addHtml( '<ol>' );
+                               while( $row = $dbr->fetchObject( $res ) ) {
+                                       $link = $skin->makeKnownLinkObj( Title::makeTitleSafe( $row->page_namespace, $row->page_title ) );
+                                       $dirmark = $wgContLang->getDirMark();
+                                       $wgOut->addHtml( '<li>' . $link . $dirmark . ' [' . $wgLang->formatNum( $row->page_counter ) . ']</li>' );
+                               }
+                               $wgOut->addHtml( '</ol>' );
+                               $dbr->freeResult( $res );
+                       }
+               }
+               
+       }
+}
 ?>