XF 1.1 Change All Private nodes to "visible"

[Nudaii]

I just imported a Phpbb3 to xenforo and when checking the permissions i see every forum section now has the "private node" option ticked

I really don't want to have to go through a few dozen sections unticking this

Is there a sql query to mass set this?

Thanks in advance

 

[Jake Bunce]

If it's only a few dozen then I would just do it manually. The permission system is sufficiently complex that I am reluctant to query permissions directly.