diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-17 23:53:04 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-17 23:53:04 +0000 |
| commit | 2ec0206283d9a7112657829ddc8e9faa3011b35a (patch) | |
| tree | 1fa35a636d15b3b522467d8a7af76a8bd3375f1d /phpBB/viewforum.php | |
| parent | 04b0b11e9766c72bc32762be3a8728b3bccfcdd5 (diff) | |
| download | forums-2ec0206283d9a7112657829ddc8e9faa3011b35a.tar forums-2ec0206283d9a7112657829ddc8e9faa3011b35a.tar.gz forums-2ec0206283d9a7112657829ddc8e9faa3011b35a.tar.bz2 forums-2ec0206283d9a7112657829ddc8e9faa3011b35a.tar.xz forums-2ec0206283d9a7112657829ddc8e9faa3011b35a.zip | |
Switched forum_auth to the forums table
git-svn-id: file:///svn/phpbb/trunk@506 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/viewforum.php')
| -rw-r--r-- | phpBB/viewforum.php | 14 |
1 files changed, 2 insertions, 12 deletions
diff --git a/phpBB/viewforum.php b/phpBB/viewforum.php index 7986d4abf2..7f92827a42 100644 --- a/phpBB/viewforum.php +++ b/phpBB/viewforum.php @@ -56,21 +56,11 @@ init_userprefs($userdata); // if(isset($forum_id)) { -/* $sql = "SELECT f.forum_name, f.forum_topics, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_votecreate, f.auth_vote, u.username, u.user_id FROM ".FORUMS_TABLE." f, ".USERS_TABLE." u, ".USER_GROUP_TABLE." ug, ".AUTH_ACCESS_TABLE." aa - WHERE f.forum_id = $forum_id - AND aa.auth_mod = 1 - AND aa.forum_id = f.forum_id - AND ug.group_id = aa.group_id - AND u.user_id = ug.user_id"; -*/ - $sql = "SELECT f.forum_name, f.forum_topics, u.username, u.user_id, fa.* - FROM ".FORUMS_TABLE." f, ".USERS_TABLE." u, ".USER_GROUP_TABLE." ug, ".AUTH_ACCESS_TABLE." aa, ".AUTH_FORUMS_TABLE." fa - WHERE f.forum_id = $forum_id - AND fa.forum_id = f.forum_id + WHERE f.forum_id = $forum_id AND aa.auth_mod = 1 - AND aa.forum_id = f.forum_id + AND ( aa.forum_id = f.forum_id OR aa.forum_id = 0 ) AND ug.group_id = aa.group_id AND u.user_id = ug.user_id"; } |