Hello, I am looking to create or get help creating a baseball stat keeping module for PHPNuke that will help a league/team baseball site keep game and player stats. To the best of my knowledge there is nothing that does this available currently.
I was hoping someone might recommend a module similar in construction that I could use as a template for my "Baseball Score Keeping" module.
Here is what I am thinking:
1) Create a "Season"
A season is comprised of "Games"
2) Create "Teams"
Teams are comprised of "Players"
3) Create "Games"
A game is a paring of two teams and their players.
4) Create "Players" and assign them to a "Team"
Those would be the tables.
In the "Games" table, individual "Players" stats would be recorded. A "Game" would link to a season and two teams.
My vision is to have an Admin login where the admin could create a new season/team/game.
For game updates, I would envision the admin creating a new game and using a pull down menu for the team selection. The teams would be listed in two columns. Under each team heading, would be a listing of "Players" in a pull down menu that was populated by the data in the "Teams" table. Then the admin would update the game stats with things like: hits, 2b, 3b, HR, SO, SAC, BB, R, Errors, and the system would generate the Batting Average and Slugging percentage.
Pretty easy right?
Any help or thoughts on this idea would be much appreciated!
Ian
Please email me if you have any ideas: tyndall@itwebsolution.com