I am developing a website using Joomla 1.0 that will use the Fireboard web forum component.
The website allows people to get their hands on resources by asking questions t a community of experts.
Similar websites have LISTSERVS where users can email-in questions to the List and receive send in/receive responses by email.
I want to simulate the ListServ functionality using Fireboard using an email pipe script that will insert data contained in emails to a MYSQL database, and also email the responses to a predetermined list of addresses.
EXACTS**********
- There will be a particular board/topic area within Fireboard where this script will function and new questions can be posted.
NEW QUESTION
- When a new question is posted as a new topic within the web forum, it will be marked as pending approval (see below)
- It should also be possible for people to send in new questions to the web forum by email. This is where the pipe comes in. the data/question contained in the body of the email should be sent to the database and flagged as a pending posting.
- People sening in questions should receive an email indicating that their new posting was received pending review
APPROVAL OF POSTING/TOPIC -- sending the question out
- When a posting is approved then the question should be sent out by email to participating members in the Joomla user database. There will be a field in the Comprofiler table that indicates whether or not a user wishes to receive these emails.
RECEIVED QUESTION -- RESPONSES
- When a user receives a question in their inbox they should be able to hit reply and answer it or write a response. This response should be piped to the forum database and set as a reply to the post. The response should also be sent out to participating members (like a ListServ).
- Also when a user responds to an active thread their response should also be sent out to participating members.
- When a posting is locked responses to it sent in by email should not be distributed or attached.
AUTHENTICATION
- Only members who are registered and participating in the program should be able to create new posting by email. This will require that the pipe script authenticate users according to their email address. Any suggestions appreciated.