Mambo -> Joomla database query

Started by JoeP, March 07, 2008, 12:49:38 PM

Previous topic - Next topic

JoeP

Does anyone know if this mambo db query:
$database->setQuery("
            SELECT `group_id`, `name`
            FROM #__core_acl_aro_groups
            ");
would be equivalent to this query for Joomla 1.5?
$database->setQuery("
            SELECT `id`, `name`
            FROM #__core_acl_aro_groups
            ");

The #__core_acl_aro_groups table for J!1.5 only contains the following fields:
id
parent_id
name
lft
rgt
value

For the default install, name = value
it appears that parent id refers to inheritance  e.g.  parent_id of USERS = id of ROOT. parent_id of Public Frontend = id of USERS, etc.

Thanks in advance.
joe

Advertisement: