29 lines
1.1 KiB
PHP
29 lines
1.1 KiB
PHP
<?php namespace ProcessWire;
|
|
|
|
/**
|
|
* Correct created_users_id on some pages from admin page ID to be default superuser ID
|
|
*
|
|
*/
|
|
class SystemUpdate20 extends SystemUpdate {
|
|
public function execute() {
|
|
$this->wire()->addHookAfter('ProcessWire::ready', $this, 'executeAtReady');
|
|
return 0; // indicates we will update system version ourselves when ready
|
|
}
|
|
public function executeAtReady() {
|
|
$database = $this->wire()->database;
|
|
$config = $this->wire()->config;
|
|
/** @var User $u */
|
|
$u = $this->wire()->users->get($config->superUserPageID);
|
|
$superuserId = $u->id && $u->isSuperuser() ? $u->id : 0;
|
|
$sql = 'UPDATE pages SET created_users_id=:superuser_id WHERE created_users_id=:admin_page_id';
|
|
$query = $database->prepare($sql);
|
|
$query->bindValue(':superuser_id', $superuserId, \PDO::PARAM_INT);
|
|
$query->bindValue(':admin_page_id', $config->adminRootPageID, \PDO::PARAM_INT);
|
|
$query->execute();
|
|
$rowCount = $query->rowCount();
|
|
if($rowCount) $this->message("Updated $rowCount page(s) for correct created_users_id");
|
|
$this->updater->saveSystemVersion(20);
|
|
}
|
|
}
|
|
|
|
|