Brent W Well-known member Aug 5, 2015 #1 Hi, Can someone scrounge up a query for me that will let me select the node id of all forum nodes where the permission for the usergroup Registered is set to revoke for View Node?
Hi, Can someone scrounge up a query for me that will let me select the node id of all forum nodes where the permission for the usergroup Registered is set to revoke for View Node?
X Xon Well-known member Aug 5, 2015 #2 The following should work: Code: select distinct content_id from xf_permission_entry_content where xf_permission_entry_content.permission_value = 'reset' and content_type = 'node' Upvote 0 Downvote
The following should work: Code: select distinct content_id from xf_permission_entry_content where xf_permission_entry_content.permission_value = 'reset' and content_type = 'node'