Merge "Add CollationFa"

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

diff --git a/includes/specials/SpecialWantedpages.php b/includes/specials/SpecialWantedpages.php
index ca26bb4..c37ecbd 100644 (file)
--- a/includes/specials/SpecialWantedpages.php
+++ b/includes/specials/SpecialWantedpages.php
@@ -49,42 +49,43 @@ class WantedPagesPage extends WantedQueryPage {
        }
 
        function getQueryInfo() {
+               $dbr = wfGetDB( DB_REPLICA );
                $count = $this->getConfig()->get( 'WantedPagesThreshold' ) - 1;
-               $query = array(
-                       'tables' => array(
+               $query = [
+                       'tables' => [
                                'pagelinks',
                                'pg1' => 'page',
                                'pg2' => 'page'
-                       ),
-                       'fields' => array(
+                       ],
+                       'fields' => [
                                'namespace' => 'pl_namespace',
                                'title' => 'pl_title',
                                'value' => 'COUNT(*)'
-                       ),
-                       'conds' => array(
+                       ],
+                       'conds' => [
                                'pg1.page_namespace IS NULL',
-                               "pl_namespace NOT IN ( '" . NS_USER . "', '" . NS_USER_TALK . "' )",
-                               "pg2.page_namespace != '" . NS_MEDIAWIKI . "'"
-                       ),
-                       'options' => array(
-                               'HAVING' => array(
-                                       "COUNT(*) > $count",
-                                       "COUNT(*) > SUM(pg2.page_is_redirect)"
-                               ),
-                               'GROUP BY' => array( 'pl_namespace', 'pl_title' )
-                       ),
-                       'join_conds' => array(
-                               'pg1' => array(
-                                       'LEFT JOIN', array(
+                               'pl_namespace NOT IN (' . $dbr->makeList( [ NS_USER, NS_USER_TALK ] ) . ')',
+                               'pg2.page_namespace != ' . $dbr->addQuotes( NS_MEDIAWIKI ),
+                       ],
+                       'options' => [
+                               'HAVING' => [
+                                       'COUNT(*) > ' . $dbr->addQuotes( $count ),
+                                       'COUNT(*) > SUM(pg2.page_is_redirect)'
+                               ],
+                               'GROUP BY' => [ 'pl_namespace', 'pl_title' ]
+                       ],
+                       'join_conds' => [
+                               'pg1' => [
+                                       'LEFT JOIN', [
                                                'pg1.page_namespace = pl_namespace',
                                                'pg1.page_title = pl_title'
-                                       )
-                               ),
-                               'pg2' => array( 'LEFT JOIN', 'pg2.page_id = pl_from' )
-                       )
-               );
+                                       ]
+                               ],
+                               'pg2' => [ 'LEFT JOIN', 'pg2.page_id = pl_from' ]
+                       ]
+               ];
                // Replacement for the WantedPages::getSQL hook
-               Hooks::run( 'WantedPages::getQueryInfo', array( &$this, &$query ) );
+               Hooks::run( 'WantedPages::getQueryInfo', [ &$this, &$query ] );
 
                return $query;
        }