Skip to content

Instantly share code, notes, and snippets.

@rozalski

rozalski/change_prefix.php

Forked from ig0r74/change_prefix.php
Created October 1, 2019 12:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rozalski/d636ba5ac0fe533073ee6147907da12f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rozalski/d636ba5ac0fe533073ee6147907da12f to your computer and use it in GitHub Desktop.
Download ZIP
Изменить префикс у таблиц MODX Revolution
Raw
change_prefix.php
<?php
ini_set("max_execution_time", 0);
ignore_user_abort(true);
$current_prefix = $modx->config['table_prefix'];
$new_prefix = 'My_Prefix234_';
$stmt = $modx->query("SHOW TABLES");
$tables = $stmt->fetchAll(PDO::FETCH_NUM);
$stmt->closeCursor();
foreach ($tables as $table) {
$table = reset($table);
$preg = "/^{$current_prefix}/u";
if (preg_match($preg, $table)) {
$new_table_name = preg_replace($preg, $new_prefix, $table);
$sql = "RENAME TABLE `{$table}` TO `{$new_table_name}`";
if ($s = $modx->prepare($sql)) {
$s->execute();
}
}
}
print "\nTables are updated";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment