parse( wfMsg( 'brokenredirectstext' ) ); } function getSQL() { $dbr =& wfGetDB( DB_SLAVE ); list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' ); $sql = "SELECT 'BrokenRedirects' AS type, p1.page_namespace AS namespace, p1.page_title AS title, pl_namespace, pl_title FROM $pagelinks AS pl JOIN $page p1 ON (p1.page_is_redirect=1 AND pl.pl_from=p1.page_id) LEFT JOIN $page AS p2 ON (pl_namespace=p2.page_namespace AND pl_title=p2.page_title ) WHERE p2.page_namespace IS NULL"; return $sql; } function getOrder() { return ''; } function formatResult( $skin, $result ) { global $wgContLang; $fromObj = Title::makeTitle( $result->namespace, $result->title ); if ( isset( $result->pl_title ) ) { $toObj = Title::makeTitle( $result->pl_namespace, $result->pl_title ); } else { $blinks = $fromObj->getBrokenLinksFrom(); 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->makeLinkObj( $fromObj ) . ''; } $from = $skin->makeKnownLinkObj( $fromObj ,'', 'redirect=no' ); $edit = $skin->makeBrokenLinkObj( $fromObj , "(".wfMsg("qbedit").")" , 'redirect=no'); $to = $skin->makeBrokenLinkObj( $toObj ); $arr = $wgContLang->getArrow(); return "$from $edit $arr $to"; } } /** * constructor */ function wfSpecialBrokenRedirects() { list( $limit, $offset ) = wfCheckLimits(); $sbr = new BrokenRedirectsPage(); return $sbr->doQuery( $offset, $limit ); } ?>