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 = 'Char'; $api = 'SkillInTraining'; 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; } // Next, start our loop over the characters and upate the database foreach ($characters as $characterID) { // Prepare the Pheal instance $pheal = new Pheal($keyID, $vCode); // Do the actual API call. pheal-ng actually handles some internal // caching too. try { $skill_in_training = $pheal->charScope->SkillInTraining(array('characterID' => $characterID)); } 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, $skill_in_training->cached_until, $characterID)) { $character_data = \EveCharacterSkillInTraining::where('characterID', '=', $characterID)->first(); if (!$character_data) { $character_data = new \EveCharacterSkillInTraining(); } if ($skill_in_training->skillInTraining == 1) { $character_data->characterID = $characterID; $character_data->currentTQTime = $skill_in_training->currentTQTime->_value; $character_data->trainingEndTime = $skill_in_training->trainingEndTime; $character_data->trainingStartTime = $skill_in_training->trainingStartTime; $character_data->trainingTypeID = $skill_in_training->trainingTypeID; $character_data->trainingStartSP = $skill_in_training->trainingStartSP; $character_data->trainingDestinationSP = $skill_in_training->trainingDestinationSP; $character_data->trainingToLevel = $skill_in_training->trainingToLevel; $character_data->skillInTraining = $skill_in_training->skillInTraining; $character_data->save(); } else { $character_data->characterID = $characterID; $character_data->skillInTraining = 0; $character_data->save(); } // Update the cached_until time in the database for this api call BaseApi::setDbCache($scope, $api, $skill_in_training->cached_until, $characterID); } } // Unlock the call BaseApi::unlockCall($lockhash); return $skill_in_training; }