jforum trydone 支配到oracle 修改内容记录

jforum trydone 部署到oracle 修改内容记录

jforumT部署到oracle需要做如下修改

1、trydone_src/com/trydone/forum/action/AttachmentAction.java

97行加JForumExecutionContext.enableCustomContent(true);

2、WebRoot/templates/default/search.htm

2行的get改为post

3、WebRoot/templates/trydone/js/attachments.js

70行的attach_${a.id}["description"] = "${a.info.comment}";修改为以下

<#if a.info.comment?exists>
   attach_${a.id}["description"] = "${a.info.comment}";
   <#else>
   attach_${a.id}["description"] = "";
   </#if>\

4、WebRoot/WEB-INF/config/SystemGlobals.properties

database.driver.name = oracle

default.container.encoding = UTF-8

5、WebRoot/WEB-INF/config/database/oracle/oracle.properties

修改数据库相关参数

6、WebRoot/WEB-INF/config/database/oracle/oracle.sql

(1)24行

UserModel.addNew = INSERT INTO jforum_users (user_id, username, user_password, user_email, user_regdate, user_actkey, rank_id) VALUES (jforum_users_seq.nextval, ?, ?, ?, ?, ?, 0)

修改为

UserModel.addNew = INSERT INTO jforum_users (user_id, username, user_password, user_email, user_regdate, user_actkey, rank_id,user_qq,user_sex,user_birthday) VALUES (jforum_users_seq.nextval, ?, ?, ?, ?, ?, 0,?,?,?)

(2)57行

SELECT p.topic_id, p.topic_id, p.post_id, p.forum_id, pt.post_subject AS subject, pt.post_text, p.post_time, p.user_id, u.username,u.user_qq,u.user_sex,u.user_birthday ,

修改改为

SELECT p.topic_id, p.post_id, p.forum_id, pt.post_subject AS subject, pt.post_text, p.post_time, p.user_id, u.username,u.user_qq,u.user_sex,u.user_birthday ,\

(3)72行

ROW_NUMBER() OVER(ORDER BY topic_first_post_id DESC) \

修改为

ROW_NUMBER() OVER(ORDER BY topic_first_post_id DESC) LINENUM \

-------------------------以下是后面再发现的

(4)9行加一个参数

CategoryModel.addNew = INSERT INTO jforum_categories (categories_id, title, display_order, moderated, parent_id) VALUES (jforum_categories_seq.nextval, ?, ?, ?,?)

generic_queries.sql文件

671行加 ,c.parent_id

JForum默认匿名用户是可以发帖的，要限制这个操作首先建立一个匿名用户组，然后给这个用户组指派权限不允许所有的论坛发帖，然后将JForum自动创建的匿名用户放到这个组中即可。

jforum trydone 支配到oracle 修改内容记录

相关推荐