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

Query for public threads

Discussion in 'XenForo Development Discussions' started by Wootalyzer, Mar 27, 2011.

  1. Wootalyzer

    Wootalyzer Active Member

    Is there an easy way to query for recent threads which are publicly viewable (aka, posted in a forum on which the guest user-group has access). All the solutions I've seen so far query for all recent posts, then prune out threads for which you do not have access.

    I'm really trying my best to avoid specifying which specific forums are included in the query -- I'd love some sql magic that merges with the permissions table instead. I just don't know enough about the permission system to know if it's possible.

    Update -- looks like it'll be pretty difficult to do in one query, because you can't really iterate up the node tree looking for permissions effectively.
     

Share This Page