1. Download 2. Installation
see Documentation
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
:%s/TYPE=/ENGINE=/ :%s/Type=/ENGINE=/
See https://github.com/mrdon/jforum-plugins/tree/master/templates/default/images
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" />
Replace/Add logo.jpg in webContent/templates/default/images
# 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, relYou can add more here.
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=?