function acquia_spi_get_admin_count in Acquia Connector 6.2

Same name and namespace in other branches

1. 7.3 acquia_spi/acquia_spi.module \acquia_spi_get_admin_count()
2. 7.2 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 1219

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, {permission} p\n             WHERE u.uid = ur.uid\n               AND ur.rid = p.rid\n               AND u.status = 1\n               AND (p.perm LIKE '%administer permissions%' OR p.perm LIKE '%administer users%')";
  $result = db_query($sql);
  while ($r = db_fetch_array($result)) {
    $count = $r['count'];
    break;
  }
  return is_numeric($count) ? $count : NULL;
}