Example #1
0
 public function getDeleteKey($keyID, $delete_all_info = false)
 {
     // Ensure that this user may access the data for $keyID
     if (!\Auth::isSuperUser()) {
         if (!in_array($keyID, Session::get('valid_keys'))) {
             App::abort(404);
         }
     }
     // Ensure the user is allowed to delete this key
     if (!\Auth::hasAccess('key_manager')) {
         App::abort(404);
     }
     // Get the full key and vCode
     $key = SeatKey::where('keyID', $keyID)->first();
     if (!$key) {
         App::abort(404);
     }
     // Based on delete_all_info, we will either just delete the key,
     // or all of the information associated with it
     switch ((bool) $delete_all_info) {
         case true:
             // Check if we can determine if this is a corporation or account/char key.
             $type = \EveAccountAPIKeyInfo::where('keyID', $keyID)->pluck('type');
             // Check if the type is set
             if ($type) {
                 // For corporation keys, we will delete corporation stuff, duhr
                 if ($type == "Corporation") {
                     // Most of the data for corporations is stored with the corporationID
                     // as key. To get this ID, we need to find the character attached to
                     // this key, and then the corporation for that character
                     $characters = BaseApi::findKeyCharacters($keyID);
                     $corporationID = BaseApi::findCharacterCorporation($characters[0]);
                     // With the corporationID now known, go ahead and cleanup the database
                     \EveCorporationAccountBalance::where('corporationID', $corporationID)->delete();
                     \EveCorporationAssetList::where('corporationID', $corporationID)->delete();
                     \EveCorporationAssetListContents::where('corporationID', $corporationID)->delete();
                     \EveCorporationAssetListLocations::where('corporationID', $corporationID)->delete();
                     \EveCorporationContactListAlliance::where('corporationID', $corporationID)->delete();
                     \EveCorporationContactListCorporate::where('corporationID', $corporationID)->delete();
                     \EveCorporationContracts::where('corporationID', $corporationID)->delete();
                     \EveCorporationContractsItems::where('corporationID', $corporationID)->delete();
                     \EveCorporationCorporationSheet::where('corporationID', $corporationID)->delete();
                     \EveCorporationCorporationSheetDivisions::where('corporationID', $corporationID)->delete();
                     \EveCorporationCorporationSheetWalletDivisions::where('corporationID', $corporationID)->delete();
                     \EveCorporationIndustryJobs::where('corporationID', $corporationID)->delete();
                     \EveCorporationMarketOrders::where('corporationID', $corporationID)->delete();
                     \EveCorporationMedals::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberMedals::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityGrantableRoles::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityGrantableRolesAtBase::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityGrantableRolesAtHQ::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityGrantableRolesAtOther::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityLog::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityRoles::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityRolesAtBase::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityRolesAtHQ::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityRolesAtOther::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberSecurityTitles::where('corporationID', $corporationID)->delete();
                     \EveCorporationMemberTracking::where('corporationID', $corporationID)->delete();
                     \EveCorporationShareholderCharacters::where('corporationID', $corporationID)->delete();
                     \EveCorporationShareholderCorporations::where('corporationID', $corporationID)->delete();
                     \EveCorporationStandingsAgents::where('corporationID', $corporationID)->delete();
                     \EveCorporationStandingsFactions::where('corporationID', $corporationID)->delete();
                     \EveCorporationStandingsNPCCorporations::where('corporationID', $corporationID)->delete();
                     \EveCorporationStarbaseDetail::where('corporationID', $corporationID)->delete();
                     \EveCorporationStarbaseList::where('corporationID', $corporationID)->delete();
                     \EveCorporationWalletJournal::where('corporationID', $corporationID)->delete();
                     \EveCorporationWalletTransactions::where('corporationID', $corporationID)->delete();
                 } else {
                     // And for character stuff, we delete character stuff
                     // Here we need to be careful now. It may happen that we have more than 1 key
                     // for a character, so we have to be aware of this. It adds a factor of
                     // complexity to the whole thing.
                     $characters = BaseApi::findKeyCharacters($keyID);
                     // Now that we know about all of the characters, we will loop over them and check
                     // that we only have 1 key for them. If more than one keys have this character, we will
                     // simply ignore the cleanup and add a message about it
                     foreach ($characters as $id => $character) {
                         // Check how many keys know about this character
                         if (\EveAccountAPIKeyInfoCharacters::where('characterID', $character)->count() > 1) {
                             // Write a log entry about this
                             \Log::warning('Character ' . $character . ' is recorded on another key and will not been cleaned up');
                             // Remove this character from $characters
                             unset($characters[$id]);
                         }
                     }
                     // So we now have an array of characterID's that can be cleaned up. Lets do that
                     if (count($characters) > 0) {
                         \EveCharacterAccountBalance::whereIn('characterID', $characters)->delete();
                         \EveCharacterAssetList::whereIn('characterID', $characters)->delete();
                         \EveCharacterAssetListContents::whereIn('characterID', $characters)->delete();
                         \EveCharacterCharacterSheet::whereIn('characterID', $characters)->delete();
                         \EveCharacterCharacterSheetSkills::whereIn('characterID', $characters)->delete();
                         \EveCharacterContactList::whereIn('characterID', $characters)->delete();
                         \EveCharacterContactListAlliance::whereIn('characterID', $characters)->delete();
                         \EveCharacterContactListCorporate::whereIn('characterID', $characters)->delete();
                         \EveCharacterContactNotifications::whereIn('characterID', $characters)->delete();
                         \EveCharacterContracts::whereIn('characterID', $characters)->delete();
                         \EveCharacterContractsItems::whereIn('characterID', $characters)->delete();
                         \EveCharacterIndustryJobs::whereIn('characterID', $characters)->delete();
                         // Intentionally ignoring the mail related information as this has a lot of overlap
                         // and is almost always usefull
                         \EveCharacterMarketOrders::whereIn('characterID', $characters)->delete();
                         \EveCharacterPlanetaryColonies::whereIn('characterID', $characters)->delete();
                         \EveCharacterPlanetaryLinks::whereIn('characterID', $characters)->delete();
                         \EveCharacterPlanetaryPins::whereIn('characterID', $characters)->delete();
                         \EveCharacterPlanetaryRoutes::whereIn('characterID', $characters)->delete();
                         \EveCharacterResearch::whereIn('characterID', $characters)->delete();
                         \EveCharacterSkillInTraining::whereIn('characterID', $characters)->delete();
                         \EveCharacterSkillQueue::whereIn('characterID', $characters)->delete();
                         \EveCharacterStandingsAgents::whereIn('characterID', $characters)->delete();
                         \EveCharacterStandingsFactions::whereIn('characterID', $characters)->delete();
                         \EveCharacterStandingsNPCCorporations::whereIn('characterID', $characters)->delete();
                         \EveCharacterUpcomingCalendarEvents::whereIn('characterID', $characters)->delete();
                         \EveCharacterWalletJournal::whereIn('characterID', $characters)->delete();
                         \EveCharacterWalletTransactions::whereIn('characterID', $characters)->delete();
                     }
                 }
                 // Finally, delete the key and redirect
                 $key->delete();
                 // Delete the information that we have for this key too
                 \EveAccountAPIKeyInfo::where('keyID', $keyID)->delete();
                 \EveAccountAPIKeyInfoCharacters::where('keyID', $keyID)->delete();
                 return Redirect::action('ApiKeyController@getAll')->with('success', 'Key has been deleted');
             } else {
                 // So, we are unable to determine the key type, so maybe this is
                 // a invalid one or whatever. Just get rid of it.
                 // Delete the API Key
                 $key->delete();
                 // Delete the information that we have for this key too
                 \EveAccountAPIKeyInfo::where('keyID', $keyID)->delete();
                 \EveAccountAPIKeyInfoCharacters::where('keyID', $keyID)->delete();
                 return Redirect::action('ApiKeyController@getAll')->with('success', 'Key has been deleted');
             }
             break;
         case false:
             // Delete the API Key
             $key->delete();
             // Delete the information that we have for this key too
             \EveAccountAPIKeyInfo::where('keyID', $keyID)->delete();
             \EveAccountAPIKeyInfoCharacters::where('keyID', $keyID)->delete();
             return Redirect::action('ApiKeyController@getAll')->with('success', 'Key has been deleted');
             break;
     }
 }
