Tags:
discussion2Add my vote for this tag create new tag
, view all tags

Message Board Plugin

This is a database based message board plugin for the TWiki system. Users can post and read messages from a database as if it was a message board fixed on the wall.

Syntax Rules

Use the TWiki Tag %MESSAGE_BOARD% with options:

Option Name Value Range Description
displayOnly '0' or '1' When set to 1 causes Message Board to just display messages, not allowing users to post new messages. When set to 0 will display posted messages and allow users to post new messages. Defaults to 0.
messageOrder 'ASC', 'DESC' Chooses the order of messages, ASC meaning newer messages showing first, DESC meaning older messages showing first. Defaults to ASC.

MessageBoardPlugin Screen Shots

  • This is the look'n'feel of the MessageBoard posted messages. Please don't take this too seriously: it's pretty customized (I've translated about all texts and messages so folks at my company could read it).

MessageBoardPluginScreenShot01.jpg

  • And this is the message posting form (displayed under the posted messages). Again, don't take this too seriously, its almost completelly translated to portuguese (and the plugin original is english).

MessageBoardPluginScreenShot02.png

MessageBoardPlugin Global Settings

  • One line description, shown in the TextFormattingRules topic:
    • Set SHORTDESCRIPTION = Database-Based message board plugin.

  • Color Settings
    • Set TABLE_HEAD_COLOR = #E3E9A5
    • Set REVERSE_LINE_COLOR = #CCCCCC

  • Icons and Image Settings
    • Set TRASH_CAN_ICON_LINK = Remove
    • Set PENCIL_ICON_LINK = Edit

  • Database Settings
    • Set DB_DRIVER = mysql
    • Set DB_SERVER = ip_address or hostname here
    • Set DB_SERVER_PORT = 3306
    • Set DB_DATABASE = message_board
    • Set DB_TABLE = message
    • Set DB_USER = board
    • Set DB_PASSWORD = password

  • Plugin Messages (so you can internationalize them):
  • Error opening connection to the database
    • Set MSG_DB_CONNECT_ERROR = ALERT! Error connecting to the database
  • Error closing connection to the database
    • Set MSG_DB_CLOSE_ERROR = ALERT! Error closing the database connection
  • Error during query preparation
    • Set MSG_DB_PREPARE_ERROR = ALERT! Error preparing query
  • Error during data fetch
    • Set MSG_DB_FETCH_ERROR = ALERT! Error fetching data from database
  • Error during query execution
    • Set MSG_DB_EXECUTE_ERROR = ALERT! Error executing query
  • No data found error
    • Set MSG_DB_NO_DATA_ERROR = ALERT! No data found
  • Update error message
    • Set MSG_DB_UPDATE_ERROR = ALERT! Error updating data
  • Insert error message
    • Set MSG_DB_INSERT_ERROR = ALERT! Error inserting data

  • Debug plugin: (See output in data/debug.txt)
    • Set DEBUG = 0

Plugin Installation Instructions

Note: You do not need to install anything on the browser to use this plugin. The following instructions are for the administrator who installs the plugin on the server where TWiki is running.

  • Download the ZIP file from the Plugin web (see below)
  • Unzip MessageBoardPlugin.zip in your twiki installation directory. Content:
    File: Description:
    data/TWiki/MessageBoardPlugin.txt Plugin topic
    data/TWiki/MessageBoardPlugin.txt,v Plugin topic repository
    lib/TWiki/Plugins/MessageBoardPlugin.pm Plugin Perl module
    pub/TWiki/MessageBoardPlugin/trashcan.png Trash Can Icon
    pub/TWiki/MessageBoardPlugin/editicon.png Pencil and Paper Icon
  • Create a table into your database using (this is mysql SQL, the only DB supported at the moment)
    CREATE DATABASE message_board;

    CREATE TABLE message(
      id INT PRIMARY KEY AUTO_INCREMENT,
      author VARCHAR(50) NOT NULL,
      due DATETIME NOT NULL,
      posted DATETIME NOT NULL,
      msg TEXT NOT NULL,
      dropped ENUM( 'Y', 'N' ) NOT NULL DEFAULT 'N'
    )
  • Create a new user and give it appropriated permissions:
      GRANT SELECT, INSERT, UPDATE, DELETE
        ON messsage_board.message
        TO board IDENTIFIED BY 'b0aRd'
  • Test if the plugin is correctly installed:
    • Open a MessageBoardTestArea and insert %MESSAGE_BOARD{ messageOrder="DESC" }% into the topic. Preview, save and try to post a message.

Plugin Info

Plugin Author: TWiki:LuisCamposDeCarvalho
Plugin Version: 15/06/2004 (V1.000)
Change History:  
15 Jun 2004: Initial version
CPAN Dependencies: DBI CGI
Other Dependencies: none
Perl Version: 5.6.1
Plugin Home: http://TWiki.org/cgi-bin/view/Plugins/MessageBoardPlugin
Feedback: http://TWiki.org/cgi-bin/view/Plugins/MessageBoardPluginDev

Related Topics: TWikiPreferences, TWikiPlugins, DefaultPlugin

-- TWiki:LuisCamposDeCarvalho - 17 Jun 2004

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatmd5 MessageBoardPlugin.md5 r2 r1 manage 0.2 K 2008-12-12 - 11:45 SopanShewale checksum file , Uploaded as a part of Release Process
Compressed Zip archivetgz MessageBoardPlugin.tgz r2 r1 manage 10.8 K 2008-12-12 - 11:45 SopanShewale See MessageBoardPlugin for details. Untar and run the installer script, Uploaded as a part of Release Process
Compressed Zip archivezip MessageBoardPlugin.zip r3 r2 r1 manage 12.7 K 2008-12-12 - 11:45 SopanShewale See MessageBoardPlugin for details. Unzip and run the installer script , Uploaded as a part of Release Process
Unknown file formatEXT MessageBoardPlugin_installer r2 r1 manage 3.5 K 2008-12-12 - 11:45 SopanShewale Installer Script, Uploaded as a part of Release Process
Edit | Attach | Watch | Print version | History: r9 < r8 < r7 < r6 < r5 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r9 - 2012-12-03 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.