Re: Clarification on ACL
Yes, that is what I used for the initial setup, however, it does not handle the multiple groups in the way I'm looking for without doing the nested approach I mentioned above. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Clarification on ACL
I've finally gotten a basic auth system set up using ACL. That has helped me understand the thing a lot better, but there's still one part I'm a bit fuzzy on when it comes to groups. I want to have groups (say A, B, C, D) where a user can be a member of one, all, or any combination of them. Each group has access to a different section of the website and the access is not shared. For example, the following nested illustration is NOT what I am after. A ||->B ||->C ||->D This is, however, the only way that group access can be done in ACL, from what I've gathered from the documentation, since each ARO can only have one parent. Now this nested style could work with by created an increasingly large number of 'groups' to handle all combinations of groups, but this is would be a very ugly thing to do, so I ask am I missing something in ACL that would make the multiple groups thing possible, or is there any way to implement what I'm looking for? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: HABTM involving 3 tables
Unless I'm misunderstanding that needs to be done each time I want to access the data, then. I was looking for a way to do the association so that it the data could then be accessed through the model, like you can with other associations. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
HABTM involving 3 tables
I have tables as below and want to use SQL statement "select groups.id as GroupID, groups.name as GroupName, views.id as ViewID, views.name as ViewName, subviews.id as SubViewID, subviews.name as SubViewName from groups,views,subviews,groups_views_subviews where groups.id = groups_views_subviews.group_id and views.id = groups_views_subviews.view_id and subviews.id = groups_views_subviews.subview_id;" to join them inside the Group class, however, I can't figure out how to do this. I assume finderSql is what I'm looking for, but I can't seem to make it work. CREATE TABLE views ( id MEDIUMINT AUTO_INCREMENT, name VARCHAR(50) NOT NULL, PRIMARY KEY(id) ); CREATE TABLE groups_views_subviews ( view_id MEDIUMINT, subview_id MEDIUMINT, group_id MEDIUMINT ); CREATE TABLE subviews ( id MEDIUMINT AUTO_INCREMENT, name VARCHAR(50) NOT NULL, PRIMARY KEY(id) ); CREATE TABLE groups ( id MEDIUMINT AUTO_INCREMENT, name VARCHAR(50) NOT NULL, PRIMARY KEY(id) ); --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---