Example #2
0
 public static function Update($keyID, $vCode)
 {
     // Start and validate they key pair
     BaseApi::bootstrap();
     BaseApi::validateKeyPair($keyID, $vCode);
     // Set key scopes and check if the call is banned
     $scope = 'Corp';
     $api = 'AssetList';
     if (BaseApi::isBannedCall($api, $scope, $keyID)) {
         return;
     }
     // Get the characters for this key
     $characters = BaseApi::findKeyCharacters($keyID);
     // Check if this key has any characters associated with it
     if (!$characters) {
         return;
     }
     // Lock the call so that we are the only instance of this running now()
     // If it is already locked, just return without doing anything
     if (!BaseApi::isLockedCall($api, $scope, $keyID)) {
         $lockhash = BaseApi::lockCall($api, $scope, $keyID);
     } else {
         return;
     }
     // So I think a corporation key will only ever have one character
     // attached to it. So we will just use that characterID for auth
     // things, but the corporationID for locking etc.
     $corporationID = BaseApi::findCharacterCorporation($characters[0]);
     // Prepare the Pheal instance
     $pheal = new Pheal($keyID, $vCode);
     // Do the actual API call. pheal-ng actually handles some internal
     // caching too.
     try {
         $asset_list = $pheal->corpScope->AssetList(array('characterID' => $characters[0]));
     } catch (\Pheal\Exceptions\APIException $e) {
         // If we cant get account status information, prevent us from calling
         // this API again
         BaseApi::banCall($api, $scope, $keyID, 0, $e->getCode() . ': ' . $e->getMessage());
         return;
     } catch (\Pheal\Exceptions\PhealException $e) {
         throw $e;
     }
     // Check if the data in the database is still considered up to date.
     // checkDbCache will return true if this is the case
     if (!BaseApi::checkDbCache($scope, $api, $asset_list->cached_until, $corporationID)) {
         // TODO: Look as how we update this. As per https://neweden-dev.com/Character/Asset_List, the itemID
         // may change. So, we cant really just update existing ids. For now, we just trash all and recreate the
         // assets :<
         // Maybe do this in one big transaction? lel
         \EveCorporationAssetList::where('corporationID', '=', $corporationID)->delete();
         \EveCorporationAssetListContents::where('corporationID', '=', $corporationID)->delete();
         // Note about /corp/Locations
         //
         // We will build a list of itemID's to update the location information about
         // while we loop over the assets. This will be stored in location_retreive and
         // processed here [1]
         $location_retreive = array();
         // Populate the assets for this corporation as well as the contents.
         foreach ($asset_list->assets as $asset) {
             // Add the asset to the location retreival array
             $location_retreive[] = $asset->itemID;
             // Process the rest of the database population
             $asset_data = new \EveCorporationAssetList();
             $asset_data->corporationID = $corporationID;
             $asset_data->itemID = $asset->itemID;
             $asset_data->locationID = $asset->locationID;
             $asset_data->typeID = $asset->typeID;
             $asset_data->quantity = $asset->quantity;
             $asset_data->flag = $asset->flag;
             $asset_data->singleton = $asset->singleton;
             $asset_data->save();
             // Process the contents if there are any
             if (isset($asset->contents)) {
                 foreach ($asset->contents as $content) {
                     $content_data = new \EveCorporationAssetListContents();
                     $content_data->corporationID = $corporationID;
                     $content_data->itemID = $asset_data->itemID;
                     $content_data->typeID = $content->typeID;
                     $content_data->quantity = $content->quantity;
                     $content_data->flag = $content->flag;
                     $content_data->singleton = $content->singleton;
                     $content_data->rawQuantity = isset($content->rawQuantity) ? $content->rawQuantity : 0;
                     $asset_data->contents()->save($content_data);
                 }
             }
         }
         // Now empty and process the locations as per [1]
         \EveCorporationAssetListLocations::where('corporationID', '=', $corporationID)->delete();
         $location_retreive = array_chunk($location_retreive, 1);
         // Iterate over the chunks.
         foreach ($location_retreive as $chunk) {
             try {
                 $locations = $pheal->corpScope->Locations(array('characterID' => $characters[0], 'ids' => implode(',', $chunk)));
             } catch (\Pheal\Exceptions\PhealException $e) {
                 // Temp hack to check the asset list thingie
                 // TBH, I am not 100% sure yet why the freaking call would fail for a id we **just**
                 // got from the previous API call...
                 if ($e->getCode() == 135 || $e->getCode() == 221) {
                     // 135 "not the owner" | 221 "illegal page request"
                     continue;
                 } else {
                     throw $e;
                 }
             }
             // Loop over the locations, check their closest celestial
             // and add the data to the database
             foreach ($locations->locations as $location) {
                 $closest_moon = BaseApi::findClosestMoon($location->itemID, $location->x, $location->y, $location->z);
                 $location_data = new \EveCorporationAssetListLocations();
                 $location_data->corporationID = $corporationID;
                 $location_data->itemID = $location->itemID;
                 $location_data->itemName = $location->itemName;
                 $location_data->x = $location->x;
                 $location_data->y = $location->y;
                 $location_data->z = $location->z;
                 $location_data->mapID = $closest_moon['id'];
                 $location_data->mapName = $closest_moon['name'];
                 $location_data->save();
             }
         }
         // Update the cached_until time in the database for this api call
         BaseApi::setDbCache($scope, $api, $asset_list->cached_until, $corporationID);
     }
     // Unlock the call
     BaseApi::unlockCall($lockhash);
     return $asset_list;
 }
