/** * @return \yii\db\ActiveQuery */ public function getAccessToken() { return $this->hasOne(OauthAccessTokens::className(), ['access_token' => 'access_token']); }
/** * @return \yii\db\ActiveQuery */ public function getOauthAccessTokens() { return $this->hasMany(OauthAccessTokens::className(), ['client_id' => 'client_id']); }
public function deleteToken($token) { $access_token = new \OauthAccessTokens(); $access_token->load($token); $stmt = $this->db->prepare(sprintf('DELETE FROM %s WHERE ACCESS_TOKEN = :token', $this->config['access_token_table'])); return $stmt->execute(compact("token")); }
public function logout($oauthAccessTokenId, $refresh) { $aFields = array(); if (!isset($_GET['u'])) { $aFields['URL'] = ''; } else { $aFields['URL'] = htmlspecialchars(addslashes(stripslashes(strip_tags(trim(urldecode($_GET['u'])))))); } if (!isset($_SESSION['G_MESSAGE'])) { $_SESSION['G_MESSAGE'] = ''; } if (!isset($_SESSION['G_MESSAGE_TYPE'])) { $_SESSION['G_MESSAGE_TYPE'] = ''; } $msg = $_SESSION['G_MESSAGE']; $msgType = $_SESSION['G_MESSAGE_TYPE']; if (!isset($_SESSION['FAILED_LOGINS'])) { $_SESSION['FAILED_LOGINS'] = 0; $_SESSION["USERNAME_PREVIOUS1"] = ""; $_SESSION["USERNAME_PREVIOUS2"] = ""; } $sFailedLogins = $_SESSION['FAILED_LOGINS']; $usernamePrevious1 = $_SESSION["USERNAME_PREVIOUS1"]; $usernamePrevious2 = $_SESSION["USERNAME_PREVIOUS2"]; $aFields['LOGIN_VERIFY_MSG'] = G::loadTranslation('LOGIN_VERIFY_MSG'); //start new session @session_destroy(); session_start(); session_regenerate_id(); setcookie("workspaceSkin", SYS_SKIN, time() + (24 * 60 * 60), "/sys" . SYS_SYS, null, false, true); if (strlen($msg) > 0) { $_SESSION['G_MESSAGE'] = $msg; } if (strlen($msgType) > 0) { $_SESSION['G_MESSAGE_TYPE'] = $msgType; } $_SESSION['FAILED_LOGINS'] = $sFailedLogins; $_SESSION["USERNAME_PREVIOUS1"] = $usernamePrevious1; $_SESSION["USERNAME_PREVIOUS2"] = $usernamePrevious2; /*----------------------------------********---------------------------------*/ if (!class_exists('pmLicenseManager')) { G::LoadClass('pmLicenseManager'); } $licenseManager =& \pmLicenseManager::getSingleton(); if (in_array(md5($licenseManager->result), array('38afd7ae34bd5e3e6fc170d8b09178a3', 'ba2b45bdc11e2a4a6e86aab2ac693cbb'))) { $G_PUBLISH = new \Publisher(); $G_PUBLISH->AddContent('xmlform', 'xmlform', 'login/licenseExpired', '', array(), 'licenseUpdate'); G::RenderPage('publish'); die(); } /*----------------------------------********---------------------------------*/ try { $oatoken = new \OauthAccessTokens(); $result = $oatoken->remove($oauthAccessTokenId); $response["status"] = "OK"; } catch (Exception $e) { $response["status"] = "ERROR"; $response["message"] = $e->getMessage(); } return $response; }
public function logout($oauthAccessTokenId, $refresh) { $aFields = array(); if (!isset($_GET['u'])) { $aFields['URL'] = ''; } else { $aFields['URL'] = htmlspecialchars(addslashes(stripslashes(strip_tags(trim(urldecode($_GET['u'])))))); } if (!isset($_SESSION['G_MESSAGE'])) { $_SESSION['G_MESSAGE'] = ''; } if (!isset($_SESSION['G_MESSAGE_TYPE'])) { $_SESSION['G_MESSAGE_TYPE'] = ''; } $msg = $_SESSION['G_MESSAGE']; $msgType = $_SESSION['G_MESSAGE_TYPE']; if (!isset($_SESSION['FAILED_LOGINS'])) { $_SESSION['FAILED_LOGINS'] = 0; $_SESSION["USERNAME_PREVIOUS1"] = ""; $_SESSION["USERNAME_PREVIOUS2"] = ""; } $sFailedLogins = $_SESSION['FAILED_LOGINS']; $usernamePrevious1 = $_SESSION["USERNAME_PREVIOUS1"]; $usernamePrevious2 = $_SESSION["USERNAME_PREVIOUS2"]; $aFields['LOGIN_VERIFY_MSG'] = G::loadTranslation('LOGIN_VERIFY_MSG'); //start new session @session_destroy(); session_start(); session_regenerate_id(); setcookie("workspaceSkin", SYS_SKIN, time() + 24 * 60 * 60, "/sys" . SYS_SYS, null, false, true); if (strlen($msg) > 0) { $_SESSION['G_MESSAGE'] = $msg; } if (strlen($msgType) > 0) { $_SESSION['G_MESSAGE_TYPE'] = $msgType; } $_SESSION['FAILED_LOGINS'] = $sFailedLogins; $_SESSION["USERNAME_PREVIOUS1"] = $usernamePrevious1; $_SESSION["USERNAME_PREVIOUS2"] = $usernamePrevious2; /*----------------------------------********---------------------------------*/ try { $oatoken = new \OauthAccessTokens(); $result = $oatoken->remove($oauthAccessTokenId); $response["status"] = "OK"; } catch (Exception $e) { $response["status"] = "ERROR"; $response["message"] = $e->getMessage(); } return $response; }
case "DEL": $oauthAccessTokenId = $_POST["oauthAccessTokenId"]; try { $oatoken = new OauthAccessTokens(); $result = $oatoken->remove($oauthAccessTokenId); $response["status"] = "OK"; } catch (Exception $e) { $response["status"] = "ERROR"; $response["message"] = $e->getMessage(); } break; case "LST": $pageSize = $_POST["pageSize"]; $sortField = isset($_POST["sort"]) ? $_POST["sort"] : ""; $sortDir = isset($_POST["dir"]) ? $_POST["dir"] : ""; $start = isset($_POST["start"]) ? $_POST["start"] : 0; $limit = isset($_POST["limit"]) ? $_POST["limit"] : $pageSize; try { $oatoken = new OauthAccessTokens(); $result = $oatoken->getAll(array("USER_ID" => $_SESSION["USER_LOGGED"]), $sortField, $sortDir, $start, $limit); $response["status"] = "OK"; $response["success"] = true; $response["resultTotal"] = $result["numRecTotal"]; $response["resultRoot"] = $result["data"]; } catch (Exception $e) { $response["status"] = "ERROR"; $response["message"] = $e->getMessage(); } break; } echo G::json_encode($response);