I already awarded this project to somebody else, but they were in an accident and will be in the hospital for at least two months. I need this project completed much sooner than that.
This project is for a Reality TV Stock Exchange. (http://www.rtvse.com)
The concept is simple, members can buy and sell shares of contestants that are currently on Reality TV shows. As contestants are voted off of the show, the admin stops trading for their shares, and anyone who has shares of a losing contestant get exactly $0.00 fake dollars for their account.
Members can only buy and sell shares. There are no complex stock tricks here. (No margins, no shorting, nothing but buy and sell)
Notes:
- The database is already complete.
- There are no graphics required for this project. I just need to see the system working. I will hire a graphic designer to do a template.
- Use SmartyTemplates if possible, the last programmer already got started with it.
- Since the last programmer was way behind schedule before the accident, I would like to see progress very quickly. Sending weekly updates with no progress is not acceptable.
——————————————-
Database
Please see the attached file, it is the original file that I sent to the programmer to create the database. He made a couple of small changes, and added details where I forgot them.
Understanding the database should make the page descriptions below very simple.
——————————————-
List of Pages with Functions Required.
Homepage:
– Sign-in/ Sign-up
– Member Account Balance (If Signed in)
– Link to Member Page (If Signed in)
– Display All Active TV Shows with thumbnails (Visible=T, Active=T)
– Display next 10 TV shows that will end
– If Member_Privelages >0, Link to create new show.
– If Member_Privelages >0, Display Shows where visible = F
Member Page
– Display Account Balance
– Display Shares Owned
– Display Shares for sale. (Edit or Cancel)
– Input new sale order
– Contestant (Select)
– Sale Price
– Number of Shares to sell (Must not exceed number available for sale)
– Change Password
– Edit Signature
===================================
TV Show Page
– 5,000 character description (If Member_Privelages > 0, edit option)
– Display clickable list of contestants for show with last sale price. (Sort high to low) include thumbnail.
– if contestant_active=F, Display, “Eliminated!”
– Display time until bidding locks.
– If member_Privelages > 0, create new contestant link?
– if member_Privelages > 0, Visible T or F?
– Display TV Show image. (Unique_TV_Show_ID.jpg)
– if member_Privelages > 0, Upload new image (Rename to unique_tv_show_id.jpg) and create thumbnail.
– if member_Privelages > 0, edit time and date option
=====================================
Create New Show
– Enter Show Title
– Visible (T or F)
– end date
– end time
– Number of Shares available per contestant (Default = 10,000)
=====================================
Create New Contestant (For Admin, Global Moderator and Show Moderator Only)
– Contestant Name
– 5,000 character input field for bio
– if member_privelages >0, upload image. (filename=c+unique_id.jpg) Thumbnail filename=ct+unique_id.jpg
====================================
Contestant Page
– 5,000 character bio (If Member=Admin, edit option)
– if member_privelages > 0, Option to select as Loser (Set Active to F)
– Place BUY order. (Price & Number of Shares) Confirm Order.
– Display Number of shares owned with Sell option if shares > 0
– if contestant_active=F, Display, “Eliminated!”
– Functions = If Contestant_Active is changed to False
– If remaining Active Contestants = 1, share price of remaining contestant is increased by final losing contestant value per share. (ie: Winner = $10/ share, Loser = $5.00/ share… Final Price of winner = $5+$10=$15)
– Share price of losing contestants are changed to $0.00
======================================================
Please ask questions via PMB if you need clarification. This project should take less than a week to complete, there are no complex functions.
