public function __construct($lastCheckedSubscription)
 {
     $userMail = UserMail::whereRaw('user_mail.id > ? and (user_mail.verify = ? or user_mail.pushbullet_verify = ?)', array($lastCheckedSubscription, 'verified', 'verified'))->first();
     $userLists = Subscription::where('subscription.user_id', $userMail->user_id)->whereNull('user_list.deleted_at')->whereNull('subscription.deleted_at')->leftJoin('user_list', 'subscription.user_list_id', '=', 'user_list.id')->distinct()->get(['user_list.id', 'subscription.id as sub_id', 'subscription.created_at', 'subscription.updated_at']);
     $subscriptionIds = $userLists->lists('sub_id');
     $profiles = UserListProfile::whereIn('user_list_profile.user_list_id', $userLists->lists('id'))->leftJoin('profile', 'user_list_profile.profile_id', '=', 'profile.id')->leftJoin('profile_ban', 'profile_ban.profile_id', '=', 'profile.id')->whereNull('user_list_profile.deleted_at')->distinct()->get(['user_list_profile.user_list_id', 'profile.id', 'profile.display_name', 'profile.small_id', 'profile.avatar_thumb', 'profile_ban.vac', 'profile_ban.community', 'profile_ban.trade', 'profile_ban.unban', 'profile_ban.created_at', 'profile_ban.updated_at', 'profile_ban.vac_banned_on']);
     $this->profiles = $profiles;
     $this->userMail = $userMail;
     $this->userLists = $userLists;
     $this->subscriptionIds = $subscriptionIds;
 }
 public function addManyToList()
 {
     $input = Input::all();
     $search = Steam::parseSearch($input['search']);
     $description = isset($input['description']) && !empty($input['description']) ? $input['description'] : null;
     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::whereIn('small_id', $smallIds)->get(['small_id']);
     $profilesParsed = [];
     foreach ($smallIds as $smallId) {
         $profile = $profiles->where('small_id', $smallId)->first();
         if (is_null($profile)) {
             $profilesParsed[] = ['small_id' => $smallId];
             continue;
         }
     }
     $multiProfile = new MultiProfile($profilesParsed);
     $multiProfile->run();
     $listId = (int) $input['list_id'];
     $userList = UserList::where('id', $listId)->first();
     $userListProfiles = UserListProfile::whereIn('profile.small_id', $smallIds)->leftjoin('profile', 'profile.id', '=', 'user_list_profile.profile_id')->where('user_list_profile.user_list_id', $listId)->where('user_list_profile.deleted_at', null)->get(['profile.small_id', 'profile.id']);
     $userListProfilesSmallId = [];
     foreach ($userListProfiles as $userListProfile) {
         $userListProfilesSmallId[] = $userListProfile->small_id;
     }
     $smallIds = array_diff($smallIds, $userListProfilesSmallId);
     $profiles = Profile::whereIn('small_id', $smallIds)->get();
     $toAddtoList = [];
     foreach ($profiles as $k => $profile) {
         if (Auth::user()->unlockUser() <= $userList->UserListProfile()->count() + $k) {
             break;
         }
         $toAddtoList[] = new UserListProfile(["profile_id" => $profile->id, "profile_name" => $profile->display_name, "profile_description" => $description]);
     }
     $userList->UserListProfile()->saveMany($toAddtoList);
     $customList = new CustomList(UserList::where('id', $listId)->first());
     if ($customList->error()) {
         return $customList->error();
     }
     return $customList->getCustomList();
 }