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

Std Main Line-up - Database Maintenance Scripts

Produces printable page of the selected Main line-up for distribution.
This process calculates starting positions for Main races based on
Heat results and Pill Numbers for 2 Heat format racing events.


Script: begin_mains_setup.php

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 mains_setup.php on Get Main Event Line-up:
  • event_date | date
  • race_class | text
  • home_club | text
  • validate | text
To Display:



Script: mains_setup.php

Input

From begin_heat_setup.php: See Output above

From racing database:
  • DATE_SUB([event_date], INTERVAL 1 DAY) | yesterday's date
  • html.Main_Size | array
  • event.[car class] | 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 Display: