[{ALLOW view All}]
[{ALLOW edit Markus}]
!!Forum / Bulletin Board
[Top java webapps|http://toppersworld.com/top-5-open-source-forum-software-written-in-java/]
![jforum|http://jforum.net/]
1. [Download|http://jforum.net/download.jsp]
2. Installation
see [Documentation|http://jforum.net/install.jsp]
If you choose MySQL you need to create the database in advance
{{{
create database <databasename> default character set 'UTF8';
}}}
and you need to update the database script at
* open <tomcat>/webapps/jforum/WEB-INF/config/database/mysql/__mysql_db_struct.sql__ with vi
* replace all occurences of 'TYPE=' and 'Type=' with 'ENGINE='
{{{
:%s/TYPE=/ENGINE=/
:%s/Type=/ENGINE=/
}}}
!Language
In the configuration you can choose a locale, but this refers only to text (java.properties).\\
If you chose anything else than en_US then you miss all images ! \\
You can find them in the source code zip under \templates\default\images !\\
You can copy all those to \images and may adjust those images with english text inside.\\
See [https://github.com/mrdon/jforum-plugins/tree/master/templates/default/images]
! Forum Icon (favicon.ico)
Insert in <head> of webContent/templates/default/header.htm
{{{
<link rel="icon" href="${contextPath}/images/anything.ico" />
<link rel="shortcut icon" href="${contextPath}/images/anything.ico" />
}}}
! Logo
Replace/Add logo.jpg in webContent/templates/default/images
! HTML
HTML tags can be used, but only those allowed in webContent/WEB-INF/config/SystemGlobals.properties
{{{
# Allowed HTML tags to be used when posting a message
html.tags.welcome = u, a, img, i, u, li, ul, font, br, p, b, hr
html.attributes.welcome = src, href, size, face, color, target, rel
}}}
You can add more here.
! Delete user
(see lang\jForum\CleanUp.xlsx)
Note: After deleting you need to restart the webapp (or web server)
jforum_users.deleted = 1 means locked ones
{{{
select user_id, user_active,username,user_email, deleted from jforum_users
where username not in ('Anonymous','Admin')
and deleted = 1
order by username, deleted;
select user_id from jforum_users
where username not in ('Anonymous','Admin')
and deleted = 1 order by user_id;
DELETE FROM jforum_attach where user_id in ( 1,2,3 )
DELETE FROM jforum_banlist where user_id in ( 1,2,3 )
DELETE FROM jforum_bookmarks where user_id in ( 1,2,3 )
DELETE FROM jforum_forums_watch where user_id in ( 1,2,3 )
DELETE FROM jforum_moderation_log where user_id in ( 1,2,3 )
DELETE FROM jforum_posts where user_id in ( 1,2,3 )
DELETE FROM jforum_topics where user_id in ( 1,2,3 )
DELETE FROM jforum_topics_watch where user_id in ( 1,2,3 )
DELETE FROM jforum_user_groups where user_id in ( 1,2,3 )
DELETE FROM jforum_users where user_id in ( 1,2,3 )
}}}
{{{
UPDATE jforum_posts SET user_id=$KILLED_ID WHERE user_id=?
UPDATE jforum_topics SET user_id=$KILLED_ID WHERE user_id=?
UPDATE jforum_attach SET user_id=$KILLED_ID WHERE user_id=?
UPDATE jforum_search_topics SET user_id=$KILLED_ID WHERE user_id=?
UPDATE jforum_vote_voters SET vote_user_id=$KILLED_ID WHERE vote_user_id=?
UPDATE jforum_privmsgs SET privmsgs_from_userid=$KILLED_ID WHERE privmsgs_from_userid=?
DELETE FROM jforum_user_groups WHERE user_id=?
DELETE FROM jforum_topics_watch WHERE user_id=?
DELETE FROM jforum_forums_watch WHERE user_id=?
DELETE FROM jforum_banlist WHERE user_id=?
DELETE FROM jforum_bookmarks WHERE user_id=?
DELETE FROM jforum_sessions WHERE session_user_id=?
DELETE FROM jforum_privmsgs WHERE privmsgs_to_userid=?
}}}