コード例 #1
0
ファイル: BannedCall.php プロジェクト: boweiliu/seat
 public static function Update()
 {
     // Learn about all of the banned calls that
     // we are aware of
     $banned_calls = \EveBannedCall::all();
     // For every banned call that we have, prepare
     // a notification to send
     foreach ($banned_calls as $banned_call) {
         // Super users will be receiving this notification,
         // so loop over the current superusers that we
         // have
         foreach (\Auth::findAllUsersWithAccess('superuser') as $super_user) {
             // Compile the full notification
             $notification_type = 'API';
             $notification_title = 'Banned Call';
             $notification_text = 'The SeAT backend has banned the ' . $banned_call->scope . '\\' . $banned_call->api . ' API call for key ' . $banned_call->ownerID . '. Reason: ' . $banned_call->reason . PHP_EOL . 'Key characters: ' . PHP_EOL;
             // Add some information about the characters on this key
             foreach (\EveAccountAPIKeyInfoCharacters::where('keyID', $banned_call->ownerID)->get() as $character) {
                 $notification_text .= ' - ' . $character->characterName . PHP_EOL;
             }
             // Send the notification
             BaseNotify::sendNotification($super_user->id, $notification_type, $notification_title, $notification_text);
         }
     }
 }
コード例 #2
0
ファイル: SeatAPIFindSickKeys.php プロジェクト: boweiliu/seat
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function fire()
 {
     $this->info('Finding keys that are not ok.');
     // Search the database for keys that are marked as disabled
     foreach (\SeatKey::where('isOk', '=', 0)->get() as $key) {
         $this->comment('Key ' . $key->keyID . ' is not ok.');
         $this->line('Characters on this key:');
         // Print the characters on the affected key
         foreach (\EveAccountAPIKeyInfoCharacters::where('keyID', '=', $key->keyID)->get() as $character) {
             $this->line('   ' . $character->characterName);
         }
     }
 }
コード例 #3
0
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function fire()
 {
     // Get the keyID from the commnad arg
     $keyID = $this->argument('keyID');
     $this->info('Searching for key: ' . $keyID);
     // Search the database for they keyID
     $characters = \EveAccountAPIKeyInfoCharacters::where('keyID', 'like', '%' . $keyID . '%')->get();
     // If we found results, prepare to display them
     if (count($characters) > 0) {
         // Loop over the found characters
         foreach ($characters as $character) {
             $this->info('Found match: ' . $character->characterName . ' with keyID: ' . $character->keyID);
         }
     } else {
         $this->error('No matches found.');
     }
 }
コード例 #4
0
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function fire()
 {
     // Get the name arg from the commandline
     $name = $this->argument('name');
     $this->info('Searching for term: ' . $name);
     // Search for keys with the character on it
     $characters = \EveAccountAPIKeyInfoCharacters::where('characterName', 'like', '%' . $name . '%')->get();
     // If there were results from the find, print
     // them
     if (count($characters) > 0) {
         // Loop over the found characeters
         foreach ($characters as $character) {
             $this->info('Found match: ' . $character->characterName . ' with keyID: ' . $character->keyID);
         }
     } else {
         $this->error('No matches found.');
     }
 }
コード例 #5
0
ファイル: TeamspeakTransfer.php プロジェクト: orloc/seat
 protected function getValidCorps($users)
 {
     $validCorps = [];
     $invalid = [];
     foreach ($users as $u) {
         $valid_keys = \SeatKey::where('user_id', $u->id)->lists('keyID');
         if (!empty($valid_keys)) {
             $corporation_affiliation = \EveAccountAPIKeyInfoCharacters::whereIn('keyID', $valid_keys)->groupBy('corporationID')->lists('corporationID');
             if (!empty($corporation_affiliation)) {
                 $viable = \EveCorporationCorporationSheet::whereIn('corporationID', $corporation_affiliation)->lists('corporationName');
                 if (!empty($viable)) {
                     $validCorps[] = ['corps' => $viable, 'user' => $u, 'user_groups' => \Auth::getUserGroups($u)];
                 }
             }
         } else {
             $invalid[] = $u;
         }
     }
     return [$validCorps, $invalid];
 }
