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 {