how to get a forum's moderator?

[Migrated From Jforum.net]

We want to display the moderator name right after each forum's name, but fail to find how.

Our current version is 2.1.4.

Please help!

Gary
[e-mail]
[originally posted on jforum.net by aeolus727]

[Migrated From Jforum.net]

I've done this before for 2.1.5 version for PostgreSQL 7.4
Just follow the steps:
1. Modify WEB-INF/config/database/genericgeneric_queries.sql, add the following query to the ForumModel section.

ForumModel.getModeratorList = SELECT DISTINCT u.user_id, u.username, rv.role_value \
        FROM jforum_roles r, jforum_role_values rv, jforum_users u, jforum_user_groups ug, jforum_users u2, jforum_roles r2 \
        WHERE r.role_id = rv.role_id \
        AND r.name = 'perm_moderation_forums' \
        AND rv.role_type = 1 \
        AND rv.role_value = ? \
        AND r.group_id = ug.group_id \
        AND ug.user_id = u.user_id \
        AND u.user_id = u2.user_id \
        AND r2.name = 'perm_moderation' \
        AND r2.role_type = 1 \
        AND r2.group_id = ug.group_id \
   UNION ( SELECT u.user_id, username, rv.role_value \
        FROM jforum_roles r, jforum_role_values rv, jforum_users u \
        WHERE r.role_id = rv.role_id \
        AND name = 'perm_moderation_forums' \
        AND rv.role_type = 1 \
        AND rv.role_value = ? \
        AND r.user_id = u.user_id )

2. Modify src/net/jforum/repository/ForumRepository.java, and add two methods for getModeratorList()

        /**
         * Gets information about the moderators of some forum.
         * @param forum The forum to retrieve information
         * @return
         */
        public static List getModeratorList(Forum forum) throws Exception
        {
                List l = forum.getModeratorList();

                if (l == null) {
                        l = DataAccessDriver.getInstance().newForumDAO().getModeratorList(forum.getId());
                        forum.setModeratorList(l);
                }

                return l;
        }

        /**
         * Gets information about the moderators of some forum.
         *
         * @param forumId The forum's id to retrieve information
         * @return
         * @throws Exception
         */
        public static List getModeratorList(int forumId) throws Exception
        {
                return getModeratorList(getForum(forumId));
        }

Modify reloadForum() to handle the cache

                        f.setModeratorList(ForumRepository.getModeratorList(f));
                        c.reloadForum(f);

3. Modify src/net/jforum/entities/Forum.java

...
import java.util.List;

...
public class Forum implements Serializable
{
...
        private List moderatorList;

        public Forum(Forum f)
        {
                ...
                this.moderatorList = f.getModeratorList();
        }
...
        public void setModeratorList(List moderatorList) {
                this.moderatorList = moderatorList;
        }

        public List getModeratorList() {
                return this.moderatorList;
        }
...

4. Modify src/net/jforum/dao/ForumDAO.java, add the following declaration

        public List getModeratorList(int forumId) throws Exception;

5. Modify src/net/jforum/dao/generic/GenericForumDAO.java, add an implementation of getModeratorList()

        /**
         * @see net.jforum.dao.ForumDAO#getModeratorList(int)
         */
        public List getModeratorList(int forumId) throws Exception
        {
                List l = new ArrayList();

                PreparedStatement p = JForum.getConnection().prepareStatement(SystemGlobals.getSql("ForumModel.getModeratorList"));
                p.setInt(1, forumId);
                p.setInt(2, forumId);

                ResultSet rs = p.executeQuery();
                while (rs.next()) {
                        User m = new User();
                        m.setUsername(rs.getString("username"));
                        m.setId(rs.getInt("user_id"));

                        l.add(m);
                }

                p.close();
                rs.close();

                return l;
        }

6. Modify templates/default/forum_list.htm, find this

<td class="row1"  >
   <span class="forumlink"><a class="forumlink" /forums/show/${forum.id}")}" rel="nofollow">${forum.name}</a></span><br />
   <span class="genmed">${forum.description}<br />
   </span><br />
</td>

modify it to look like the following:

<td class="row1"  >
   <span class="forumlink"><a class="forumlink" /forums/show/${forum.id}")}" rel="nofollow">${forum.name}</a></span><br />
   <span class="genmed">${forum.description}<br />
   ${I18n.getMessage("ForumIndex.moderators")}
   <#list fir.getModeratorList(forum.id) as moderator>
   <a /user/profile/${moderator.id}")}" rel="nofollow"><span>${moderator.username}</span></a> 
   </#list>
   </span><br />
</td>

7. Modify templates/default/forum_show.htm, find this

<span class="gensmall"><!-- forum moderators --></span>

modify it to look like the following:

<span class="gensmall"><!-- forum moderators --><b>${I18n.getMessage("ForumIndex.moderators")}:
  <#list forum.getModeratorList() as moderator>
  <a /user/profile/${moderator.id}")}" rel="nofollow"><span>${moderator.username}</span></a> 
  </#list></b></span>

That's all, enjoy it.
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

thank, solved it.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

The checked in fixes killed my 2.15 copy refer to bugs forum for details

[originally posted on jforum.net by mqjoe1]