diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-03-02 06:32:50 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-03-02 06:32:50 +0000 |
| commit | f51b6b934590a72f3de02ef0b48a3ab565bb2b1c (patch) | |
| tree | 38d8f40d790f5bfdcc80f74c23729901c9bdbec5 | |
| parent | dcc2b2fe194163d455360fbb8726fe80b6c03378 (diff) | |
| download | forums-f51b6b934590a72f3de02ef0b48a3ab565bb2b1c.tar forums-f51b6b934590a72f3de02ef0b48a3ab565bb2b1c.tar.gz forums-f51b6b934590a72f3de02ef0b48a3ab565bb2b1c.tar.bz2 forums-f51b6b934590a72f3de02ef0b48a3ab565bb2b1c.tar.xz forums-f51b6b934590a72f3de02ef0b48a3ab565bb2b1c.zip | |
Viewforum gets moderator list now
git-svn-id: file:///svn/phpbb/trunk@74 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/viewforum.php | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/phpBB/viewforum.php b/phpBB/viewforum.php index 90b092df67..8e425dfb78 100644 --- a/phpBB/viewforum.php +++ b/phpBB/viewforum.php @@ -27,9 +27,9 @@ include('common.'.$phpEx); // If not give them a nice error page. if(isset($forum_id)) { - $sql = "SELECT f.forum_type, f.forum_name - FROM ".FORUMS_TABLE." f - WHERE forum_id = '$forum_id'"; + $sql = "SELECT f.forum_type, f.forum_name, u.username, u.user_id + FROM ".FORUMS_TABLE." f, ".FORUM_MODS_TABLE." fm, ".USERS_TABLE." u + WHERE f.forum_id = '$forum_id' AND fm.forum_id = '$forum_id' AND u.user_id = fm.user_id"; } else { @@ -54,7 +54,12 @@ if(!$forum_row) } $forum_name = stripslashes($forum_row[0]["forum_name"]); -$forum_moderators = "<a href=\"profile.$phpEx?mode=viewprofile&user_id=1\">james</a>"; +for($x = 0; $x < $db->sql_numrows($result); $x++) +{ + if($x > 0) + $forum_moderators .= ", "; + $forum_moderators .= "<a href=\"profile.$phpEx?mode=viewprofile&user_id=".$forum_row[$x]["user_id"]."\">".$forum_row[$x]["username"]."</a>"; +} $pagetype = "viewforum"; $page_title = "View Forum - $forum_name"; |