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'))); }