Support

  1. Queenielass
  2. Support
  3. Monday, May 07 2018, 06:37 PM
  4.  Subscribe via email
I am struggling a bit with making access to only certain user groups match ACL.

1. When a member joins they choose between 2 groups and are automatically assigned as Registered and either Group A (Mentors) or Group B (Mentees)
I want the search to be available to only Mentees (B) and think I have managed this with the SQL.
However rather than a menu-link to Search I needed to make it stand out so created a module with css styling to go to a hidden-menu item with access for only Mentees (B) in the ACL
However the link appears to both groups unless I remove Group B from the Registered access level.
This feels wrong. Could you check for me please? I suspect this is a Joomla issue rather than easy profile but the advanced functions of EP have got me in a knot :o

2. I have created a Manager-only user Group which does not add them as Registered users nor in Mentor or Mentee groups. However they are appearing in Searches which really must not happen. Again, this may be due to my poor configuration of Joomla ACL.
Please can you check this for me to see where I'm going wrong?
Access info in secure tab.
admin Accepted Answer
Admin
Hi,

1) can you please help me to identify the menu item and module by specifying the name of both :)

2) I found that in one of your Users List menu item you have set following Custom SQL Where (see screenshot):
user_id NOT IN (11,8,7,6)
This exclude a specific users with these user id but I think you want to exclude group_id instead user_id, so it become something like
group_id NOT IN (11,8,7,6)
Attachments (1)
  1. 2 weeks ago
  2. Support
  3. # 1
Queenielass Accepted Answer
Pro
1. The menu item is in 'hidden-menu' It is called 'Search for a Mentor' alias is and the access level is for only Mentees.
The module is called "Search for a Mentor menu button" and is added as a particle/module in the Main Menu through the Gantry section.
I MAY have managed to fix this now, but I would appreciate it if you could check, please?
When a User signs up as a Mentee they are automatically added to Mentee user-group and registered user-group using the SQL in the registration process.

2. I have removed all but one instance of the User search menu and changed the SQL to reflect the
group_id NOT IN (11,8,7,6)

However, Mentees(group ID 11) still show up in Mentor search.

3. Also, in the main Social Network user list, I have realised that the members of the Manager-only group also show up in the Easy Profile » Social Network ( Menu item Alias: network) for members only - ie Registered members and I can't understand why?
  1. 2 weeks ago
  2. Support
  3. # 2
admin Accepted Answer
Admin
Hi,
sorry for late reply.

1) The Access Level of the module and of seems correct.

2) try with
user_id NOT IN (SELECT user_id FROM #__user_usergroup_map WHERE group_id IN (11,8,7,6))
We need something like this because there is a INNER JOIN between Joomla User Table and Joomla Usergroups Table. Basically a Sql WHERE like your does not exclude users in registered usergroup.

3) Can you please explain me better? sorry, I did not understood :(
  1. one week ago
  2. Support
  3. # 3
Queenielass Accepted Answer
Pro
2. I'm sorry but I don't understand what to put. Can you help please?

user_id NOT IN (SELECT user_id FROM #__user_usergroup_map WHERE group_id IN (11,8,7,6))


I tried using the ID of the Registered group - didn't work user_id NOT IN (2) WHERE group_id IN (11,8,7,6))

I tried using a specific userID user_id NOT IN (296 WHERE group_id IN (11,8,7,6))

The groups I do NOT want to show are the Mentees group 11 and Managers group 7 Administrators group 6 and Super Users group 6

3. When on the Social Network page we do not want the Managers to show up in the member/list (nothing to do with searching for users) They are not in the Registered User Group so shouldn't show

The members circled are Manager/administrators and not "members" - how do get it so they don't show?
Attachments (1)
  1. one week ago
  2. Support
  3. # 4
admin Accepted Answer
Admin
Hi,
2) you should put in SQL parameter this:
user_id NOT IN (SELECT user_id FROM #__user_usergroup_map WHERE group_id IN (11,8,7,6))


with this users in usergroup 11,8,7 and 6 should be hidden

3) Social Network plugin show all users, to remove some user please follow these steps:
- Go to Extensions->Plugins
- Search for "Social Network"
- Click to the plugin called "Easy Profile - Social Network"
- Add in parameter "Exclude Users From People List" the comma separated IDs of users, so something like 406,409,....
  1. one week ago
  2. Support
  3. # 5
Queenielass Accepted Answer
Pro
Many, many, many thanks. It works a treat! :D
  1. one week ago
  2. Support
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.