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 if( is_null( $nt ) ) {
51 return "<!-- Bad title '" . htmlspecialchars( $result->title
) . "' -->";
53 $plink = $skin->makeBrokenLink( $nt->getPrefixedText(), "" );
54 $nl = wfMsg( "nlinks", $result->value
);
55 $nlink = $skin->makeKnownLink( $wgContLang->specialPage( "Whatlinkshere" ), $nl,
56 "target=" . $nt->getPrefixedURL() );
58 return "{$plink} ({$nlink})";
65 function wfSpecialWantedpages() {
66 list( $limit, $offset ) = wfCheckLimits();
68 $wpp = new WantedPagesPage();
70 $wpp->doQuery( $offset, $limit );