コード例 #6
0
ファイル: BaseNotify.php プロジェクト: boweiliu/seat
 public static function canAccessCorp($userID, $corpID)
 {
     // Get the SeAT user based on the userID
     $user = \Auth::findUserById($userID);
     // Determine the keys that the user owns
     $valid_keys = \SeatKey::where('user_id', $user->id)->lists('keyID');
     // Check if we have received any keys in the
     // previous query
     if (!empty($valid_keys)) {
         // Get a list of the corporationID's that the
         // user is affaliated with
         $corporation_affiliation = \EveAccountAPIKeyInfoCharacters::whereIn('keyID', $valid_keys)->groupBy('corporationID')->lists('corporationID');
         // With the affiliations known, loop over them
         // matching the affaliated corporationID with
         // the corporationID in question
         foreach ($corporation_affiliation as $affiliation) {
             // If we have a match, return true
             if ($affiliation == $corpID) {
                 return true;
             }
         }
     }
     return false;
 }
コード例 #7
0
ファイル: AccountAPIKeyInfo.php プロジェクト: boweiliu/seat
 public static function Update($keyID, $vCode)
 {
     // Start and validate they key pair
     BaseApi::bootstrap();
     BaseApi::validateKeyPair($keyID, $vCode);
     $scope = 'Account';
     $api = 'APIKeyInfo';
     // Prepare the Pheal instance
     $pheal = new Pheal($keyID, $vCode);
     // Do the actual API call. pheal-ng actually handles some internal
     // caching too.
     try {
         $key_info = $pheal->accountScope->APIKeyInfo();
     } catch (\Pheal\Exceptions\APIException $e) {
         // Some API responses require some rather important actions
         // SeATs perspective. For eg. Expired keys, IP bans, rate
         // limits etc. As APIKeyInfo is probably one of the
         // most called eveapi Updater, we will add the
         // logic here to check for these types of
         // responses.
         // Source: https://api.eveonline.com/Eve/ErrorList.xml.aspx
         switch ($e->getCode()) {
             // "API key authentication failure."
             case 202:
                 // "Authentication failure."
             // "Authentication failure."
             case 203:
             case 204:
                 // "Authentication failure."
             // "Authentication failure."
             case 205:
                 // "Authentication failure."
             // "Authentication failure."
             case 210:
                 // "Authentication failure (final pass)."
             // "Authentication failure (final pass)."
             case 212:
                 // The API is probably entirely wrong.
                 BaseApi::disableKey($keyID, $e->getCode() . ': ' . $e->getMessage());
                 return;
                 // "Invalid Corporation Key. Key owner does not fullfill role
                 // requirements anymore."
             // "Invalid Corporation Key. Key owner does not fullfill role
             // requirements anymore."
             case 220:
                 // Owner of the corporation key doesnt have hes roles anymore?
                 BaseApi::disableKey($keyID, $e->getCode() . ': ' . $e->getMessage());
                 return;
                 // "Illegal page request! Please verify the access granted by the key you are using!."
             // "Illegal page request! Please verify the access granted by the key you are using!."
             case 221:
                 // Not 100% sure how to handle this one. This call has no
                 // access mask requirement...
                 return;
                 // "Key has expired. Contact key owner for access renewal."
             // "Key has expired. Contact key owner for access renewal."
             case 222:
                 // We have a invalid key. Expired or deleted.
                 BaseApi::disableKey($keyID, $e->getCode() . ': ' . $e->getMessage());
                 return;
                 // "Authentication failure. Legacy API keys can no longer be
                 // used. Please create a new key on support.eveonline.com
                 // and make sure your application supports Customizable
                 // API Keys."
             // "Authentication failure. Legacy API keys can no longer be
             // used. Please create a new key on support.eveonline.com
             // and make sure your application supports Customizable
             // API Keys."
             case 223:
                 // The API we are working with is waaaaaay too old.
                 BaseApi::disableKey($keyID, $e->getCode() . ': ' . $e->getMessage());
                 return;
                 // "Web site database temporarily disabled."
             // "Web site database temporarily disabled."
             case 901:
                 // The EVE API Database is apparently down, so mark the
                 // server as 'down' in the cache so that subsequent
                 // calls don't fail because of this.
                 \Cache::put('eve_api_down', true, 30);
                 return;
                 // "EVE backend database temporarily disabled.""
             // "EVE backend database temporarily disabled.""
             case 902:
                 // The EVE API Database is apparently down, so mark the
                 // server as 'down' in the cache so that subsequent
                 // calls don't fail because of this.
                 \Cache::put('eve_api_down', true, 30);
                 return;
                 // "Your IP address has been temporarily blocked because it
                 // is causing too many errors. See the cacheUntil
                 // timestamp for when it will be opened again.
                 // IPs that continually cause a lot of errors
                 // in the API will be permanently banned,
                 // please take measures to minimize
                 // problematic API calls from your
                 // application."
             // "Your IP address has been temporarily blocked because it
             // is causing too many errors. See the cacheUntil
             // timestamp for when it will be opened again.
             // IPs that continually cause a lot of errors
             // in the API will be permanently banned,
             // please take measures to minimize
             // problematic API calls from your
             // application."
             case 904:
                 // If we are rate limited, set the status of the eveapi
                 // server to 'down' in the cache so that subsequent
                 // calls don't fail because of this.
                 // Get time of IP ban in minutes, rounded up to the next whole minute
                 $time = round(($e->cached_until_unixtime - $e->request_time_unixtime) / 60, 0, PHP_ROUND_HALF_UP);
                 \Cache::put('eve_api_down', true, $time);
                 return;
                 // We got a problem we don't know what to do with, so log
                 // and throw the exception so that the can debug it.
             // We got a problem we don't know what to do with, so log
             // and throw the exception so that the can debug it.
             default:
                 \Log::error('Call to APIKeyInfo for ' . $keyID . ' failed with: ' . $e->getCode() . ':' . $e->getMessage(), array('src' => __CLASS__));
                 throw $e;
                 break;
         }
         // Process a ban request as needed
         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, $key_info->cached_until, $keyID)) {
         $key_data = \EveAccountAPIKeyInfo::where('keyID', '=', $keyID)->first();
         if (!$key_data) {
             $key_data = new \EveAccountAPIKeyInfo();
         }
         $key_data->keyID = $keyID;
         $key_data->accessMask = $key_info->key->accessMask;
         $key_data->type = $key_info->key->type;
         $key_data->expires = strlen($key_info->key->expires) > 0 ? $key_info->key->expires : null;
         // hack much?
         $key_data->save();
         // Check if we have any knowledge of any characters for this key. We will remove values from this
         // array as we move along to determine which characters we should delete that are possibly no
         // longer on this key
         $known_characters = array();
         foreach (\EveAccountAPIKeyInfoCharacters::where('keyID', '=', $keyID)->get() as $character) {
             $known_characters[] = $character->characterID;
         }
         $known_characters = array_flip($known_characters);
         // Update the key characters
         foreach ($key_info->key->characters as $character) {
             // Check if we need to update || insert
             $character_data = \EveAccountAPIKeyInfoCharacters::where('keyID', '=', $keyID)->where('characterID', '=', $character->characterID)->first();
             if (!$character_data) {
                 $character_data = new \EveAccountAPIKeyInfoCharacters();
             }
             // else, add/update
             $character_data->characterID = $character->characterID;
             $character_data->characterName = $character->characterName;
             $character_data->corporationID = $character->corporationID;
             $character_data->corporationName = $character->corporationName;
             $key_data->characters()->save($character_data);
             // Remove this characterID from the known_characters as its still on
             // the key
             if (array_key_exists($character->characterID, $known_characters)) {
                 unset($known_characters[$character->characterID]);
             }
         }
         // Delete the characters that are no longer part of this key
         foreach (array_flip($known_characters) as $oldcharacter) {
             \EveAccountAPIKeyInfoCharacters::where('keyID', '=', $keyID)->where('characterID', '=', $oldcharacter)->delete();
         }
         // Update the cached_until time in the database for this api call
         BaseApi::setDbCache($scope, $api, $key_info->cached_until, $keyID);
     }
     return $key_info;
 }
