Schedules - schedule.dat
Thu, Sep 8, 2016
Schedules
A row in the schedule.dat file may end early. If the row does not have a home score then the game has not been played yet.
Completed Game
| Index | Column | Name | C Type | PHP Type | Format | Examples |
|---|---|---|---|---|---|---|
| 0 | A | Game Date | char* | string | m/d/y | 01/01/03,12/12/16,04/28/12,04/28/03 |
| 1 | B | Field | char* | string | SSV2N,HSP14,HSP5NW,OP2 | |
| 2 | C | Game Time | char* | string | h:i | 11:00,13:15,15:00,08:45 |
| 3 | D | Home Number | char* | string | 8730,88A6,8430 | |
| 4 | E | Visitor Number | char* | string | 8730,88A6,8430 | |
| 5 | F | Game Number | signed integer | integer | -1578,-1579,16,-13,-815 | |
| 6 | G | Home Score | unsigned integer | integer | 0,1,2,3,4,5..10,11,12,13 | |
| 7 | H | Visitor Score | unsigned integer | integer | 0,1,2,3,4,5..10,11,12,13 | |
| 8 | I | Referee Number | char* | string | 849,2962,xxx | |
| 9 | J | 1st Assistant Referee Number | char* | string | 849,2962,xxx | |
| 10 | K | 2nd Assistant Referee Number | char* | string | 849,2962,xxx | |
| 11 | L | Referee Mentor Number | char* | string | 849,2962 | |
| 12 | M | Home Yellow Card Count | unsigned integer | integer | 0,1,2,3,4,12 | |
| 13 | N | Home Red Card Count | unsigned integer | integer | 0,1,2,3,4,12 | |
| 14 | O | Visitor Yellow Card Count | unsigned integer | integer | 0,1,2,3,4,12 | |
| 15 | P | Visitor Red Card Count | unsigned integer | integer | 0,1,2,3,4,12 | |
| 16 | Q | Extra Pipe at End of Line | void* | string |
Future Game
| Index | Column | Name | C Type | PHP Type | Format | Examples |
|---|---|---|---|---|---|---|
| 0 | A | Game Date | char* | string | m/d/y | 01/01/03,12/12/16,04/28/12,04/28/03 |
| 1 | B | Field | char* | string | SSV2N,HSP14,HSP5NW,OP2 | |
| 2 | C | Game Time | char* | string | h:i | 11:00,13:15,15:00,08:45 |
| 3 | D | Home Number | char* | string | 8730,88A6,8430 | |
| 4 | E | Visitor Number | char* | string | 8730,88A6,8430 | |
| 5 | F | Game Number | signed integer | integer | -1578,-1579,16,-13,-815 | |
| 6 | G | Extra Pipe at End of Line | void* | string |
Game Date
The game date is formatted like mm/dd/yy. Occasionally, someone will put in a reschedule with a date in another format, (yyyy, or d/m/y), but John always uses mm/dd/yy.
Field
These are arbitrary codes for the soccer field on which the game will be played.
The codes FF and TBA are special.
- FF is a forfeit.
- TBA is To Be Announced
John doesn’t put these in; Dana does, and he is not sure exactly how she uses them.
Game Time
The game time is formatted like hh:mm and uses a 24-hour clock.
Home and Visitor Numbers
These are the team ids from team.dat. The subdivision id is embedded in the first three characters of the team id.
Game Number
This is an integer that is always |x| > 0. This value is negative if the game has been rescheduled.
This field is mostly sequential and from what I can tell is composed entirely of signed integers.
Home Score
This field will not be available if the game has not been played. If so, the field may be replaced with the Extra Pipe at End of Line.
The Extra Pipe at End of Line is not guaranteed to exist either.
Referee/Mentor Number
The referee/mentor numbers are always an unsigned integer. We are not currently using the mentor field, as it is handled in the referee adjustments.