Postgres: make sure ar_len is added when updating, alpha stuff in updaters.inc
[lhc/web/wiklou.git] / includes / SpecialBrokenRedirects.php
1 <?php
2 /**
3 *
4 * @addtogroup SpecialPage
5 */
6
7 /**
8 *
9 * @addtogroup SpecialPage
10 */
11 class BrokenRedirectsPage extends PageQueryPage {
12 var $targets = array();
13
14 function getName() {
15 return 'BrokenRedirects';
16 }
17
18 function isExpensive( ) { return true; }
19 function isSyndicated() { return false; }
20
21 function getPageHeader( ) {
22 global $wgOut;
23 return $wgOut->parse( wfMsg( 'brokenredirectstext' ) );
24 }
25
26 function getSQL() {
27 $dbr = wfGetDB( DB_SLAVE );
28 list( $page, $redirect ) = $dbr->tableNamesN( 'page', 'redirect' );
29
30 $sql = "SELECT 'BrokenRedirects' AS type,
31 p1.page_namespace AS namespace,
32 p1.page_title AS title,
33 rd_namespace,
34 rd_title
35 FROM $redirect AS rd
36 JOIN $page p1 ON (rd.rd_from=p1.page_id)
37 LEFT JOIN $page AS p2 ON (rd_namespace=p2.page_namespace AND rd_title=p2.page_title )
38 WHERE p2.page_namespace IS NULL";
39 return $sql;
40 }
41
42 function getOrder() {
43 return '';
44 }
45
46 function formatResult( $skin, $result ) {
47 global $wgUser, $wgContLang;
48
49 $fromObj = Title::makeTitle( $result->namespace, $result->title );
50 if ( isset( $result->rd_title ) ) {
51 $toObj = Title::makeTitle( $result->rd_namespace, $result->rd_title );
52 } else {
53 $blinks = $fromObj->getBrokenLinksFrom();
54 if ( $blinks ) {
55 $toObj = $blinks[0];
56 } else {
57 $toObj = false;
58 }
59 }
60
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>';
64 }
65
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();
70
71 $out = "{$from} {$edit}";
72
73 if( $wgUser->isAllowed( 'delete' ) ) {
74 $delete = $skin->makeKnownLinkObj( $fromObj, wfMsgHtml( 'brokenredirects-delete' ), 'action=delete' );
75 $out .= " {$delete}";
76 }
77
78 $out .= " {$arr} {$to}";
79 return $out;
80 }
81 }
82
83 /**
84 * constructor
85 */
86 function wfSpecialBrokenRedirects() {
87 list( $limit, $offset ) = wfCheckLimits();
88
89 $sbr = new BrokenRedirectsPage();
90
91 return $sbr->doQuery( $offset, $limit );
92
93 }
94 ?>