[Michael]

sweet as Ryan, get some pages sorted and Ill start filling in the blanks, Once Thursday rocks around and the friendship games are over Ill be straight into it.

[Michael]

Na I completely forgot and im not back there until monday.

[Michael]

Yeah they should fit you fine kyle, Ill bring them along with me and ill give them to you next time I see you.

[Michael]

Didn’t ask any way, woulda been helpful though because he does know his ice hockey. But nup if your gana be that way <img src="{SMILIES_PATH}/tongue.gif" alt="” title=”Tongue” />

[Michael]

"Ryan":tsf0he7s wrote:

I have a request <img src="{SMILIES_PATH}/smiley.gif" alt="” title=”Smiley” /> This is apparently possible, but I’m not sure how difficult is to implement.

It would be great to be able to output the stats, schedules, team rosters etc. directly to PDF so that they could be sent as emails, printed easily etc.

Ryan,[/quote:tsf0he7s]

No!!!! Its a nightmare to generate pdf’s with php, until someone finds me a html2pdf program your only getting html pages <img src="{SMILIES_PATH}/cheesy.gif" alt="” title=”Cheesy” />

[quote:tsf0he7s]If you have them in an excel spreadsheet, Michael might be able to tweak them in excel to make them importable as well.[/quote:tsf0he7s]

Yup, no problem to import excel spreedsheets, just keep doing them that way for now.

[quote:tsf0he7s]Yeah, I should have checked with Michael about a timeline.

When he offered to do this I kinda presumed it would take a few weeks. Maybe in lieu of you setting something up for a fortnight or so Aaron, maybe for now we can just post the pdfs and then once Michael has his thing up and running you can add the data to it?

Michael?[/quote:tsf0he7s]

It could be a couple of weeks if not months depending on the time I have to spend on it, Either way Ill get it working bit by bit and add features as there ready.

[Michael]

*sigh* why did I have to notice the dumb rule.

[Michael]

Ok well the cloning of teams wouldn’t change either way, you would still be able to do it as thats done on the php side of things, and I can see where this will be handly now. It may be a little tasking on visiting teams if this system is used however as all the tops have to entered first.

Heres what ill do, I will add a new table with tops, the team name colour and description, and also the option to have a photo or picture, When creating a team you can choose the top, if a top isn’t there you’ll have to add it (this is where i could see the problems with visiting teams or national/international events)

Sound good?

[Michael]

"Kyle":jzv1l6k3 wrote:

And now I’m coming around to having two tables, ‘tops’ and ‘teams’. Each team has one (hypothetically two, for home and away, but we don’t do that here) tops. There might be many instances of the team beasts, but they’d all use the same tops table entry.[/quote:jzv1l6k3]

That would be what color, and alternate_color are for. Having a seperate entry for Jersey means the person entering the team has to enter a jersey first? The team does not belong to the Jersey! The jersey belongs to the team <img src="{SMILIES_PATH}/cheesy.gif" alt="” title=”Cheesy” />

[Michael]

This situation is dunedin specific because we share tops, But the teams are not the same!, just because the name is Beasts does not mean that they are the same team , if they were the same team they would have the same people. so creating and reusing the Beasts team would be silly as its not really the beasts team.

[Michael]

http://yahooxtra.net.nz/sport/0,,14606- … 00,00.html

[Michael]

It would be no extra burden on the scores, by all means im working on simplifying the system for them, it would be a simple point click enter player number and done.

Finances I think is something we can work on later as its a Program in its own. As for registration I did allow for that in “Players” where it says diha_registered, this would be where the “admin” ticks that the player has paided there registration.

If the people handling the money did find it useful it could be used to let people know they have not paid for practices or games.

As for the sms thing, not something I know a lot about but I’m sure its doable.

[quote:1cyddj5t]My point is, there’s things that don’t change about teams – name, top color etc. There are other things about teams that do change – the players in them, manager, coach etc.

Take the Beasts for example. The DIHL beasts are going to have a slightly different team lineup than the SIHL Beasts. I would have done it by a ‘team’ table which indicated all the different teams that we can have. And then made a team_instance table, which links to the team table. Players, coaches etc, link to team_instance_id. So if you’re playing in both Beasts teams, you’d be in both instances. Ryan, who is playing Bears in the DIHL, only links to one.

