* (bug 8437) Make Title::loadRestrictions() initialise $mRestrictions properly

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

diff --git a/includes/SpecialMostlinked.php b/includes/SpecialMostlinked.php
index 28a209e..2794ecb 100644 (file)
--- a/includes/SpecialMostlinked.php
+++ b/includes/SpecialMostlinked.php
@@ -1,4 +1,5 @@
 <?php
+
 /**
  * A special page to show pages ordered by the number of pages linking to them
  *
@@ -6,13 +7,12 @@
  * @subpackage SpecialPage
  *
  * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
+ * @author Rob Church <robchur@gmail.com>
  * @copyright Copyright © 2005, Ævar Arnfjörð Bjarmason
+ * @copyright © 2006 Rob Church
  * @license http://www.gnu.org/copyleft/gpl.html GNU General Public License 2.0 or later
  */
 
-/* */
-require_once 'QueryPage.php';
-
 /**
  * @package MediaWiki
  * @subpackage SpecialPage
@@ -28,38 +28,59 @@ class MostlinkedPage extends QueryPage {
         */
        function getSQL() {
                $dbr =& wfGetDB( DB_SLAVE );
-               extract( $dbr->tableNames( 'pagelinks', 'page' ) );
+               list( $pagelinks, $page ) = $dbr->tableNamesN( 'pagelinks', 'page' );
                return
                        "SELECT 'Mostlinked' AS type,
                                pl_namespace AS namespace,
                                pl_title AS title,
                                COUNT(*) AS value,
-
                                page_namespace
                        FROM $pagelinks
                        LEFT JOIN $page ON pl_namespace=page_namespace AND pl_title=page_title
-                       GROUP BY pl_namespace,pl_title
+                       GROUP BY 1,2,3,5
                        HAVING COUNT(*) > 1";
        }
 
-       function formatResult( $skin, $result ) {
-               global $wgContLang;
-
-               $nt = Title::makeTitle( $result->namespace, $result->title );
-               $text = $wgContLang->convert( $nt->getPrefixedText() );
-
-               if ( $this->isCached() )
-                       $plink = $skin->makeKnownLink( $nt->getPrefixedText(), $text );
-               else {
-                       $plink = is_null( $result->page_namespace )
-                               ? $skin->makeBrokenLink( $nt->getPrefixedText(), $text )
-                               : $skin->makeKnownLink( $nt->getPrefixedText(), $text );
+       /**
+        * Pre-fill the link cache
+        */
+       function preprocessResults( &$db, &$res ) {
+               if( $db->numRows( $res ) > 0 ) {
+                       $linkBatch = new LinkBatch();
+                       while( $row = $db->fetchObject( $res ) )
+                               $linkBatch->addObj( Title::makeTitleSafe( $row->namespace, $row->title ) );
+                       $db->dataSeek( $res, 0 );
+                       $linkBatch->execute();
                }
+       }
 
-               $nl = wfMsg( 'nlinks', $result->value );
-               $nlink = $skin->makeKnownLink( $wgContLang->specialPage( 'Whatlinkshere' ), $nl, 'target=' . $nt->getPrefixedURL() );
+       /**
+        * Make a link to "what links here" for the specified title
+        *
+        * @param $title Title being queried
+        * @param $skin Skin to use
+        * @return string
+        */
+       function makeWlhLink( &$title, $caption, &$skin ) {
+               $wlh = SpecialPage::getTitleFor( 'Whatlinkshere', $title->getPrefixedDBkey() );
+               return $skin->makeKnownLinkObj( $wlh, $caption );
+       }
 
-               return "{$plink} ({$nlink})";
+       /**
+        * Make links to the page corresponding to the item, and the "what links here" page for it
+        *
+        * @param $skin Skin to be used
+        * @param $result Result row
+        * @return string
+        */
+       function formatResult( $skin, $result ) {
+               global $wgLang;
+               $title = Title::makeTitleSafe( $result->namespace, $result->title );
+               $link = $skin->makeLinkObj( $title );
+               $wlh = $this->makeWlhLink( $title,
+                       wfMsgExt( 'nlinks', array( 'parsemag', 'escape'),
+                               $wgLang->formatNum( $result->value ) ), $skin );
+               return wfSpecialList( $link, $wlh );
        }
 }