public function challenges()
{
$startd = DB::table('Games')->select('start')->first();
$endd = DB::table('Games')->select('stop')->first();
if ($startd->start > Carbon::now()) {
return view("pages.countdown");
} elseif ($endd->stop < Carbon::now()) {
return view('pages.closed');
}
$num_users = User::count();
$completed = Submitted_flag::count();
$num_challenges = Challenge::count();
$average_c = $completed / $num_users / $num_challenges * 100;
$stats = array('num_users' => $num_users, 'completed' => $completed, 'average' => $average_c);
$mycompleted = Submitted_flag::where('user_id', Auth::user()->id)->get()->toArray();
$game = Game::first();
$categories = Category::get();
$categories = $categories->toArray();
foreach ($categories as $category) {
$challenges = Challenge::where('category_id', $category['id'])->orderby('point_value', 'ASC')->get()->toArray();
$categories[(int) $category['id'] - 1]['challenges'] = $challenges;
}
$directory = base_path() . '/public/Challenges_Repo/';
$files = scandir($directory);
$startd = DB::table('Games')->select('start')->first();
if ($startd->start > Carbon::now()) {
$start = true;
} else {
$start = false;
}
$data = array('user' => Auth::user(), 'game' => $game, 'categories' => $categories, 'stats' => $stats, 'files' => $files, 'completed' => $mycompleted, 'start' => $start);
return view("pages.challenges")->with('data', $data);
}
public function challenges()
{
/*$game = Game::first();
$categories = Category::get();
$categories = $categories->toArray();
foreach($categories as $category)
{
$challenges = Challenge::where('category_id', $category['id'])->get()->toArray();
$categories[(int)$category['id'] - 1]['challenges'] = $challenges;
}
$data = array('game' => $game, 'categories' => $categories);*/
$num_users = User::count();
$completed = Submitted_flag::count();
$num_challenges = Challenge::count();
$average_c = $completed / $num_users / $num_challenges * 100;
$stats = array('num_users' => $num_users, 'completed' => $completed, 'average' => $average_c);
$game = Game::first();
$categories = Category::get();
$categories = $categories->toArray();
foreach ($categories as $category) {
$challenges = Challenge::where('category_id', $category['id'])->get()->toArray();
$categories[(int) $category['id'] - 1]['challenges'] = $challenges;
}
$directory = base_path() . '/public/Challenges_Repo/';
$files = scandir($directory);
$data = array('user' => Auth::user(), 'game' => $game, 'categories' => $categories, 'stats' => $stats, 'files' => $files);
return view("pages.challenges")->with('data', $data);
}