/**
* @param $code
* @param $state
*/
public function SSOLogin($code, $state)
{
// Get the login token
$tokenURL = "https://login.eveonline.com/oauth/token";
$base64 = base64_encode($this->config->getConfig("clientID", "crestsso") . ":" . $this->config->getConfig("secretKey", "crestsso"));
$data = json_decode($this->app->cURL->sendData($tokenURL, array("grant_type" => "authorization_code", "code" => $code), array("Authorization: Basic {$base64}")));
$accessToken = $data->access_token;
$refreshToken = $data->refresh_token;
//$expiresIn = $data->expires_in;
// Verify token
$verifyURL = "https://login.eveonline.com/oauth/verify";
$data = json_decode($this->app->cURL->sendData($verifyURL, array(), array("Authorization: Bearer {$accessToken}")));
$characterID = $data->CharacterID;
$characterName = $data->CharacterName;
$characterOwnerHash = $data->CharacterOwnerHash;
//$expiresOn = $data->ExpiresOn;
$scopes = $data->Scopes;
$tokenType = $data->TokenType;
// Generate a unique id
$uniqueID = uniqid("", true);
// Insert it all to the table
$this->app->Db->execute("INSERT INTO users (characterName, characterID, characterOwnerHash, loginHash, accessToken, refreshToken, scopes, tokenType) VALUES (:characterName, :characterID, :characterOwnerHash, :loginHash, :accessToken, :refreshToken, :scopes, :tokenType) ON DUPLICATE KEY UPDATE characterName = :characterName, characterID = :characterID, characterOwnerHash = :characterOwnerHash, loginHash = :loginHash, accessToken = :accessToken, refreshToken = :refreshToken, scopes = :scopes, tokenType = :tokenType", array(":characterName" => $characterName, ":characterID" => $characterID, ":characterOwnerHash" => $characterOwnerHash, ":loginHash" => $uniqueID, ":accessToken" => $accessToken, ":refreshToken" => $refreshToken, ":scopes" => $scopes, ":tokenType" => $tokenType));
// Create the auto login cookie
$this->app->setEncryptedCookie($this->config->getConfig("name", "cookies", "rena"), $uniqueID, time() + $this->config->getConfig("time", "cookies", 3600 * 24 * 30), "/", $this->app->request->getHost(), $this->config->getConfig("ssl", "cookies", true), "true");
// Setup the groups (corp and alli)
$data = $this->app->characters->getAllByID($characterID);
// Tell resque to do stuff
if (!$data["characterID"]) {
\Resque::enqueue("now", "\\ProjectRena\\Task\\Resque\\updateCharacter", array("characterID" => $characterID));
sleep(6);
// Sleep for 6 seconds, not ideal but whatever
$data = $this->app->characters->getAllByID($characterID, 0);
// Refetch the data, just this time we skip the cache!
}
// Only do all of the group stuff if the character exists in the database.. if said character doesn't exist, we'll push the character to resque and do it all there!
if ($data) {
// Check if the user is in groups they're not allowed to be in.. this goes for corporation and alliance only!
$validGroups = array("corporation" => $data["corporationID"], "alliance" => $data["allianceID"]);
foreach ($validGroups as $type => $id) {
$innerData = $this->db->query("SELECT groupID, groupType FROM usersGroups WHERE userID = :id", array(":id" => $this->app->Users->getUserByName($characterName)["id"]));
foreach ($innerData as $check) {
if ($check["groupType"] == $type) {
if ($check["groupID"] != $id) {
$this->db->execute("DELETE FROM usersGroups WHERE userID = :id AND groupID = :groupID", array(":id" => $this->app->Users->getUserByName($characterName)["id"], ":groupID" => $check["groupID"]));
}
}
}
}
// Now add the user to the groups they're allowed to be in, this doesn't happen on anything but login so that we are a bit sql heavy there is fine!
$this->app->Groups->updateGroup($data["corporationID"], $this->app->corporations->getAllByID($data["corporationID"])["corporationName"]);
$this->app->UsersGroups->setGroup($this->app->Users->getUserByName($characterName)["id"], $data["corporationID"], "corporation");
$this->app->Groups->setAdmins($data["corporationID"], array($this->app->corporations->getAllByID($data["corporationID"])["ceoID"]));
if ($data["allianceID"] > 0) {
$this->app->Groups->updateGroup($data["allianceID"], $this->app->alliances->getAllByID($data["allianceID"])["allianceName"]);
$this->app->UsersGroups->setGroup($this->app->Users->getUserByName($characterName)["id"], $data["allianceID"], "alliance");
$this->app->Groups->setAdmins($data["allianceID"], array($this->app->corporations->getAllByID($this->app->alliances->getAllByID($data["allianceID"])["executorCorporationID"])["ceoID"]));
}
}
// Set the session
$_SESSION["characterName"] = $characterName;
$_SESSION["characterID"] = $characterID;
$_SESSION["loggedIn"] = true;
// Insert the IP
$this->app->UsersLogins->updateIP($this->app->Users->getUserByName($characterName)["id"], $this->app->request->getIp());
\Resque::enqueue("now", "\\ProjectRena\\Task\\Resque\\ipUpdater", array("userID" => $this->app->Users->getUserByName($characterName)["id"], "ip" => $this->app->request->getIp()));
// Redirect back to where the person came from
$this->app->redirect($state);
}
public function getMembersByName($allianceName)
{
return $this->db->query("SELECT characterID, characterName FROM characters WHERE allianceID = (SELECT allianceID FROM alliances WHERE allianceName = :allianceName)", array(":allianceName" => $allianceName), 3600);
}
/**
* @param $corporationName
* @return array|bool
* @throws \Exception
*/
public function getMembersByName($corporationName)
{
return $this->db->query("SELECT characterID, characterName FROM characters WHERE corporationID = (SELECT corporationID FROM corporations WHERE corporationName = :corporationName)", array(":corporationName" => $corporationName), 3600);
}
/**
* @param $orbitID
*
* @return array|bool
* @throws \Exception
*/
public function getAllByOrbitID($orbitID)
{
return $this->db->query("SELECT * FROM mapDenormalize WHERE orbitID = :orbitID", array(":orbitID" => $orbitID), 3600);
}
