* constructor
*/
function wfSpecialStatistics() {
- global $wgUser, $wgOut, $wgLang, $wgRequest;
+ global $wgOut, $wgLang, $wgRequest;
$fname = 'wfSpecialStatistics';
$action = $wgRequest->getVal( 'action' );
$dbr =& wfGetDB( DB_SLAVE );
extract( $dbr->tableNames( 'page', 'site_stats', 'user', 'user_groups' ) );
- $row = $dbr->selectRow( 'site_stats', '*', false, 'wfSpecialStatistics' );
+ $row = $dbr->selectRow( 'site_stats', '*', false, $fname );
$views = $row->ss_total_views;
$edits = $row->ss_total_edits;
$good = $row->ss_good_articles;
# Update schema
$u = new SiteStatsUpdate( 0, 0, 0 );
$u->doUpdate();
- $row = $dbr->selectRow( 'site_stats', '*', false, 'wfSpecialStatistics' );
+ $row = $dbr->selectRow( 'site_stats', '*', false, $fname );
}
if ( isset( $row->ss_total_pages ) ) {
$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 );
- $sql = "SELECT COUNT(*) AS total FROM $user_groups WHERE ug_group='sysop'";
- $res = $dbr->query( $sql, $fname );
- $row = $dbr->fetchObject( $res );
- $admins = $row->total;
-
if ($action == 'raw') {
$wgOut->disable();
header( 'Pragma: nocache' );
$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', $edits ? $views / $edits : 0 ) ),
+ $wgLang->formatNum( $numJobs )
+ );
+
$text .= "\n==" . wfMsg( 'userstats' ) . "==\n";
-
+
$text .= wfMsg( 'userstatstext',
$wgLang->formatNum( $users ),
$wgLang->formatNum( $admins ),
// should logically be after #admins, danm backwards compatability!
$wgLang->formatNum( sprintf( '%.2f', $admins / $users * 100 ) )
);
-
+
$wgOut->addWikiText( $text );
}
}