Example #3
0
 public static function findClosestMoon($itemID, $x, $y, $z)
 {
     // Get the system location of the itemID
     $systemID = \EveCorporationAssetList::where('itemID', '=', $itemID)->first();
     $nearest_distance = INF;
     // Placeholder amount
     // Prepare some empty responses
     $calculatedSystemID = null;
     $calculatedSystemName = null;
     // Find the closest moonID to $x, $x & $z. groupID 8 looks like moons only in the SDE
     foreach (\EveMapDenormalize::where('groupID', '=', 8)->where('solarSystemID', '=', $systemID->locationID)->get() as $system) {
         // So it looks there are 2 ways of determining the nearest celestial. The sqrt one is
         // aparently a lot more accurate, versus the manhattan one that can be seen in the ECM
         // source is slightly less accurate. TBH, I have no idea which one to use.
         // See: http://math.stackexchange.com/a/42642
         $distance = sqrt(pow($x - $system->x, 2) + pow($y - $system->y, 2) + pow($z - $system->z, 2));
         // Or we can use this alternative from ECM: https://github.com/evecm/ecm/blob/master/ecm/plugins/assets/tasks/assets.py#L418
         // that uses http://en.wikipedia.org/wiki/Taxicab_geometry
         // $distance = abs($x - $system->x) + abs($y - $system->y) + abs($z - $system->z);
         // We are only interested in the moonID that is closest to our asset.
         // so will update to this moon if it is closer than the previous one
         if ($distance < $nearest_distance) {
             // Update the current closes distance for the next pass
             $nearest_distance = $distance;
             // Set the variables that will eventually be returned
             $calculatedSystemID = $system->itemID;
             $calculatedSystemName = $system->itemName;
         }
     }
     return array('id' => $calculatedSystemID, 'name' => $calculatedSystemName);
 }