/bboard system

• User directory: /bboard/
• Admin directory: message deletion, etc., is handling by admin-*.html scripts within the user directory; heavy duty stuff such as creating a new bboard or adding a maintainer is done at /admin/bboard/
• data model : /doc/sql/bboard.sql
• adding searching to your bboards

• Q&A format, developed for the photo.net site and one of the most refined interfaces
• Editorial-commentary format, developed for cognet.mit.edu. This is suitable for when the publisher has longish thought-provoking editorials. Readers then submit commentary on this. A big advantage of this format is that the user interface isn't festooned with the words "question" and "answer".
• US-geospatial format, developed for scorecard.org. This allows messages to be tagged with a zip code, county, or state. So you can look at discussion nation-wide, in a region, or limited to a zip code.
• original threads interface. This is a lot like USENET and it doesn't scale very well as the discussion accumulates threads.

File upload

create sequence bboard_upload_id_sequence;

create table bboard_uploaded_files (
	bboard_upload_id	integer primary key,
	msg_id			not null references bboard,
	file_type		varchar(100),	-- e.g., "photo"
	file_extension		varchar(50), 	-- e.g., "jpg"
	-- can be useful when deciding whether to present all of something
	n_bytes			integer,
	-- generally the filename will be "*msg_id*-*upload_id*.extension"
	-- where the extension was the originally provided (so 
	-- that ns_guesstype will work)
	filename_stub		varchar(200) not null,
	-- fields that only make sense if this is an image
	caption			varchar(4000),
	-- will be null if the photo was small to begin with
	thumbnail_stub		varchar(200),
	original_width		integer,
	original_height		integer
);

Permissions Model

Goal: To allow per-group bboards, and to use the new ACS permissions system to control user and administrative access to the bboards.

Each bboard topic is now associated with an administrative group, created using ad_administration_group_add, with "bboard" as the module and the topic_id as the sub-module. Any users who have been added to the corresponding administration group by ad_administration_group_user_add will have administrative access to the topic. They can access the bboard/admin-xxx pages, and moderate discussions on the topic.

Public and Private Bboards

Read-access := any | public | group

 any    :=  topic may be viewed by any user of the system
 public :=  topic may only be view by a registered user of the system
 group  :=  topic may only be viewed by members of the topic's group(s)

Write-access :=  public | group

 public := any registered user may post a message or reply
 group  := only members of the topic's group(s) may post or reply to messages

 createlang pltcl mydb
 

    # do we use OpenACS search solution?
    # Change this to 1 to add searching in bboards.
    # You'll need PL/Tcl installed. See www/doc/bboard.html for more details.
    ns_param UseOpenACSSearch 0