5 * @subpackage SpecialPage
11 require_once 'QueryPage.php';
16 * @subpackage SpecialPage
18 class WantedPagesPage
extends QueryPage
{
21 function WantedPagesPage( $inc = false, $nlinks = true ) {
22 $this->setListoutput( $inc );
23 $this->nlinks
= $nlinks;
30 function isExpensive() {
33 function isSyndicated() { return false; }
36 global $wgWantedPagesThreshold;
37 $count = $wgWantedPagesThreshold - 1;
38 $dbr =& wfGetDB( DB_SLAVE
);
39 $pagelinks = $dbr->tableName( 'pagelinks' );
40 $page = $dbr->tableName( 'page' );
42 "SELECT 'Wantedpages' AS type,
43 pl_namespace AS namespace,
47 LEFT JOIN $page AS pg1
48 ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title
49 LEFT JOIN $page AS pg2
50 ON pl_from = pg2.page_id
51 WHERE pg1.page_namespace IS NULL
52 AND pg2.page_namespace != 8
53 GROUP BY pl_namespace, pl_title
54 HAVING COUNT(*) > $count";
58 * Cache page existence for performance
60 function preprocessResults( &$db, &$res ) {
61 $batch = new LinkBatch
;
62 while ( $row = $db->fetchObject( $res ) )
63 $batch->addObj( Title
::makeTitleSafe( $row->namespace, $row->title
) );
66 // Back to start for display
67 if ( $db->numRows( $res ) > 0 )
68 // If there are no rows we get an error seeking.
69 $db->dataSeek( $res, 0 );
73 function formatResult( $skin, $result ) {
76 $title = Title
::makeTitleSafe( $result->namespace, $result->title
);
78 if( $this->isCached() ) {
79 # Check existence; which is stored in the link cache
80 if( !$title->exists() ) {
82 $pageLink = $skin->makeBrokenLinkObj( $title );
84 # Make a struck-out blue link
85 $pageLink = "<s>" . $skin->makeKnownLinkObj( $title ) . "</s>";
88 # Not cached? Don't bother checking existence; it can't
89 $pageLink = $skin->makeBrokenLinkObj( $title );
92 # Make a link to "what links here" if it's required
93 $wlhLink = $this->nlinks
94 ?
$this->makeWlhLink( $title, $skin, wfMsgHtml( 'nlinks', $result->value
) )
97 return wfSpecialList($pageLink, $wlhLink);
101 * Make a "what links here" link for a specified title
102 * @param $title Title to make the link for
103 * @param $skin Skin to use
104 * @param $text Link text
107 function makeWlhLink( &$title, &$skin, $text ) {
108 $wlhTitle = Title
::makeTitle( NS_SPECIAL
, 'Whatlinkshere' );
109 return $skin->makeKnownLinkObj( $wlhTitle, $text, 'target=' . $title->getPrefixedUrl() );
117 function wfSpecialWantedpages( $par = null, $specialPage ) {
118 $inc = $specialPage->including();
121 @list
( $limit, $nlinks ) = explode( '/', $par, 2 );
122 $limit = (int)$limit;
123 $nlinks = $nlinks === 'nlinks';
126 list( $limit, $offset ) = wfCheckLimits();
130 $wpp = new WantedPagesPage( $inc, $nlinks );
132 $wpp->doQuery( $offset, $limit, !$inc );