Registered users user (Less Super User) - Joomla! Forum - community, help and support

hi.

i have code displays number of registered users

code: select all

<?php
$db = jfactory::getdbo();
$query = $db->getquery(true);
$query->select('count(id) numusers')->from('#__users')->where('block = 0');
$db->setquery($query);
$numusers = $db->loadresult();
echo ''.$numusers.' ';
?>   


it works fine, displays number of super users, problem because have installed extension displays registered users.

i have written modification:

code: select all

<?php
$db = jfactory::getdbo();
$query = $db->getquery(true);
$query->select('count(id) numusers')->from('#__users')->where('block = 0');
$db->setquery($query);
$numusers = $db->loadresult();
$y = 1;
echo $numusers - $y;
?>   


to point, works, considering there 1 super user (me), wouldn't reply higher needs, instance in case of multiple administrators, etc.

is there way remove super users account?

perhaps using code administrator files display number of users in registered users group, in other post on same forum:

http://forum.joomla.org/viewtopic.php?f=706&t=933637

if possible. cannot find string far.

thanks.

your query select users not disabled.
the user groups in #_usergroups , users mapped in #_user_usergroup_map
sup-admins group id=8

code: select all

where block = 0 , id in (select user_id from  #_user_usergroup_map group_id not 8)