58 lines
1.9 KiB
PHP
58 lines
1.9 KiB
PHP
|
<?php namespace ProcessWire;
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Add 'published', and 'published_users_id' properties to pages table, and populates them
|
||
|
|
*
|
||
|
|
*/
|
||
|
|
class SystemUpdate12 extends SystemUpdate {
|
||
|
|
|
||
|
|
public function execute() {
|
||
|
|
|
||
|
|
$query = $this->wire('database')->prepare("SHOW columns FROM `pages` LIKE 'published'");
|
||
|
|
$query->execute();
|
||
|
|
$result = true;
|
||
|
|
|
||
|
|
if($query->rowCount() == 0) {
|
||
|
|
|
||
|
|
try {
|
||
|
|
$this->wire('database')->exec('ALTER TABLE pages ADD published datetime DEFAULT NULL AFTER `created_users_id`');
|
||
|
|
$this->message("Added 'published' column to pages table");
|
||
|
|
} catch(\Exception $e) {
|
||
|
|
$this->error($e->getMessage());
|
||
|
|
$result = false;
|
||
|
|
}
|
||
|
|
/*
|
||
|
|
if($result) try {
|
||
|
|
$this->wire('database')->exec('ALTER TABLE pages ADD published_users_id int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `published`');
|
||
|
|
$this->message("Added 'published_users_id' column to pages table");
|
||
|
|
} catch(\Exception $e) {
|
||
|
|
$this->error($e->getMessage());
|
||
|
|
$result = false;
|
||
|
|
}
|
||
|
|
*/
|
||
|
|
if($result) try {
|
||
|
|
//$sql = 'UPDATE pages SET published=modified, published_users_id=modified_users_id WHERE pages.status<2048 AND published IS NULL';
|
||
|
|
$sql = 'UPDATE pages SET published=created WHERE pages.status<2048 AND published IS NULL';
|
||
|
|
$query = $this->wire('database')->prepare($sql);
|
||
|
|
$query->execute();
|
||
|
|
$numRows = $query->rowCount();
|
||
|
|
$this->message("Populated values to 'published' for $numRows pages");
|
||
|
|
$this->wire('database')->exec('ALTER TABLE pages ADD KEY published (published)');
|
||
|
|
} catch(\Exception $e) {
|
||
|
|
$this->error($e->getMessage());
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$this->addHookAfter('ProcessWire::ready', $this, 'executeAtReady');
|
||
|
|
|
||
|
|
return $result;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function executeAtReady() {
|
||
|
|
if($this->wire('fields')->get('published')) {
|
||
|
|
$this->error("You have a field named 'published' that conflicts with the Page 'published' property. Please rename your field as soon as possible.");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|