X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2Fspecials%2Fpagers%2FBlockListPager.php;h=5789c283bea955c292841bc83f7c6d9404efe0cb;hb=589fa9248d991e5999dbdc18c22ff891bb73e87d;hp=fe7cac0dd1ec4fcdee3809d95ce31d065925c6e3;hpb=220bda9175a18458449e9d754fb48830c1f76f25;p=lhc%2Fweb%2Fwiklou.git diff --git a/includes/specials/pagers/BlockListPager.php b/includes/specials/pagers/BlockListPager.php index fe7cac0dd1..5789c283be 100644 --- a/includes/specials/pagers/BlockListPager.php +++ b/includes/specials/pagers/BlockListPager.php @@ -23,7 +23,7 @@ * @ingroup Pager */ use MediaWiki\MediaWikiServices; -use Wikimedia\Rdbms\ResultWrapper; +use Wikimedia\Rdbms\IResultWrapper; class BlockListPager extends TablePager { @@ -210,15 +210,16 @@ class BlockListPager extends TablePager { function getQueryInfo() { $commentQuery = CommentStore::getStore()->getJoin( 'ipb_reason' ); + $actorQuery = ActorMigration::newMigration()->getJoin( 'ipb_by' ); $info = [ - 'tables' => [ 'ipblocks', 'user' ] + $commentQuery['tables'], + 'tables' => array_merge( + [ 'ipblocks' ], $commentQuery['tables'], $actorQuery['tables'], [ 'user' ] + ), 'fields' => [ 'ipb_id', 'ipb_address', 'ipb_user', - 'ipb_by', - 'ipb_by_text', 'by_user_name' => 'user_name', 'ipb_timestamp', 'ipb_auto', @@ -231,9 +232,11 @@ class BlockListPager extends TablePager { 'ipb_deleted', 'ipb_block_email', 'ipb_allow_usertalk', - ] + $commentQuery['fields'], + ] + $commentQuery['fields'] + $actorQuery['fields'], 'conds' => $this->conds, - 'join_conds' => [ 'user' => [ 'LEFT JOIN', 'user_id = ipb_by' ] ] + $commentQuery['joins'] + 'join_conds' => [ + 'user' => [ 'LEFT JOIN', 'user_id = ' . $actorQuery['fields']['ipb_by'] ] + ] + $commentQuery['joins'] + $actorQuery['joins'] ]; # Filter out any expired blocks @@ -286,7 +289,7 @@ class BlockListPager extends TablePager { /** * Do a LinkBatch query to minimise database load when generating all these links - * @param ResultWrapper $result + * @param IResultWrapper $result */ function preprocessResults( $result ) { # Do a link batch query