public function OAuthStoreSQL::listConsumerTokens in Lingotek Translation 7.7

Same name and namespace in other branches

1. 7.2 lib/oauth-php/library/store/OAuthStoreSQL.php \OAuthStoreSQL::listConsumerTokens()
2. 7.3 lib/oauth-php/library/store/OAuthStoreSQL.php \OAuthStoreSQL::listConsumerTokens()
3. 7.4 lib/oauth-php/library/store/OAuthStoreSQL.php \OAuthStoreSQL::listConsumerTokens()
4. 7.5 lib/oauth-php/library/store/OAuthStoreSQL.php \OAuthStoreSQL::listConsumerTokens()
5. 7.6 lib/oauth-php/library/store/OAuthStoreSQL.php \OAuthStoreSQL::listConsumerTokens()

* Fetch a list of all consumer tokens accessing the account of the given user. * *

Parameters

int user_id: * @return array

Overrides OAuthStoreAbstract::listConsumerTokens

File

lib/oauth-php/library/store/OAuthStoreSQL.php, line 1562

Class

OAuthStoreSQL

Code

public function listConsumerTokens($user_id) {
  $rs = $this
    ->query_all_assoc('
				SELECT	osr_consumer_key 		as consumer_key,
						osr_consumer_secret		as consumer_secret,
						osr_enabled				as enabled,
						osr_status 				as status,
						osr_application_uri		as application_uri,
						osr_application_title	as application_title,
						osr_application_descr	as application_descr,
						ost_timestamp			as timestamp,	
						ost_token				as token,
						ost_token_secret		as token_secret,
						ost_referrer_host		as token_referrer_host,
						osr_callback_uri		as callback_uri
				FROM oauth_server_registry
					JOIN oauth_server_token
					ON ost_osr_id_ref = osr_id
				WHERE ost_usa_id_ref = %d
				  AND ost_token_type = \'access\'
				  AND ost_token_ttl  >= NOW()
				ORDER BY osr_application_title
				', $user_id);
  return $rs;
}