public function OAuthStorePostgreSQL::listServers in Lingotek Translation 7.7

Same name and namespace in other branches

1. 7.2 lib/oauth-php/library/store/OAuthStorePostgreSQL.php \OAuthStorePostgreSQL::listServers()
2. 7.3 lib/oauth-php/library/store/OAuthStorePostgreSQL.php \OAuthStorePostgreSQL::listServers()
3. 7.4 lib/oauth-php/library/store/OAuthStorePostgreSQL.php \OAuthStorePostgreSQL::listServers()
4. 7.5 lib/oauth-php/library/store/OAuthStorePostgreSQL.php \OAuthStorePostgreSQL::listServers()
5. 7.6 lib/oauth-php/library/store/OAuthStorePostgreSQL.php \OAuthStorePostgreSQL::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:

int user_id:

Return value

array

Overrides OAuthStoreAbstract::listServers

File

lib/oauth-php/library/store/OAuthStorePostgreSQL.php, line 701

Class

OAuthStorePostgreSQL

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;
}