function acquia_spi_get_admin_count in Acquia Connector 7.2

Same name and namespace in other branches

1. 6.2 acquia_spi/acquia_spi.module \acquia_spi_get_admin_count()
2. 7.3 acquia_spi/acquia_spi.module \acquia_spi_get_admin_count()

The number of users who have admin-level user roles.

Parameters

n/a:

Return value

int

1 call to acquia_spi_get_admin_count()

acquia_spi_get in acquia_spi/acquia_spi.module

Gather site profile information about this site.

File

acquia_spi/acquia_spi.module, line 1311

Send site profile information (NSPI) and system data to Acquia Insight.

Code

function acquia_spi_get_admin_count() {
  $count = NULL;
  $sql = "SELECT COUNT(DISTINCT u.uid) as count\n              FROM {users} u, {users_roles} ur, {role_permission} p\n              WHERE u.uid = ur.uid\n                AND ur.rid = p.rid\n                AND u.status = 1\n                AND (p.permission = 'administer permissions' OR p.permission = 'administer users')";
  $result = db_query($sql)
    ->fetchObject();
  return isset($result->count) && is_numeric($result->count) ? $result->count : NULL;
}