$db->setQuery($query); $groups = @array_merge($groups, $db->loadObjectList()); $lists['group_id'] = JHTML::_('select.genericlist', $groups, 'group_id', 'class="inputbox" size="1" ' . $javascript, 'value', 'text', $group_id); cacl_html::show_functions($rows, $pageNav, $lists, $group_id); } function editFunction($edit) { global $mainframe, $option; $group_id = 0; //$mainframe->getUserStateFromRequest( $option.'.functions.group_id', 'group_id', 0, 'int' ); // Initialize variables $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $uid = $user->get('id'); $cid = JRequest::getVar('cid', array(0), '', 'array'); JArrayHelper::toInteger($cid, array(0)); $row = new CACL_function($db); if ($edit) { $row->load($cid[0]); } else { $row->group_id = $group_id; } // build the html select list for ordering $query = 'SELECT ordering AS value, name AS text' . ' FROM #__community_acl_functions' . ($row->group_id > 0 ? ' WHERE group_id = ' . $db->Quote($row->group_id) : '') . ' ORDER BY ordering'; /* if ($edit) { $lists['ordering'] = JHTML::_('list.specificordering', $row, $cid[0], $query ); } else { $lists['ordering'] = JHTML::_('list.specificordering', $row, '', $query ); } $query = 'SELECT id AS value, name AS text' . ' FROM `#__community_acl_groups`' . ' ORDER BY name' ; $db->setQuery( $query );