<?php
/**
- *
- * @package MediaWiki
- * @subpackage SpecialPage
- */
+*
+* @package MediaWiki
+* @subpackage SpecialPage
+*/
/**
- * constructor
- */
+* constructor
+*/
function wfSpecialStatistics() {
- global $wgUser, $wgOut, $wgLang;
+ global $wgOut, $wgLang, $wgRequest;
$fname = 'wfSpecialStatistics';
- $wgOut->addHTML( '<h2>' . wfMsg( 'sitestats' ) . "</h2>\n" );
-
- $dbr =& wfGetDB( DB_SLAVE );
- extract( $dbr->tableNames( 'page', 'site_stats', 'user', 'user_rights' ) );
+ $action = $wgRequest->getVal( 'action' );
- $sql = "SELECT COUNT(page_id) AS total FROM $page";
- $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;
- $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 ) ) );
-
- $wgOut->addWikiText( $text );
- $wgOut->addHTML( '<h2>' . wfMsg( 'userstats' ) . "</h2>\n" );
-
- $sql = "SELECT COUNT(user_id) AS total FROM $user";
- $res = $dbr->query( $sql, $fname );
- $row = $dbr->fetchObject( $res );
- $total = $row->total;
-
- $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' ) . ']]';
-
- $text = wfMsg( 'userstatstext',
- $wgLang->formatNum( $total ),
- $wgLang->formatNum( $admins ), $ap );
- $wgOut->addWikiText( $text );
+ # 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 );
+ }
+
+ 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;
+ }
+
+ 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;
+ }
+
+ $admins = $dbr->selectField( 'user_groups', 'COUNT(*)', array( 'ug_group' => 'sysop' ), $fname );
+ $numJobs = $dbr->selectField( 'job', 'COUNT(*)', '', $fname );
+
+ if ($action == 'raw') {
+ $wgOut->disable();
+ header( 'Pragma: nocache' );
+ echo "total=$total;good=$good;views=$views;edits=$edits;users=$users;admins=$admins\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 )
+ );
+
+ $text .= "\n==" . wfMsg( 'userstats' ) . "==\n";
+
+ $text .= wfMsg( 'userstatstext',
+ $wgLang->formatNum( $users ),
+ $wgLang->formatNum( $admins ),
+ '[[' . wfMsg( 'administrators' ) . ']]',
+ // should logically be after #admins, danm backwards compatability!
+ $wgLang->formatNum( sprintf( '%.2f', $admins / $users * 100 ) )
+ );
+
+ $wgOut->addWikiText( $text );
+ }
}
-?>
\ No newline at end of file
+?>