Developing a "Question of the Week" module?

Hi there!

I'm looking for some development and/or implementation help.

Question of the Week is a section of our site featuring questions that have been posed by an authenticated moderator to the unauthenticated site visitors. We currently do this by hand from emailed-in responses, and would like to at least partially automate the process.

The question is in the form of a sentence or two, and is typically open for responses for a week, after which time the question is closed and answers are published.

The answer is in the form of a couple of sentences or short essay. A few demographic fields should also be collected, with the moderator being able to select each field as private/public and required/optional, along with submitter's IP address.

Answers are queued for moderation before display. States for each answer are unapproved, approved, denied (abuse/spam/irrelevance). Visitors are unable to see other visitors' answers until the question has been closed and the approved answers have been published.

Publishing creates HTML body with the question and then the approved answers, each with that answer's public demographic information. Unapproved and denied answers do not get published. The HTML body is then either manually pasted into a QotW book page, or it creates a new page in the QotW book. Or some other better solution that has yet to be proposed.

There are two routes we are willing to take if nobody wants to write a module for this. We would prefer to keep the process entirely within our Drupal 6 site using appropriate module(s) and/or php. The other route is a standalone php5/mysql5 app that produces the paste-into-drupal content as described above.

What do you folks think?