1. 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

Discussion in 'XenForo Questions and Support' started by BamaStangGuy, Aug 5, 2015.

  1. BamaStangGuy

    BamaStangGuy Well-Known Member

    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?
     
  2. Xon

    Xon Well-Known Member

    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'
     

Share This Page