includes/SpecialStatistics.php

   1 <?php
   2 /**
   3 *
   4 * @package MediaWiki
   5 * @subpackage SpecialPage
   6 */
   7
   8 /**
   9 * constructor
  10 */
  11 function wfSpecialStatistics() {
  12         global $wgOut, $wgLang, $wgRequest;
  13         $fname = 'wfSpecialStatistics';
  14
  15         $action = $wgRequest->getVal( 'action' );
  16
  17         $dbr =& wfGetDB( DB_SLAVE );
  18         extract( $dbr->tableNames( 'page', 'site_stats', 'user', 'user_groups' ) );
  19
  20         $row = $dbr->selectRow( 'site_stats', '*', false, $fname );
  21         $views = $row->ss_total_views;
  22         $edits = $row->ss_total_edits;
  23         $good = $row->ss_good_articles;
  24         $images = $row->ss_images;
  25
  26         # This code is somewhat schema-agnostic, because I'm changing it in a minor release -- TS
  27         if ( isset( $row->ss_total_pages ) && $row->ss_total_pages == -1 ) {
  28                 # Update schema
  29                 $u = new SiteStatsUpdate( 0, 0, 0 );
  30                 $u->doUpdate();
  31                 $row = $dbr->selectRow( 'site_stats', '*', false, $fname );
  32         }
  33
  34         if ( isset( $row->ss_total_pages ) ) {
  35                 $total = $row->ss_total_pages;
  36         } else {
  37                 $sql = "SELECT COUNT(page_namespace) AS total FROM $page";
  38                 $res = $dbr->query( $sql, $fname );
  39                 $pageRow = $dbr->fetchObject( $res );
  40                 $total = $pageRow->total;
  41         }
  42
  43         if ( isset( $row->ss_users ) ) {
  44                 $users = $row->ss_users;
  45         } else {
  46                 $sql = "SELECT MAX(user_id) AS total FROM $user";
  47                 $res = $dbr->query( $sql, $fname );
  48                 $userRow = $dbr->fetchObject( $res );
  49                 $users = $userRow->total;
  50         }
  51
  52         $admins = $dbr->selectField( 'user_groups', 'COUNT(*)', array( 'ug_group' => 'sysop' ), $fname );
  53         $numJobs = $dbr->selectField( 'job', 'COUNT(*)', '', $fname );
  54
  55         if ($action == 'raw') {
  56                 $wgOut->disable();
  57                 header( 'Pragma: nocache' );
  58                 echo "total=$total;good=$good;views=$views;edits=$edits;users=$users;admins=$admins;images=$images;jobs=$numJobs\n";
  59                 return;
  60         } else {
  61                 $text = '==' . wfMsg( 'sitestats' ) . "==\n" ;
  62                 $text .= wfMsg( 'sitestatstext',
  63                         $wgLang->formatNum( $total ),
  64                         $wgLang->formatNum( $good ),
  65                         $wgLang->formatNum( $views ),
  66                         $wgLang->formatNum( $edits ),
  67                         $wgLang->formatNum( sprintf( '%.2f', $total ? $edits / $total : 0 ) ),
  68                         $wgLang->formatNum( sprintf( '%.2f', $edits ? $views / $edits : 0 ) ),
  69                         $wgLang->formatNum( $numJobs ),
  70                         $wgLang->formatNum( $images )
  71                 );
  72
  73                 $text .= "\n==" . wfMsg( 'userstats' ) . "==\n";
  74
  75                 $text .= wfMsg( 'userstatstext',
  76                         $wgLang->formatNum( $users ),
  77                         $wgLang->formatNum( $admins ),
  78                         '[[' . wfMsgForContent( 'grouppage-sysop' ) . ']]', # TODO somehow remove, kept for backwards compatibility
  79                         $wgLang->formatNum( sprintf( '%.2f', $admins / $users * 100 ) ),
  80                         User::makeGroupLinkWiki( 'sysop' )
  81                 );
  82
  83                 $wgOut->addWikiText( $text );
  84
  85                 global $wgDisableCounters, $wgMiserMode, $wgUser, $wgLang, $wgContLang;
  86                 if( !$wgDisableCounters && !$wgMiserMode ) {
  87                         $sql = "SELECT page_namespace, page_title, page_counter FROM {$page} WHERE page_is_redirect = 0 AND page_counter > 0 ORDER BY page_counter DESC";
  88                         $sql = $dbr->limitResult($sql, 10, 0);
  89                         $res = $dbr->query( $sql, $fname );
  90                         if( $res ) {
  91                                 $wgOut->addHtml( '<h2>' . wfMsgHtml( 'statistics-mostpopular' ) . '</h2>' );
  92                                 $skin =& $wgUser->getSkin();
  93                                 $wgOut->addHtml( '<ol>' );
  94                                 while( $row = $dbr->fetchObject( $res ) ) {
  95                                         $link = $skin->makeKnownLinkObj( Title::makeTitleSafe( $row->page_namespace, $row->page_title ) );
  96                                         $dirmark = $wgContLang->getDirMark();
  97                                         $wgOut->addHtml( '<li>' . $link . $dirmark . ' [' . $wgLang->formatNum( $row->page_counter ) . ']</li>' );
  98                                 }
  99                                 $wgOut->addHtml( '</ol>' );
 100                                 $dbr->freeResult( $res );
 101                         }
 102                 }
 103
 104         }
 105 }
 106 ?>