CP Home
Database
Description
Script Index
I-5 QMC
MySQL
Database
SQL
PHP
HTML
Email

Generic Race Line-up - Database Maintenance Scripts

Produces printable line-up page of the selected drivers for distribution.
This process permits the user to select starting positions for any race from the list of registered drivers.


Script: begin_race_setup.php

Input

From Maintenance Menu:
  1. home_club | text
  2. validate | text
From racing database:
  1. CURDATE() | today's date
  2. html.Car_Classes | array
  3. html.Head | text
  4. html.Menu_Top | text
  5. html.Tail | text
  6. validate.Mode | text
Actions



Output

To race_lineup_form.php on Get Registered Drivers:
  1. event_date | date
  2. race_class | text
  3. home_club | text
  4. validate | text
To Display:



Script: race_lineup_form.php

Input

From begin_race_setup.php: See Output above

From racing database:
  1. DATE_SUB([event_date], INTERVAL 1 DAY) | yesterday's date
  2. event.[car class] | array
  3. html.Head | text
  4. html.Menu_Top | text
  5. html.Tail | text
  6. validate.Mode | text
  7. drivers.First_Name | text
  8. drivers.Last_Name | text
Actions



Output

To print_race_lineup.php on Create Lineup Page:
  1. event_date | date
  2. race_class | text
  3. type | text
  4. status | text
  5. [Driver_ID] | value=[position#]
    (one item for each registered driver)
  6. home_club | text
  7. validate | text
To Display:


Script: print_race_lineup.php

Input

From race_lineup_form.php: See Output above

From racing database:
  1. DATE_SUB([event_date], INTERVAL 1 DAY) | yesterday's date
  2. event.[car class] | array
  3. validate.Mode | text
  4. drivers.First_Name | text
  5. drivers.Last_Name | text
Actions



Output

To Display: