/** * Validate and save changes. * * @return Response */ public function patchIndex(BoardConfigRequest $request, Board $board) { $input = $request->all(); $optionGroups = $request->getBoardOptions(); foreach ($optionGroups as $optionGroup) { foreach ($optionGroup->options as $option) { $setting = BoardSetting::firstOrNew(['option_name' => $option->option_name, 'board_uri' => $board->board_uri]); $option->option_value = $input[$option->option_name]; $setting->option_value = $input[$option->option_name]; $setting->save(); } } $board->title = $input['boardBasicTitle']; $board->description = $input['boardBasicDesc']; $board->is_overboard = isset($input['boardBasicOverboard']) && !!$input['boardBasicOverboard']; $board->is_indexed = isset($input['boardBasicIndexed']) && !!$input['boardBasicIndexed']; $board->is_worksafe = isset($input['boardBasicWorksafe']) && !!$input['boardBasicWorksafe']; $board->save(); Event::fire(new BoardWasModified($board)); return $this->view(static::VIEW_CONFIG, ['board' => $board, 'groups' => $optionGroups]); }
/** * Imports users and creates roles based on addition data in that row. * * @return void */ public function importInfinityRolesAndBoards() { # BORROW SEEDERS require base_path() . "/database/seeds/OptionSeeder.php"; require base_path() . "/database/seeds/PermissionSeeder.php"; require base_path() . "/database/seeds/RoleSeeder.php"; # DESTROY SEQUENCE if (DB::connection() instanceof \Illuminate\Database\PostgresConnection) { $this->comment("\tDropping role sequence."); DB::statement("DROP SEQUENCE IF EXISTS roles_role_id_seq CASCADE;"); } $PermissionSeeder = new \PermissionSeeder(); $PermissionSeeder->setCommand($this); $PermissionSeeder->run(); $PermissionGroupSeeder = new \PermissionGroupSeeder(); $PermissionGroupSeeder->setCommand($this); $PermissionGroupSeeder->run(); $OptionSeeder = new \OptionSeeder(); $OptionSeeder->setCommand($this); $OptionSeeder->run(); $OptionGroupSeeder = new \OptionGroupSeeder(); $OptionGroupSeeder->setCommand($this); $OptionGroupSeeder->run(); $RoleSeeder = new \RoleSeeder(); $RoleSeeder->setCommand($this); $RoleSeeder->runMaster(); $RolePermissionSeeder = new \RolePermissionSeeder(); $RolePermissionSeeder->setCommand($this); $RolePermissionSeeder->run(); \Artisan::call('cache:clear'); # REPAIR SEQUENCE if (DB::connection() instanceof \Illuminate\Database\PostgresConnection) { $this->comment("\tCreating role_id sequence again."); DB::statement("CREATE SEQUENCE roles_role_id_seq;"); $pgSeqNext = DB::table('roles')->select(DB::raw("(MAX(\"role_id\") + 1) AS next"))->pluck("next"); DB::statement("ALTER SEQUENCE roles_role_id_seq OWNED BY \"roles\".\"role_id\" RESTART WITH {$pgSeqNext};"); DB::statement("ALTER TABLE roles ALTER COLUMN role_id SET DEFAULT nextval('roles_role_id_seq');"); } # THEIR TABLES $tBoardsTable = $this->tcon->table("boards")->join('board_create', 'boards.uri', '=', 'board_create.uri')->select('boards.*', 'board_create.time'); $tModsTable = $this->tcon->table("mods"); # BEGIN USER IMPORT $this->info("\tImporting Users ..."); $userAdmin = null; $userBoardRelationships = []; $usersImported = 0; $tModsTable->chunk(100, function ($mods) use(&$userAdmin, &$userBoardRelationships, &$usersImported) { $this->line("\t\tHandling 100 users ..."); foreach ($mods as $mod) { # CREATE USER $user = new User(['username' => $mod->username, 'email' => property_exists($mod, "email") ? $mod->email ?: null : null, 'password' => null, 'password_legacy' => json_encode(['hasher' => "Vichan", 'hash' => $mod->password, 'salt' => $mod->salt])]); // 8chan has an issue with duplicates. try { $saved = $user->save(); } catch (\Exception $e) { $saved = false; } if ($saved) { ++$usersImported; # REMEMBER ROLES if ($mod->boards) { // TODO // Pull these values from config when formal importer created. switch ($mod->type) { // Janitor (Disabled) case 10: // Disabled // Disabled case 99: $this->comment("\t\tMod {$user->username} is disabled."); break; // Board volunteer // Board volunteer case 19: // Board owner // Board owner case 20: if (!isset($userBoardRelationships[$mod->boards])) { $userBoardRelationships[$mod->boards] = []; } $userBoardRelationships[$mod->boards][$user->user_id] = $mod->type; break; // Global volunteer // Global volunteer case 25: $this->comment("\t\tSetting {$user->username} to Global Mod."); $user->roles()->attach(Role::ID_MODERATOR); break; // Admin // Admin case 30: $this->comment("\t\tSetting {$user->username} to Global Admin."); $user->roles()->attach(Role::ID_ADMIN); $userAdmin = $userAdmin ?: $user; break; // Not identified! // Not identified! default: $this->error("\t\tMod {$user->username} has invalid mod type {$mod->type}."); break; } } } } }); $this->info("\tImported {$usersImported} users(s)."); if (!$userAdmin) { $this->comment("\tFailed to import an admin. This may cause problems."); } unset($mods, $mod, $user); # BEGIN BOARD IMPORT $this->info("\tImporting Boards ..."); $boardsImported = 0; $tBoardsTable->chunk(100, function ($boards) use(&$boardsImported, $userAdmin, $userBoardRelationships) { $this->line("\t\tHandling 100 boards ..."); foreach ($boards as $tBoard) { // We have an array like [board_uri => [ user_id => user_role ]] in the user import. // This fetches the first key of the biggest item. $boardOwner = []; if (isset($userBoardRelationships[$tBoard->uri])) { $boardOwner = array_keys($userBoardRelationships[$tBoard->uri], max($userBoardRelationships[$tBoard->uri])); } // Or it defaults to our admin. if (!isset($boardOwner[0])) { $this->comment("\t\t/{$tBoard->uri}/ has no known owner, assuming it is {$userAdmin->username}."); $boardOwner = $userAdmin->user_id; } else { $boardOwner = isset($boardOwner) ? $boardOwner[0] : $userAdmin->user_id; } $hBoard = new Board(['board_uri' => $tBoard->uri, 'title' => $tBoard->title, 'description' => $tBoard->subtitle, 'created_at' => new Carbon($tBoard->time), 'created_by' => $boardOwner, 'operated_by' => $boardOwner, 'posts_total' => $tBoard->posts_total, 'is_indexed' => !!$tBoard->indexed, 'is_overboard' => !!$tBoard->indexed, 'is_worksafe' => !!$tBoard->sfw]); if ($hBoard->save()) { ++$boardsImported; if (!$tBoard->public_bans || !$tBoard->public_logs || $tBoard->public_logs == 2) { $role = Role::getAnonymousRoleForBoard($hBoard); $perms = []; if (!$tBoard->public_bans) { $perms[] = ['permission_id' => "board.bans", 'value' => false]; } if (!$tBoard->public_logs || $tBoard->public_logs == 2) { $perms[] = ['permission_id' => "board.logs", 'value' => false]; } $role->permissionAssignments()->createMany($perms); } } else { $this->error("Failed to save /{$hBoard->board_uri}/."); } } }); $this->info("\tImported {$boardsImported} board(s)."); unset($boards, $tBoard, $hBoard); # BEGIN ROLE CONFIGURATION $this->info("\tCreating roles ..."); $roleBoardVols = 0; $roleBoardOwners = 0; $roleBoardSkips = 0; // Okay, so apparently sometimes there are users that own boards that don't exist. // We cannot crate roles for these boards, so lets prune useless data. $boardsWeCareAbout = Board::select('board_uri')->whereIn('board_uri', array_keys($userBoardRelationships))->get()->pluck('board_uri'); if ($boardsWeCareAbout->count() != count($userBoardRelationships)) { $this->comment("\t\tThere are " . (count($userBoardRelationships) - $boardsWeCareAbout->count()) . " board(s) which users own that do not exist!"); } foreach ($boardsWeCareAbout as $board) { $ownerRole = null; $janitorRole = null; $roles = $userBoardRelationships[$board]; foreach ($roles as $mod => $role) { // TODO // Pull these values from config when formal importer created. switch ($role) { // Board volunteer case 19: $janitorRole = $janitorRole ?: Role::getJanitorRoleForBoard($board); $userRole = new UserRole(['user_id' => $mod, 'role_id' => $janitorRole->role_id]); if ($userRole->save()) { ++$roleBoardVols; } break; // Board owner // Board owner case 20: $ownerRole = $ownerRole ?: Role::getOwnerRoleForBoard($board); $userRole = new UserRole(['user_id' => $mod, 'role_id' => $ownerRole->role_id]); if ($userRole->save()) { ++$roleBoardOwners; } break; default: $this->line("\t\tI don't know what to do with role {$role} for user id {$mod} in {$board}."); break; } } } $this->info("\t\tCreated {$roleBoardOwners} owner(s) and {$roleBoardVols} janitor(s) "); $this->info("\t\tPulled roles from " . count($userBoardRelationships) . " boards with relationships."); unset($board, $roles, $mod, $role, $userRole, $janitorRole, $ownerRole); }
/** * Allows for the creation of a new board. * * @return Response */ public function putCreate(Request $request) { if (!$this->user->canCreateBoard()) { return abort(403); } $configErrors = []; // Check time and quantity restraints. if (!$this->user->canAdminConfig()) { $boardLastCreated = null; $boardsOwned = 0; $boardCreateTimer = $this->option('boardCreateTimer'); $boardsCreateMax = $this->option('boardCreateMax'); if (!$this->user->isAnonymous()) { foreach ($this->user->createdBoards as $board) { ++$boardsOwned; if (is_null($boardLastCreated) || $board->created_at->timestamp > $boardLastCreated->timestamp) { $boardLastCreated = $board->created_at; } } } if ($boardsCreateMax > 0 && $boardsOwned >= $boardsCreateMax) { $configErrors[] = Lang::choice("panel.error.board.create_more_than_max", $boardsCreateMax, ['boardsCreateMax' => $boardsCreateMax]); } if ($boardCreateTimer > 0 && (!is_null($boardLastCreated) && $boardLastCreated->diffInMinutes() < $boardCreateTimer)) { $configErrors[] = Lang::choice("panel.error.board.create_so_soon", $boardLastCreated->addMinutes($boardCreateTimer)->diffInMinutes() + 1, ['boardCreateTimer' => $boardLastCreated->diffInMinutes()]); } } if (count($configErrors)) { return redirect()->back()->withInput()->withErrors($configErrors); } // Validate input. // If the user is anonymous, we must also be creating an account. $input = Input::all(); if ($this->user->isAnonymous()) { $validator = $this->registrar->validator($input); if ($validator->fails()) { $this->throwValidationException($request, $validator); } } // Generate a list of banned URIs. $bannedUris = array_filter(explode("\n", $this->option('boardUriBanned'))); $bannedUris[] = "cp"; $bannedUris = implode(",", $bannedUris); // Validate the basic boardconstraints. $input['board_uri'] = strtolower((string) $input['board_uri']); $requirements = ['board_uri' => ["required", "unique:boards,board_uri", "not_in:{$bannedUris}", "string", "regex:(" . Board::URI_PATTERN . ")"], 'title' => "required|string|between:1,255", 'description' => "string|between:0,255"]; $validator = Validator::make($input, $requirements); if ($validator->fails()) { $this->throwValidationException($request, $validator); } if ($this->user->isAnonymous()) { $this->auth->login($this->registrar->create($request->all())); $this->user = $this->auth->user(); } // Create the board. $board = new Board(['board_uri' => $input['board_uri'], 'title' => $input['title'], 'description' => $input['description'], 'created_by' => $this->user->user_id, 'operated_by' => $this->user->user_id]); $board->save(); // Seed board ownership permissions. $board->setOwner($this->user); $this->log("log.board.create", $board->board_uri); Event::fire(new BoardWasCreated($board, $this->user)); return redirect("cp/board/{$board->board_uri}"); }