<?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 QueryPage {
- var $nlinks;
+class WantedPagesPage extends WantedQueryPage {
- function WantedPagesPage( $inc = false, $nlinks = true ) {
- $this->setListoutput( $inc );
- $this->nlinks = $nlinks;
- }
-
- function getName() {
- return 'Wantedpages';
+ function __construct( $name = 'Wantedpages' ) {
+ parent::__construct( $name );
}
- function isExpensive() {
+ function isIncludable() {
return true;
}
- function isSyndicated() { return false; }
-
- function getSQL() {
- global $wgWantedPagesThreshold;
- $count = $wgWantedPagesThreshold - 1;
- $dbr = wfGetDB( DB_SLAVE );
- $pagelinks = $dbr->tableName( 'pagelinks' );
- $page = $dbr->tableName( 'page' );
- return
- "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 ( 2, 3 )
- AND pg2.page_namespace != 8
- GROUP BY pl_namespace, pl_title
- HAVING COUNT(*) > $count";
- }
- /**
- * Cache page existence for performance
- */
- function preprocessResults( $db, $res ) {
- $batch = new LinkBatch;
- while ( $row = $db->fetchObject( $res ) )
- $batch->add( $row->namespace, $row->title );
- $batch->execute();
+ function execute( $par ) {
+ $inc = $this->including();
- // Back to start for display
- if ( $db->numRows( $res ) > 0 )
- // If there are no rows we get an error seeking.
- $db->dataSeek( $res, 0 );
- }
-
- /**
- * Format an individual result
- *
- * @param $skin Skin to use for UI elements
- * @param $result Result row
- * @return string
- */
- public function formatResult( $skin, $result ) {
- $title = Title::makeTitleSafe( $result->namespace, $result->title );
- if( $title instanceof Title ) {
- if( $this->isCached() ) {
- $pageLink = $title->exists()
- ? '<s>' . $skin->makeLinkObj( $title ) . '</s>'
- : $skin->makeBrokenLinkObj( $title );
- } else {
- $pageLink = $skin->makeBrokenLinkObj( $title );
- }
- return wfSpecialList( $pageLink, $this->makeWlhLink( $title, $skin, $result ) );
- } else {
- $tsafe = htmlspecialchars( $result->title );
- return "Invalid title in result set; {$tsafe}";
- }
- }
-
- /**
- * Make a "what links here" link for a specified result if required
- *
- * @param $title Title to make the link for
- * @param $skin Skin to use
- * @param $result Result row
- * @return string
- */
- private function makeWlhLink( $title, $skin, $result ) {
- global $wgLang;
- if( $this->nlinks ) {
- $wlh = SpecialPage::getTitleFor( 'Whatlinkshere' );
- $label = wfMsgExt( 'nlinks', array( 'parsemag', 'escape' ),
- $wgLang->formatNum( $result->value ) );
- return $skin->makeKnownLinkObj( $wlh, $label, 'target=' . $title->getPrefixedUrl() );
- } else {
- return null;
+ 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';
+ }
}