public function Home()
{
$nbPlayersWithoutPhoto = Player::where('photo', null)->count();
$nbPlayersWithoutEmail = Player::where('email', null)->count();
//$nbTeamsWithoutCaptain = Player::where('photo', null)->count();
return view('admin.home', array('nbPlayersWithoutPhoto' => $nbPlayersWithoutPhoto, 'nbPlayersWithoutEmail' => $nbPlayersWithoutEmail));
}
/**
* Define the application's command schedule.
*
* @param \Illuminate\Console\Scheduling\Schedule $schedule
* @return void
*/
protected function schedule(Schedule $schedule)
{
$schedule->call(function () {
$players = DB::connection('game')->table('player_characters')->get();
foreach ($players as $player) {
if (!Player::where('id', $player->id)->exists()) {
$player_info = ['id' => $player->id, 'name' => $player->given_name, 'level' => $player->level, 'class' => 0, 'gold' => $player->gold, 'family_name' => $player->family_id ? DB::connection('game')->table('family')->where('id', $player->family_id)->first()->name : '-'];
Player::create($player_info);
}
}
})->everyTenMinutes();
$schedule->call(function () {
$families = DB::connection('game')->table('family')->get();
foreach ($families as $family) {
if (!Family::where('id', $family->id)->exists()) {
$gold = 0;
foreach (DB::connection('game')->table('player_characters')->where('family_id', $family->id)->get() as $player) {
$gold += $player->gold;
}
$family_info = ['id' => $family->id, 'name' => $family->name, 'level' => $family->lv, 'gold' => $gold, 'members' => DB::connection('game')->table('player_characters')->where('family_id', $family->id)->count(), 'leader' => DB::connection('game')->table('player_characters')->where('id', $family->leader_id)->first()->given_name];
Family::create($family_info);
}
}
})->everyTenMinutes();
}
/**
* Search players. If direct match, send to player page. If not, return all results to search results view.
*
* @param SearchRequest|Request $request
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector|\Illuminate\View\View
*/
public function playerSearch(SearchRequest $request)
{
$player = Player::where('name', $request->input('searchTerm'))->first();
if ($player) {
return redirect(route('view-player', array('id' => $player->accountID)));
}
$results = Player::where('name', 'LIKE', '%' . $request->input('searchTerm') . '%')->paginate(15);
return view('search.results', compact('results'));
}
public function getPlayers()
{
$players = [];
foreach ($this->Scores->groupBy('player_id') as $id => $t) {
$players[] = Player::where('id', '=', $id)->first();
}
if (count($players) > 0) {
return $players;
}
return false;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$this->info('[' . date('d/m/Y H:i:s') . '][FFTT:Players] STARTING');
$licencies = xml_liste_joueur_o('18270175');
Player::where('active', 1)->update(['active' => 0, 'saison' => date('Y') . '-' . (date('Y') - 1)]);
foreach ($licencies as $licencie) {
Artisan::queue('FFTT:Player', ['licence' => $licencie->licence]);
$this->info('[' . date('d/m/Y H:i:s') . '][FFTT:Players] ' . $licencie->licence . ' ending');
}
$this->info('[' . date('d/m/Y H:i:s') . '][FFTT:Players] ENDED');
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show(Request $request, Vote $votes)
{
$player1ID = Input::get('ddlPlayer1');
$player2ID = Input::get('ddlPlayer2');
$players_list = Player::orderby('last_name')->orderby('first_name')->get()->lists('last_first_name', 'player_id');
$player1 = Player::where('player_id', '=', $player1ID)->first();
$player2 = Player::where('player_id', '=', $player2ID)->first();
$h2h = new Match();
$head2head = $h2h->head2head($player1ID, $player2ID);
$skills = Skill::orderby('skill_id')->get();
$voter_id = \Auth::user()->id;
return view('pages/matchups.show', compact('players_list', 'player1', 'player2', 'head2head', 'skills', 'votes', 'voter_id'));
}
/**
* Joins the game of another person
*/
public function join()
{
$players = Player::where('user_id', Auth::id())->get();
$gameIds = $players->lists('game_id')->toArray();
$game = Game::whereNotIn('id', $gameIds)->where(['state' => Game::STATE_OPEN])->first();
if (is_null($game)) {
session()->flash('error', sprintf(self::ERROR_NO_GAMES_FOUND, Auth::user()->name));
return redirect()->route('welcome');
}
$player = new Player();
$player->game_id = $game->id;
$player->user_id = Auth::id();
$player->troops = 5;
$player->save();
session()->flash('success', sprintf(self::MESSAGE_JOINED_GAME, Auth::user()->name));
return redirect()->route(self::ROUTE_SHOW_GAME, [$game->id]);
}
public function __construct()
{
/*Licznik zmian, który zmienia się po 24h od dodania zmiany*/
$date = Carbon::now();
$date->modify('-24 hours');
$formatted_date = $date->format('Y-m-d H:i:s');
$countchange = Change::where('created_at', '>', $formatted_date)->count();
/*Licznik graczy Online na serwerze*/
$countonline = Player::where('online', '=', 1)->count();
/*Licznik niedoczytanych wiadomości prywatnych*/
$notread1 = Message::where('to_user_id', \Auth::id())->where('read', 0)->count();
if (\Auth::check()) {
Cache::remember('users', 5, function () {
return User::where('id', \Auth::id())->update(['last_activity' => Carbon::now()]);
});
}
/*Licznik i skrypt usuwający i nadający banicję za 4 ostrzeżenia na stronie*/
$countcautions = Caution::where('user_id', \Auth::id())->count();
if (!\Auth::guest() && $countcautions == 4) {
$user = User::where('id', \Auth::id())->first();
$g = array(4);
$user->update(['banned' => 'Zbanowany za 4 ostrzeżenia na stronie']);
$user->group()->sync($g);
}
$deleteCaution = Caution::where('user_id', \Auth::id())->where('created_at', '<=', Carbon::now()->subDays(14));
$deleteCaution->delete();
$section = Section::lists('name', 'id');
$lives = Live::latest('created_at')->take(5)->get();
if (!\Auth::guest()) {
$notifications = \Auth::user()->notification()->latest('created_at')->take(10)->get();
View::share('notifications', $notifications);
}
View::share('countchange', $countchange);
View::share('countonline', $countonline);
View::share('notread1', $notread1);
View::share('section', $section);
View::share('lives', $lives);
$this->middleware('banned', ['except' => ['auth']]);
}
protected function getFactionStat($fid, $stat, $total = 0)
{
$players = Player::where('faction_id', $fid)->get();
foreach ($players as $k => $v) {
if ($v[$stat] > 0) {
$total += $v[$stat];
}
}
return $total;
}
/**
* @param $name
* @return \Illuminate\Http\RedirectResponse
*/
public function postPlayerUndelete($name)
{
$player = Player::where('name', $name)->first();
if ($player == null || !\Auth::user()->isAdmin()) {
abort(404);
}
if (!DeletedPlayer::where('player_name', $name)->first()) {
return back()->with('error', 'Player no longer in deleted list');
}
$delplayer = DeletedPlayer::where('player_name', $name)->first();
$delplayer->delete();
return redirect()->back()->with('success', 'Success! Player will be removed from deleted-list within an hour.');
}
public function PlayersNoPhoto()
{
$players = Player::where('photo', null)->get();
return view('admin.batchs.players', array('players' => $players));
}
public function online()
{
$players = Player::where('online', '=', 1)->get();
return view('character.online', compact('players'));
}
/**
* 创建玩家实例
*/
public function create()
{
// 取得玩家终端ID
$intDeviceId = Input::get('device_id');
// 终端ID检查
if (!$intDeviceId || $intDeviceId == "") {
return 'Create Error';
}
// 检查玩家是否已经存在
$objPlayerCheck = Player::where('device_id', $intDeviceId)->get();
if (!empty($objPlayerCheck->toArray())) {
return 'Player Is Exsit';
}
// TODO Truncate
DB::beginTransaction();
// 创建玩家实例
$objPlayer = new Player();
$objPlayer->device_id = $intDeviceId;
if ($objPlayer->save()) {
// 若玩家实例创建成功,创建玩家数据
$objPlayerData = new PlayerData();
// 玩家数据初始化 TODO
$objPlayerData->id = $objPlayer->id;
$objPlayerData->code = "";
$objPlayerData->profile = "";
$objPlayerData->money = 500;
$objPlayerData->stone = 50;
if ($objPlayerData->save()) {
// 最初的卡片赋予 TODO 初始卡片选择
$objPlayer->appendCard(1);
// 最初的队伍组建
$objPlayer->firstTeam();
// 其他初始化项目 如果有的话添加
DB::commit();
return Response::json($objPlayerData);
} else {
// 若保持失败
DB::rollback();
return Response::json(null);
}
} else {
// 若保持失败
DB::rollback();
return Response::json(null);
}
}
/**
* Search players
*
* @return json
**/
public function search(SearchPlayerRequest $request)
{
$players = Player::where('first_name', 'like', '%' . $request->search . '%')->orWhere('last_name', 'like', '%' . $request->search . '%')->orWhere('email', 'like', '%' . $request->search . '%')->distinct()->paginate(20);
return view('dashboard.players.index', compact('players', 'request'));
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$licence = $this->argument('licence');
if (is_array($licence)) {
$licence = $licence[0];
}
$lic = xml_licence_b($licence)->licence;
if ($lic != '') {
$player = Player::where('licence', $licence)->first();
if ($player == null) {
$player = new Player();
}
$player->idlicence = $lic->idlicence;
$player->licence = $lic->licence;
$player->nom = $lic->nom;
$player->prenom = $lic->prenom;
$player->numclub = $lic->numclub;
$player->sexe = $lic->sexe;
$player->type = $lic->type;
$player->certif = $lic->certif;
$player->validation = $lic->validation;
$player->echelon = $lic->echelon;
$player->place = $lic->place;
$player->point = (int) $lic->point;
$player->cat = $lic->cat;
$player->pointm = $lic->pointm == '' ? 500 : (int) $lic->pointm;
$player->apointm = $lic->apointm == '' ? 500 : (int) $lic->apointm;
$player->initm = $lic->initm == '' ? 500 : (int) $lic->initm;
$player->active = 1;
$player->save();
$histos = xml_histo_classement($player->licence);
$i = 1;
foreach ($histos as $hist) {
$histo = RankHisto::where('player_id', $player->id)->where('id_h', $i)->first();
if ($histo == null) {
$histo = new RankHisto();
}
$histo->id_h = $i;
$histo->player_id = $player->id;
$histo->echelon = $hist->echelon;
$histo->place = $hist->place;
$histo->point = (int) $hist->point;
$histo->saison = $hist->saison;
$histo->phase = (int) $hist->phase;
$histo->save();
$i++;
}
Versus::where('player_id', $player->id)->where('active', 1)->update(['active' => 0, 'saison' => date('Y') . '-' . (date('Y') - 1)]);
$parties_mysql = xml_partie_mysql($player->licence);
foreach ($parties_mysql as $partie) {
$versus = Versus::where('player_id', $player->id)->where('advlicence', $partie->advlic)->where('date', $partie->date)->first();
if ($versus == null) {
$versus = new Versus();
}
$versus->player_id = $player->id;
$versus->licence = $partie->licence;
$versus->advlicence = $partie->advlic;
$versus->vd = $partie->vd;
$versus->numjourn = $partie->numjourn;
$versus->codechamp = $partie->codechamp;
$versus->date = $partie->date;
$versus->datef = substr($partie->date, 6, 2) . substr($partie->date, 3, 2) . substr($partie->date, 0, 2);
$versus->advsexe = $partie->advsexe;
$versus->advnompre = $partie->advnompre;
$versus->pointres = $partie->pointres;
$versus->coefchamp = $partie->coefchamp;
$versus->advclaof = $partie->advclaof;
$versus->active = 1;
$versus->save();
}
$parties_mysql = xml_partie($player->licence);
foreach ($parties_mysql as $partie) {
$versus = Versus::where('player_id', $player->id)->where('advnompre', substr($partie->nom, 0, 24))->where('date', $partie->date)->where('vd', $partie->victoire)->first();
if ($versus != null) {
$versus->epreuve = $partie->epreuve;
$versus->classement = $partie->classement;
$versus->forfait = $partie->forfait;
$versus->active = 1;
$versus->save();
}
}
if ($player->photo == null) {
$glob = glob(public_path('img/photos/licencies/' . str_slug($player->nom) . '-' . str_slug($player->prenom) . '.*'));
if (count($glob) > 0) {
$image = $glob[0];
$player->photo = 'licencies/' . str_slug($player->nom) . '-' . str_slug($player->prenom) . '.' . pathinfo($image)['extension'];
$player->save();
} else {
$image = public_path('img/photos/none.jpg');
}
} else {
$image = public_path('img/photos/' . $player->photo);
}
if (file_exists($image)) {
if (pathinfo($image)['extension'] == 'png') {
$jpg_image = imagecreatefrompng($image);
} else {
$jpg_image = imagecreatefromjpeg($image);
}
$red = imagecolorallocate($jpg_image, 180, 0, 0);
$green = imagecolorallocate($jpg_image, 0, 180, 0);
$font_path = public_path() . '/fonts/IndieFlower.ttf';
$points = round($player->pointm - $player->point, 0);
if ($points >= 0) {
$color = $green;
$points = '+' . $points;
} else {
$color = $red;
}
$imgSize = getimagesize($image)[0];
$size = 66 * $imgSize / 300;
$x = 130 * $imgSize / 300;
$y = 290 * $imgSize / 300;
imagettftext($jpg_image, $size, 10, $x, $y, $color, $font_path, $points);
imagejpeg($jpg_image, public_path() . '/img/photos/prog-' . str_slug($player->nom) . '-' . str_slug($player->prenom) . '.jpg');
imagedestroy($jpg_image);
}
} else {
dd($licence);
}
}
public function home()
{
$players = Player::where('active', 1)->orderBy('pointm', 'desc')->orderBy('nom', 'asc')->orderBy('prenom', 'asc')->get();
return view('front.players.home', array('players' => $players));
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id, $serverId)
{
$player = Player::where('serverID', $serverId)->where('accountID', $id)->firstOrFail();
return view('players.view', compact('player'));
}
public function getPlayerById($id)
{
$player = Player::where('id', (int) $id);
return response()->json(['player' => $player]);
}
/**
* Delete player by id.
*
* @param int $id
* @return Response
*/
public function delete($id)
{
$player = NULL;
if (is_numeric($id)) {
$player = Player::find($id)->first();
} else {
$player = Player::where('nick', '=', $id)->first();
}
if ($player === NULL) {
$this->tpl['title'] = 'Not found';
$this->tpl['error']['message'] = 'User not found';
$this->tpl['error']['description'] = 'Sorry, but your user is not found.';
return \Response::view('errors.404', $this->tpl);
}
$player->delete();
return \Redirect::route('players');
}
