8 * implements Special:Wantedpages
11 class WantedPagesPage
extends QueryPage
{
14 function WantedPagesPage( $inc = false, $nlinks = true ) {
15 $this->setListoutput( $inc );
16 $this->nlinks
= $nlinks;
23 function isExpensive() {
26 function isSyndicated() { return false; }
29 global $wgWantedPagesThreshold;
30 $count = $wgWantedPagesThreshold - 1;
31 $dbr = wfGetDB( DB_SLAVE
);
32 $pagelinks = $dbr->tableName( 'pagelinks' );
33 $page = $dbr->tableName( 'page' );
35 "SELECT 'Wantedpages' AS type,
36 pl_namespace AS namespace,
40 LEFT JOIN $page AS pg1
41 ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title
42 LEFT JOIN $page AS pg2
43 ON pl_from = pg2.page_id
44 WHERE pg1.page_namespace IS NULL
45 AND pl_namespace NOT IN ( 2, 3 )
46 AND pg2.page_namespace != 8
48 HAVING COUNT(*) > $count";
52 * Cache page existence for performance
54 function preprocessResults( $db, $res ) {
55 $batch = new LinkBatch
;
56 while ( $row = $db->fetchObject( $res ) )
57 $batch->add( $row->namespace, $row->title
);
60 // Back to start for display
61 if ( $db->numRows( $res ) > 0 )
62 // If there are no rows we get an error seeking.
63 $db->dataSeek( $res, 0 );
67 * Format an individual result
69 * @param $skin Skin to use for UI elements
70 * @param $result Result row
73 public function formatResult( $skin, $result ) {
74 $title = Title
::makeTitleSafe( $result->namespace, $result->title
);
75 if( $title instanceof Title
) {
76 if( $this->isCached() ) {
77 $pageLink = $title->exists()
78 ?
'<s>' . $skin->makeLinkObj( $title ) . '</s>'
79 : $skin->makeBrokenLinkObj( $title );
81 $pageLink = $skin->makeBrokenLinkObj( $title );
83 return wfSpecialList( $pageLink, $this->makeWlhLink( $title, $skin, $result ) );
85 $tsafe = htmlspecialchars( $result->title
);
86 return "Invalid title in result set; {$tsafe}";
91 * Make a "what links here" link for a specified result if required
93 * @param $title Title to make the link for
94 * @param $skin Skin to use
95 * @param $result Result row
98 private function makeWlhLink( $title, $skin, $result ) {
100 if( $this->nlinks
) {
101 $wlh = SpecialPage
::getTitleFor( 'Whatlinkshere' );
102 $label = wfMsgExt( 'nlinks', array( 'parsemag', 'escape' ),
103 $wgLang->formatNum( $result->value
) );
104 return $skin->makeKnownLinkObj( $wlh, $label, 'target=' . $title->getPrefixedUrl() );
115 function wfSpecialWantedpages( $par = null, $specialPage ) {
116 $inc = $specialPage->including();
119 @list
( $limit, $nlinks ) = explode( '/', $par, 2 );
120 $limit = (int)$limit;
121 $nlinks = $nlinks === 'nlinks';
124 list( $limit, $offset ) = wfCheckLimits();
128 $wpp = new WantedPagesPage( $inc, $nlinks );
130 $wpp->doQuery( $offset, $limit, !$inc );