Exemplo n.º 1
0
 public function getCustomList()
 {
     if ($this->error()) {
         return $this->error();
     }
     $userList = $this->userList;
     $userListProfiles = UserList::where('user_list.id', $userList->id)->leftjoin('user_list_profile as ulp_1', 'ulp_1.user_list_id', '=', 'user_list.id')->whereNull('ulp_1.deleted_at')->leftJoin('user_list_profile as ulp_2', function ($join) {
         $join->on('ulp_2.profile_id', '=', 'ulp_1.profile_id')->whereNull('ulp_2.deleted_at');
     })->leftjoin('profile', 'ulp_1.profile_id', '=', 'profile.id')->leftjoin('profile_ban', 'profile.id', '=', 'profile_ban.profile_id')->leftjoin('users', 'profile.small_id', '=', 'users.small_id')->leftJoin('subscription', function ($join) {
         $join->on('subscription.user_list_id', '=', 'user_list.id')->whereNull('subscription.deleted_at');
     })->groupBy('profile.id')->orderBy('ulp_1.id', 'desc')->get(['ulp_1.profile_name', 'ulp_1.profile_description', 'profile.id', 'profile.display_name', 'profile.avatar_thumb', 'profile.small_id', 'profile_ban.vac', 'profile_ban.vac_banned_on', 'profile_ban.community', 'profile_ban.trade', 'users.site_admin', 'users.donation', 'users.beta', \DB::raw('max(ulp_1.created_at) as created_at'), \DB::raw('count(ulp_2.profile_id) as total'), \DB::raw('count(distinct subscription.id) as sub_count')]);
     $canSub = false;
     $subscription = null;
     if (Auth::check()) {
         $user = Auth::user();
         $userMail = $user->UserMail;
         $subscription = $user->Subscription->where('user_list_id', $userList->id)->first();
         if ($userMail && ($userMail->verify == "verified" || $userMail->pushbullet_verify == "verified")) {
             $canSub = true;
         }
     }
     $return = ['id' => $userList->id, 'title' => $userList->title, 'author' => $userList->user->display_name, 'my_list' => $this->myList(), 'can_sub' => $canSub, 'subscription' => $subscription, 'privacy' => $userList->privacy, 'sub_count' => isset($userListProfiles[0]) ? $userListProfiles[0]->sub_count : 0, 'list' => []];
     foreach ($userListProfiles as $userListProfile) {
         if (is_null($userListProfile->id)) {
             continue;
         }
         $vacBanDate = new DateTime($userListProfile->vac_banned_on);
         $return['list'][] = ['id' => $userListProfile->id, 'display_name' => $userListProfile->profile_name ?: $userListProfile->display_name, 'avatar_thumb' => $userListProfile->avatar_thumb, 'small_id' => $userListProfile->small_id, 'steam_64_bit' => Steam::to64Bit($userListProfile->small_id), 'vac' => $userListProfile->vac, 'vac_banned_on' => $vacBanDate->format("M j Y"), 'community' => $userListProfile->community, 'trade' => $userListProfile->trade, 'site_admin' => (int) $userListProfile->site_admin ?: 0, 'donation' => (int) $userListProfile->donation ?: 0, 'beta' => (int) $userListProfile->beta ?: 0, 'profile_description' => $userListProfile->profile_description, 'times_added' => ['number' => $userListProfile->total, 'time' => (new DateTime($userListProfile->created_at))->format("M j Y")]];
     }
     $multiProfile = new MultiProfile($return['list']);
     $return['list'] = $multiProfile->run();
     return $return;
 }
