public function v15()
{
// Regenerate cache
Cache::clear(false);
// Notifications
$notifications = array('enabled' => 1, 'signup' => 0, 'contact' => '');
$this->Setting->setOption('notifications', json_encode($notifications));
// Calendar settings
$calendar = array('weekStartDay' => 0, 'title' => 'event', 'timeToDisplay' => 'time_invitation', 'gameIcon' => 1, 'dungeonIcon' => 1);
$this->Setting->setOption('calendar', json_encode($calendar));
// Set main characters
$sql = "SELECT t.user_id, t.game_id, t.character_id, MAX(t.used) AS nb_used\n FROM (\n SELECT ec.user_id, e.game_id, ec.character_id, COUNT(ec.id) AS used\n FROM " . $this->dbPrefix . "events_characters ec \n JOIN " . $this->dbPrefix . "users u ON ec.user_id=u.id\n JOIN " . $this->dbPrefix . "events e ON e.id=ec.event_id\n GROUP BY ec.character_id\n ORDER BY used DESC, u.id ASC, e.game_id ASC, ec.character_id\n ) t\n GROUP BY t.user_id, t.game_id";
if ($eventsCharacters = $this->EventsCharacter->query($sql)) {
foreach ($eventsCharacters as $eventsCharacter) {
$toUpdate = array();
$toUpdate['id'] = $eventsCharacter['t']['character_id'];
$toUpdate['main'] = 1;
$this->Character->save($toUpdate);
}
}
$params = array();
$params['recursive'] = -1;
$params['group'] = array('user_id', 'game_id');
$params['fields'] = array('id', 'user_id', 'game_id');
$params['order'] = array('main DESC', 'level DESC');
if ($characters = $this->Character->find('all', $params)) {
foreach ($characters as $character) {
$params = array();
$params['recursive'] = -1;
$params['fields'] = array('Character.id');
$params['conditions']['user_id'] = $character['Character']['user_id'];
$params['conditions']['game_id'] = $character['Character']['game_id'];
$params['conditions']['main'] = 1;
if (!$this->Character->find('first', $params)) {
$toUpdate = array();
$toUpdate['id'] = $character['Character']['id'];
$toUpdate['main'] = 1;
$this->Character->save($toUpdate);
}
}
}
// New role own events
$toSaveRole = array('title' => __('Can manage own events only'), 'alias' => 'manage_own_events', 'description' => __('Can create, edit and delete own events only. Can also manage the roster for his events'));
App::uses('RolePermission', 'Model');
$RolePermissionModel = new RolePermission();
$RolePermissionModel->create();
$RolePermissionModel->save($toSaveRole);
// Mushstats
$this->Setting->setOption('Mushstats', time());
}
private function postInstallData($siteTitle)
{
// Add default settings
$host = substr_count($_SERVER['HTTP_HOST'], '.') > 1 ? substr($_SERVER['HTTP_HOST'], strpos($_SERVER['HTTP_HOST'], '.') + 1) : $_SERVER['HTTP_HOST'];
$host = strpos($host, ':') !== false ? substr($host, 0, strpos($host, ':')) : $host;
// Remove port if present on unusual configurations
App::uses('Setting', 'Model');
$settingModel = new Setting();
$defaultSettings = array();
$defaultSettings['title'] = $siteTitle;
$defaultSettings['theme'] = json_encode(array('logo' => '/img/logo.png', 'bgcolor' => '#444444', 'bgimage' => $this->request->webroot . 'img/bg.png', 'bgrepeat' => 'repeat'));
$defaultSettings['css'] = '';
$defaultSettings['notifications'] = json_encode(array('enabled' => 1, 'signup' => 0, 'contact' => ''));
$defaultSettings['email'] = json_encode(array('name' => 'MushRaider', 'from' => 'mushraider@' . $host, 'encoding' => '', 'transport' => 'Mail', 'host' => '', 'port' => '', 'username' => '', 'password' => ''));
$defaultSettings['Mushstats'] = time();
$defaultSettings['calendar'] = json_encode(array('weekStartDay' => 1, 'title' => 'event', 'timeToDisplay' => 'time_invitation', 'gameIcon' => 1, 'dungeonIcon' => 1));
$defaultSettings['timezone'] = 'Europe/Paris';
foreach ($defaultSettings as $option => $value) {
$settingModel->create();
$settingModel->save(array('option' => $option, 'value' => $value));
}
// Add default roles permissions
$rolesPermissions = array(array('title' => __('Full permissions'), 'alias' => 'full_permissions', 'description' => __('Like Chuck Norris, he can do anything. This overwrite every permissions')), array('title' => __('Limited admin access'), 'alias' => 'limited_admin', 'description' => __('Like Robin, he can do some things but not all (like driving the batmobile or change user role)')), array('title' => __('Can manage events'), 'alias' => 'manage_events', 'description' => __('Can create, edit and delete events. Can also manage the roster for each events')), array('title' => __('Can manage own events only'), 'alias' => 'manage_own_events', 'description' => __('Can create, edit and delete own events only. Can also manage the roster for his events')), array('title' => __('Can create templates'), 'alias' => 'create_templates', 'description' => __('Can create events templates')), array('title' => __('Can create reports'), 'alias' => 'create_reports', 'description' => __('Can create events reports')));
App::uses('RolePermission', 'Model');
$RolePermissionModel = new RolePermission();
foreach ($rolesPermissions as $rolesPermission) {
$RolePermissionModel->create();
$RolePermissionModel->save($rolesPermission);
}
// Add new roles permissions to existing roles
App::uses('Role', 'Model');
$RoleModel = new Role();
App::uses('RolePermissionRole', 'Model');
$RolePermissionRoleModel = new RolePermissionRole();
$RolePermissionRoleModel->__add(array('role_id' => $RoleModel->getIdByAlias('admin'), 'role_permission_id' => $RolePermissionModel->getIdByAlias('full_permissions')));
$RolePermissionRoleModel->__add(array('role_id' => $RoleModel->getIdByAlias('officer'), 'role_permission_id' => $RolePermissionModel->getIdByAlias('limited_admin')));
$RolePermissionRoleModel->__add(array('role_id' => $RoleModel->getIdByAlias('officer'), 'role_permission_id' => $RolePermissionModel->getIdByAlias('manage_events')));
$RolePermissionRoleModel->__add(array('role_id' => $RoleModel->getIdByAlias('officer'), 'role_permission_id' => $RolePermissionModel->getIdByAlias('create_templates')));
$RolePermissionRoleModel->__add(array('role_id' => $RoleModel->getIdByAlias('officer'), 'role_permission_id' => $RolePermissionModel->getIdByAlias('create_reports')));
}
