/**
* Shows the player profile
*
* @param integer $id
* @param string $name
*/
public function profile($id, $name = '')
{
// Cache key
$key = sprintf('player.%u', $id);
// Is there already a cached version for the player
$isCached = Cache::has($key);
// Get or Set cache for player
$player = Cache::remember($key, 5, function () use($id) {
$json = $this->repository->setopts(['ban.previous.server', 'ban.record.server', 'reputation', 'infractionsGlobal', 'infractionsServer.server', 'stats.server', 'specialGroups'], true)->getPlayerById($id)->toJson();
return json_decode($json);
});
$charts = Cache::remember(sprintf('player.%u.charts', $id), 5, function () use($id) {
$charts = [];
$charts['overview'] = new Collection(DB::select(File::get(storage_path() . '/sql/playerCommandOverview.sql'), [$id]));
$charts['spline'] = new Collection(DB::select(File::get(storage_path() . '/sql/playerCommandHistory.sql'), [$id]));
$charts['aliases'] = Record::where('command_type', 48)->where('target_id', $id)->select(DB::raw('record_message AS `player_name`, COUNT(record_id) AS `seen`'))->groupBy('player_name')->get();
$charts['iphistory'] = Record::where('command_type', 49)->where('target_id', $id)->where('record_message', '!=', 'No previous IP on record')->select(DB::raw('record_message AS `ip`, COUNT(record_id) AS `seen`'))->groupBy('ip')->get();
$charts['overview'] = $charts['overview']->map(function ($command) {
return [$command->label, intval($command->value)];
});
$charts['aliases'] = $charts['aliases']->map(function ($a) {
return [$a->player_name, intval($a->seen)];
});
$charts['iphistory'] = $charts['iphistory']->map(function ($ip) {
return [$ip->ip, intval($ip->seen)];
});
return $charts;
});
$groups = MainHelper::specialGroups($player->special_groups, 'player_group');
$page_title = !empty($player->ClanTag) ? sprintf('[%s] %s', $player->ClanTag, $player->SoldierName) : $player->SoldierName;
return View::make('player.profile', compact('player', 'page_title', 'charts', 'isCached', 'groups'));
}
public function getSpecialGroups()
{
$groups = MainHelper::specialGroups();
return MainHelper::response($groups, null, null, null, false, true);
}
public function index()
{
$players = Special::with('player', 'game', 'server')->get();
$groups = MainHelper::specialGroups();
return View::make('admin.adkats.special_players.index', compact('players', 'groups'))->with('page_title', Lang::get('navigation.admin.adkats.items.special_players.title'));
}
public function getGroupAttribute()
{
$group = MainHelper::specialGroups($this->player_group);
return $group;
}