Exemplo n.º 2
0
 private function grabFromDB()
 {
     $userListProfiles = UserListProfile::select('profile.id', 'profile.display_name', 'profile.avatar_thumb', 'profile.small_id', 'profile_ban.vac', 'profile_ban.vac_banned_on', 'profile_ban.community', 'profile_ban.trade', 'users.site_admin', 'users.donation', 'users.beta', \DB::raw('max(user_list_profile.created_at) as created_at'), \DB::raw('count(user_list_profile.id) as total'))->groupBy('profile.id')->orderBy('total', 'desc')->whereNull('user_list_profile.deleted_at')->leftjoin('profile', 'user_list_profile.profile_id', '=', 'profile.id')->leftjoin('profile_ban', 'profile.id', '=', 'profile_ban.profile_id')->leftjoin('users', 'profile.small_id', '=', 'users.small_id')->take(20)->get();
     $return = [];
     foreach ($userListProfiles as $userListProfile) {
         $vacBanDate = new DateTime($userListProfile->vac_banned_on);
         $return[] = ['id' => $userListProfile->id, 'display_name' => $userListProfile->display_name, 'avatar_thumb' => $userListProfile->avatar_thumb, 'small_id' => $userListProfile->small_id, 'steam_64_bit' => Steam::to64Bit($userListProfile->small_id), 'vac' => $userListProfile->vac, 'vac_banned_on' => $vacBanDate->format("M j Y"), 'community' => $userListProfile->community, 'trade' => $userListProfile->trade, 'site_admin' => (int) $userListProfile->site_admin ?: 0, 'donation' => (int) $userListProfile->donation ?: 0, 'beta' => (int) $userListProfile->beta ?: 0, 'times_added' => ['number' => $userListProfile->total, 'time' => (new DateTime($userListProfile->created_at))->format("M j Y")]];
     }
     $multiProfile = new MultiProfile($return);
     $return = $multiProfile->run();
     $this->updateCache($return);
     return $return;
 }
Exemplo n.º 3
0
 public function search($searchKey)
 {
     $searchCache = "search_key_{$searchKey}";
     if (!Cache::has($searchCache)) {
         return ['error' => 'no values'];
     }
     $search = Steam::parseSearch(Cache::pull($searchCache));
     if (Auth::check()) {
         if (count($search) > Auth::User()->unlockSearch()) {
             return ['error' => 'Too many profiles listed in search box.'];
         }
     } else {
         if (count($search) > 30) {
             return ['error' => 'Too many profiles listed in search box for a guest.'];
         }
     }
     if (!is_array($search)) {
         return ['error' => 'Invalid Search Option'];
     }
     $validProfile = array();
     $invalidProfile = array();
     foreach ($search as $potentialProfile) {
         $steam3Id = Steam::findUser($potentialProfile);
         if (isset($steam3Id['error'])) {
             $invalidProfile[] = $potentialProfile;
         } else {
             $validProfile[] = $steam3Id['success'];
         }
     }
     $smallIds = Steam::toSmallId($validProfile);
     $profiles = Profile::select('profile.id', 'profile.display_name', 'profile.avatar_thumb', 'profile.small_id', 'profile.created_at', 'profile_ban.vac', 'profile_ban.vac_banned_on', 'profile_ban.community', 'profile_ban.trade', 'users.site_admin', 'users.donation', 'users.beta', \DB::raw('max(user_list_profile.created_at) as created_at'), \DB::raw('count(user_list_profile.id) as total'))->groupBy('profile.id')->leftJoin('user_list_profile', function ($join) {
         $join->on('user_list_profile.profile_id', '=', 'profile.id')->whereNull('user_list_profile.deleted_at');
     })->whereIn('profile.small_id', $smallIds)->leftjoin('profile_ban', 'profile.id', '=', 'profile_ban.profile_id')->leftjoin('users', 'profile.small_id', '=', 'users.small_id')->get();
     $profilesParsed = [];
     foreach ($smallIds as $smallId) {
         $profile = $profiles->where('small_id', (int) $smallId)->first();
         if (is_null($profile)) {
             $profilesParsed[] = ['small_id' => $smallId];
             continue;
         }
         $vacBanDate = new DateTime($profile->vac_banned_on);
         $profilesParsed[] = ['id' => $profile->id, 'display_name' => $profile->display_name, 'avatar_thumb' => $profile->avatar_thumb, 'small_id' => (int) $smallId, 'steam_64_bit' => Steam::to64Bit($profile->small_id), 'vac' => $profile->vac, 'vac_banned_on' => $vacBanDate->format("M j Y"), 'community' => $profile->community, 'trade' => $profile->trade, 'site_admin' => (int) $profile->site_admin ?: 0, 'donation' => (int) $profile->donation ?: 0, 'beta' => (int) $profile->beta ?: 0, 'times_added' => ['number' => $profile->total ?: 0, 'time' => (new DateTime($profile->created_at))->format("M j Y")]];
     }
     $multiProfile = new MultiProfile($profilesParsed);
     $profilesParsed = $multiProfile->run();
     $return = ['title' => 'Search Result', 'list' => $profilesParsed];
     return $return;
 }
