*/ use Wikimedia\Rdbms\IResultWrapper; use Wikimedia\Rdbms\IDatabase; /** * Special:Listredirects - Lists all the redirects on the wiki. * @ingroup SpecialPage */ class ListredirectsPage extends QueryPage { function __construct( $name = 'Listredirects' ) { parent::__construct( $name ); } public function isExpensive() { return true; } function isSyndicated() { return false; } function sortDescending() { return false; } public function getQueryInfo() { return [ 'tables' => [ 'p1' => 'page', 'redirect', 'p2' => 'page' ], 'fields' => [ 'namespace' => 'p1.page_namespace', 'title' => 'p1.page_title', 'value' => 'p1.page_title', 'rd_namespace', 'rd_title', 'rd_fragment', 'rd_interwiki', 'redirid' => 'p2.page_id' ], 'conds' => [ 'p1.page_is_redirect' => 1 ], 'join_conds' => [ 'redirect' => [ 'LEFT JOIN', 'rd_from=p1.page_id' ], 'p2' => [ 'LEFT JOIN', [ 'p2.page_namespace=rd_namespace', 'p2.page_title=rd_title' ] ] ] ]; } function getOrderFields() { return [ 'p1.page_namespace', 'p1.page_title' ]; } /** * Cache page existence for performance * * @param IDatabase $db * @param IResultWrapper $res */ function preprocessResults( $db, $res ) { if ( !$res->numRows() ) { return; } $batch = new LinkBatch; foreach ( $res as $row ) { $batch->add( $row->namespace, $row->title ); $redirTarget = $this->getRedirectTarget( $row ); if ( $redirTarget ) { $batch->addObj( $redirTarget ); } } $batch->execute(); // Back to start for display $res->seek( 0 ); } /** * @param stdClass $row * @return Title|null */ protected function getRedirectTarget( $row ) { if ( isset( $row->rd_title ) ) { return Title::makeTitle( $row->rd_namespace, $row->rd_title, $row->rd_fragment, $row->rd_interwiki ); } else { $title = Title::makeTitle( $row->namespace, $row->title ); $article = WikiPage::factory( $title ); return $article->getRedirectTarget(); } } /** * @param Skin $skin * @param object $result Result row * @return string */ function formatResult( $skin, $result ) { $linkRenderer = $this->getLinkRenderer(); # Make a link to the redirect itself $rd_title = Title::makeTitle( $result->namespace, $result->title ); $rd_link = $linkRenderer->makeLink( $rd_title, null, [], [ 'redirect' => 'no' ] ); # Find out where the redirect leads $target = $this->getRedirectTarget( $result ); if ( $target ) { # Make a link to the destination page $lang = $this->getLanguage(); $arr = $lang->getArrow() . $lang->getDirMark(); $targetLink = $linkRenderer->makeLink( $target, $target->getFullText() ); return "$rd_link $arr $targetLink"; } else { return "$rd_link"; } } protected function getGroupName() { return 'pages'; } }