**Updated [read this section last]**
This database is open to the
public. No access should be restrictred
to anyone, however it would be useful to
allow users to create seperate accounts to
I would prefer an SQL database.
We will still need to create the website this will be based upon.
Volume of articles expected = about 100-200/week. >
What I need is a system not so different to PlanetSourceCode.com. Before I begin, I am totally open to comments as I have little experience with this kind of web development, so feel free to give advice.
Anyone should be able to upload files to the database. It should accept the html and pure text files, they should not be zipped/archived.
Once the files are submitted, they should automatically be added to the database. File uploads should not exceed 700kb in size, and should have a maximum upload of 2MB each day/24 hours.
When they do submit a file, it should give them the option of submitting a file directly (uploading), or giving the URL of another file on the internet.
If they give a URL instead of uploading, then they should not be limited to the file types above. Also, the files should not be added immediately if this is the case, but the URL should be sent to an email address and then left at that.
There must be a way for everyone to search the database using keywords. Results should be displayed like a general search engine.
Should have an administration like area which requires a password, where files and user comments can be deleting and/or modyfied.
Lastly, users should be able to post comments relating to each file. When users post it should have fields for name, subject, and body. When each post is displayed it should have a 'Report Post' button or similar message, which alerts the admin either from the admin section or via email. These comments should be shown at the end of each article.
Once again, if something is unclear or something has been left out - please comment and I will rephrase it.
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
Recent versions of Netscape/Internet Explorer
## Deadline information
Project requires *us* to be able to make basic changes to the web interface without effecting the code. We do have some experience :)