安道生網站技術練功房 - 分享經驗，累積智慧

JForum 2.1.7還沒提供熱門主題這個功能，但有一個功能類似的最新主題，我試著仿照最新主題的邏輯實作了熱門主題這個功能，以下是主要的修改步驟：
1. 在WEB-INF/config/database/generic/generic_queries.sql的TopicModel.selectRecentTopicsByLimit下新增一個SQL指令

TopicModel.selectHottestTopicsByLimit = SELECT t.*, p.user_id AS last_user_id, p.post_time, 0 AS attach \
	FROM jforum_topics t, jforum_posts p \
	WHERE p.post_id = t.topic_last_post_id \
	AND p.need_moderate = 0 \
	ORDER BY topic_views DESC \
	LIMIT ?

這裡我是以主題的點閱次數來當作熱門排序的基礎。你可以先執行看看是否可以執行成功。

2.將templates/default/recent_thread.htm複製為templates/default/hottest_thread.htm並且將所有的 "recent" 字串替換為 "hottest"。

3.修改WEB-INF/config/urlPattern.properties (將它們加在含有recentTopics字串的設定底下)

rss.hottestTopics.0 = 

# Hottest Topics
hottestTopics.list.0 =
hottestTopics.showTopicsByUser.1 = user_id
hottestTopics.showTopicsByUser.2 = start, user_id

4.修改WEB-INF/config/templatesMapping.properties(將它們加在含有recent字串的設定底下)

hottest.list = hottest_thread.htm
hottest.usertopics.show = user_topics_show.htm

5.修改WEB-INF/config/modulesMapping.properties(將它們加在含有recentTopics字串的設定底下)

hottestTopics = net.jforum.view.forum.HottestTopicsAction

6.複製src/net/jforum/view/forum/RecentTopicsAction.java為src/net/jforum/view/forum/HottestTopicsAction.java, 並將所有的 "recent" 替換為 "hottest", 所有的 "Recent" 替換為 "Hottest", 所有的 "RECENT" 替換為 "HOTTEST"。

7.修改src/net/jforum/util/preferences/TemplateKeys.java(將它們加在含有recent字串的宣告底下)

	public static final String HOTTEST_LIST = "hottest.list";
	public static final String HOTTEST_USER_TOPICS_SHOW = "hottest.usertopics.show";

8.修改src/net/jforum/util/preferences/ConfigKeys.java(將它們加在含有recent字串的宣告底下)

	public static final String HOTTEST_TOPICS = "topic.hottest";

9.修改TopicRepository.java(將它們加在含有recent字串的方法底下)

	private static final String HOTTEST = "hottest";

	/**
	 * Get all cached hottest topics. 
	 * 
	 */	
	public static List getHottestTopics()
	{
		List l = (List)cache.get(FQN, HOTTEST);
		
		if (l == null || l.size() == 0
			|| !SystemGlobals.getBoolValue(ConfigKeys.TOPIC_CACHE_ENABLED)) {
			l = loadHottestTopics();
		}
		
		return new ArrayList(l);
	}

	/**
	 * Add hottest topics to the cache
	 */
	public static List loadHottestTopics()
	{
		TopicDAO tm = DataAccessDriver.getInstance().newTopicDAO();
		int limit = SystemGlobals.getIntValue(ConfigKeys.HOTTEST_TOPICS);
		
		List l = tm.selectHottestTopics(limit);
		cache.add(FQN, HOTTEST, new LinkedList(l));
		
		return l;
	}

10.修改src/net/jforum/dao/TopicDAO.java(將它們加在含有recent字串的方法宣告底下)

	/**
	 * Selects hottest topics 
	 *
	 * @param limit The number of topics to retrieve
     * @return List
	 */
	public List selectHottestTopics (int limit) ;

11.修改src/net/jforum/dao/generic/GenericTopicDAO.java(將它們加在含有recent字串的方法底下)

	/**
	 * @see net.jforum.dao.TopicDAO#selectHottestTopics(int)
	 */
	public List selectHottestTopics(int limit)
	{
		PreparedStatement p = null;
		try {
			p = JForumExecutionContext.getConnection().prepareStatement(
					SystemGlobals.getSql("TopicModel.selectHottestTopicsByLimit"));
			p.setInt(1, limit);

			List list = this.fillTopicsData(p);
			p = null;
			return list;
		}
		catch (SQLException e) {
			throw new DatabaseException(e);
		}
		finally {
			DbUtils.close(p);
		}
	}

12.修改src/net/jforum/view/forum/common/TopicsCommon.java的deleteTopic()方法(將它們加在TopicRepository.loadMostRecentTopics();的陳述底下)

    // Updates the Hottest Topics if it contains this topic
    TopicRepository.loadHottestTopics();

13.修改src/net/jforum/view/forum/PostAction.java的delete()方法(將它們加在TopicRepository.loadMostRecentTopics();的陳述底下)

		TopicRepository.loadHottestTopics();

14.修改src/net/jforum/view/forum/ModerationHelper.java的removeTopics()方法及moveTopicsSave()方法(將它們加在TopicRepository.loadMostRecentTopics();的陳述底下)

		TopicRepository.loadHottestTopics();

15.新增topic.hottest參數到WEB-INF/config/SystemGlobals.properties及WEB-INF/config/jforum-custom.conf

topic.hottest = 50

16.新增ForumBase.hottestTopics到WEB-INF/config/languages/en_US.properties及您的本地語系, 如zh_TW.properties

ForumBase.hottestTopics = Hottest Topics

ForumBase.hottestTopics = 熱門主題

17.修改templates/default/header.htm, 新增一個熱門主題的超連結(可以由最新主題複製然後再修改)

18.用ant重新編譯

19.重新啟動Tomcat或用manager重新載入JForum

另外幾個檔案