4 * @addtogroup SpecialPage
9 * @addtogroup SpecialPage
11 class BrokenRedirectsPage
extends PageQueryPage
{
12 var $targets = array();
15 return 'BrokenRedirects';
18 function isExpensive( ) { return true; }
19 function isSyndicated() { return false; }
21 function getPageHeader( ) {
23 return $wgOut->parse( wfMsg( 'brokenredirectstext' ) );
27 $dbr =& wfGetDB( DB_SLAVE
);
28 list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' );
30 $sql = "SELECT 'BrokenRedirects' AS type,
31 p1.page_namespace AS namespace,
32 p1.page_title AS title,
36 JOIN $page p1 ON (p1.page_is_redirect=1 AND pl.pl_from=p1.page_id)
37 LEFT JOIN $page AS p2 ON (pl_namespace=p2.page_namespace AND pl_title=p2.page_title )
38 WHERE p2.page_namespace IS NULL";
46 function formatResult( $skin, $result ) {
47 global $wgUser, $wgContLang;
49 $fromObj = Title
::makeTitle( $result->namespace, $result->title
);
50 if ( isset( $result->pl_title
) ) {
51 $toObj = Title
::makeTitle( $result->pl_namespace
, $result->pl_title
);
53 $blinks = $fromObj->getBrokenLinksFrom();
61 // $toObj may very easily be false if the $result list is cached
62 if ( !is_object( $toObj ) ) {
63 return '<s>' . $skin->makeLinkObj( $fromObj ) . '</s>';
66 $from = $skin->makeKnownLinkObj( $fromObj ,'', 'redirect=no' );
67 $edit = $skin->makeKnownLinkObj( $fromObj, wfMsgHtml( 'brokenredirects-edit' ), 'action=edit' );
68 $to = $skin->makeBrokenLinkObj( $toObj );
69 $arr = $wgContLang->getArrow();
71 $out = "{$from} {$edit}";
73 if( $wgUser->isAllowed( 'delete' ) ) {
74 $delete = $skin->makeKnownLinkObj( $fromObj, wfMsgHtml( 'brokenredirects-delete' ), 'action=delete' );
78 $out .= " {$arr} {$to}";
86 function wfSpecialBrokenRedirects() {
87 list( $limit, $offset ) = wfCheckLimits();
89 $sbr = new BrokenRedirectsPage();
91 return $sbr->doQuery( $offset, $limit );