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;
}
