* Further work on rev_deleted; changed to a bitfield with several data-hiding

[lhc/web/wiklou.git] / includes / SpecialWantedpages.php

diff --git a/includes/SpecialWantedpages.php b/includes/SpecialWantedpages.php
index aece6c6..f4a8f30 100644 (file)
--- a/includes/SpecialWantedpages.php
+++ b/includes/SpecialWantedpages.php
@@ -8,7 +8,7 @@
 /**
  *
  */
-require_once ( 'QueryPage.php' ) ;
+require_once 'QueryPage.php';
 
 /**
  *
@@ -16,6 +16,12 @@ require_once ( 'QueryPage.php' ) ;
  * @subpackage SpecialPage
  */
 class WantedPagesPage extends QueryPage {
+       var $nlinks;
+
+       function WantedPagesPage( $inc = false, $nlinks = true ) {
+               $this->setListoutput( $inc );
+               $this->nlinks = $nlinks;
+       }
 
        function getName() {
                return 'Wantedpages';
@@ -24,48 +30,78 @@ class WantedPagesPage extends QueryPage {
        function isExpensive() {
                return true;
        }
+       function isSyndicated() { return false; }
 
        function getSQL() {
+               global $wgWantedPagesThreshold;
+               $count = $wgWantedPagesThreshold - 1;
                $dbr =& wfGetDB( DB_SLAVE );
-               $brokenlinks = $dbr->tableName( 'brokenlinks' );
-
-               # We cheat and return the full-text from bl_to in the title.
-               # In the future, a pre-parsed name will be available.
+               $pagelinks = $dbr->tableName( 'pagelinks' );
+               $page      = $dbr->tableName( 'page' );
                return
-                       "SELECT 'Wantedpages' as type,
-                               0 as namespace,
-                               bl_to as title,
-                               COUNT(DISTINCT bl_from) as value
-                       FROM $brokenlinks
-                       GROUP BY bl_to
-                       HAVING value > 1";
+                       "SELECT 'Wantedpages' AS type,
+                               pl_namespace AS namespace,
+                               pl_title AS title,
+                               COUNT(*) AS value
+                        FROM $pagelinks
+                        LEFT JOIN $page
+                        ON pl_namespace=page_namespace AND pl_title=page_title
+                        WHERE page_namespace IS NULL
+                        GROUP BY pl_namespace,pl_title
+                        HAVING COUNT(*) > $count";
+       }
+
+       /**
+        * Fetch user page links and cache their existence
+        */
+       function preprocessResults( &$db, &$res ) {
+               $batch = new LinkBatch;
+               while ( $row = $db->fetchObject( $res ) )
+                       $batch->addObj( Title::makeTitleSafe( $row->namespace, $row->title ) );
+               $batch->execute();
+
+               // Back to start for display
+               if ( $db->numRows( $res ) > 0 )
+                       // If there are no rows we get an error seeking.
+                       $db->dataSeek( $res, 0 );
        }
 
+
        function formatResult( $skin, $result ) {
-               global $wgLang;
-
-               $nt = Title::newFromDBkey( $result->title );
-               if( is_null( $nt ) ) {
-                       return "<!-- Bad title '" . htmlspecialchars( $result->title ) . "' -->";
-               }
-               $plink = $skin->makeBrokenLink( $nt->getPrefixedText(), "" );
-               $nl = wfMsg( "nlinks", $result->value );
-               $nlink = $skin->makeKnownLink( $wgLang->specialPage( "Whatlinkshere" ), $nl,
-                 "target=" . $nt->getPrefixedURL() );
-
-               return "{$plink} ({$nlink})";
+               global $wgContLang;
+
+               $nt = Title::makeTitle( $result->namespace, $result->title );
+               $text = $wgContLang->convert( $nt->getPrefixedText() );
+               $plink = $this->isCached() ?
+                       $skin->makeLinkObj( $nt, $text ) :
+                       $skin->makeBrokenLink( $nt->getPrefixedText(), $text );
+
+               $nl = wfMsg( 'nlinks', $result->value );
+               $nlink = $skin->makeKnownLink( $wgContLang->specialPage( 'Whatlinkshere' ), $nl, 'target=' . $nt->getPrefixedURL() );
+
+               return $this->nlinks ? "$plink ($nlink)" : $plink;
        }
 }
 
 /**
  * constructor
  */
-function wfSpecialWantedpages() {
-       list( $limit, $offset ) = wfCheckLimits();
+function wfSpecialWantedpages( $par = null, $specialPage ) {
+       $inc = $specialPage->including();
+
+       if ( $inc ) {
+               @list( $limit, $nlinks ) = explode( '/', $par, 2 );
+               $limit = (int)$limit;
+               $nlinks = $nlinks === 'nlinks';
+               $offset = 0;
+       } else {
+               list( $limit, $offset ) = wfCheckLimits();
+               $nlinks = true;
+       }
 
-       $wpp = new WantedPagesPage();
+       $wpp = new WantedPagesPage( $inc, $nlinks );
 
-       $wpp->doQuery( $offset, $limit );
+       $wpp->doQuery( $offset, $limit, !$inc );
 }
 
 ?>