Hello,
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.
I have 20 years of experience as a Web & Software developer while living in Bryan, Ohio, USA. I have done this, or something similar, or something in the same direction. Or.... I've started it. I spent months working on developing a fully-randomizing baseball "world". It's a huge project, for sure, and a very interesting one. I never finished, or even got close. Just ran out of time and money.
Let me know if you'd like to talk more.
Thanks.
Joe
I have check this requirement,have some query,so need to discuss this,please tell me how we can start the discussion.
We have a team of professionals,they have more than 11 year of experience,so we can manage this work.
expertise in php/mysql and their MVC frameworks like laravel-4,symfony-2,cakephp,html,html-5,bootstrap, etc,