I want add a new function

[Migrated From Jforum.net]

hi:
I want to add a new function that list the hotted Topics like recent topic s. Is Ok? Could you give any instruction ?
[originally posted on jforum.net by chopin]

[Migrated From Jforum.net]

Humm not a really simple question ...

I think you want to add this in UserAction.java

Try to to this :

in cvs\jforum\src\net\jforum\util\preferences\TemplateKeys.java add
public static final String USER_MYFUNCTION = "user.myfunction";

in cvs\jforum\WEB-INF\config\templatesMapping.properties add
user.myfunction = user_mynewfunction.htm

in cvs\jforum\WEB-INF\config\urlPattern.properties add
user.myfunction.0 = 
user.myfunction.1 = start

in cvs\jforum\templates\default\ create user_mynewfunction.htm

in cvs\jforum\src\net\jforum\view\forum\UserAction.java add
public void myfunction() throws Exception {
// Put your code here like this for e.g.
int start = this.preparePagination(DataAccessDriver.getInstance().newUserDAO().getTotalUsers());
int usersPerPage = SystemGlobals.getIntValue(ConfigKeys.USERS_PER_PAGE);
List users = DataAccessDriver.getInstance().newUserDAO().selectAll(start ,usersPerPage);
this.context.put("users", users);
this.context.put("pageTitle", I18n.getMessage("ForumBase.usersList"));
this.setTemplateName(TemplateKeys.USER_MYFUNCTION);
}

[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

Thank you very much.
I will try it.
If I have any question on the development, I will turn to you. Is oK?
[originally posted on jforum.net by chopin]

[Migrated From Jforum.net]

No pb man, but maybe I haven't all answers 8)
I'm just playing with JForum for few months and I'm not a "real"expert in java.
[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

I have successfully add the hot_topics_list function
[originally posted on jforum.net by chopin]

[Migrated From Jforum.net]

Glad to know that you have successfully add your function.
Maybe you could provide here some implementation to help others 8)
[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

I would really appreciate if someone had a working implementation of this "hottest topics"-function? That's exactly what I need.

:roll:
[originally posted on jforum.net by Akumite]

[Migrated From Jforum.net]

I just finished implementing hottest topics from recent topics.
1. add the SQL to WEB-INF/config/database/generic/generic_queries.sql below TopicModel.selectRecentTopicsByLimit

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.copy templates/default/recent_thread.htm to templates/default/hottest_thread.htm and change all "recent" to "hottest"

3.modify WEB-INF/config/urlPattern.properties (add them just below where you find a recentTopics-like)

rss.hottestTopics.0 = 

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

4.modify WEB-INF/config/templatesMapping.properties(add them just below where you find a recent-like)

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

5.modify WEB-INF/config/modulesMapping.properties(add it just below where you find a recentTopics-like)

hottestTopics = net.jforum.view.forum.HottestTopicsAction

6.copy src/net/jforum/view/forum/RecentTopicsAction.java to src/net/jforum/view/forum/HottestTopicsAction.java and replace all "recent" to "hottest", all "Recent" to "Hottest", all "RECENT" to "HOTTEST".

7. modifiy src/net/jforum/util/preferences/TemplateKeys.java(add them just below where you find a recent-like)

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

8. modify src/net/jforum/util/preferences/ConfigKeys.java(add it just below where you find a recent-like)

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

9. modify TopicRepository.java(add them just below where you find a recent-like)

	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. modify src/net/jforum/dao/TopicDAO.java(add them just below where you find a recent-like)

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

11. modify src/net/jforum/dao/generic/GenericTopicDAO.java(add them just below where you find a recent-like)

	/**
	 * @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. add topic.hottest to WEB-INF/config/SystemGlobals.properties and WEB-INF/config/jforum-custom.conf

topic.hottest = 50

13. add ForumBase.hottestTopics = Hottest Topics to WEB-INF/config/languages/en_US.properties and your locale language.

14. modify templates/default/header.htm add a link to hottestTopics (just copy the recentTopics one and modify it)

15. rebuild and restart Tomcat
I attached 3 files, the rest is simple for you to finish it. If you don't know how to complete them. Please visit my site.
http://www.andowson.com/posts/list/50.page
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

Great.

Please fill a Jira Task for that.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Will this be included in new versions of JForum?

If not, and these steps are completed, will the functionality still be available after upgrade to newer versions of JForum?
[originally posted on jforum.net by frankern]