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

Audit Sheet - Database Maintenance Scripts

Lists a table for checking the effect of Heat race results and Pill Numbers on Main race starting priority


Script: insp_rpt.php

Input

From Maintenance Menu:
  1. home_club | text
From racing database:
  1. CURDATE() | today's date
  2. DATE_SUB([today's date], INTERVAL 1 DAY) | yesterday's date
  3. html.Car_Classes | array
  4. race.Results_Array | array
  5. events.[car class] | array
  6. drivers.First_Name | text
  7. drivers.Last_Name | text
Actions



Note: If a driver is registered but doesn't race in one or both Heats they will get an incorrect priority. This can be corrected by giving them a very high Pill Number (ie 21000) or editing the race to give them a high finish position (ie 11th place) in the races they missed.

Output

To Display: