private function removeOrphanedCharacter($keyID, $uid, $character_array)
{
$stmt = $this->_db->prepare('SELECT character_id FROM user_characters WHERE userid = ? AND key_keyid = ?');
$stmt->execute(array($uid, $keyID));
$characters = $stmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($characters as $character) {
unset($character_array[$character['character_id']]);
}
if (!empty($character_array)) {
foreach ($character_array as $delete_character) {
Character::deleteCharacter($delete_character, $uid, $this->_db);
}
}
}
$stmt->execute(array($user->getUID(), $keyID));
$characters = $stmt->fetchAll(PDO::FETCH_ASSOC);
$character_array = array();
foreach ($characters as $character) {
$character_array[$character['charid']] = $character['charid'];
}
foreach ($key->getCharacters() as $character) {
$char = new Character($character['characterID'], $key->getKeyID(), $key->getVCode(), $key->getAccessMask(), $db, $user);
if ($char->getExistance() or $char->getExistance() == FALSE) {
$char->updateCharacterInfo();
}
unset($character_array[$char->getCharacterID()]);
}
if (!empty($character_array)) {
foreach ($character_array as $delete_character) {
Character::deleteCharacter($delete_character, $user->getUID());
}
}
$refresh = $key->refreshAPIKey('refresh');
setAlert('success', 'API Key Refreshed', 'The API key has been successfully refreshed.');
}
} elseif (!($key->getAccessMask() & MINIMUM_API) and $key->getKeyStatus() == 1) {
setAlert('danger', 'The API Key Does Not Meet Minimum Requirements', 'The required minimum Access Mask for API keys is ' . MINIMUM_API . '. Please create a new key using the Create Key link.');
}
} elseif ($request['value'] == 'delete') {
}
if ($user->getAdminAccess()) {
$stmt = $db->prepare('SELECT * FROM user_apikeys JOIN user_accounts ON user_apikeys.uid = user_accounts.uid ORDER BY user_accounts.username ASC');
$stmt->execute(array());
$keys = $stmt->fetchAll(PDO::FETCH_ASSOC);
} else {
