function acquia_spi_get_admin_count in Acquia Connector 7.3
Same name and namespace in other branches
- 6.2 acquia_spi/acquia_spi.module \acquia_spi_get_admin_count()
- 7.2 acquia_spi/acquia_spi.module \acquia_spi_get_admin_count()
The number of users who have admin-level user roles.
Return value
int Number of users.
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 1465 - 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;
}