if (count($functions) < 1) { $lists['cacl_fid'] = JText::_('There is no functions'); } cacl_html::showAssignUsers($lists); } function showUnassignUsers($option, $cid) { global $mainframe; $db =& JFactory::getDBO(); $query = 'SELECT id, CONCAT(name, \' (\', username, \')\') AS name ' . ' FROM `#__users`' . ' WHERE `id` IN (\'' . implode("','", $cid) . '\')' . ' ORDER BY name'; $db->setQuery($query); $lists['user_list'] = $db->loadObjectList(); $query = 'SELECT id AS value, name AS text' . ' FROM `#__community_acl_groups`' . ' ORDER BY name'; $db->setQuery($query); $groups = $db->loadObjectList(); $lists['cacl_gid'] = JHTML::_('select.genericlist', $groups, 'cacl_group_list', ' class="inputbox" size="7" style="max-width:100px;" multiple="multiple" ', 'value', 'text', null); if (count($groups) < 1) { $lists['cacl_gid'] = JText::_('There is no groups'); } $query = 'SELECT id ' . ' FROM `#__community_acl_groups`' . ' ORDER BY name'; $db->setQuery($query); $groups = $db->loadObjectList(); $query = 'SELECT id AS value, name AS text, group_id' . ' FROM `#__community_acl_roles`' . ' ORDER BY group_id, name'; $db->setQuery($query); $roles = $db->loadObjectList(); $tmp_arr = array(); if (is_array($roles) && count($roles)) { $tmp_arr = array(); foreach ($groups as $group) { $z = 0; foreach ($roles as $i => $role) { if ($role->group_id != $group->id) { continue; } $tmp_arr[] = array('group' => $role->group_id, 'value' => $role->value, 'text' => $role->text); $z++; } if ($z == 0) { $tmp_arr[] = array('group' => $group->id, 'value' => 0, 'text' => JText::_('None')); } } } $lists['cacl_rid_arr'] = $tmp_arr; $lists['cacl_rid'] = JHTML::_('select.genericlist', $roles, 'cacl_role_list', ' class="inputbox" size="7" style="max-width:100px;" multiple="multiple" ', 'value', 'text', null);