Need somebody to create a PHP/mySQL site that is a comprehensive database of musical bands. Needs to include pages that are easily editable/created by any registered user. With that, also needs a way to revert back to previous 'page edits' incase of accidental deletion. Also needs to include an admin section, where specific permissions can be set to individual pages.
Have the ability to create/edit band pages to include biography, discography, band picture(could be pulled form gallery), record label(s), current members, former members, hometown, years active (IE 2000 - present or 1999 - 2005) website link, & myspace link.
List of all releases by band
Cover image, record label that released, and tracklisting of album. Also, the ability to upload pressing information of different vinyl pressings of said record. An image gallery to display images of record (Different vinyl colors/alternate album covers)
Simple image gallery that would allow people to browse/upload photos of band merchandise (IE: T-shirts, sweatshirts, shorts etc.)
Same as merchandise, but should include only photos of bands.
Record Label profile-
Similar to bands, but only needs to include biography, logo image, website & myspace link, and discography. The discography should show a list of records released by that label.
Allow users to create a list of their 'Haves' and 'Wants' to display all vinyl/other merchandise that is owned. Lists should be text only. If possible, have the distinction to search only 'haves', 'wants' or both.
The ability to post news articles. Should be able to create categories, and use a small php code to choose which page displays which category.
Allow users to upload flyers and information on upcoming concerts.
Past Flyer gallery-
Image gallery that would allow users to upload flyers from past shows.
Users need to be able to register to add/edit bands/record labels, and create tradelists. Users should be assigned permissions by admins (IE: Admins, Moderators, User) Users should also be able to be banned by admins.
The ability to moderate users, post new articles etc.
As far as site design goes, I am more worried about just having a templating system in place. I have sufficient background in HTML/CSS design to create/edit the actual templates themselves. Something similar to wordpress would be ideal.
The site needs to be able to "save states" like Wikipedia does, to be able to revert back to a former state in case of spamming, graffitti, or information being deleted by someone. I do have some experience with PHP/SQL, building simple CMS's, photo galleries and user systems, as well as modifiying existing scripts to suit my needs. For this project though, I don't have a firm enough grasp on the relationship between PHP and SQL to do it myself. I am not opposed to using preexisting software that has been modified to suit these needs, provided it can be used without a copyright notice. One thing that is a must is ease of editing by the users. I find MediaWiki very hard to add information, as the user needs to format everything themselves. Something simple, using forms or something I guess. I just want to use a template (IE Band Profile), and have the SQL tables fill the information in. Everything in the site should be searchable, and cross reference itself between Band Profile/Record Label/Image Galleries/Upcoming Shows etc.