public function OAuthStoreSQL::listServers in Lingotek Translation 7.2

Same name and namespace in other branches

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

* Get a list of all consumers from the consumer registry. * The consumer keys belong to the user or are public (user id is null) * *

Parameters

string q query term: * @param int user_id * @return array

Overrides OAuthStoreAbstract::listServers

File

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

Class

OAuthStoreSQL

Code

public function listServers($q = '', $user_id) {
  $q = trim(str_replace('%', '', $q));
  $args = array();
  if (!empty($q)) {
    $where = ' WHERE (	ocr_consumer_key like \'%%%s%%\'
						  	 OR ocr_server_uri like \'%%%s%%\'
						  	 OR ocr_server_uri_host like \'%%%s%%\'
						  	 OR ocr_server_uri_path like \'%%%s%%\')
						 AND (ocr_usa_id_ref = %d OR ocr_usa_id_ref IS NULL)
					';
    $args[] = $q;
    $args[] = $q;
    $args[] = $q;
    $args[] = $q;
    $args[] = $user_id;
  }
  else {
    $where = ' WHERE ocr_usa_id_ref = %d OR ocr_usa_id_ref IS NULL';
    $args[] = $user_id;
  }
  $servers = $this
    ->query_all_assoc('
					SELECT	ocr_id					as id,
							ocr_usa_id_ref			as user_id,
							ocr_consumer_key 		as consumer_key,
							ocr_consumer_secret 	as consumer_secret,
							ocr_signature_methods	as signature_methods,
							ocr_server_uri			as server_uri,
							ocr_server_uri_host		as server_uri_host,
							ocr_server_uri_path		as server_uri_path,
							ocr_request_token_uri	as request_token_uri,
							ocr_authorize_uri		as authorize_uri,
							ocr_access_token_uri	as access_token_uri
					FROM oauth_consumer_registry
					' . $where . '
					ORDER BY ocr_server_uri_host, ocr_server_uri_path
					', $args);
  return $servers;
}