Exemplo n.º 4
0
 private function updateUsingAPI()
 {
     $getSmallId = [];
     foreach ($this->refreshProfiles as $profile) {
         $smallId = $profile['profile']['small_id'];
         $key = $profile['profile_key'];
         $getSmallId[] = (int) $smallId;
         $toSaveKey[$smallId] = $key;
     }
     /* grab 'info' from web api and handle errors */
     $steamAPI = new SteamAPI('info');
     $steamAPI->setSmallId($getSmallId);
     $steamInfos = $steamAPI->run();
     if ($steamAPI->error()) {
         return ['error' => $steamAPI->errorMessage()];
     }
     if (!isset($steamInfos->response->players[0])) {
         return ['error' => 'profile_null'];
     }
     // simplify the variable
     $steamInfos = $steamInfos->response->players;
     /* grab 'ban' from web api and handle errors */
     $steamAPI = new SteamAPI('ban');
     $steamAPI->setSmallId($getSmallId);
     $steamBans = $steamAPI->run();
     if ($steamAPI->error()) {
         return ['error' => $steamAPI->errorMessage()];
     }
     if (!isset($steamBans->players[0])) {
         return ['error' => 'profile_null'];
     }
     $steamBans = $steamBans->players;
     // whereIn('profile.small_id', $getSmallId)->
     $profiles = Profile::whereIn('profile.small_id', $getSmallId)->groupBy('profile.id')->leftjoin('profile_ban', 'profile_ban.profile_id', '=', 'profile.id')->leftjoin('users', 'profile.small_id', '=', 'users.small_id')->leftjoin('user_list_profile', 'user_list_profile.profile_id', '=', 'profile.id')->whereNull('user_list_profile.deleted_at')->get(['profile.id', 'profile.small_id', 'profile.display_name', 'profile.privacy', 'profile.avatar_thumb', 'profile.avatar', 'profile.profile_created', 'profile.alias', 'profile.created_at', 'profile_ban.community', 'profile_ban.vac', 'profile_ban.trade', 'profile_ban.unban', 'users.site_admin', 'users.donation', 'users.beta', \DB::raw('max(user_list_profile.created_at) as last_added_created_at'), \DB::raw('count(user_list_profile.id) as total')]);
     $indexSave = [];
     foreach ($steamInfos as $k => $info) {
         $indexSave[Steam::toSmallId($info->steamid)] = ['steamInfos' => $k];
     }
     foreach ($steamBans as $k => $ban) {
         // Lets just not update if api didn't return for this user
         if (!isset($indexSave[Steam::toSmallId($ban->SteamId)])) {
             continue;
         }
         $indexSave[Steam::toSmallId($ban->SteamId)]['steamBans'] = $k;
     }
     $newProfiles = [];
     foreach ($getSmallId as $k => $smallId) {
         // api didn't give values for this user
         if (!isset($indexSave[$smallId])) {
             continue;
         }
         $keys = $indexSave[$smallId];
         $steamInfo = $steamInfos[$keys['steamInfos']];
         if (!isset($keys['steamBans'])) {
             continue;
         }
         // right now dont let this user get through. Figure out a better method
         $steamBan = $steamBans[$keys['steamBans']];
         $profile = $profiles->where('small_id', $smallId)->first();
         if (is_null($profile)) {
             $profile = Profile::whereSmallId($smallId)->first();
             if (!isset($profile->id)) {
                 $profile = new Profile();
                 $profile->small_id = $smallId;
             }
             if (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->save();
         $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) {
                 $skipProfileBan = false;
                 $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) {
             $profile->ProfileBan()->save($profileBan);
         }
         /* 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();
         if ($profileOldAlias->count() == 0) {
             $profileOldAlias = new ProfileOldAlias();
             $profileOldAlias->profile_id = $profile->id;
             $profileOldAlias->seen = time();
             $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()) {
                 $newAlias = new ProfileOldAlias();
                 $newAlias->profile_id = $profile->id;
                 $newAlias->seen = time();
                 $newAlias->seen_alias = $profile->display_name;
                 $profile->ProfileOldAlias()->save($newAlias);
             }
         }
         $steam64BitId = Steam::to64Bit($profile->small_id);
         $vacBanDate = new DateTime();
         $vacBanDate->sub(new DateInterval("P{$steamBan->DaysSinceLastBan}D"));
         $oldAliasArray = [];
         foreach ($profileOldAlias as $k => $oldAlias) {
             if (!is_object($oldAlias)) {
                 $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")];
         }
         $profileCheckCache = "profile_checked_";
         $currentProfileCheck = ['number' => 0, 'time' => date("M j Y", time())];
         if (Cache::has($profileCheckCache . $profile->smallId)) {
             $currentProfileCheck = Cache::get($profileCheckCache . $profile->smallId);
         }
         $newProfileCheck = ['number' => $currentProfileCheck['number'] + 1, 'time' => date("M j Y", time())];
         Cache::forever($profileCheckCache . $profile->smallId, $newProfileCheck);
         $return = ['id' => $profile->id, 'display_name' => $steamInfo->personaname, 'avatar' => Steam::imgToHTTPS($steamInfo->avatarfull), 'avatar_thumb' => Steam::imgToHTTPS($steamInfo->avatar), 'small_id' => $profile->small_id, 'steam_64_bit' => $steam64BitId, 'steam_32_bit' => Steam::to32Bit($steam64BitId), 'profile_created' => isset($steamInfo->timecreated) ? date("M j Y", $steamInfo->timecreated) : "Unknown", 'privacy' => $steamInfo->communityvisibilitystate, 'alias' => Steam::friendlyAlias(json_decode($profile->alias)), 'created_at' => $profile->created_at ? $profile->created_at->format("M j Y") : null, 'vac' => $combinedBan, 'vac_banned_on' => $vacBanDate->format("M j Y"), 'community' => $steamBan->CommunityBanned, 'trade' => $steamBan->EconomyBan != 'none', 'site_admin' => (int) $profile->site_admin ?: 0, 'donation' => (int) $profile->donation ?: 0, 'beta' => (int) $profile->beta ?: 0, 'profile_old_alias' => $oldAliasArray, 'times_checked' => $currentProfileCheck, 'times_added' => ['number' => (int) $profile->total ?: 0, 'time' => (new DateTime($profile->last_added_created_at))->format("M j Y")]];
         $newProfiles[$toSaveKey[$profile->small_id]] = $return;
         $this->updateCache($profile->small_id, $return);
     }
     // Send somewhere else to update alias
     // This takes too long for many profiles
     $randomString = str_random(12);
     $updateAliasCacheName = "update_alias_";
     if (Cache::has($updateAliasCacheName . $randomString)) {
         while (Cache::has($updateAliasCacheName . $randomString)) {
             $randomString = str_random(12);
         }
     }
     Cache::forever($updateAliasCacheName . $randomString, $getSmallId);
     shell_exec('php artisan update:alias ' . $randomString . ' > /dev/null 2>/dev/null &');
     return $newProfiles;
 }
Exemplo n.º 5
0
 private function grabFromDB()
 {
     $profile = Profile::where('profile.small_id', $this->smallId)->leftjoin('profile_ban', 'profile.id', '=', 'profile_ban.profile_id')->leftjoin('users', 'profile.small_id', '=', 'users.small_id')->first(['profile.id', 'profile.display_name', 'profile.avatar', 'profile.avatar_thumb', 'profile.small_id', 'profile.profile_created', 'profile.privacy', 'profile.alias', 'profile.created_at', 'profile_ban.vac', 'profile_ban.vac_banned_on', 'profile_ban.community', 'profile_ban.trade', 'users.site_admin', 'users.donation', 'users.beta']);
     /* Copied and pasted from function above */
     $profileOldAlias = $profile->ProfileOldAlias()->whereProfileId($profile->id)->orderBy('id', 'desc')->get();
     $gettingCount = UserListProfile::whereProfileId($profile->id)->orderBy('id', 'desc')->whereNull('deleted_at')->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);
     /* WOW THAT WAS SHORT!!!!! */
     $steam64BitId = Steam::to64Bit($profile->small_id);
     $oldAliasArray = [];
     foreach ($profileOldAlias as $k => $oldAlias) {
         $oldAliasArray[] = ["newname" => $oldAlias->seen_alias, "timechanged" => $oldAlias->seen->format("M j Y")];
     }
     $return = ['id' => $profile->id, 'display_name' => $profile->display_name, 'avatar' => $profile->avatar, 'small_id' => $profile->small_id, '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' => $profile->privacy, 'alias' => Steam::friendlyAlias(json_decode($profile->alias)), 'created_at' => $profile->created_at->format("M j Y"), 'vac' => $profile->vac, 'vac_banned_on' => $profile->vac_banned_on->format("M j Y"), 'community' => $profile->community, 'trade' => $profile->trade, 'site_admin' => (int) $profile->site_admin ?: 0, 'donation' => (int) $profile->donation ?: 0, 'beta' => (int) $profile->beta ?: 0, 'profile_old_alias' => $oldAliasArray, 'times_checked' => $currentProfileCheck, 'times_added' => $profileTimesAdded];
     return $return;
 }
Exemplo n.º 6
0
 public function setSmallId($smallId)
 {
     $this->setSteamId(Steam::to64Bit($smallId));
     return $this;
 }