Search options

First of... I'm not skilled with MySQL although I know enough to be able to guess from time to time. Perhaps I'm guessing wrong this time but we'll see.

I created a test user who is a regular member (primary group, gid 4) and let him join another user group (Spelledare, gid 8). When going to the forum Spelledare (only members with gid 8 has access to it) the following query is executed...

SELECT f.forum_name, f.redirect_url, f.moderators, f.num_topics, f.sort_by, fp.post_topics
FROM mb_forums AS f
LEFT JOIN mb_forum_perms AS fp ON ( fp.forum_id=f.id AND fp.group_id=4 )
LEFT JOIN mb_forum_perms AS fp1 ON ( fp1.forum_id=f.id AND fp1.group_id=8 )
WHERE (
    (
        fp.read_forum IS NULL OR fp.read_forum=1
    ) OR (
        fp1.read_forum IS NULL OR fp1.read_forum=1
    )
)
AND f.id=15

When used with phpmyadmin i get the following output...

forum_name    redirect_url    moderators    num_topics    sort_by    post_topics
Spelledare    NULL            NULL          14            0          0

No permissions to post topics! However, if I manually change fp.group_id to 8 and fp1.group_id to 4 I get post_topic=1. Does this mean that if fp matches the database it never checks fp1, fp2, fp3, etc? If so - how do you make it continue?