I would like to have someone help me develop a fully functioning virtual sports league. Think of Fantasy Football or Fantasy Baseball, except instead of using actual NFL or MLB players, we use players that sign up individually and input a few fields (their name, Xbox Live Gamertag, Position they play). I'm already capturing that information.
A typical database row/record in our current MySQL db has the following columns: UserID [text], Gamertag [text], Position [choice from dropdown], League Manager [Y/N], General Manager [Y/N], Owner [Y/N], Team [choice from dropdown], Active [Y/N]
The League Manager can assign other Users to be General Managers and/or Owners.
As Players sign up for the league, they manually input their Gamertag, Position, and whether they're Active, their Team is NULL so they are free agents.
Team owners have a draft where they draft from the pool of free agents. As players are drafted, they are assigned a Team (in the future, there may be a salary field for bidding on players rather than a simple draft).
Once all of the free agents are gone, the draft ends. Once the draft ends, games are scheduled between the teams. Owners and GM's assign players to their roster for those scheduled games. There will be limits as to how many games a player can play in a given week, as well as a minimum
Once scheduled games are completed, Owners or GM's of the respective two teams that played enter their teams stats/results. This would probably need to go into a different table. Stats entered would be Goals, Assists, PIMs, Shots, Hits, Saves, GoalsAgainst, and possibly a few more.
If both team Owners/GM's stats are agreed upon, the results are approved, otherwise they are in a disputed status. Once the results are approved, the league standings are updated to reflect the results. At the end of the season, there is a playoff tournament between the highest ranked teams.
11 freelancers están ofertando el promedio de $717 para este trabajo
Hi We are very interested in this [login to view URL] can do that job in a normal [login to view URL] have great experience of preparing Complete Scope,Complete documentation,attractive design ,Webdevelopment,QA and then support for specific da Más
Sir, lets discuss more in details. WE ARE WORKING ON A SIMILAR PROJECT, KINDLY CHECK THIS LINK : [login to view URL] . Please share your SKYPE id. We are waiting. Thanks
Hello, can talk more about this project ? [login to view URL] my portfolio [login to view URL] [login to view URL] [login to view URL] last project. Thanks