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 = 'StarbaseDetail';
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);
// We now need to loop over the starbases that we have for this corporation
// and update the details as needed.
foreach (\EveCorporationStarbaseList::where('corporationID', '=', $corporationID)->get() as $starbase) {
// Do the actual API call. pheal-ng actually handles some internal
// caching too.
try {
$starbase_detail = $pheal->corpScope->StarbaseDetail(array('characterID' => $characters[0], 'itemID' => $starbase->itemID));
} catch (\Pheal\Exceptions\APIException $e) {
// In the odd chance that we get a old/invalid ID, catch only that error
// else go boom
if ($e->getCode() == 114) {
\Log::error('API Exception caught but continuing. Error: ' . $e->getCode() . ': ' . $e->getMessage(), array('src' => __CLASS__));
continue;
}
// I suspect that there is a caching specific thing here that I don't understand. I know
// this is a bad thing, but for now, just continue when this occurs, and write a entry
// to the application log about it.
//
// Error: 221: Illegal page request! Please verify the access granted by the key you are using!
// ^~~~ this after we just got the starbase list... :(
if ($e->getCode() == 221) {
\Log::error('API Exception caught but continuing. Error: ' . $e->getCode() . ': ' . $e->getMessage(), array('src' => __CLASS__));
continue;
}
// Lastly, go boom as something out of the ordinary is wrong.
throw $e;
} catch (\Pheal\Exceptions\PhealException $e) {
// Lets add some information to the original exception and raise it
$new_error = $e->getMessage() . ' - Current starbaseID: ' . $starbase->itemID;
throw new \Exception($new_error, $e->getCode());
}
// Update the details
$starbase_data = \EveCorporationStarbaseDetail::where('corporationID', '=', $corporationID)->where('itemID', '=', $starbase->itemID)->first();
if (!$starbase_data) {
$starbase_data = new \EveCorporationStarbaseDetail();
}
$starbase_data->corporationID = $corporationID;
$starbase_data->itemID = $starbase->itemID;
// Fromt he outer loop
$starbase_data->state = $starbase_detail->state;
$starbase_data->stateTimestamp = $starbase_detail->stateTimestamp;
$starbase_data->onlineTimestamp = $starbase_detail->onlineTimestamp;
$starbase_data->usageFlags = $starbase_detail->generalSettings->usageFlags;
$starbase_data->deployFlags = $starbase_detail->generalSettings->deployFlags;
$starbase_data->allowCorporationMembers = $starbase_detail->generalSettings->allowCorporationMembers;
$starbase_data->allowAllianceMembers = $starbase_detail->generalSettings->allowAllianceMembers;
$starbase_data->useStandingsFrom = $starbase_detail->combatSettings->useStandingsFrom->ownerID;
$starbase_data->onStandingDrop = $starbase_detail->combatSettings->onStandingDrop->standing;
$starbase_data->onStatusDropEnabled = $starbase_detail->combatSettings->onStatusDrop->enabled;
$starbase_data->onStatusDropStanding = $starbase_detail->combatSettings->onStatusDrop->standing;
$starbase_data->onAggression = $starbase_detail->combatSettings->onAggression->enabled;
$starbase_data->onCorporationWar = $starbase_detail->combatSettings->onCorporationWar->enabled;
// Add the fuel to the various fields
foreach ($starbase_detail->fuel as $fuel) {
if ($fuel->typeID == 16275) {
$starbase_data->strontium = $fuel->quantity;
}
// Four different fuel block typeIDs
// 4051 Caldari Fuel Block
// 4246 Minmatar Fuel Block
// 4247 Amarr Fuel Block
// 4312 Gallente Fuel Block
if (in_array($fuel->typeID, array('4051', '4246', '4247', '4312'))) {
$starbase_data->fuelBlocks = $fuel->quantity;
}
// Various starbase charters
// 24592 Amarr Empire Starbase Charter
// 24593 Caldari State Starbase Charter
// 24594 Gallente Federation Starbase Charter
// 24595 Minmatar Republic Starbase Charter
// 24596 Khanid Kingdom Starbase Charter
// 24597 Ammatar Mandate Starbase Charter
if (in_array($fuel->typeID, array('24592', '24593', '24594', '24595', '24596', '24597'))) {
$starbase_data->starbaseCharter = $fuel->quantity;
}
}
$starbase_data->save();
}
// Unlock the call
BaseApi::unlockCall($lockhash);
return null;
}
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 = 'StarbaseList';
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 {
$starbase_list = $pheal->corpScope->StarbaseList(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, $starbase_list->cached_until, $corporationID)) {
// So for this call I dont think we should just trash all of the posses and their
// details. Instead, cause I'm bad, well get all of the current posses for the corp
// and delete the values that we know of. The resulting array will be the ones we delete
// as they are probably removed/killed posses
$old_starbases = array();
foreach (\EveCorporationStarbaseList::where('corporationID', '=', $corporationID)->get() as $item) {
$old_starbases[] = $item->itemID;
}
// Arrayflip hax to get the starbaseID's as keys
$old_starbases = array_flip($old_starbases);
// <-- help a noob please :<
// Next, loop over the starbases from the API and populate/update the db
foreach ($starbase_list->starbases as $starbase) {
$starbase_data = \EveCorporationStarbaseList::where('corporationID', '=', $corporationID)->where('itemID', '=', $starbase->itemID)->first();
if (!$starbase_data) {
$starbase_data = new \EveCorporationStarbaseList();
}
$starbase_data->corporationID = $corporationID;
$starbase_data->itemID = $starbase->itemID;
$starbase_data->typeID = $starbase->typeID;
$starbase_data->locationID = $starbase->locationID;
$starbase_data->moonID = $starbase->moonID;
$starbase_data->state = $starbase->state;
$starbase_data->stateTimestamp = $starbase->stateTimestamp;
$starbase_data->onlineTimestamp = $starbase->onlineTimestamp;
$starbase_data->standingOwnerID = $starbase->standingOwnerID;
$starbase_data->save();
// Update the old_starbases list by removing the ones that still
// exist
if (array_key_exists($starbase->itemID, $old_starbases)) {
unset($old_starbases[$starbase->itemID]);
}
}
// Delete old starbases if there are any
if (count($old_starbases) > 0) {
// Delete the old starbase...
foreach (array_flip($old_starbases) as $starbase_id) {
\EveCorporationStarbaseList::where('itemID', '=', $starbase_id)->delete();
}
// ... and its details
foreach (array_flip($old_starbases) as $starbase_id) {
\EveCorporationStarbaseDetail::where('itemID', '=', $starbase_id)->delete();
}
}
// Update the cached_until time in the database for this api call
BaseApi::setDbCache($scope, $api, $starbase_list->cached_until, $corporationID);
}
// Unlock the call
BaseApi::unlockCall($lockhash);
return $starbase_list;
}
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;
}
}