http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97999
Revision: 97999
Author: catrope
Date: 2011-09-24 12:56:27 +0000 (Sat, 24 Sep 2011)
Log Message:
-----------
Use the indexes added in r97998 to do ORDER BY mbf_timestamp, mbf_id
Modified Paths:
--------------
trunk/extensions/MoodBar/ApiQueryMoodBarComments.php
trunk/extensions/MoodBar/SpecialMoodBarFeedback.php
Modified: trunk/extensions/MoodBar/ApiQueryMoodBarComments.php
===================================================================
--- trunk/extensions/MoodBar/ApiQueryMoodBarComments.php 2011-09-24
12:50:22 UTC (rev 97998)
+++ trunk/extensions/MoodBar/ApiQueryMoodBarComments.php 2011-09-24
12:56:27 UTC (rev 97999)
@@ -31,8 +31,9 @@
$this->applyContinue( $params['continue'],
$params['dir'] == 'older' );
}
- // Add ORDER BY mbf_timestamp {ASC|DESC}
+ // Add ORDER BY mbf_timestamp {ASC|DESC}, mbf_id {ASC|DESC}
$this->addWhereRange( 'mbf_timestamp', $params['dir'], null,
null );
+ $this->addWhereRange( 'mbf_id', $params['dir'], null, null );
$this->addOption( 'LIMIT', $params['limit'] + 1 );
$res = $this->select( __METHOD__ );
Modified: trunk/extensions/MoodBar/SpecialMoodBarFeedback.php
===================================================================
--- trunk/extensions/MoodBar/SpecialMoodBarFeedback.php 2011-09-24 12:50:22 UTC
(rev 97998)
+++ trunk/extensions/MoodBar/SpecialMoodBarFeedback.php 2011-09-24 12:56:27 UTC
(rev 97999)
@@ -180,7 +180,7 @@
),
$conds,
__METHOD__,
- array( 'LIMIT' => $limit, 'ORDER BY' => 'mbf_timestamp
DESC' ),
+ array( 'LIMIT' => $limit, 'ORDER BY' => 'mbf_timestamp
DESC, mbf_id DESC' ),
array( 'user' => array( 'LEFT JOIN',
'user_id=mbf_user_id' ) )
);
}
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
