public function patchNeeded()
{
// bêta 2
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='default_role_id' AND TABLE_NAME='" . Configure::read('Database.prefix') . "characters'";
if (!$this->controller->Character->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/beta-2');
}
// bêta 3
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='status' AND TABLE_NAME='" . Configure::read('Database.prefix') . "dungeons'";
if (!$this->controller->User->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/beta-3');
}
// v1.1
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='status' AND TABLE_NAME='" . Configure::read('Database.prefix') . "characters'";
if (!$this->controller->User->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.1');
}
// v1.3
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='bridge' AND TABLE_NAME='" . Configure::read('Database.prefix') . "users'";
if (!$this->controller->User->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.3');
}
// v1.3.5
App::uses('EventsTemplate', 'Model');
$EventsTemplate = new EventsTemplate();
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='time_invitation' AND TABLE_NAME='" . Configure::read('Database.prefix') . "events_templates'";
if (!$EventsTemplate->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.3.5');
}
// v1.4
App::uses('RaidsRole', 'Model');
$RaidsRole = new RaidsRole();
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='order' AND TABLE_NAME='" . Configure::read('Database.prefix') . "raids_roles'";
if (!$RaidsRole->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.4');
}
// v1.4.1
App::uses('EventsCharacter', 'Model');
$EventsCharacter = new EventsCharacter();
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='last_notification' AND TABLE_NAME='" . Configure::read('Database.prefix') . "events_characters'";
if (!$EventsCharacter->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.4.1');
}
// v1.5
App::uses('Event', 'Model');
$Event = new Event();
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='open' AND TABLE_NAME='" . Configure::read('Database.prefix') . "events'";
if (!$Event->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.5');
}
// v1.5.2
App::uses('Event', 'Model');
$Event = new Event();
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='time_inscription' AND TABLE_NAME='" . Configure::read('Database.prefix') . "events'";
if (!$Event->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.5.2');
}
// v1.6
App::uses('User', 'Model');
$User = new User();
$sql = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='calendar_key' AND TABLE_NAME='" . Configure::read('Database.prefix') . "users'";
if (!$User->query($sql)) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.6');
}
// v1.6.2
App::uses('Setting', 'Model');
$SettingModel = new Setting();
$notifications = json_decode($SettingModel->getOption('notifications'), true);
if (!isset($notifications['comments'])) {
return $this->redirectToPatch('/admin/patcher/apply/v-1.6.2');
}
}
