Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Joomla Bridge Support => Topic started by: JoeP on March 07, 2008, 12:49:38 PM

Title: Mambo -> Joomla database query
Post by: JoeP on March 07, 2008, 12:49:38 PM
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