/** 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)); }