|
Record Race Results - Database Maintenance Scripts
Provides a form for recording race results based on registered drivers.
Inserts recorded race results into the database.
Produces printable race results page for distribution.
Input
From Maintenance Menu:
- home_club | text
- validate | text
From racing database:
- CURDATE() | today's date
- html.Car_Classes | array
- html.Head | text
- html.Menu_Top | text
- html.Tail | text
- validate.Mode | text
Actions
Output
To add_race_form.php on Record Race Form:
- event_date | date
- race_class | text
- home_club | text
- validate | text
To Display:
Input
From begin_record_race.php: See Output above
From racing database:
- DATE_SUB([event_date], INTERVAL 1 DAY) | day before
(needed for 2nd day of 2 day events to get registered drivers)
- event.[car class] | array
- html.Race_Name | array
- html.Head | text
- html.Menu_Top | text
- html.Tail | text
- validate.Mode | text
- drivers.First_Name | text
- drivers.Last_Name | text
Actions
Output
To insert_race_results.php on Submit Race:
- event_date | date
- race_class | text
- type | text
- status | text
- [Driver_ID] | position_number
- [Driver_ID]_points | points
- home_club | text
- validate | text
To Display:
Input
From add_race_form.php: See Output above
From racing database:
- DATE_SUB([event_date], INTERVAL 1 DAY) | day before
- validate.Mode | text
- drivers.First_Name | text
- drivers.Last_Name | text
- drivers.Home_Club | text
Actions
Output
To racing database:
- drivers.Race_Points | array
- drivers.Car_Class | array
- race.Race_ID | integer
- race.Type | text
- race.Race_Class | text
- race.Status | text
- race.Race_Date | date
- race.Results | html
- race.Results_Array | array
To Display:
 |
