<?php
/**
+ * Implements Special:Wantedpages
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License along
+ * with this program; if not, write to the Free Software Foundation, Inc.,
+ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ * http://www.gnu.org/copyleft/gpl.html
+ *
* @file
* @ingroup SpecialPage
*/
/**
- * implements Special:Wantedpages
+ * A special page that lists most linked pages that does not exist
+ *
* @ingroup SpecialPage
*/
class WantedPagesPage extends WantedQueryPage {
- var $nlinks;
- function WantedPagesPage( $inc = false, $nlinks = true ) {
- $this->setListoutput( $inc );
- $this->nlinks = $nlinks;
+ function __construct( $name = 'Wantedpages' ) {
+ parent::__construct( $name );
}
- function getName() {
- return 'Wantedpages';
+ function isIncludable() {
+ return true;
}
- function getSQL() {
- global $wgWantedPagesThreshold;
- $count = $wgWantedPagesThreshold - 1;
- $dbr = wfGetDB( DB_SLAVE );
- $pagelinks = $dbr->tableName( 'pagelinks' );
- $page = $dbr->tableName( 'page' );
- $sql = "SELECT 'Wantedpages' AS type,
- pl_namespace AS namespace,
- pl_title AS title,
- COUNT(*) AS value
- FROM $pagelinks
- LEFT JOIN $page AS pg1
- ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title
- LEFT JOIN $page AS pg2
- ON pl_from = pg2.page_id
- WHERE pg1.page_namespace IS NULL
- AND pl_namespace NOT IN ( " . NS_USER . ", ". NS_USER_TALK . ")
- AND pg2.page_namespace != " . NS_MEDIAWIKI . "
- GROUP BY pl_namespace, pl_title
- HAVING COUNT(*) > $count";
+ function execute( $par ) {
+ $inc = $this->including();
- wfRunHooks( 'WantedPages::getSQL', array( &$this, &$sql ) );
- return $sql;
+ if ( $inc ) {
+ $this->limit = (int)$par;
+ $this->offset = 0;
+ }
+ $this->setListoutput( $inc );
+ $this->shownavigation = !$inc;
+ parent::execute( $par );
}
-}
-/**
- * constructor
- */
-function wfSpecialWantedpages( $par = null, $specialPage ) {
- $inc = $specialPage->including();
+ function getQueryInfo() {
+ $dbr = wfGetDB( DB_REPLICA );
+ $count = $this->getConfig()->get( 'WantedPagesThreshold' ) - 1;
+ $query = [
+ 'tables' => [
+ 'pagelinks',
+ 'pg1' => 'page',
+ 'pg2' => 'page'
+ ],
+ 'fields' => [
+ 'namespace' => 'pl_namespace',
+ 'title' => 'pl_title',
+ 'value' => 'COUNT(*)'
+ ],
+ 'conds' => [
+ 'pg1.page_namespace IS NULL',
+ 'pl_namespace NOT IN (' . $dbr->makeList( [ NS_USER, NS_USER_TALK ] ) . ')',
+ 'pg2.page_namespace != ' . $dbr->addQuotes( NS_MEDIAWIKI ),
+ ],
+ 'options' => [
+ 'HAVING' => [
+ 'COUNT(*) > ' . $dbr->addQuotes( $count ),
+ 'COUNT(*) > SUM(pg2.page_is_redirect)'
+ ],
+ 'GROUP BY' => [ 'pl_namespace', 'pl_title' ]
+ ],
+ 'join_conds' => [
+ 'pg1' => [
+ 'LEFT JOIN', [
+ 'pg1.page_namespace = pl_namespace',
+ 'pg1.page_title = pl_title'
+ ]
+ ],
+ 'pg2' => [ 'LEFT JOIN', 'pg2.page_id = pl_from' ]
+ ]
+ ];
+ // Replacement for the WantedPages::getSQL hook
+ // Avoid PHP 7.1 warning from passing $this by reference
+ $wantedPages = $this;
+ Hooks::run( 'WantedPages::getQueryInfo', [ &$wantedPages, &$query ] );
- if ( $inc ) {
- @list( $limit, $nlinks ) = explode( '/', $par, 2 );
- $limit = (int)$limit;
- $nlinks = $nlinks === 'nlinks';
- $offset = 0;
- } else {
- list( $limit, $offset ) = wfCheckLimits();
- $nlinks = true;
+ return $query;
}
- $wpp = new WantedPagesPage( $inc, $nlinks );
-
- $wpp->doQuery( $offset, $limit, !$inc );
+ protected function getGroupName() {
+ return 'maintenance';
+ }
}