Nikerabbit has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/189224

Change subject: Remove about 700 unnecessary queries
......................................................................

Remove about 700 unnecessary queries

2*supported languages

Change-Id: Ib43a853631c4aaf4d7324e9566a0d9625e21a83c
---
M specials/SpecialSupportedLanguages.php
1 file changed, 7 insertions(+), 2 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Translate 
refs/changes/24/189224/1

diff --git a/specials/SpecialSupportedLanguages.php 
b/specials/SpecialSupportedLanguages.php
index 426e61e..f31175a 100644
--- a/specials/SpecialSupportedLanguages.php
+++ b/specials/SpecialSupportedLanguages.php
@@ -252,7 +252,7 @@
                $tables = array( 'page', 'revision', 'text' );
                $vars = array_merge(
                        Revision::selectTextFields(),
-                       array( 'page_title', 'page_namespace' ),
+                       Revision::selectPageFields(),
                        Revision::selectFields()
                );
                $conds = array(
@@ -266,9 +266,14 @@
 
                $users = array();
                $lb = new LinkBatch;
+               $lc = LinkCache::singleton();
 
                foreach ( $res as $row ) {
-                       $rev = new Revision( $row );
+                       $title = Title::newFromRow( $row );
+                       // Does not contain page_content_model, but should not 
matter
+                       $lc->addGoodLinkObjFromRow( $title, $row );
+
+                       $rev = Revision::newFromRow( $row );
                        $text = ContentHandler::getContentText( 
$rev->getContent() );
                        $code = strtolower( preg_replace( '!/translators$!', 
'', $row->page_title ) );
 

-- 
To view, visit https://gerrit.wikimedia.org/r/189224
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib43a853631c4aaf4d7324e9566a0d9625e21a83c
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Translate
Gerrit-Branch: master
Gerrit-Owner: Nikerabbit <[email protected]>

_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to