コード例 #8
0
ファイル: ApiKeyController.php プロジェクト: boweiliu/seat
 public function getSetGroupMain($personid, $characterid)
 {
     // Lets do some quick checks to ensure that the person exists
     if (!SeatPeople::where('personID', $personid)->first()) {
         return Redirect::action('ApiKeyController@getPeople')->withErrors('Whatever you just tried simply wont work.');
     }
     // Delete the old main
     SeatPeopleMain::where('personID', $personid)->delete();
     $person = SeatPeople::with('main')->where('personID', $personid)->first();
     // Get the main information
     $main = new SeatPeopleMain();
     $main->characterID = $characterid;
     $main->characterName = EveAccountAPIKeyInfoCharacters::where('characterID', $characterid)->pluck('characterName');
     $person->main()->save($main);
     $person->save();
     return Redirect::action('ApiKeyController@getPeople')->with('success', 'Group has had its main updated to ' . $main->characterName);
 }
コード例 #9
0
ファイル: BaseAPI.php プロジェクト: boweiliu/seat
 public static function findCharacterCorporation($characterID)
 {
     // Locate the key in the db
     $character = \EveAccountAPIKeyInfoCharacters::where('characterID', '=', $characterID)->first();
     if (!$character) {
         return;
     }
     // Return the characters corporationID
     return $character->corporationID;
 }
