Apply live hack from Wikimedia code base: profiling point around SVN version lookup
[lhc/web/wiklou.git] / includes / SpecialMostlinked.php
index c792638..b4de0a0 100644 (file)
@@ -1,16 +1,16 @@
 <?php
-/**
- *
- * @package MediaWiki
- * @subpackage SpecialPage
- */
-
-require_once ( 'QueryPage.php' ) ;
 
 /**
+ * A special page to show pages ordered by the number of pages linking to them.
+ * Implements Special:Mostlinked
+ *
+ * @addtogroup SpecialPage
  *
- * @package MediaWiki
- * @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
  */
 class MostlinkedPage extends QueryPage {
 
@@ -18,36 +18,64 @@ class MostlinkedPage extends QueryPage {
        function isExpensive() { return true; }
        function isSyndicated() { return false; }
 
+       /**
+        * Note: Getting page_namespace only works if $this->isCached() is false
+        */
        function getSQL() {
-               $dbr =& wfGetDB( DB_SLAVE );
-               extract( $dbr->tableNames( 'pagelinks', 'page' ) );
+               $dbr = wfGetDB( DB_SLAVE );
+               list( $pagelinks, $page ) = $dbr->tableNamesN( 'pagelinks', 'page' );
                return
                        "SELECT 'Mostlinked' AS type,
                                pl_namespace AS namespace,
                                pl_title AS title,
                                COUNT(*) AS value,
-                               -- FIXME: The presence of this is a bug
                                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;
+       /**
+        * 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();
+               }
+       }
 
-               $nt = Title::makeTitle( $result->namespace, $result->title );
-               $text = $wgContLang->convert( $nt->getPrefixedText() );
-               if ( is_null( $result->page_namespace ) )
-                       $plink = $skin->makeBrokenLink( $nt->getPrefixedText(), $text );
-               else
-                       $plink = $skin->makeKnownLink( $nt->getPrefixedText(), $text );
-               
-               $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 );
        }
 }
 
@@ -62,4 +90,4 @@ function wfSpecialMostlinked() {
        $wpp->doQuery( $offset, $limit );
 }
 
-?>
+