Inetone: Forum

Forum / Bulletin Board#

jforum #

1. Download 2. Installation

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=?