Tigga, it honestly depends on how many forums you don't want to show. For example, on my board, I only have a few private forums that nobody should see. So, it might be more efficient for me to hard code those in instead of basing them on forumpermissions. Then, my query would say:
WHERE open<>10 $iforumperms and forumid not in (1,3,4)
That might help speed things up a bit. However, if you have a ton of forums that are only visible to select users, you might be stuck with the slower query.
Typically, I would simply exclude forums that guests shouldn't see and be happy with that and not worry that the latest private threads don't show up in the list.
Amy
|