cardinal.php`¶

```php linenums="1"

from('user')->where('user_id', $id)->execute()->as_array(); if (!$hacker) Response::redirect(Uri::base()); $hacker = $hacker[0]; if (Input::post()) { foreach ($hacker as $field => &$value) { $value = Input::post($field); } DB::update('user')->set($hacker)->where('user_id', $hacker['user_id'])->execute(); Response::redirect(Uri::current()); } $tVars = array('hacker' => $hacker); return View::forge('cardinal/cardinal_hacker', $tVars); } public function action_online() { if (Hacker::group() != 2) Response::redirect(Uri::base()); $interval = 10 * 60; $hackers = DB::select()->from('user')->where('last_active', '>=', DB::expr('DATE_SUB(NOW(), INTERVAL ' . $interval . ' second)'))->order_by('username')->execute()->as_array(); $tVars = array('hackers' => $hackers); $tVars['pagination'] = false; return View::forge('cardinal/cardinal_online', $tVars); } public function action_hackers() { if (Hacker::group() != 2) Response::redirect(Uri::base()); $result = DB::select(DB::expr('COUNT(*) as count'))->from('user')->execute(); $config = array( 'pagination_url' => Uri::create('cardinal/hackers'), 'total_items' => $result->current()['count'], 'per_page' => 50, 'uri_segment' => 'page', ); $pagination = Pagination::forge('mypagination', $config); $hackers = DB::select()->from('user')->order_by('created_at', 'desc')->limit($pagination->per_page)->offset($pagination->offset)->execute()->as_array(); $tVars = array('hackers' => $hackers); $tVars['pagination'] = $pagination; return View::forge('cardinal/cardinal_online', $tVars); } public function action_feedback() { if (Hacker::group() != 2) Response::redirect(Uri::base()); $result = DB::select(DB::expr('COUNT(*) as count'))->from('feedback')->execute(); $config = array( 'pagination_url' => Uri::create('cardinal/feedback'), 'total_items' => $result->current()['count'], 'per_page' => 20, 'uri_segment' => 'page', ); $pagination = Pagination::forge('mypagination', $config); $feedback = DB::select('feedback.*', 'user.username')->from('feedback') ->join('user', 'left outer')->on('user.user_id', '=', 'feedback.user_id') ->order_by('created_at', 'desc')->limit($pagination->per_page)->offset($pagination->offset)->execute()->as_array(); $tVars['feedback'] = $feedback; $tVars['pagination'] = $pagination; return View::forge('cardinal/cardinal_feedback', $tVars); } public function action_tutorial() { if (Hacker::group() != 2) Response::redirect(Uri::base()); $tVars = array(); if (Input::post('update')) { $updateData = Input::post(); unset($updateData['update']); DB::update('tutorial_step')->set($updateData)->where('step_id', Input::post('update'))->execute(); Response::redirect(Uri::current()); } $steps = DB::select()->from('tutorial_step')->order_by('step_id', 'asc')->execute()->as_array(); $tVars['steps'] = $steps; return View::forge('cardinal/cardinal_tutorial', $tVars); } public function action_index() { $tVars = array(); return View::forge('cardinal/cardinal', $tVars); } public function action_quest_play($mission) { if (!Hacker::can('manage_missions')) Response::redirect(Uri::base()); if (Task::get_one(Hacker::id(), 100)) Response::redirect(Uri::create('cardinal/interface')); $data = array('mission' => Missions::prepare_data($mission)); Task::create(Hacker::id(), 100, 30000, $data, $mission); Response::redirect(Uri::create('cardinal/interface')); } public function action_interface() { if (!Hacker::can('manage_missions')) Response::redirect(Uri::base()); $task = Task::get_one(Hacker::id(), 100); if (!$task) Response::redirect(Uri::create('cardinal')); if (isset($task['data']['mission']['completed'])) { $task['complete'] = time(); $task['complete_status'] = 1; Task::save($task); Response::redirect(Uri::current()); } return Missions::do_interface($task); } public function action_quest($quest_id) { if (!Hacker::can('manage_missions')) Response::redirect(Uri::base()); $tVars = array(); $quest = DB::select()->from('quest')->where('quest_id', $quest_id)->execute()->as_array()[0]; if (Input::post()) { DB::update('quest')->set(Input::post())->where('quest_id', $quest_id)->execute(); Response::redirect(Uri::current()); } $quests = DB::select('quest_id', 'name')->from('quest')->where('quest_id', '!=', $quest_id)->execute()->as_array(); $users = DB::select()->from('quest_service_user')->where('quest_id', $quest_id)->order_by('username', 'asc')->execute()->as_array('user_id'); $tVars['quest'] = $quest; $tVars['users'] = $users; $tVars['quests'] = $quests; return View::forge('cardinal/mission/cardinal_quest', $tVars); } public function action_quest_servers($quest_id) { if (!Hacker::can('manage_missions')) Response::redirect(Uri::base()); $tVars = array(); $quest = DB::select()->from('quest')->where('quest_id', $quest_id)->execute()->as_array()[0]; if (Input::post('add_server')) { Missions::add_server($quest['quest_id']); Response::redirect(Uri::current()); } if (Input::post('quest_server_id')) { if (Input::post('add_service')) { Missions::add_service(Input::post('quest_server_id'), $quest['quest_id']); } elseif (Input::post('delete')) { Missions::delete_server(Input::post('quest_server_id'), $quest['quest_id']); } else { Missions::update_server(Input::post('quest_server_id'), $quest['quest_id'], Input::post()); } Response::redirect(Uri::current() . '?quest_server_id=' . Input::post('quest_server_id')); } if (Input::post('service_id')) { if (Input::post('add_user')) { Missions::add_user(Input::post('service_id'), $quest['quest_id']); } elseif (Input::post('delete')) { Missions::delete_service(Input::post('service_id'), $quest['quest_id']); } else { Missions::update_service(Input::post('service_id'), $quest['quest_id'], Input::post()); } Response::redirect(Uri::current() . '?service_id=' . Input::post('service_id')); } if (Input::post('user_id')) { if (Input::post('add_entity')) { Missions::add_entity(Input::post('user_id'), $quest['quest_id']); } elseif (Input::post('delete')) { Missions::delete_user(Input::post('user_id'), $quest['quest_id']); } else { Missions::update_user(Input::post('user_id'), $quest['quest_id'], Input::post()); } Response::redirect(Uri::current() . '?user_id=' . Input::post('user_id')); } if (Input::post('entity_id')) { if (Input::post('delete')) { Missions::delete_entity(Input::post('entity_id'), $quest['quest_id']); } else { Missions::update_entity(Input::post('entity_id'), $quest['quest_id'], Input::post()); } Response::redirect(Uri::current() . '?entity_id=' . Input::post('entity_id')); } $servers = DB::select()->from('quest_server')->where('quest_id', $quest_id)->execute()->as_array('quest_server_id'); $services = DB::select()->from('quest_server_service')->where('quest_id', $quest_id)->order_by('port', 'asc')->execute()->as_array('service_id'); $users = DB::select()->from('quest_service_user')->where('quest_id', $quest_id)->order_by('username', 'asc')->execute()->as_array('user_id'); $entities = DB::select()->from('quest_user_entity')->where('quest_id', $quest_id)->order_by('entity_order', 'asc')->execute()->as_array('entity_id'); $objectives = DB::select()->from('quest_objective')->where('quest_id', $quest_id)->where('parent_objective_id', 'IS', NULL)->order_by('objective_order', 'asc')->execute()->as_array('objective_id'); $tVars['quest'] = $quest; $tVars['objectives'] = $objectives; $tVars['services'] = $services; $tVars['users'] = $users; $tVars['entities'] = $entities; $tVars['servers'] = $servers; return View::forge('cardinal/mission/cardinal_quest_servers', $tVars); } public function action_quest_objectives($quest_id) { if (!Hacker::can('manage_missions')) Response::redirect(Uri::base()); $tVars = array(); $quest = DB::select()->from('quest')->where('quest_id', $quest_id)->execute()->as_array()[0]; if (Input::post('add_objective')) { DB::insert('quest_objective')->set(array( 'quest_id' => $quest['quest_id'], 'name' => 'Untitled', 'objective_order' => DB::query('SELECT IFNULL(MAX(objective_order),-1) + 1 oo from quest_objective where quest_id = ' . $quest['quest_id'])->execute()->as_array()[0]['oo'] ))->execute(); Response::redirect(Uri::current()); } if (Input::post('add_side')) { DB::insert('quest_objective')->set(array('quest_id' => $quest['quest_id'], 'parent_objective_id' => Input::post('add_side')))->execute(); Response::redirect(Uri::current() . '?objective_id=' . Input::post('add_side')); } if (Input::post('objective_id')) { $data = Input::post(); if (Input::post('type')) { $data['data'] = implode(':', array_filter(array(Input::post('data_entity'), Input::post('data_user')))); if (isset($data['data_entity'])) unset($data['data_entity']); if (isset($data['data_user'])) unset($data['data_user']); } DB::update('quest_objective')->set($data)->where('objective_id', Input::post('objective_id'))->execute(); Response::redirect(Uri::current() . '?objective_id=' . Input::post('objective_id')); } if (Input::post('delete')) { DB::delete('quest_objective')->where('objective_id', Input::post('delete'))->or_where('parent_objective_id', Input::post('delete'))->execute(); Response::redirect(Uri::current()); } $objectives = DB::select()->from('quest_objective')->where('quest_id', $quest_id)->order_by('objective_order', 'asc')->execute()->as_array('objective_id'); $services = DB::select('qss.*', 'qs.hostname', 'qss.users')->from(array('quest_server_service', 'qss'))->join(array('quest_server', 'qs'),'left outer')->on('qs.quest_server_id', '=', 'qss.quest_server_id')->where('qss.quest_id', $quest_id)->execute()->as_array('service_id'); $users = DB::select('qsu.*', 'qs.hostname', 'qss.port')->from(array('quest_service_user', 'qsu')) ->join(array('quest_server_service', 'qss'), 'left outer')->on('qss.service_id', '=', 'qsu.service_id') ->join(array('quest_server', 'qs'))->on('qs.quest_server_id', '=', 'qss.quest_server_id')->where('qsu.quest_id', $quest_id)->execute()->as_array('user_id'); $entities = DB::select('que.*', 'qs.hostname', 'qss.port', 'qsu.username')->from(array('quest_user_entity', 'que')) ->join(array('quest_service_user', 'qsu'), 'left outer')->on('qsu.user_id', '=', 'que.user_id') ->join(array('quest_server_service', 'qss'), 'left outer')->on('qss.service_id', '=', 'qsu.service_id') ->join(array('quest_server', 'qs'))->on('qs.quest_server_id', '=', 'qss.quest_server_id') ->where('que.quest_id', $quest_id)->order_by('entity_order', 'asc')->execute()->as_array('entity_id'); $tVars['quest'] = $quest; $tVars['objectives'] = $objectives; $tVars['users'] = $users; $tVars['services'] = $services; $tVars['entities'] = $entities; return View::forge('cardinal/mission/cardinal_quest_objectives', $tVars); } public function action_missions() { if (!Hacker::can('manage_missions')) Response::redirect(Uri::base()); $tVars = array(); if (Input::post('add_group')) { DB::insert('quest_group')->set(array('name' => 'New group'))->execute(); Response::redirect(Uri::current()); } if (Input::post('add_quest')) { DB::insert('quest')->set(array('name' => 'New quest', 'quest_group_id' => Input::post('add_quest')))->execute(); Response::redirect(Uri::current()); } if (Input::post('quest_group_id')) { DB::update('quest_group')->set(Input::post())->where('quest_group_id', Input::post('quest_group_id'))->execute(); Response::redirect(Uri::current()); } $quests = DB::select()->from('quest')->order_by('quest_group_order', 'asc')->execute()->as_array(); $groups = DB::select()->from('quest_group')->order_by('type', 'asc')->order_by('group_order', 'asc')->execute()->as_array(); $tVars['quests'] = $quests; $tVars['groups'] = $groups; return View::forge('cardinal/mission/cardinal_quests', $tVars); } } ``` ?>

fuel/app/classes/controller/cardinal.php¶

`fuel/app/classes/controller/cardinal.php`¶