5 * @subpackage SpecialPage
11 require_once ( 'QueryPage.php' ) ;
16 * @subpackage SpecialPage
18 class WantedPagesPage
extends QueryPage
{
24 function isExpensive() {
27 function isSyndicated() { return false; }
30 $dbr =& wfGetDB( DB_SLAVE
);
31 $brokenlinks = $dbr->tableName( 'brokenlinks' );
33 # We cheat and return the full-text from bl_to in the title.
34 # In the future, a pre-parsed name will be available.
35 $agrvalue=$dbr->aggregateValue('COUNT(DISTINCT bl_from)');
37 "SELECT 'Wantedpages' as type,
40 COUNT(DISTINCT bl_from) as value
43 HAVING $agrvalue > 1";
46 function formatResult( $skin, $result ) {
49 $nt = Title
::newFromDBkey( $result->title
);
50 $text = $wgContLang->convert( $result->title
);
51 if( is_null( $nt ) ) {
52 return "<!-- Bad title '" . htmlspecialchars( $result->title
) . "' -->";
54 $plink = $skin->makeBrokenLink( $nt->getPrefixedText(), $text );
55 $nl = wfMsg( "nlinks", $result->value
);
56 $nlink = $skin->makeKnownLink( $wgContLang->specialPage( "Whatlinkshere" ), $nl,
57 "target=" . $nt->getPrefixedURL() );
59 return "{$plink} ({$nlink})";
66 function wfSpecialWantedpages() {
67 list( $limit, $offset ) = wfCheckLimits();
69 $wpp = new WantedPagesPage();
71 $wpp->doQuery( $offset, $limit );