I need a song requesting script. Here how it works.
Song Request Process
User enters artist and song title (Membership required).
The member is already in the member area.
This information is entered into a database.
Request Table
User ID (taken from environment) & Song ID
Song Table
Song ID, Artist ID & Song Tile
Artist Table
Artists ID, Artists Name
Create new artist of not in the artist table.
Create new song if not in the song table.
I’ll need a browser for the users to see song requests by alphabetical artist or alphabetical song title.
I need another option to upload a file to fill the request. The file name would be [login to view URL], [login to view URL] etc as multiple copies come in to satisfy the quest.
File Table
FileID, User ID (of Uploader), SongID, date
The File browsers can download any submitted file and rate it.
Rating Table
User ID, FileID & Rating
I want to display the requested songs for a given artist by name or ID with the option for users to also request a song or download/rate uploaded songs.