wikiBirthday.php

Go to the documentation of this file.

<?php
use MediaWiki\MediaWikiServices;
 
require_once __DIR__ . '/Maintenance.php';
 
class WikiBirthday extends Maintenance {
    public function __construct() {
        parent::__construct();
        $this->addDescription( "Print this wiki's birthday and age" );
    }
 
    private function computeAge( string $wikiCreatedAt ) {
        return date_diff(
            date_create(),
            date_create( $wikiCreatedAt )
        );
    }
 
    public function execute() {
        $dbr = $this->getDB( DB_REPLICA );
 
        $revId = $dbr->newSelectQueryBuilder()
            ->table( 'revision' )
            ->field( 'MIN(rev_id)' )
            ->caller( __METHOD__ )
            ->fetchField();
 
        $archiveRevId = $dbr->newSelectQueryBuilder()
            ->table( 'archive' )
            ->field( 'MIN(ar_rev_id)' )
            ->caller( __METHOD__ )
            ->fetchField();
 
        if ( $archiveRevId && $archiveRevId < $revId ) {
            $timestamp = $dbr->newSelectQueryBuilder()
                ->table( 'archive' )
                ->field( 'ar_timestamp' )
                ->where( [ 'ar_rev_id' => (int)$archiveRevId ] )
                ->caller( __METHOD__ )
                ->fetchField();
        } else {
            $timestamp = $dbr->newSelectQueryBuilder()
                ->table( 'revision' )
                ->field( 'rev_timestamp' )
                ->where( [ 'rev_id' => (int)$revId ] )
                ->caller( __METHOD__ )
                ->fetchField();
        }
 
        $birthDay = MediaWikiServices::getInstance()->getContentLanguage()
            ->getHumanTimestamp( MWTimestamp::getInstance( $timestamp ) );
 
        $text = "Wiki was created on: " . $birthDay . " <age: " .
            $this->computeAge( $timestamp )->format(
                "%y yr(s), %m month(s), %d day(s)"
            ) . " old>.";
 
        $this->output( $text . "\n" );
    }
}
 
$maintClass = WikiBirthday::class;
require_once RUN_MAINTENANCE_IF_MAIN;