Remove unused private "filterPage" function from specials/SpecialExport.php
[lhc/web/wiklou.git] / includes / QueryPage.php
index 51226ed..a50c882 100644 (file)
@@ -49,7 +49,6 @@ $wgQueryPages = array(
 );
 wfRunHooks( 'wgQueryPages', array( &$wgQueryPages ) );
 
-## Maybe this can be re-enabled with the new hit-counting infrastructure??
 global $wgDisableCounters;
 if ( !$wgDisableCounters )
        $wgQueryPages[] = array( 'PopularPagesPage',            'Popularpages'          );
@@ -205,9 +204,9 @@ class QueryPage {
         * Clear the cache and save new results
         */
        function recache( $limit, $ignoreErrors = true ) {
-               $fname = get_class($this) . '::recache';
+               $fname = get_class( $this ) . '::recache';
                $dbw = wfGetDB( DB_MASTER );
-               $dbr = wfGetDB( DB_SLAVE, array( $this->getName(), 'QueryPage::recache', 'vslow' ) );
+               $dbr = wfGetDB( DB_SLAVE, array( $this->getName(), __METHOD__, 'vslow' ) );
                if ( !$dbw || !$dbr ) {
                        return false;
                }
@@ -223,37 +222,30 @@ class QueryPage {
                $dbw->delete( 'querycache', array( 'qc_type' => $this->getName() ), $fname );
                # Do query
                $sql = $this->getSQL() . $this->getOrder();
-               if ($limit !== false)
-                       $sql = $dbr->limitResult($sql, $limit, 0);
-               $res = $dbr->query($sql, $fname);
+               if ( $limit !== false )
+                       $sql = $dbr->limitResult( $sql, $limit, 0 );
+               $res = $dbr->query( $sql, $fname );
                $num = false;
                if ( $res ) {
                        $num = $dbr->numRows( $res );
                        # Fetch results
-                       $insertSql = "INSERT INTO $querycache (qc_type,qc_namespace,qc_title,qc_value) VALUES ";
-                       $first = true;
+                       $vals = array();
                        while ( $res && $row = $dbr->fetchObject( $res ) ) {
-                               if ( $first ) {
-                                       $first = false;
-                               } else {
-                                       $insertSql .= ',';
-                               }
                                if ( isset( $row->value ) ) {
-                                       $value = $row->value;
+                                       $value = intval( $row->value ); // @bug 14414
                                } else {
                                        $value = 0;
                                }
-
-                               $insertSql .= '(' .
-                                       $dbw->addQuotes( $row->type ) . ',' .
-                                       $dbw->addQuotes( $row->namespace ) . ',' .
-                                       $dbw->addQuotes( $row->title ) . ',' .
-                                       $dbw->addQuotes( $value ) . ')';
+                               
+                               $vals[] = array('qc_type' => $row->type,
+                                               'qc_namespace' => $row->namespace,
+                                               'qc_title' => $row->title,
+                                               'qc_value' => $value);
                        }
 
                        # Save results into the querycache table on the master
-                       if ( !$first ) {
-                               if ( !$dbw->query( $insertSql, $fname ) ) {
+                       if ( count( $vals ) ) {
+                               if ( !$dbw->insert( 'querycache', $vals, __METHOD__ ) ) {
                                        // Set result to false to indicate error
                                        $dbr->freeResult( $res );
                                        $res = false;
@@ -312,10 +304,12 @@ class QueryPage {
                                $tRow = $dbr->fetchObject( $tRes );
 
                                if( $tRow ) {
-                                       $updated = $wgLang->timeAndDate( $tRow->qci_timestamp, true, true );
+                                       $updated = $wgLang->timeanddate( $tRow->qci_timestamp, true, true );
+                                       $updateddate = $wgLang->date( $tRow->qci_timestamp, true, true );
+                                       $updatedtime = $wgLang->time( $tRow->qci_timestamp, true, true );
                                        $wgOut->addMeta( 'Data-Cache-Time', $tRow->qci_timestamp );
                                        $wgOut->addInlineScript( "var dataCacheTime = '{$tRow->qci_timestamp}';" );
-                                       $wgOut->addWikiMsg( 'perfcachedts', $updated );
+                                       $wgOut->addWikiMsg( 'perfcachedts', $updated, $updateddate, $updatedtime );
                                } else {
                                        $wgOut->addWikiMsg( 'perfcached' );
                                }
@@ -496,7 +490,7 @@ class QueryPage {
         */
        function feedResult( $row ) {
                if( !isset( $row->title ) ) {
-                       return NULL;
+                       return null;
                }
                $title = Title::MakeTitle( intval( $row->namespace ), $row->title );
                if( $title ) {
@@ -515,7 +509,7 @@ class QueryPage {
                                $this->feedItemAuthor( $row ),
                                $comments);
                } else {
-                       return NULL;
+                       return null;
                }
        }
 
@@ -535,7 +529,7 @@ class QueryPage {
        }
 
        function feedDesc() {
-               return wfMsg( 'tagline' );
+               return wfMsgExt( 'tagline', 'parsemag' );
        }
 
        function feedUrl() {
@@ -543,3 +537,85 @@ class QueryPage {
                return $title->getFullURL();
        }
 }
+
+/**
+ * Class definition for a wanted query page like
+ * WantedPages, WantedTemplates, etc
+ */
+abstract class WantedQueryPage extends QueryPage {
+
+       function isExpensive() {
+               return true;
+       }
+
+       function isSyndicated() {
+               return false;
+       }
+
+       /**
+        * Cache page existence for performance
+        */
+       function preprocessResults( $db, $res ) {
+               $batch = new LinkBatch;
+               while ( $row = $db->fetchObject( $res ) )
+                       $batch->add( $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 );
+       }
+       
+       /**
+        * Format an individual result
+        *
+        * @param $skin Skin to use for UI elements
+        * @param $result Result row
+        * @return string
+        */
+       public function formatResult( $skin, $result ) {
+               $title = Title::makeTitleSafe( $result->namespace, $result->title );
+               if( $title instanceof Title ) {
+                       if( $this->isCached() ) {
+                               $pageLink = $title->exists()
+                                       ? '<s>' . $skin->link( $title ) . '</s>'
+                                       : $skin->link(
+                                               $title,
+                                               null,
+                                               array(),
+                                               array(),
+                                               array( 'broken' )
+                                       );
+                       } else {
+                               $pageLink = $skin->link(
+                                       $title,
+                                       null,
+                                       array(),
+                                       array(),
+                                       array( 'broken' )
+                               );
+                       }
+                       return wfSpecialList( $pageLink, $this->makeWlhLink( $title, $skin, $result ) );
+               } else {
+                       $tsafe = htmlspecialchars( $result->title );
+                       return wfMsgHtml( 'wantedpages-badtitle', $tsafe );
+               }
+       }
+       
+       /**
+        * Make a "what links here" link for a given title
+        *
+        * @param $title Title to make the link for
+        * @param $skin Skin object to use
+        * @param $result Object: result row
+        * @return string
+        */
+       private function makeWlhLink( $title, $skin, $result ) {
+               global $wgLang;
+               $wlh = SpecialPage::getTitleFor( 'Whatlinkshere' );
+               $label = wfMsgExt( 'nlinks', array( 'parsemag', 'escape' ),
+               $wgLang->formatNum( $result->value ) );
+               return $skin->link( $wlh, $label, array(), array( 'target' => $title->getPrefixedText() ) );
+       }
+}