Page MenuHomeWickedGov Phorge
Files F4061854

characterEditStats.php
No OneTemporary
Actions

Size
3 KB
Referenced Files
None
Subscribers
None

characterEditStats.php
View Options

<?php
/**
* Show number of characters translated over a given period of time.
*
* @author Santhosh Thottingal
* @copyright Copyright © 2013 Santhosh Thottingal
* @license GPL-2.0-or-later
* @file
* @ingroup Script Stats
*/
// Standard boilerplate to define $IP
use MediaWiki\Extension\Translate\MessageLoading\MessageHandle;
use MediaWiki\Extension\Translate\SystemUsers\FuzzyBot;
use MediaWiki\Maintenance\Maintenance;
use MediaWiki\MediaWikiServices;
use MediaWiki\Title\Title;
if ( getenv( 'MW_INSTALL_PATH' ) !== false ) {
$IP = getenv( 'MW_INSTALL_PATH' );
} else {
$dir = __DIR__;
$IP = "$dir/../../..";
}
require_once "$IP/maintenance/Maintenance.php";
class CharacterEditStats extends Maintenance {
public function __construct() {
parent::__construct();
$this->addDescription( 'Script to show number of characters translated .' );
$this->addOption(
'top',
'(optional) Show given number of language codes (default: show all)',
false, /*required*/
true /*has arg*/
);
$this->addOption(
'days',
'(optional) Calculate for given number of days (default: 30)',
false, /*required*/
true /*has arg*/
);
$this->addOption(
'ns',
'(optional) Comma separated list of namespace IDs',
false, /*required*/
true /*has arg*/
);
$this->requireExtension( 'Translate' );
}
public function execute() {
global $wgSitename, $wgTranslateMessageNamespaces;
$days = (int)$this->getOption( 'days', 30 );
$top = (int)$this->getOption( 'top', -1 );
$namespaces = [];
if ( $this->hasOption( 'ns' ) ) {
$input = explode( ',', $this->getOption( 'ns' ) );
foreach ( $input as $namespace ) {
if ( is_numeric( $namespace ) ) {
$namespaces[] = $namespace;
}
}
} else {
$namespaces = $wgTranslateMessageNamespaces;
}
// Select set of edits to report on
$rows = $this->getRevisionsFromHistory( $days, $namespaces );
// Get counts for edits per language code after filtering out edits by FuzzyBot
$codes = [];
foreach ( $rows as $_ ) {
// Filter out edits by FuzzyBot
if ( $_->user_text === FuzzyBot::getName() ) {
continue;
}
$handle = new MessageHandle( Title::newFromText( $_->title ) );
$code = $handle->getCode();
if ( !isset( $codes[$code] ) ) {
$codes[$code] = 0;
}
$codes[$code] += $_->length;
}
// Sort counts and report descending up to $top rows.
arsort( $codes );
$i = 0;
$total = 0;
$this->output( "Character edit stats for last $days days in $wgSitename\n" );
$this->output( "code\tname\tedit\n" );
$this->output( "-----------------------\n" );
$languageNameUtils = MediaWikiServices::getInstance()->getLanguageNameUtils();
foreach ( $codes as $code => $num ) {
if ( $i++ === $top ) {
break;
}
$language = $languageNameUtils->getLanguageName( $code );
if ( !$language ) {
// this will be very rare, but avoid division by zero in next line
continue;
}
$charRatio = mb_strlen( $language, 'UTF-8' ) / strlen( $language );
$num = (int)( $num * $charRatio );
$total += $num;
$this->output( "$code\t$language\t$num\n" );
}
$this->output( "-----------------------\n" );
$this->output( "Total\t\t$total\n" );
}
private function getRevisionsFromHistory( int $days, array $namespaces ): array {
$dbr = MediaWikiServices::getInstance()->getDBLoadBalancer()->getConnection( DB_REPLICA );
$cutoff = $dbr->addQuotes( $dbr->timestamp( time() - $days * 24 * 3600 ) );
$revisionStore = MediaWikiServices::getInstance()->getRevisionStore();
$result = $revisionStore->newSelectQueryBuilder( $dbr )
->select(
[
'title' => 'page_title',
'user_text' => 'actor_rev_user.actor_name',
'length' => 'rev_len',
]
)
->joinPage()
->where( [
"rev_timestamp > $cutoff",
'page_namespace' => $namespaces,
] )
->caller( __METHOD__ )
->fetchResultSet();
return iterator_to_array( $result );
}
}
$maintClass = CharacterEditStats::class;
require_once RUN_MAINTENANCE_IF_MAIN;

File Metadata

Mime Type
text/x-php
Expires
Aug 16 2026, 09:45 (12 w, 1 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
11/35/d4f8cbb5e7e6b3c8a1b2c45d1eec
Default Alt Text
characterEditStats.php (3 KB)

Event Timeline