• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Select all node ids where the registered usergroup permission is set to revoke

Brent W

Well-known member
#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?
 

Xon

Well-known member
#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'