Page MenuHomeWickedGov Phorge
Files F1432651

TemporaryAccountHandler.php
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

TemporaryAccountHandler.php
View Options

<?php
namespace MediaWiki\CheckUser\Api\Rest\Handler;
use MediaWiki\CheckUser\CheckUserQueryInterface;
use Wikimedia\ParamValidator\ParamValidator;
use Wikimedia\ParamValidator\TypeDef\IntegerDef;
use Wikimedia\Rdbms\IReadableDatabase;
use Wikimedia\Rdbms\SelectQueryBuilder;
class TemporaryAccountHandler extends AbstractTemporaryAccountNameHandler implements CheckUserQueryInterface {
/**
* @inheritDoc
*/
protected function getData( $actorId, IReadableDatabase $dbr ): array {
// The limit is the smaller of the user-provided limit parameter and the maximum row count.
$limit = min( $this->getValidatedParams()['limit'], $this->config->get( 'CheckUserMaximumRowCount' ) );
$resultRows = [];
foreach ( self::RESULT_TABLES as $table ) {
$prefix = self::RESULT_TABLE_TO_PREFIX[$table];
$queryBuilder = $dbr->newSelectQueryBuilder()
->select( [ 'ip' => "{$prefix}ip", 'timestamp' => 'MAX(' . $prefix . 'timestamp)' ] )
->from( $table )
->where( [ "{$prefix}actor" => $actorId ] )
->groupBy( "{$prefix}ip" )
->orderBy( 'timestamp', SelectQueryBuilder::SORT_DESC )
->limit( $limit )
->caller( __METHOD__ );
$resultRows = array_merge( $resultRows, iterator_to_array( $queryBuilder->fetchResultSet() ) );
}
// Order the results by the timestamp column descending.
usort( $resultRows, static function ( $a, $b ) {
return $b->timestamp <=> $a->timestamp;
} );
// Get the IP addresses from $resultRows in the order applied by usort.
$result = array_column( $resultRows, 'ip' );
// Remove duplicated IPs (if any)
$result = array_unique( $result );
// Apply the limit to the IPs list and then return them.
return [ 'ips' => array_slice( $result, 0, $limit ) ];
}
/**
* @inheritDoc
*/
public function getParamSettings() {
$settings = parent::getParamSettings();
$settings['limit'] = [
self::PARAM_SOURCE => 'query',
ParamValidator::PARAM_TYPE => 'integer',
ParamValidator::PARAM_REQUIRED => false,
ParamValidator::PARAM_DEFAULT => $this->config->get( 'CheckUserMaximumRowCount' ),
IntegerDef::PARAM_MAX => $this->config->get( 'CheckUserMaximumRowCount' ),
IntegerDef::PARAM_MIN => 1
];
return $settings;
}
}

File Metadata

Mime Type
text/x-php
Expires
Sat, May 16, 22:07 (1 d, 2 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
c1/02/b6f8f4cc0d5d2562e5657a9b64d7
Default Alt Text
TemporaryAccountHandler.php (2 KB)

Event Timeline