http://www.mediawiki.org/wiki/Special:Code/MediaWiki/73453
Revision: 73453
Author: thomasv
Date: 2010-09-21 09:05:29 +0000 (Tue, 21 Sep 2010)
Log Message:
-----------
use select wrapper (follow-up to r73216)
Modified Paths:
--------------
trunk/extensions/ProofreadPage/ProofreadPage_body.php
Modified: trunk/extensions/ProofreadPage/ProofreadPage_body.php
===================================================================
--- trunk/extensions/ProofreadPage/ProofreadPage_body.php 2010-09-21
06:55:49 UTC (rev 73452)
+++ trunk/extensions/ProofreadPage/ProofreadPage_body.php 2010-09-21
09:05:29 UTC (rev 73453)
@@ -783,11 +783,13 @@
$pagelist = "'".implode( "', '", $pp)."'";
$page_ns_index = MWNamespace::getCanonicalIndex(
strtolower( $page_namespace ) );
$dbr = wfGetDB( DB_SLAVE );
- $catlinks = $dbr->tableName( 'categorylinks' );
- $page = $dbr->tableName( 'page' );
$cat = $dbr->strencode( str_replace( ' ' , '_' ,
wfMsgForContent( 'proofreadpage_quality0_category' ) ) );
- $query = "SELECT page_title FROM $page LEFT JOIN
$catlinks on cl_from=page_id WHERE page_title in ( $pagelist ) AND cl_to='$cat'
AND page_namespace=$page_ns_index;" ;
- $res = $dbr->query( $query , __METHOD__ );
+ $res = $dbr->select( array('page', 'categorylinks' ),
+ array("page_title"),
+ array("page_title IN ( $pagelist
)", "cl_to='$cat'", "page_namespace=$page_ns_index" ),
+ __METHOD__, null,
+ array('categorylinks' => array (
'LEFT JOIN','cl_from=page_id') ) );
+
$q0_pages = array();
if( $res ) {
while( $o = $dbr->fetchObject( $res ) ) {
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
