I was looking at getting hold of the software used here from Nick Lynn (who runs the site):
[url:1s1scxl7]http://www.sncicehockey.com/?opt=schedule[/url:1s1scxl7]

It can be purchased here [url:1s1scxl7]http://www.TheHockeyStop.com[/url:1s1scxl7] but it’s US$100 I think and it’s GPL anyway so no point paying for the damn thing. Plus it apparently has a few bugs in it, like you can’t make corrections afterwards – well you could probably change the database directly but that’s no good for anyone but me who has direct access to it, plus it’s a pain the ass. Nick hasn’t sent me the software yet.

In principle we should be able to create something ourselves but I’m definitely not knowledgeable enough for that. The computer tech guy at the university chemistry department offered to make one, but he’s given up as he got bored of it.

Do you reckon you could make something similar Mike? There’d be quite a bit of database work to make it work. I suspect if you made it you could probably make a few bucks off it too as all the software for this purpose is either crap, or mega expensive. That one above is the cheapest I’ve seen so far but it certainly isn’t perfect. It requires safe mode to be off – apparently this is a bad thing.

Ryan,

Aaron’s offered to do the stats for us this DIHL, but I don’t think he’s really sure what he’s going to do with them.

I agree, if someone could write a database to process statistics, which also did team and tournament management, it’s a gaping hole in the market waiting to be filled. Even a shareware one could easily make a few grand I’m sure.

Sounds promising ” title=”Smiley” />

Um, now to explain exactly what it is we need.

Well obviously there needs to be a login function for the statisticians to enter their data, an htaccess protected folder would do for that I guess.

Then the stats would need to be calculated as per this type of thing:
http://www.dunedinicehockey.hellyer.kiwi/docum … tats06.pdf

But on top of that, it’d be great to be able to click on a player and see their exact stats for each game.

And be able to click on each team and see the exact stats for each game of their season.

Also, some way to rank players and teams automatically based on number of goals, penalty minutes, assists etc. etc.

Preferably set it up to either be easily skinnable by me, or with a nice CSS based design with no extraneous code turfed in there. We could iron any bugs in the display side of things later I guess though, the actually programming is the tricky bit!

There’s a bunch more things we’ll want too, but I can’t think of them right now and I’ve got to go ….

Great input kyle ” title=”Cheesy” />, plans are in motion and Ive already started planning. I will add every feature you’ve just listed.

I can’t give an eta at this time as I’m busy with work and the friendships.

Keep the input coming.

Mmm well so far I’ve set it up for tournament’s and finances, I’m going to be working on stats today then Ill start building a front end to this mammoth.

Edit: for those interested in database structure, heres my first draft, I am now entering it in as a MySQL database with the correct datatypes etc.

Database Scheme

Table “users”
• user_id (Auto increment)
• player_id
• username
• password (SHA1) VARCHAR (40)
• email
• type

Table “players”
• player_id (Auto increment)
• first_name
• last_name
• picture?
• experience (Highest level played)
• played_time (Length of time played)
• registered
• management_only
• date_of_birth

Table “players_positions”
• player_id
• team_id
• position

Tables “players_finances”
• player_id
• type (topay, payed)
• description
• amount
• time

Table “players_hired_gear”
• player_id
• item

Table “players_addresses”
• player_id
• street
• suburb
• city
• country
• post_code
• description

Table “players_phonenumbers”
• player_id
• type
• description
• area_code
• number

Table “players_teams”
• player_id
• team_id
• number

Table “teams”
• team_id (Auto increment)
• name
• description
• color
• alternate_color
• manager
• coach
• assistant_coach

Table “competitions”
• competition_id (Auto increment)
• name
• description
• start_time

Table “competitions_teams”
• competition _id
• team_id

Table “devisions”
• devision_id (Auto increment)
• competition_id
• name
• description

Table “devisions_teams”
• devision_id
• team_id

Table “games”
• game_id (Auto)
• competition_id
• devision_id
• description
• team1_id
• team2_id
• scheduled_start
• period1_start
• period2_start
• period3_start

Table “goals”
• goal_id
• game_id
• player_id
• team_id
• time

Table “goals_assisted”
• goal_id
• player_id

Table “penalties”
• penalty_id
• game_id
• player_id
• team_id
• type
• description
• minutes
• time

Table “shots”
• shot_id
• game_id
• player_id
• team_id
• time

This will change slightly as I notice things that need to be added or removed, it can have features added to it as we need them also