Liam wrote:Excellent idea. Only problem is the new webmaster hasn't a clue how the present scoring system works without trying to edit it.
HI Liam,
The TT series scoring system is the simplest of the two, the nationals is a lot more complicated because it records each individual race results, overall results, who entered and qualified the previous year, most improved using Robert England's formula, trophies for all sorts of sub comps, entries etc.
It is essentially just adding up the overall placings in each event and getting the overall position. There is a table entry that defines the series and thus how many results need to be recorded to secure a trophy win.
A team event trophy is possible to add because the competitor entry recorded in the DB includes their club. I suspect you'd need to a new table into the DB to record the overall results for the club for the best 3 (or however many you want to settle for, config option in series? or just use no qualifying races?) competitors in the club, an SQL statement should be able to get the info from the DB and a little program to get the results transferred into the table in a meaningful manner. You may want to link the comps whose results you are using in the table as well. Then its just a case of creating a user consumable page to call up.
Martin S.
