public function index($gamertag = '', $characterId = '')
{
try {
$account = Account::with('destiny.characters')->where('seo', Text::seoGamertag($gamertag))->firstOrFail();
$games = GamePlayer::with('game')->select('game_players.*', 'games.occurredAt')->leftJoin('games', 'game_players.game_id', '=', 'games.instanceId')->where('membershipId', $account->destiny->membershipId)->where('deaths', 0)->where('games.instanceId', '!=', 0)->orderBy('games.occurredAt', 'DESC')->get();
$games->each(function ($game_player) {
$game_player->url = $game_player->game->buildUrl();
});
// setup hash cache
Hashes::cacheAccountHashes($account, $games);
return view('destiny.profile', ['account' => $account, 'games' => $games, 'characterId' => $account->destiny->characterExists($characterId) ? $characterId : false, 'description' => ($account->isPandaLove() ? "PandaLove: " : null) . $account->gamertag . " Destiny Profile", 'title' => $account->gamertag . ($account->isPandaLove() ? " (Panda Love Member)" : null)]);
} catch (ModelNotFoundException $e) {
\App::abort(404, 'Da Gone!!! We have no idea what you are looking for.');
}
}
