4 * @addtogroup SpecialPage
8 * implements Special:Wantedpages
9 * @addtogroup SpecialPage
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->addObj( Title
::makeTitleSafe( $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 Skin to use for UI elements
70 * @param object $result Result row
73 public function formatResult( $skin, $result ) {
75 $title = Title
::makeTitleSafe( $result->namespace, $result->title
);
76 if( $title instanceof Title
) {
77 if( $this->isCached() ) {
78 $pageLink = $title->exists()
79 ?
'<s>' . $skin->makeLinkObj( $title ) . '</s>'
80 : $skin->makeBrokenLinkObj( $title );
82 $pageLink = $skin->makeBrokenLinkObj( $title );
84 return wfSpecialList( $pageLink, $this->makeWlhLink( $title, $skin, $result ) );
86 $tsafe = htmlspecialchars( $result->title
);
87 return "Invalid title in result set; {$tsafe}";
92 * Make a "what links here" link for a specified result if required
94 * @param Title $title Title to make the link for
95 * @param Skin $skin Skin to use
96 * @param object $result Result row
99 private function makeWlhLink( $title, $skin, $result ) {
101 if( $this->nlinks
) {
102 $wlh = SpecialPage
::getTitleFor( 'Whatlinkshere' );
103 $label = wfMsgExt( 'nlinks', array( 'parsemag', 'escape' ),
104 $wgLang->formatNum( $result->value
) );
105 return $skin->makeKnownLinkObj( $wlh, $label, 'target=' . $title->getPrefixedUrl() );
116 function wfSpecialWantedpages( $par = null, $specialPage ) {
117 $inc = $specialPage->including();
120 @list
( $limit, $nlinks ) = explode( '/', $par, 2 );
121 $limit = (int)$limit;
122 $nlinks = $nlinks === 'nlinks';
125 list( $limit, $offset ) = wfCheckLimits();
129 $wpp = new WantedPagesPage( $inc, $nlinks );
131 $wpp->doQuery( $offset, $limit, !$inc );