/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $userKey = $request->input('_key'); if ($userKey && !empty($userKey)) { $user = User::where('user_key', $userKey)->first(); if (Auth::check()) { $prevuser = Auth::user(); Auth::logout(); } if ($user->exists()) { Auth::login($user); $response = $next($request); Auth::logout(); if (isset($prevuser) && isset($prevuser->id)) { Auth::login($prevuser); } return $response; } else { $response = $next($request); } if (isset($prevuser)) { Auth::login($prevuser); } return $response; } if ($request->is('api/v1/donate/ipn')) { return $next($request); } return parent::handle($request, $next); }
public function IPNAction() { $listener = new ListenerBuilder(); $listener = $listener->build(); $listener->onVerified(function (MessageVerifiedEvent $event) { $ipnMessage = $event->getMessage(); if ($ipnMessage->get('payment_status') != 'Completed') { return; } $original_amount = $ipnMessage->get('mc_gross'); $amount_sub = $ipnMessage->get('mc_fee'); $smallId = $ipnMessage->get('custom'); $donationLog = new DonationLog(); $donationLog->status = 'Completed'; $donationLog->amount = $original_amount - $amount_sub; $donationLog->original_amount = $original_amount; if (is_numeric($smallId)) { $user = User::whereSmallId($smallId)->first(); if (isset($user->id)) { $user->donation += $original_amount; $user->save(); $donationLog->small_id = $smallId; Cache::forget("profile_{$smallId}"); } } $donationLog->save(); }); $listener->listen(); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { if ($this->auth->guest()) { if ($request->ajax()) { return response('Unauthorized.', 401); } else { $thisRoute = explode('.', $request->route()->getName()); if ($thisRoute[0] == 'api') { $userKey = $request->input('_key'); if ($userKey && !empty($userKey)) { $user = User::where('user_key', $userKey)->first(); if (isset($user->id)) { return $next($request); } } return ['error' => 'forbidden']; } return redirect()->guest('auth/login'); } } return $next($request); }
public function login() { if (Auth::check() || Auth::viaRemember()) { return redirect()->intended('/list')->with('success', 'You have Successfully logged in!'); } $steamuser = SteamAuth::Auth(); $steam64BitId = str_replace("http://steamcommunity.com/openid/id/", "", $steamuser['steamid']); $steamAPI = new SteamAPI('info'); $steamAPI->setSteamId($steam64BitId); $userSteamInfo = $steamAPI->run(); if (isset($userSteamInfo->type) && $userSteamInfo->type == 'error' || !isset($userSteamInfo->response->players[0])) { return redirect()->intended('/')->with('error', 'There was an error trying to communicate with Steam Server.'); } $userSteamInfo = $userSteamInfo->response->players[0]; $steamAPI = new SteamAPI('friends'); $steamAPI->setSteamId($steam64BitId); $userSteamFriends = $steamAPI->run(); $simpleFriends = []; if (isset($userSteamFriends->friendslist)) { $userSteamFriends = $userSteamFriends->friendslist->friends; foreach ($userSteamFriends as $userSteamFriend) { $simpleFriends[] = Steam::toSmallId($userSteamFriend->steamid); } } $smallId = Steam::toSmallId($steam64BitId); // Try to grab user or create new one $user = User::firstOrCreate(['small_id' => $smallId]); $user->display_name = $userSteamInfo->personaname; $user->friendslist = json_encode($simpleFriends); $singleProfile = new SingleProfile($smallId); $singleProfile->getProfile(); if (!$user->save()) { return redirect()->intended('/')->with('error', 'There was an error adding user to database'); } Auth::login($user, true); return redirect()->intended('/list')->with('success', 'You have Successfully logged in.'); }
function __construct($userList) { if (!isset($userList->id)) { $this->error = "list_invalid"; return; } if (Auth::check()) { $user = Auth::User(); $userFriends = json_decode($user->friendslist); if ($user->id != $userList->user_id) { $listAuthor = User::whereId($userList->user_id)->first(); if ($listAuthor->exists() && !empty($userFriends) && !in_array($listAuthor->small_id, $userFriends) && $userList->privacy == 2 || $userList->privacy == 3) { $this->error = "list_no_permission"; return; } } } else { if ($userList->privacy == 2 || $userList->privacy == 3) { $this->error = "list_no_permission"; return; } } $this->userList = $userList; }
public function listList() { $return = ['my_list' => [], 'friends_list' => []]; $user = Auth::user(); $myLists = UserList::where('user_list.user_id', $user->id)->leftjoin('user_list_profile as ulp_1', 'ulp_1.user_list_id', '=', 'user_list.id')->groupBy('user_list.id')->orderBy('user_list.id', 'desc')->leftJoin('subscription', function ($join) { $join->on('subscription.user_list_id', '=', 'user_list.id')->whereNull('subscription.deleted_at'); })->whereNull('ulp_1.deleted_at')->get(['user_list.id', 'user_list.title', 'user_list.privacy', 'user_list.created_at', \DB::raw('count(ulp_1.id) as users_in_list'), \DB::raw('count(distinct subscription.id) as sub_count')]); foreach ($myLists as $myList) { $return['my_list'][] = ['id' => $myList->id, 'title' => $myList->title, 'privacy' => $myList->privacy, 'created_at' => $myList->created_at->format("M j Y"), 'users_in_list' => $myList->users_in_list, 'sub_count' => $myList->sub_count]; } if (isset($user->friendslist)) { $friendsList = json_decode($user->friendslist); $myfriendsLists = User::whereIn('users.small_id', $friendsList)->whereNotIn('user_list.privacy', [3])->whereNull('user_list_profile.deleted_at')->groupBy('user_list.id')->orderBy('user_list.id', 'desc')->leftjoin('user_list', 'user_list.user_id', '=', 'users.id')->leftjoin('user_list_profile', 'user_list.id', '=', 'user_list_profile.user_list_id')->leftjoin('profile', 'profile.small_id', '=', 'users.small_id')->leftJoin('subscription', function ($join) { $join->on('subscription.user_list_id', '=', 'user_list.id')->whereNull('subscription.deleted_at'); })->having('users_in_list', '>', 0)->get(['profile.id as profile_id', 'profile.display_name', 'profile.avatar_thumb', 'profile.small_id', 'user_list.id as user_list_id', 'user_list.title', 'user_list.privacy', 'user_list.created_at', 'users.site_admin', 'users.donation', 'users.beta', \DB::raw('count(user_list_profile.created_at) as users_in_list'), \DB::raw('count(Distinct subscription.id) as sub_count')]); foreach ($myfriendsLists as $myfriendsList) { if (!isset($myfriendsList->profile_id) || empty($myfriendsList->profile_id)) { continue; } $return['friends_list'][] = ['profile_id' => $myfriendsList->profile_id, 'display_name' => $myfriendsList->display_name, 'avatar_thumb' => $myfriendsList->avatar_thumb, 'steam_64_bit' => Steam::to64bit($myfriendsList->small_id), 'user_list_id' => $myfriendsList->user_list_id, 'title' => $myfriendsList->title, 'privacy' => $myfriendsList->privacy, 'created_at' => $myfriendsList->created_at->format("M j Y"), 'site_admin' => (int) $myfriendsList->site_admin ?: 0, 'donation' => (int) $myfriendsList->donation ?: 0, 'beta' => (int) $myfriendsList->beta ?: 0, 'users_in_list' => $myfriendsList->users_in_list, 'sub_count' => $myfriendsList->sub_count]; } } return $return; }
public function newUserKey(Request $request) { if ($request->input('_key')) { return ['error' => 'forbidden']; } $user = Auth::user(); $users = User::whereNotNull('user_key')->get(); while (true) { $userKey = str_random(32); $exist = $users->where('user_key', $userKey)->first(); if (!isset($exist->id)) { $user->user_key = $userKey; $user->save(); break; } } return [$user->user_key]; }
private function updateUsingAPI() { /* Time to follow that great guide to updating via API above */ /* grab 'info' from web api and handle errors */ $steamAPI = new SteamAPI('info'); $steamAPI->setSmallId($this->smallId); $steamInfo = $steamAPI->run(); if ($steamAPI->error()) { return ['error' => $steamAPI->errorMessage()]; } if (!isset($steamInfo->response->players[0])) { return ['error' => 'profile_null']; } $steamInfo = $steamInfo->response->players[0]; /* grab 'ban' from web api and handle errors */ $steamAPI = new SteamAPI('ban'); $steamAPI->setSmallId($this->smallId); $steamBan = $steamAPI->run(); if ($steamAPI->error()) { return ['error' => $steamAPI->errorMessage()]; } if (!isset($steamBan->players[0])) { return ['error' => 'profile_null']; } $steamBan = $steamBan->players[0]; /* grab 'alias' from old web api but do not break on errors */ $steamAPI = new SteamAPI('alias'); $steamAPI->setSmallId($this->smallId); $steamAlias = $steamAPI->run(); if ($steamAPI->error()) { $steamAlias = []; } else { usort($steamAlias, array('VacStatus\\Steam\\Steam', 'aliasSort')); } /* Successfully passed steam's not very reliable api servers */ /* Lets hope we got the alias as well :))) */ /* Lets start up with profile table */ $profile = Profile::whereSmallId($this->smallId)->first(); if (!isset($profile->id)) { $profile = new Profile(); $profile->small_id = $this->smallId; if (isset($steamInfo->timecreated)) { $profile->profile_created = $steamInfo->timecreated; } } else { // Make sure to update if this was private and now suddenly public if (empty($profile->profile_created) && isset($steamInfo->timecreated)) { $profile->profile_created = $steamInfo->timecreated; } } $profile->display_name = $steamInfo->personaname; $profile->avatar = Steam::imgToHTTPS($steamInfo->avatarfull); $profile->avatar_thumb = Steam::imgToHTTPS($steamInfo->avatar); $profile->privacy = $steamInfo->communityvisibilitystate; $profile->alias = json_encode($steamAlias); if (!$profile->save()) { return ['error' => 'profile_save_error']; } /* Now to do profile_ban table */ $profileBan = $profile->ProfileBan; // Dont update the profile_ban if there is nothing to update // This has to do with in the future when I check for new bans to notify/email $skipProfileBan = false; $newVacBanDate = new DateTime(); $newVacBanDate->sub(new DateInterval("P{$steamBan->DaysSinceLastBan}D")); $combinedBan = (int) $steamBan->NumberOfVACBans + (int) $steamBan->NumberOfGameBans; if (!isset($profileBan->id)) { $profileBan = new ProfileBan(); $profileBan->profile_id = $profile->id; $profileBan->unban = false; } else { $skipProfileBan = $profileBan->skipProfileBanUpdate($steamBan); if ($profileBan->vac != (int) $steamBan->NumberOfVACBans + (int) $steamBan->NumberOfGameBans && $profileBan->vac_banned_on->format('Y-m-d') !== $newVacBanDate->format('Y-m-d')) { $skipProfileBan = false; $profileBan->timestamps = false; } if ($profileBan->vac > $combinedBan) { $profileBan->timestamps = false; $profileBan->unban = true; } } $profileBan->vac = $combinedBan; $profileBan->community = $steamBan->CommunityBanned; $profileBan->trade = $steamBan->EconomyBan != 'none'; $profileBan->vac_banned_on = $newVacBanDate->format('Y-m-d'); if (!$skipProfileBan) { if (!$profile->ProfileBan()->save($profileBan)) { return ['error' => 'profile_ban_save_error']; } } /* Time to do profile_old_alias */ /* Checks to make sure if there is already a same name before inserting new name */ $profileOldAlias = $profile->ProfileOldAlias()->whereProfileId($profile->id)->orderBy('id', 'desc')->get(); $currentTime = new DateTime(); if ($profileOldAlias->count() == 0) { $profileOldAlias = new ProfileOldAlias(); $profileOldAlias->profile_id = $profile->id; $profileOldAlias->seen = $currentTime->format('Y-m-d'); $profileOldAlias->seen_alias = $profile->display_name; $profileOldAlias->save(); } else { $match = false; $recent = 0; foreach ($profileOldAlias as $oldAlias) { if (!is_object($oldAlias)) { continue; } if ($oldAlias->seen_alias == $profile->display_name) { $match = true; break; } $recent = $oldAlias->compareTime($recent); } if (!$match && $recent + Steam::$UPDATE_TIME < time()) { $currentTime = new DateTime(); $newAlias = new ProfileOldAlias(); $newAlias->profile_id = $profile->id; $newAlias->seen = $currentTime->format('Y-m-d'); $newAlias->seen_alias = $profile->display_name; $profile->ProfileOldAlias()->save($newAlias); } } $profileOldAlias = $profile->ProfileOldAlias()->whereProfileId($profile->id)->orderBy('id', 'desc')->get(); /* Finished inserting / updating into the DB! */ /* Check to see if this user has an account in vacstatus */ $user = User::where('small_id', $this->smallId)->first(); /* getting the number of times checked and added */ $gettingCount = UserListProfile::whereProfileId($profile->id)->orderBy('id', 'desc')->get(); $profileTimesAdded = ['number' => $gettingCount->count(), 'time' => isset($gettingCount[0]) ? (new DateTime($gettingCount[0]->created_at))->format("M j Y") : null]; $profileCheckCache = "profile_checked_"; $currentProfileCheck = ['number' => 0, 'time' => date("M j Y", time())]; if (Cache::has($profileCheckCache . $this->smallId)) { $currentProfileCheck = Cache::get($profileCheckCache . $this->smallId); } $newProfileCheck = ['number' => $currentProfileCheck['number'] + 1, 'time' => date("M j Y", time())]; Cache::forever($profileCheckCache . $this->smallId, $newProfileCheck); /* Writing the return array for the single profile */ $steam64BitId = Steam::to64Bit($profile->small_id); $oldAliasArray = []; foreach ($profileOldAlias as $k => $oldAlias) { if ($oldAlias === true) { $oldAliasArray[] = ["newname" => $profileOldAlias->seen_alias, "timechanged" => $profileOldAlias->seen->format("M j Y")]; break; } $oldAliasArray[] = ["newname" => $oldAlias->seen_alias, "timechanged" => $oldAlias->seen->format("M j Y")]; } $return = ['id' => $profile->id, 'display_name' => $steamInfo->personaname, 'avatar' => Steam::imgToHTTPS($steamInfo->avatarfull), 'avatar_thumb' => Steam::imgToHTTPS($steamInfo->avatar), 'small_id' => $this->smallId, 'steam_64_bit' => $steam64BitId, 'steam_32_bit' => Steam::to32Bit($steam64BitId), 'profile_created' => isset($profile->profile_created) ? date("M j Y", $profile->profile_created) : "Unknown", 'privacy' => $steamInfo->communityvisibilitystate, 'alias' => Steam::friendlyAlias($steamAlias), 'created_at' => $profile->created_at->format("M j Y"), 'vac' => $combinedBan, 'vac_banned_on' => $newVacBanDate->format("M j Y"), 'community' => $steamBan->CommunityBanned, 'trade' => $steamBan->EconomyBan != 'none', 'site_admin' => (int) isset($user->id) ? $user->site_admin : 0, 'donation' => (int) isset($user->id) ? $user->donation : 0, 'beta' => (int) isset($user->id) ? $user->beta : 0, 'profile_old_alias' => $oldAliasArray, 'times_checked' => $currentProfileCheck, 'times_added' => $profileTimesAdded]; /* YAY nothing broke :D time to return the data (and update cache) */ $this->updateCache($return); return $return; }
public function user() { $users = User::paginate(50); return view('admin.pages.database.users', compact('users')); }