| @@ 92-109 (lines=18) @@ | ||
| 89 | return $stmt->fetch(PDO::FETCH_ASSOC); |
|
| 90 | } |
|
| 91 | ||
| 92 | public function get($accessTokenKey) |
|
| 93 | { |
|
| 94 | $stmt = $this->db->prepare( |
|
| 95 | 'SELECT |
|
| 96 | user_id, |
|
| 97 | access_token, |
|
| 98 | client_id, |
|
| 99 | scope |
|
| 100 | FROM tokens |
|
| 101 | WHERE |
|
| 102 | access_token_key = :access_token_key' |
|
| 103 | ); |
|
| 104 | ||
| 105 | $stmt->bindValue(':access_token_key', $accessTokenKey, PDO::PARAM_STR); |
|
| 106 | $stmt->execute(); |
|
| 107 | ||
| 108 | return $stmt->fetch(PDO::FETCH_ASSOC); |
|
| 109 | } |
|
| 110 | ||
| 111 | public function getAuthorizedClients($userId) |
|
| 112 | { |
|
| @@ 111-126 (lines=16) @@ | ||
| 108 | return $stmt->fetch(PDO::FETCH_ASSOC); |
|
| 109 | } |
|
| 110 | ||
| 111 | public function getAuthorizedClients($userId) |
|
| 112 | { |
|
| 113 | $stmt = $this->db->prepare( |
|
| 114 | 'SELECT |
|
| 115 | client_id, |
|
| 116 | scope |
|
| 117 | FROM tokens |
|
| 118 | WHERE |
|
| 119 | user_id = :user_id' |
|
| 120 | ); |
|
| 121 | ||
| 122 | $stmt->bindValue(':user_id', $userId, PDO::PARAM_STR); |
|
| 123 | $stmt->execute(); |
|
| 124 | ||
| 125 | return $stmt->fetchAll(PDO::FETCH_ASSOC); |
|
| 126 | } |
|
| 127 | ||
| 128 | public function removeClientTokens($userId, $clientId) |
|
| 129 | { |
|