How get all roles which can see newly created node
MantasK - October 3, 2009 - 06:46
| Project: | Taxonomy Access Control Lite |
| Version: | 6.x-1.3 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
Hi.
I need a little bit support.
How can I select all roles and users who can view newly created node? In my module I implement hook_nodeapi, which have to send email notification to all users who can view that node. And I only need these to which permissions are set.
Now I've implemented it with "Term Permissions" module:
SELECT tpr . * , users.*
FROM {term_permissions_role} AS tpr
LEFT JOIN {users_roles} ur ON ur.rid = tpr.rid
LEFT JOIN {users} users ON ur.uid = users.uid
WHERE tpr.tid IN ('. implode(",", $terms) .')'But I don't need this module at all and now its too much configuration for users.
Thanks.