Basic Description
===========================
Basic Pool beting system for different Sports.
Technical Requirement
===========================
-Linux PHP
-MySql
-HTML
-CSS
-Photoshop design source Images. (PSD files for later edition)
-Install scripts: Tarball with source code (PHP) and .SQL files.
Functional REquirements
===========================
**Administration Panel:
-Create Events-> choose 1 sport, add next week matches.
-Edit Events -> Edition, while event is not open yet, then Open Event for Bets. Match Scores will be entered here too as they happen.
-Suscribe Users to events -> Choose a user from a search box or list, add Open Events via Checkbox, then save per user.
-Edition CRUDs (catalog data) -> Sports, Teams.
**Splash Screen:
-Nice sports design, with Login / Register option.
-Users can register themselves, they'll wait for Administrator to suscribe them to an Event.
**Users Panel:
-Events (Possible status: Open, Closed, Finished)->
Open Events (for status open)->
Users can enter their bet or change while event is open.
Past events (for status closed and finished)->
When Closed, it means no longer can bet, matches are in progress and, matches scores can be seen as they are happening, also users can review what all users have bet in the whole event.
When finished, they can see results here matches and user scores, first three winners are announced (some can be tied) and are determined on the calculation of the scores and handicaps.
-Control Panel -> They can edit:
Name
Logo (a default must be assigned when created the account)
Password
(Username cannot be changed)
Close account definitely.
MysqlDAta (suggested, can be as you wish as long all requirements can be achieved)
===========================
Entities:
users (userName, password, name, email, logo "file name", comments, enabled)
sports (idSport, sportName, logo, enabled)
teams (idteam, idSport, teamName, logo, enabled)
Transactional:
Events (idSport (pk), description, comments "free text for prizes or special rules", dateStart, dateEnd, status)
Matches (idMatch(pk), idSport(fk), idTeam1(fk), idTeam2(fk), handyTeam1, handyTeam2, scoreTeam1, scoreTeam2, dateTimeMatch, comments "free text such as stadium, etc")
Bets (idBet(pk), userName(fk), idMatch(fk), winnerTeam)
Results (idEvent, position, username, score) (there can be ties, so there may be more than one user in the same position)
Payments will be made as i can see demos every week or less.
I would like to authorize design on every screen we can use images for GUI authorization.
We can discuss formula or calculus when project is given