コード例 #10
0
ファイル: CharacterController.php プロジェクト: boweiliu/seat
 public function getAjaxIndustry($characterID)
 {
     // Check the character existance
     $character = DB::table('account_apikeyinfo_characters')->where('characterID', $characterID)->first();
     // Check if whave knowledge of this character, else, 404
     if (count($character) <= 0) {
         App::abort(404);
     }
     // Next, check if the current user has access. Superusers may see all the things,
     // normal users may only see their own stuffs. . SuperUser() inherits 'recruiter'
     if (!\Auth::hasAccess('recruiter')) {
         if (!in_array(EveAccountAPIKeyInfoCharacters::where('characterID', $characterID)->pluck('keyID'), Session::get('valid_keys'))) {
             App::abort(404);
         }
     }
     // Get current working jobs
     $current_jobs = DB::table('character_industryjobs as a')->select(DB::raw("\n                *, CASE\n                when a.stationID BETWEEN 66015148 AND 66015151 then\n                    (SELECT s.stationName FROM staStations AS s\n                      WHERE s.stationID=a.stationID-6000000)\n                when a.stationID BETWEEN 66000000 AND 66014933 then\n                    (SELECT s.stationName FROM staStations AS s\n                      WHERE s.stationID=a.stationID-6000001)\n                when a.stationID BETWEEN 66014934 AND 67999999 then\n                    (SELECT c.stationName FROM `eve_conquerablestationlist` AS c\n                      WHERE c.stationID=a.stationID-6000000)\n                when a.stationID BETWEEN 60014861 AND 60014928 then\n                    (SELECT c.stationName FROM `eve_conquerablestationlist` AS c\n                      WHERE c.stationID=a.stationID)\n                when a.stationID BETWEEN 60000000 AND 61000000 then\n                    (SELECT s.stationName FROM staStations AS s\n                      WHERE s.stationID=a.stationID)\n                when a.stationID>=61000000 then\n                    (SELECT c.stationName FROM `eve_conquerablestationlist` AS c\n                      WHERE c.stationID=a.stationID)\n                else (SELECT m.itemName FROM mapDenormalize AS m\n                WHERE m.itemID=a.stationID) end\n                AS location,a.stationID AS locID"))->where('a.characterID', $characterID)->where('endDate', '>', date('Y-m-d H:i:s'))->orderBy('endDate', 'asc')->get();
     // Get the passed jobs
     $finished_jobs = DB::table('character_industryjobs as a')->select(DB::raw("\n                *, CASE\n                when a.stationID BETWEEN 66015148 AND 66015151 then\n                    (SELECT s.stationName FROM staStations AS s\n                      WHERE s.stationID=a.stationID-6000000)\n                when a.stationID BETWEEN 66000000 AND 66014933 then\n                    (SELECT s.stationName FROM staStations AS s\n                      WHERE s.stationID=a.stationID-6000001)\n                when a.stationID BETWEEN 66014934 AND 67999999 then\n                    (SELECT c.stationName FROM `eve_conquerablestationlist` AS c\n                      WHERE c.stationID=a.stationID-6000000)\n                when a.stationID BETWEEN 60014861 AND 60014928 then\n                    (SELECT c.stationName FROM `eve_conquerablestationlist` AS c\n                      WHERE c.stationID=a.stationID)\n                when a.stationID BETWEEN 60000000 AND 61000000 then\n                    (SELECT s.stationName FROM staStations AS s\n                      WHERE s.stationID=a.stationID)\n                when a.stationID>=61000000 then\n                    (SELECT c.stationName FROM `eve_conquerablestationlist` AS c\n                      WHERE c.stationID=a.stationID)\n                else (SELECT m.itemName FROM mapDenormalize AS m\n                WHERE m.itemID=a.stationID) end\n                AS location,a.stationID AS locID"))->where('a.characterID', $characterID)->where('endDate', '<=', date('Y-m-d H:i:s'))->orderBy('endDate', 'desc')->get();
     // Return the view
     return View::make('character.view.industry')->with('characterID', $characterID)->with('current_jobs', $current_jobs)->with('finished_jobs', $finished_jobs);
 }
