Tree view of groups

[epaz]

I have entered some new groups in my local installation (groups.png) using the "Access Manager" screen. In the "Users" screen we have the ability to assign one group to each user and the hierarchy tree view is correct (list_develop.png).

I have exported these records from my local database and I have imported them in the official database of my site. The hierarchy tree view in the "Users" screen is a mess (list_official.png) but in the "Access Manager" everything looks fine (groups.png).

What is the problem? Comparing the data in the elx_core_acl_aro_groups table I can see that the group_id, parent_id, name fields have exactly the same values in both databases. The other 2 fields (lft & rgt) differ. Is this a problem? Can anyone help me understand the way the "thing" works. If I manually change these values what will happen? Are there any logical links to these fields in other tables?

Please advise....

[old attachment deleted by admin]

[datahell]

elx_core_acl_aro_groups
"lft" and "rgt" columns are the most important ones as they show you how you "travel" inside the hierarchy tree and the parent groups.

[epaz]

Can you explain a little further? What is the meaning of these names?

[datahell]

I created a graphical representation of the standard elxis groups and the hierarchy tree. The group IDs are just numbers. The important parameters are the lft and rgt values as they show you group parents (each group strength). For example the "Registered" group has lft= 4 and rgt=11. This means that is contained by all groups with lft, rgt values between 4 and 11, so: Author(5,10), Editor (6,9) and Publisher(7,8). These groups are "stronger" (have more privileges) than the "Registered" group. The hierarchy tree is generated by "traveling" through the lft and rgt values in ascending order. Elxis updates automatically lft and rgt values when ever you edit/add/delete a group.


[old attachment deleted by admin]

[epaz]

Just fine. Life will be easier when recursive queries will be supported in mySQL. Queries in the form of CONNECT BY PRIOR if speaking in Oracle terms. As far as I know such queries are supported by Oracle, SQL Server 2005 and Firebird 2.1

Thanx