http://www.mediawiki.org/wiki/Special:Code/MediaWiki/72509
Revision: 72509
Author: demon
Date: 2010-09-06 20:23:41 +0000 (Mon, 06 Sep 2010)
Log Message:
-----------
(bug 25084) Update FlaggedRevs for new categorylinks schema. Add cl_type to the
WHERE clause to skip the filesort
Modified Paths:
--------------
trunk/extensions/FlaggedRevs/specialpages/UnreviewedPages_body.php
Modified: trunk/extensions/FlaggedRevs/specialpages/UnreviewedPages_body.php
===================================================================
--- trunk/extensions/FlaggedRevs/specialpages/UnreviewedPages_body.php
2010-09-06 20:11:24 UTC (rev 72508)
+++ trunk/extensions/FlaggedRevs/specialpages/UnreviewedPages_body.php
2010-09-06 20:23:41 UTC (rev 72509)
@@ -270,6 +270,13 @@
$fields[] = 'cl_sortkey';
$conds['cl_to'] = $this->category;
$conds[] = 'cl_from = page_id';
+ if( $this->namespace == NS_FILE ) {
+ $conds['cl_type'] = 'file';
+ } elseif( $this->namespace == NS_CATEGORY ) {
+ $conds['cl_type'] = 'subcat';
+ } else {
+ $conds['cl_type'] = 'page';
+ }
$this->mIndexField = 'cl_sortkey';
$useIndex = array( 'categorylinks' => 'cl_sortkey' );
$groupBy = 'cl_sortkey,cl_from';
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
