maintenance/updateArticleCount.inc.php

   1 <?php
   2
   3 /**
   4  * Support class for the updateArticleCount.php maintenance script
   5  *
   6  * @package MediaWiki
   7  * @subpackage Maintenance
   8  * @author Rob Church <robchur@gmail.com>
   9  */
  10
  11 class ArticleCounter {
  12
  13         var $dbr;
  14         var $namespaces;
  15
  16         function ArticleCounter() {
  17                 global $wgContentNamespaces;
  18                 $this->namespaces = $wgContentNamespaces;
  19                 $this->dbr =& wfGetDB( DB_SLAVE );
  20         }
  21
  22         /**
  23          * Produce a comma-delimited set of namespaces
  24          * Includes paranoia
  25          *
  26          * @return string
  27          */
  28         function makeNsSet() {
  29                 foreach( $this->namespaces as $namespace )
  30                         $namespaces[] = intval( $namespace );
  31                 return implode( ', ', $namespaces );
  32         }
  33
  34         /**
  35          * Produce SQL for the query
  36          *
  37          * @return string
  38          */
  39         function makeSql() {
  40                 extract( $this->dbr->tableNames( 'page', 'pagelinks' ) );
  41                 $nsset = $this->makeNsSet();
  42                 return "SELECT COUNT(*) AS count FROM {$page}
  43                                 LEFT JOIN {$pagelinks} ON pl_from = page_id
  44                                 WHERE page_namespace IN ( $nsset )
  45                                 AND page_is_redirect = 0
  46                                 AND page_len > 0
  47                                 AND pl_namespace IS NOT NULL";
  48         }
  49
  50         /**
  51          * Count the number of valid content pages in the wiki
  52          *
  53          * @return mixed Integer, or false if there's a problem
  54          */
  55         function count() {
  56                 $res = $this->dbr->query( $this->makeSql(), __METHOD__ );
  57                 if( $res ) {
  58                         $row = $this->dbr->fetchObject( $res );
  59                         $this->dbr->freeResult( $res );
  60                         return (int)$row->count;
  61                 } else {
  62                         return false; # Look out for this when handling the result
  63                 }
  64         }
  65
  66 }
  67
  68 ?>