X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=blobdiff_plain;f=includes%2Fspecials%2FSpecialWantedpages.php;h=c37ecbd17adf9ae1aa3bfb47965bbb3417b6a716;hp=ca26bb4babda63b519e521b556a19af3e450f968;hb=ce079cf6ad79ca8d3360817f809b219d166f9153;hpb=640892e0fd6e4acc0407f84d81dc7bf9b651592f

diff --git a/includes/specials/SpecialWantedpages.php b/includes/specials/SpecialWantedpages.php
index ca26bb4bab..c37ecbd17a 100644
--- 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;
 	}