protected function get_group_children($var_1 = null, $var_2 = null, $var_3 = null) { if (!$var_3) { $var_3 = 'NO_RECURSE'; } $query = 'SELECT g1.' . $this->_db->NameQuote('id') . "\n FROM " . $this->_db->NameQuote('#__usergroups') . " AS g1"; if ($var_3 == 'RECURSE') { $query .= "\n LEFT JOIN " . $this->_db->NameQuote('#__usergroups') . " AS g2" . ' ON g2.' . $this->_db->NameQuote('lft') . ' < g1.' . $this->_db->NameQuote('lft') . ' AND g2.' . $this->_db->NameQuote('rgt') . ' > g1.' . $this->_db->NameQuote('rgt') . "\n WHERE g2." . $this->_db->NameQuote('id') . " = " . (int) $var_1; } else { $query .= "\n WHERE g1." . $this->_db->NameQuote('parent_id') . " = " . (int) $var_1; } $query .= "\n ORDER BY g1." . $this->_db->NameQuote('title'); $this->_db->setQuery($query); $return = $this->_db->loadResultArray(); return $return; }