コード例 #11
0
ファイル: filters.php プロジェクト: boweiliu/seat
    // We can check if the user is authed and if so, get the keyID's
    // this user is valid for.
    // We will also get a list of corporation ID's that the user is
    // affiliated to. This can be used to check the permissions then
    // later for specific functions such as starbases etc.
    // We will also check if the user has any director roles in any
    // of the affiliated corporations. Directors will be allowed to
    // assign permissions to other members of their corporation
    if (\Auth::check()) {
        // Valid API Keys
        $valid_keys = SeatKey::where('user_id', \Auth::User()->id)->lists('keyID');
        Session::put('valid_keys', $valid_keys);
        // Affiliated corporationID's.
        if (!empty($valid_keys)) {
            // Get the list of corporationID's that the user is affiliated with
            $corporation_affiliation = EveAccountAPIKeyInfoCharacters::whereIn('keyID', $valid_keys)->groupBy('corporationID')->lists('corporationID');
            Session::put('corporation_affiliations', $corporation_affiliation);
            // Determine which corporations the user is a director for
            if (!empty($corporation_affiliation)) {
                $is_director = EveCorporationMemberSecurityRoles::whereIn('corporationID', $corporation_affiliation)->where('roleID', '=', '1')->groupBy('corporationID')->lists('corporationID');
                Session::put('is_director', $is_director);
            }
        } else {
            // Just to ensure that we dont have some strange errors later, lets
            // define a empty array in the session for corporation_affiliations
            Session::put('corporation_affiliations', array());
            Session::put('is_director', array());
            Session::put('valid_keys', array());
        }
    }
});