Diese Seite (Version-1) wurde zuletzt am 29-Sept.-2018 19:56 von Administrator geändert.

Du bist nicht autorisiert, diese Seite umzubenennen.

Du bist nicht autorisiert, diese Seite zu löschen.

Versionsgeschichte der Seite

Version Zuletzt geändert Größe Autor Änderungen Kommentar

Links

Eingehende Links Ausgehende Links
Forum
Forum

Versionsunterschiede

Unterschiede zwischen Version und .

Zeile 1: 99 Zeilen hinzugefügt.
[{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=?
}}}
Diese Seite (Version-1) wurde zuletzt am 29-Sept.-2018 19:56 von Administrator geändert.Top