| Index: trunk/extensions/FlaggedRevs/api/FlaggedRevsApi.hooks.php |
| — | — | @@ -62,7 +62,7 @@ |
| 63 | 63 | 'fr_rev_id' => array_keys( $revids ) ), LIST_AND ); |
| 64 | 64 | } |
| 65 | 65 | $module->addWhere( $db->makeList( $where, LIST_OR ) ); |
| 66 | | - $module->addOption( 'USE INDEX', array( 'flaggedrevs' => 'PRIMARY' ) ); |
| | 66 | + //$module->addOption( 'USE INDEX', array( 'flaggedrevs' => 'page_rev' ) ); |
| 67 | 67 | |
| 68 | 68 | $res = $module->select( __METHOD__ ); |
| 69 | 69 | |
| Index: trunk/extensions/FlaggedRevs/presentation/specialpages/reports/ReviewedVersions_body.php |
| — | — | @@ -93,15 +93,15 @@ |
| 94 | 94 | if ( !in_array( $this->namespace, $namespaces ) ) { |
| 95 | 95 | $conds[] = "1 = 0"; |
| 96 | 96 | } |
| 97 | | - $conds["fr_page_id"] = $this->pageID; |
| 98 | | - $conds[] = "fr_rev_id = rev_id"; |
| 99 | | - $conds[] = "fr_user = user_id"; |
| | 97 | + $conds['fr_page_id'] = $this->pageID; |
| | 98 | + $conds[] = 'fr_rev_id = rev_id'; |
| 100 | 99 | $conds[] = 'rev_deleted & ' . Revision::DELETED_TEXT . ' = 0'; |
| | 100 | + $conds[] = 'fr_user = user_id'; |
| 101 | 101 | return array( |
| 102 | 102 | 'tables' => array( 'flaggedrevs', 'revision', 'user' ), |
| 103 | 103 | 'fields' => 'fr_rev_id,fr_timestamp,rev_timestamp,fr_quality,fr_user,user_name', |
| 104 | 104 | 'conds' => $conds, |
| 105 | | - 'options' => array( 'USE INDEX' => array( 'flaggedrevs' => 'PRIMARY' ) ) |
| | 105 | + //'options' => array( 'USE INDEX' => array( 'flaggedrevs' => 'page_rev' ) ) |
| 106 | 106 | ); |
| 107 | 107 | } |
| 108 | 108 | |