*/ /** * Special:Listredirects - Lists all the redirects on the wiki. * @ingroup SpecialPage */ class ListredirectsPage extends QueryPage { function __construct( $name = 'Listredirects' ) { parent::__construct( $name ); } function isExpensive() { return true; } function isSyndicated() { return false; } function sortDescending() { return false; } function getQueryInfo() { return array( 'tables' => array( 'p1' => 'page', 'redirect', 'p2' => 'page' ), 'fields' => array( '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' => array( 'p1.page_is_redirect' => 1 ), 'join_conds' => array( 'redirect' => array( 'LEFT JOIN', 'rd_from=p1.page_id' ), 'p2' => array( 'LEFT JOIN', array( 'p2.page_namespace=rd_namespace', 'p2.page_title=rd_title' ) ) ) ); } function getOrderFields() { return array ( 'p1.page_namespace', 'p1.page_title' ); } /** * Cache page existence for performance * * @param $db DatabaseBase * @param $res ResultWrapper */ function preprocessResults( $db, $res ) { $batch = new LinkBatch; foreach ( $res as $row ) { $batch->add( $row->namespace, $row->title ); $batch->addObj( $this->getRedirectTarget( $row ) ); } $batch->execute(); // Back to start for display if ( $res->numRows() > 0 ) { // If there are no rows we get an error seeking. $db->dataSeek( $res, 0 ); } } 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(); } } function formatResult( $skin, $result ) { # Make a link to the redirect itself $rd_title = Title::makeTitle( $result->namespace, $result->title ); $rd_link = Linker::link( $rd_title, null, array(), array( '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 = Linker::link( $target ); return "$rd_link $arr $targetLink"; } else { return "$rd_link"; } } protected function getGroupName() { return 'pages'; } }