/** Working with API keys*/
$keys = true;
/** Checking to see if we've submitted an action */
if (isset($_POST['action'])) {
/** Checking to see what action we're performing*/
if ($_POST['action'] == 'refresh' || $_POST['action'] == 'add') {
/** Saving our API keys from $_POST */
$keyID = $_POST['keyID'];
$vCode = $_POST['vCode'];
/** Creating an API key object */
$key = new ApiKey($keyID, $vCode, $user, $db);
/** Doing either the add or the refresh action */
$keyUpdate = $key->refreshAPIKey($_POST['action']);
} elseif ($_POST['action'] == 'delete') {
/** Deleting the API Key */
ApiKey::deleteKey($_POST['keyID'], $user, $db);
}
}
$stmt = $db->prepare('SELECT * FROM user_apikeys WHERE userid = ? ORDER BY key_keyid ASC');
$stmt->execute(array($user->getUserID()));
$apiKeys = $stmt->fetchAll(\PDO::FETCH_ASSOC);
$characterArray = array();
if ($stmt->rowCount() >= 1) {
foreach ($apiKeys as $key) {
$stmt_lookup_characters = $db->prepare('SELECT character_id,key_keyid,corporation_id,' . 'alliance_id,sso_character FROM user_characters WHERE key_keyid = ?');
$stmt_lookup_characters->execute(array($key['key_keyid']));
$characterArray[$key['key_keyid']] = $stmt_lookup_characters->fetchAll(PDO::FETCH_ASSOC);
}
}
} elseif ($pageRequest[0] == "characters") {
if (isset($_POST['action'])) {
public static function deleteUser($uid)
{
global $db;
$stmt = $db->prepare('SELECT * FROM user_apikeys WHERE uid = ?');
$stmt->execute(array($uid));
$keys = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($keys as $key) {
ApiKey::deleteKey($key['userid'], $uid);
}
$stmt = $db->prepare('SELECT * FROM user_applications WHERE uid = ?');
$stmt->execute(array($uid));
$apps = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($apps as $app) {
$stmt = $db->prepare('DELETE FROM group_application_comments WHERE application_id = ?');
$stmt->execute(array($app['application_id']));
}
$stmt = $db->prepare('DELETE FROM user_applications WHERE uid = ?');
$stmt->execute(array($uid));
$stmt = $db->prepare('DELETE FROM user_accounts WHERE uid = ?');
$stmt->execute(array($uid));
}
