diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2011-12-03 13:29:22 +0100 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2011-12-03 13:29:22 +0100 |
commit | ca32f08966f1b51fcb19460f0996bb0c4048e6fe (patch) | |
tree | ec04cc15b867bc21eedca904cea9af0254531a11 /maintenance/updateArticleCount.php | |
parent | a22fbfc60f36f5f7ee10d5ae6fe347340c2ee67c (diff) |
Update to MediaWiki 1.18.0
* also update ArchLinux skin to chagnes in MonoBook
* Use only css to hide our menu bar when printing
Diffstat (limited to 'maintenance/updateArticleCount.php')
-rw-r--r-- | maintenance/updateArticleCount.php | 66 |
1 files changed, 10 insertions, 56 deletions
diff --git a/maintenance/updateArticleCount.php b/maintenance/updateArticleCount.php index b0dceb58..dbbfb80c 100644 --- a/maintenance/updateArticleCount.php +++ b/maintenance/updateArticleCount.php @@ -27,9 +27,6 @@ require_once( dirname( __FILE__ ) . '/Maintenance.php' ); class UpdateArticleCount extends Maintenance { - // Content namespaces - private $namespaces; - public function __construct() { parent::__construct(); $this->mDescription = "Count of the number of articles and update the site statistics table"; @@ -37,64 +34,21 @@ class UpdateArticleCount extends Maintenance { } public function execute() { - global $wgContentNamespaces; - $this->namespaces = $wgContentNamespaces; $this->output( "Counting articles..." ); - $result = $this->count(); - if ( $result !== false ) { - $this->output( "found {$result}.\n" ); - if ( $this->hasOption( 'update' ) ) { - $this->output( "Updating site statistics table... " ); - $dbw = wfGetDB( DB_MASTER ); - $dbw->update( 'site_stats', array( 'ss_good_articles' => $result ), array( 'ss_row_id' => 1 ), __METHOD__ ); - $this->output( "done.\n" ); - } else { - $this->output( "To update the site statistics table, run the script with the --update option.\n" ); - } + $counter = new SiteStatsInit( false ); + $result = $counter->articles(); + + $this->output( "found {$result}.\n" ); + if ( $this->hasOption( 'update' ) ) { + $this->output( "Updating site statistics table... " ); + $dbw = wfGetDB( DB_MASTER ); + $dbw->update( 'site_stats', array( 'ss_good_articles' => $result ), array( 'ss_row_id' => 1 ), __METHOD__ ); + $this->output( "done.\n" ); } else { - $this->output( "failed.\n" ); + $this->output( "To update the site statistics table, run the script with the --update option.\n" ); } } - - /** - * Produce a comma-delimited set of namespaces - * Includes paranoia - * - * @return string - */ - private function makeNsSet() { - foreach ( $this->namespaces as $namespace ) - $namespaces[] = intval( $namespace ); - return implode( ', ', $namespaces ); - } - - /** - * Produce SQL for the query - * - * @param $dbr Database handle - * @return string - */ - private function makeSql( $dbr ) { - list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' ); - $nsset = $this->makeNsSet(); - return "SELECT COUNT(DISTINCT page_id) AS pagecount " . - "FROM $page, $pagelinks " . - "WHERE pl_from=page_id and page_namespace IN ( $nsset ) " . - "AND page_is_redirect = 0 AND page_len > 0"; - } - - /** - * Count the number of valid content pages in the wiki - * - * @return mixed Integer, or false if there's a problem - */ - private function count() { - $dbr = wfGetDB( DB_SLAVE ); - $res = $dbr->query( $this->makeSql( $dbr ), __METHOD__ ); - $row = $dbr->fetchObject( $res ); - return $row ? $row->pagecount : false; - } } $maintClass = "UpdateArticleCount"; |