| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/wiki/includes/block/ |
Upload File : |
<?php
namespace MediaWiki\Block;
use Wikimedia\Rdbms\IReadableDatabase;
use Wikimedia\Rdbms\SelectQueryBuilder;
/**
* Helpers for building queries that determine whether a user is hidden
* @since 1.42
*/
class HideUserUtils {
/**
* Select users that are not hidden
*/
public const SHOWN_USERS = 1;
/**
* Select users that are hidden
*/
public const HIDDEN_USERS = 2;
/**
* Get an SQL expression suitable for use in WHERE clause which will be
* true for either hidden or non-hidden users as specified.
*
* The expression will contain a subquery.
*
* @param IReadableDatabase $dbr
* @param string $userIdField The field to be used as the user_id when
* joining on block. Defaults to "user_id".
* @param int $status Either self::SHOWN_USERS or self::HIDDEN_USERS
* depending on what sort of user you want to match.
* @return string
*/
public function getExpression(
IReadableDatabase $dbr,
string $userIdField = 'user_id',
$status = self::SHOWN_USERS
) {
// Use a scalar subquery, not IN/EXISTS, to avoid materialization (T360160)
return '(' .
$dbr->newSelectQueryBuilder()
->select( '1' )
// $userIdField may be e.g. block_target.bt_user so an inner table
// alias is necessary to ensure that that refers to the outer copy
// of the block_target table.
->from( 'block_target', 'hu_block_target' )
->join( 'block', 'hu_block', 'hu_block.bl_target=hu_block_target.bt_id' )
->where( [ "hu_block_target.bt_user=$userIdField", 'hu_block.bl_deleted' => 1 ] )
->limit( 1 )
->caller( __METHOD__ )
->getSQL() .
') ' .
( $status === self::HIDDEN_USERS ? 'IS NOT NULL' : 'IS NULL' );
}
/**
* Add a field and related joins to the query builder. The field in the
* query result will be true if the user is hidden or false otherwise.
*
* @param SelectQueryBuilder $qb The query builder to be modified
* @param string $userIdField The name of the user_id field to use in the join
* @param string $deletedFieldAlias The field alias which will be true if the user is hidden.
*/
public function addFieldToBuilder(
SelectQueryBuilder $qb,
$userIdField = 'user_id',
$deletedFieldAlias = 'hu_deleted'
) {
$cond = '(' .
$qb->newSubquery()
->select( '1' )
// $userIdField may be e.g. block_target.bt_user so an inner table
// alias is necessary to ensure that that refers to the outer copy
// of the block_target table.
->from( 'block_target', 'hu_block_target' )
->join( 'block', 'hu_block', 'hu_block.bl_target=hu_block_target.bt_id' )
->where( [ "hu_block_target.bt_user=$userIdField", 'hu_block.bl_deleted' => 1 ] )
->limit( 1 )
->caller( __METHOD__ )
->getSQL() .
') IS NOT NULL';
$qb->select( [ $deletedFieldAlias => $cond ] );
}
}