I need a new site developed for demu.org. It's basically going to re-produce what is currently there and add/refine a few features. The website is a file repository focusing on DOS and early Windows software. The site will go from your development to production immediately so while I'm not looking for any fancy web development or graphics, it will need to be polished enough to be a final product. I would love for it to be very clean and look/feel retro (mid 90's?).
## Deliverables
Guest Interface
--- Main Page
- A box with a randomly selected featured resource
- Drop down lists of the first and second tier categories
- Area for links to custom pages (Contact Us, Contribute, DVD, etc.)
- A "Recent" page which will display the last ~48 resources added to the site and a RSS feed for the new files
- Area which will display the last ~2 news postings with a ability to view older archived news and a RSS feed for the news.
- A "Top Downloads" page. The system should generate this list daily and base it off the most downloads within the last 7 days.
--- Listings Page
- Ability to view pages in selected category as either a simple list, detailed list, or thumbnails
- Ability to order pages in selected category by title, popularity (algorithm needed to determine popularity), rating, or random
--- File "Resource" Page
- Display screenshot if available
- Display link to download the file
- Display # of times file has been download (which software will count and update)
- Display Meta Data -- Publisher, Developer, Year Released, Version, License, Original Filename, Keywords, Named Persons, First/Second Category, Caption, and GOG/Amazon affiliate links.
- Allow visitor to rate the file 1-5 stars, and will display the current average rating for the file
- Allow visitor to post a comment regarding the file and that comment will then go into a que to be approved by Admin
Admin Interface
- Ability to create first tier and second tier categories (DOS Games: Action)
- Ability to make a second tier hidden (e.g., DOS Games: Adult) so that it will not appear in category lists BUT will be searchable if there is a keyword hit
- Ability to upload files, a screenshot (server automatically resizes, compresses image if needed), and enter in all of the meta data for a record (Publisher, developer, year, etc.)
- Ability to add/delete/modify Meta Data fields "on the fly" (e.g., add an "Engine" field)
- Ability to modify, delete resource records once they are on the server
- Ability to approve/reject comments
- Ability to post news (text with an optional image)
Importation of previous Database
- I will have a csv file of ~4,000 records which will