4 * Support class for the updateArticleCount.php maintenance script
7 * @subpackage Maintenance
8 * @author Rob Church <robchur@gmail.com>
11 class ArticleCounter
{
16 function ArticleCounter() {
17 global $wgContentNamespaces;
18 $this->namespaces
= $wgContentNamespaces;
19 $this->dbr
=& wfGetDB( DB_SLAVE
);
23 * Produce a comma-delimited set of namespaces
28 function makeNsSet() {
29 foreach( $this->namespaces
as $namespace )
30 $namespaces[] = intval( $namespace );
31 return implode( ', ', $namespaces );
35 * Produce SQL for the query
40 extract( $this->dbr
->tableNames( 'page', 'pagelinks' ) );
41 $nsset = $this->makeNsSet();
42 return "SELECT DISTINCT page_namespace,page_title FROM $page,$pagelinks " .
43 "WHERE pl_from=page_id and page_namespace IN ( $nsset ) " .
44 "AND page_is_redirect = 0 AND page_len > 0";
48 * Count the number of valid content pages in the wiki
50 * @return mixed Integer, or false if there's a problem
53 $res = $this->dbr
->query( $this->makeSql(), __METHOD__
);
55 $count = $this->dbr
->numRows( $res );
56 $this->dbr
->freeResult( $res );
59 # Look out for this when handling the result
60 # - Actually it's unreachable, !$res throws an exception -- TS