5 * @subpackage SpecialPage
11 require_once('QueryPage.php');
16 * @subpackage SpecialPage
18 class DoubleRedirectsPage
extends PageQueryPage
{
21 return 'DoubleRedirects';
24 function isExpensive( ) { return true; }
25 function isSyndicated() { return false; }
27 function getPageHeader( ) {
28 #FIXME : probably need to add a backlink to the maintenance page.
29 return '<p>'.wfMsg("doubleredirectstext")."</p><br>\n";
33 $dbr =& wfGetDB( DB_SLAVE
);
34 extract( $dbr->tableNames( 'page', 'links', 'text' ) );
36 $sql = "SELECT pa.page_namespace as ns_a, pa.page_title as title_a,
37 pb.page_namespace as ns_b, pb.page_title as title_b,
39 FROM $text AS t, $links,$page AS pa,$page AS pb
40 WHERE pa.page_is_redirect=1 AND pb.page_is_redirect=1 AND l_to=pb.page_id
42 AND pb.page_latest=t.old_id" ;
50 function formatResult( $skin, $result ) {
52 $ns = $wgContLang->getNamespaces() ;
53 $from = $skin->makeKnownLink( $ns[$result->ns_a
].':'.$result->title_a
,'', 'redirect=no' );
54 $edit = $skin->makeBrokenLink( $ns[$result->ns_a
].':'.$result->title_a
, "(".wfMsg("qbedit").")" , 'redirect=no');
55 $to = $skin->makeKnownLink( $ns[$result->ns_b
].':'.$result->title_b
,'');
56 $content = $result->rt
;
58 return "$from $edit => $to ($content)";
65 function wfSpecialDoubleRedirects() {
66 list( $limit, $offset ) = wfCheckLimits();
68 $sdr = new DoubleRedirectsPage();
70 return $sdr->doQuery( $offset, $limit );