If you put it in one table with multiple beasts instances then you’re both recreating data, and also you’d have no way to list all players who played for the Beasts this year, as they’d be in Beasts 1 and Beasts 2.
[/quote:1cyddj5t]

Ok I see, I think where im getting confused here is that in Dunedin we have “teams” for competitions that always have same name, but really they are not the same team, they just have the same name because thats the name on the tops we have.

In your example, I would see it like this. Create two teams rather than one “Beasts (DIHL ” and “Beasts (SIHL)”, Keep in mind this “program” could help out other rinks around New Zealand that don’t use the same “grouping” method we use in Dunedin because we have tops with those team names.

Beasts in that term is a “Group” of teams, not a team. Yes? No?

Thanks heaps for your input kyle it really helps when thinking things through as two minds are greater than one. and thanks for the score sheet <img src="{SMILIES_PATH}/cheesy.gif" alt="” title=”Cheesy” />[/quote]

[Michael]

Wow about time, thats wicked <img src="{SMILIES_PATH}/cheesy.gif" alt="” title=”Cheesy” />

[Michael]

Good input once again Kyle <img src="{SMILIES_PATH}/cheesy.gif" alt="” title=”Cheesy” /> now its time for me to explain a few things

Having a seperate table for position covers the multiple positions thing, so for each position they play on a team etc another entry is added to players_positions. By ticking 1 or more boxes it will add one or more entry’s stating that users ID the team they will be playing that position for “if applicable” and the position.

With finances I was not sure if there would be a need for it to be linked back to a tournament or game as some finance items may not be related to one, this is why each one has a “Description”. But I see how it will be helpful, I will add a link to tournaments.

A player can be in any number of teams. Players are placed into teams before the tournament by organizers or by choice (However things are run for that tournament), so there is no limit as to how many times a player is entered.

I agree with the extra email contacts, I will add that also.

Teams do not need the manager, coach or ass. coach and if its changed its changed for that “Team” so each entry of a team is changed.

“Time” referees to a UNIX timestamp, it has no specific format.

Venue is a good idea, I will add it.

I had a discussion with Ryan about the competition thing, the reason why I have the option to add teams directly to a competition is because not all competitions will have more than one devision, in the case that a competition only had one devision the organizer entering the competition would be required to specify a devision for a tournament with no divisions?

Instead it has the option to have a devision less competition or one with devisions.

If a competition has more than one devision it will ignore the “completions_teams” table completely and look in “divisions_teams” hence the double up there.

• period1_start
• period2_start
• period3_start

These are for another underlining possiblilty of the program, To speed things along for the scorers I’m looking at making a scoring program that will work with the database to make there lives easier. The period starts would allow a detailed time line of how the game went for players to view after the game.

[quote:van2xuab]
I don’t understand why you need this one either. It’s just a linkage, why not have a one-to-many relationship between the table before and teams? I’m no SQL expert though, so maybe you just need to. And, that’s not how you spell division. [/quote:van2xuab]

Good question, it comes down to efficiently and size of MySQL and the database, yes thats the way about 80% of people who have not worked with any type of SQL database for a very very long time would do it. But… By adding 2 extra tables that arn’t going to be used every time you are adding to the size of each entry. By using a separate table assists are only entered when they happen instead of when they don’t happen also. ( Things shouldn’t be left blank as a rule of thumb, but sometimes its unavoidable ).

[quote:van2xuab]If you have ‘type’ you shouldn’t need to enter minutes. It should look it up from a table, I can’t think that we’d want people manually entering how long penalties are. Minor, double minor, major, game etc are all fixed. [/quote:van2xuab]

I see what you mean, but people would not have to enter it manually, I was thinking here it would just be added by the type of penalty any way. So I suppose there isn’t a need for time but instead a new table for penalties and there times.

Did not know about the period thing, will add something now.
Also the time thing is another fancy thing that would be included in the scoring system, when they clicked for a shot at the net it would record the time as well with no extra effort for a detailed time line of the game <img src="{SMILIES_PATH}/cheesy.gif" alt="” title=”Cheesy” />

If manually entered the times would be unneeded

Hope this clears some things up.[/quote]

[Michael]

Edit: Useless post

[Michael]

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

[Author]

Posts