You have chosen to sponsor your bid up to a maximum amount of .
We're looking for a Ruby or PHP app that will accept the name or id of a message/discussion board on the following sites and download its content into a MySQL database:
3. any Simple Machines Forum
The basic structure of the DB will be (your comments and suggestions welcome):
Sites: id, name, front_page_url, other_metadata
Users: id, name, join_date. running_post_total, other_metadata, site_id
Topics: id, subject, date_opened, running_post_total, other_metadata, site_id
Messages: id, content, date_posted, other_metadata, user_id, parent_message_id, topic_id, site_id
Summary of relationships -
users:sites 1:1 (may turn out to be 1:many, for now assume 1:1),
messages:messages 1:many (replies),
May not need to store site_id everywhere given those relationships, but DB should allow for fast querying of topics per site, for instance.