public function indexGame($id) { $game = Game::where('id', '=', $id)->orWhere('slug', '=', $id)->first(); $events = $game->gameEvent()->where('approved', '=', '1')->where('public_state', '=', '1')->where('finish_date', '>=', date("Y-m-d"))->orderBy('start_date')->get(); if (Sentry::check() && Sentry::getUser()->timezone) { return View::make('event.index_game_tz', array('events' => $events)); } return View::make('event.index_game', array('events' => $events)); }
public function getRanking() { $ranking = Game::where('points', '>', 0)->orderBy('points', 'desc')->with('user')->with('level'); $ranking = $ranking->paginate(20); return View::make('game.ranking', compact('ranking')); }
public static function getGameUrlSiteMap() { $now = Carbon\Carbon::now(); $games = Game::where('status', ENABLED)->where('start_date', '<=', $now)->orderBy('start_date', 'desc')->get(); return $games; }