Für die BoardPage Sitemap habe ich folgende SQL Bedingung eingebunden.
SQL
- board.boardID NOT IN (SELECT objectID FROM wcf1_acl_option_to_group og INNER JOIN wcf1_object_type_definition otd ON otd.definitionName = 'com.woltlab.wcf.acl' INNER JOIN wcf1_object_type ot ON ot.objectType = 'com.woltlab.wbb.board' AND ot.definitionID = otd.definitionID INNER JOIN wcf1_acl_option o ON o.objectTypeID = ot.objectTypeID AND o.optionName = 'canEnterBoard' WHERE og.optionID = o.optionID AND og.groupID IN (1, 2) AND og.optionValue = 0) AND isInvisible = 0 AND isClosed = 0 AND ISNULL(( SELECT b.boardID FROM wbb1_board b LEFT JOIN wbb1_board b2 ON b2.boardID = b.parentID WHERE b.boardID = board.parentID AND ((b.isInvisible = 1 OR b2.isInvisible = 1) OR (b.isClosed = 1 OR b2.isClosed = 1))))