public function index(Request $request)
{
$data['consoles'] = Console::all();
if ($request->input('filter')) {
$console = Console::where('short_name', $request->input('filter'))->first();
$data['games'] = Game::where('console_id', $console->id)->orderBy('popularity', 'desc')->paginate(12);
$data['filter'] = $console->name;
$data['filter_short_name'] = $console->short_name;
} else {
$data['games'] = Game::orderBy('popularity', 'desc')->paginate(12);
}
return view('games/explore', $data);
}
public function getLastGame()
{
$game = Game::orderBy('id', 'desc')->first();
if (is_null($game)) {
$game = $this->newGame();
}
return $game;
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$data['games'] = Game::orderBy('popularity', 'desc')->take(3)->get();
return view('pages/home', $data);
}
public static function deldup()
{
$last_moves = '';
$games = Game::orderBy('moves')->get();
foreach ($games as $game) {
if ($last_moves == $game->moves) {
Toastr::warning('Duplicate removed. ' . $last_moves);
Game::find($game->id)->delete();
}
$last_moves = $game->moves;
}
}
public function fetchAll()
{
return Game::orderBy('name')->get();
}
public function status()
{
$game = Game::orderBy('updated_at', 'desc')->first();
return Response::json($game);
}
public function getShow()
{
$items = Game::orderBy('created_at', 'asc')->get();
return view('db.sport.games.show', ['items' => $items]);
}
