| Index: trunk/extensions/MoodBar/ApiQueryMoodBarComments.php |
| — | — | @@ -31,8 +31,9 @@ |
| 32 | 32 | $this->applyContinue( $params['continue'], $params['dir'] == 'older' ); |
| 33 | 33 | } |
| 34 | 34 | |
| 35 | | - // Add ORDER BY mbf_timestamp {ASC|DESC} |
| | 35 | + // Add ORDER BY mbf_timestamp {ASC|DESC}, mbf_id {ASC|DESC} |
| 36 | 36 | $this->addWhereRange( 'mbf_timestamp', $params['dir'], null, null ); |
| | 37 | + $this->addWhereRange( 'mbf_id', $params['dir'], null, null ); |
| 37 | 38 | $this->addOption( 'LIMIT', $params['limit'] + 1 ); |
| 38 | 39 | |
| 39 | 40 | $res = $this->select( __METHOD__ ); |
| Index: trunk/extensions/MoodBar/SpecialMoodBarFeedback.php |
| — | — | @@ -180,7 +180,7 @@ |
| 181 | 181 | ), |
| 182 | 182 | $conds, |
| 183 | 183 | __METHOD__, |
| 184 | | - array( 'LIMIT' => $limit, 'ORDER BY' => 'mbf_timestamp DESC' ), |
| | 184 | + array( 'LIMIT' => $limit, 'ORDER BY' => 'mbf_timestamp DESC, mbf_id DESC' ), |
| 185 | 185 | array( 'user' => array( 'LEFT JOIN', 'user_id=mbf_user_id' ) ) |
| 186 | 186 | ); |
| 187 | 187 | } |