'.wfMsg('brokenredirectstext')."
\n";
}
function getSQL() {
$dbr =& wfGetDB( DB_SLAVE );
extract( $dbr->tableNames( 'page', 'pagelinks' ) );
$sql = "SELECT 'BrokenRedirects' AS type,
p1.page_namespace AS namespace,
p1.page_title AS title,
pl_namespace,
pl_title
FROM $pagelinks, $page AS p1
LEFT JOIN $page AS p2
ON pl_namespace=p2.page_namespace AND pl_title=p2.page_title
WHERE p1.page_is_redirect=1
AND pl_from=p1.page_id
AND p2.page_namespace IS NULL";
return $sql;
}
function getOrder() {
return '';
}
function formatResult( $skin, $result ) {
$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 );
return "$from $edit → $to";
}
}
/**
* constructor
*/
function wfSpecialBrokenRedirects() {
list( $limit, $offset ) = wfCheckLimits();
$sbr = new BrokenRedirectsPage();
return $sbr->doQuery( $offset, $limit );
}
?>