Forum Replies Created
-
Posts
-
Ok so I finished making the stats calculating stuff, heres the data that can be pulled from the database at the moment with a standard score sheet entry.
Team:
GP – Games played
W – Wins
L – Loses
T – Ties
OTW – Overtime wins
OTL – Overtime loses
OTT – Overtime ties (don’t really happen, not even sure If I need this?)
PTS – Points (0 for loses, 1 for ties, 2 for wins) Total
GF – Goals for
GA – Goals against
SO – ShutoutsPlayer:
GP – Games played
G – Goals
A – Assists
PTS – Points (G+A)
PPG – Power play goals
PPA – Power play assists
SHG – Short handed goals
SHA – Short handed assists
GWG – Game winning goals
GWA – Game winning assists
GTG – Game tying goals
GTA – Game tying assitsGoalie:
GP – Games played (as goalie)
GS – Games started
TOI – Time on ice
ATOI – Average time on ice
GA – Goals against
GAA – Goals against average
SOG – Shots on goal
SV – Saves
SVP – Save percentage
SO – ShutoutsAll these stats can be limited to a game, collection of games, teams, competitions or of course viewed all together.
The Goalie stats will show up on anyone who has played as a goalie before, as all stats relate to one player it will take into account all the teams the player ever played for etc unless a limit is added.
If anyone can think of any other useful stats let me know, also If anyone knows much Mysql I would like someone to help me optimize the queries as I know a lot of the stuff I’ve written can optimized, I just need to sit down and think about how and two minds are better than one.
[quote:22pc4blo]Also, you don’t have to worry about port forwarding if you download from servers Smiley[/quote:22pc4blo]
Thats why the invented UPnP my friend.
The times that go on the game sheet are the offical times at which the goal was scored, so if it was recorded at that time then entering it into the computer wont cause any problems at all.
As with coincidental penalties, they will still be recorded so theres no problem there.
It would be possible for the scoring to be done at the same time but they need a hard copy (which could be printed after). The problem there is syncing the time on the computer and the time on clock, it would be more accurate to enter the time from the clock each time rather than have the computer work it out.
Ok well im done for the day so heres my latest build, major changes to the includes/lib/stats folder.
Have the team stats all built and most of the player stats bar game winning goals and game tying goals.
There are also a few changes to the database, however they wont be the last.
file available here[/url:2lx010o5]
The stats app is designed to have the information entered afterwards. there is no need for anyone to sit there with a laptop unless they want to be able to supply live stats.
ohhh kyle but it is!, the score sheet in its self is a time line, it records when goals were scored and when penalties were handed out. With that data alone you can work out if the goal was scored on a power play or not.
Rather than make the statistics all user input, you simply enter the time line of the game in and it will spit out all the stats. Much easier on the person entering it as it doesn’t involve any extra work and less human error.
Working out power play goals is difficult as you have to compare penalties time, duration, period with the goals. You need to work out how many men were on the ice for both teams, due to the nature of a database this is spreed across a few tables. Also you have to take into account for goals scored when shorthanded canceling out penalties that would otherwise still be running.
Another problem that is puzzling me at the moment is when penalties carry over to another period, as the stats are recorded in minutes from the start or the period this can be tricky, especially when you have to allow for different period times as we sometimes do 15mins or 20mins.
Any way it looks like I’ve got the jist of it sorted now.
God damn working out power play goals and short handed goals are proving to be mentally challenging!
Just completed the Team stats backend, generating highly versatile stats that can be limited to a range of games, and competitions. Also leaves the ability to compare games/competitions etc.
I’m about 85% complete on the back end, I have Player stats and goalie stats left to get done which should be done by the end of the day. Then its all over to designing a front end and inserting data.
Depending on how much help I get for a front end I estimate we will be beta testing this sometime next week.
Will release code once I’m done on the backend.
Heres another release of the latest source code, a lot of changes to back end stuff. I recommend anyone interested in PHP or codes in PHP takes a look, I could do with the comments or it could be a great learning tool for you.
Attached here[/url:vvujwme5]
In terms of what statistics I will generate from the data recorded, I am going by this wikipedia page http://en.wikipedia.org/wiki/Ice_hockey_statistics, only ones that I won’t be able to generate is the player’s on ice time and the +/- for each player as we don’t keep track of who’s on the ice at any time.
If you know of things that should be added let me know so I can add them.
Ill have to make some time to go over it with you sometime. or attempt to draw something up in photoshop.
Attached is the source so far for those interested, I don’t comment my work because I’m lazy, But I will explain anything if people really want to know. I’m on msn ALL THE TIME.
The database is the basics of what I thought was needed, it will grow as things come to my attention and so will the database layer files.
