tableNamesN( 'page', 'redirect' ); $sql = "SELECT 'BrokenRedirects' AS type, p1.page_namespace AS namespace, p1.page_title AS title, rd_namespace, rd_title FROM $redirect AS rd JOIN $page p1 ON (rd.rd_from=p1.page_id) LEFT JOIN $page AS p2 ON (rd_namespace=p2.page_namespace AND rd_title=p2.page_title ) WHERE rd_namespace >= 0 AND p2.page_namespace IS NULL"; return $sql; } function getOrder() { return ''; } function formatResult( $skin, $result ) { global $wgUser, $wgContLang, $wgLang; $fromObj = Title::makeTitle( $result->namespace, $result->title ); if ( isset( $result->rd_title ) ) { $toObj = Title::makeTitle( $result->rd_namespace, $result->rd_title ); } else { $blinks = $fromObj->getBrokenLinksFrom(); # TODO: check for redirect, not for links if ( $blinks ) { $toObj = $blinks[0]; } else { $toObj = false; } } // $toObj may very easily be false if the $result list is cached if ( !is_object( $toObj ) ) { return '' . $skin->link( $fromObj ) . ''; } $from = $skin->linkKnown( $fromObj, null, array(), array( 'redirect' => 'no' ) ); $links = array(); $links[] = $skin->linkKnown( $fromObj, wfMsgHtml( 'brokenredirects-edit' ), array(), array( 'action' => 'edit' ) ); $to = $skin->link( $toObj, null, array(), array(), array( 'broken' ) ); $arr = $wgContLang->getArrow(); $out = $from . wfMsg( 'word-separator' ); if( $wgUser->isAllowed( 'delete' ) ) { $links[] = $skin->linkKnown( $fromObj, wfMsgHtml( 'brokenredirects-delete' ), array(), array( 'action' => 'delete' ) ); } $out .= wfMsg( 'parentheses', $wgLang->pipeList( $links ) ); $out .= " {$arr} {$to}"; return $out; } } /** * constructor */ function wfSpecialBrokenRedirects() { list( $limit, $offset ) = wfCheckLimits(); $sbr = new BrokenRedirectsPage(); return $sbr->doQuery( $offset, $limit ); }