award_awards
award_prizes
award_types
award_awards_projectcategories
award_awards_projectdivisions
winners
students
projects
registrations
Also modified all code that uses those tables to work with the conference id
instead of the year, with the exception of these files:
communication.inc.php
reports_students.inc.php
rerollprizes.php
remote.php
The "rerollprizes.php" probably doesn't matter, having been a one-time usage
file anyway. The others will need to be modified in the future to correctly
use the conference id instead of the year.
options. This way, the logo/fairname can be moved around and
resized. Ensure those fields exist in each report. Convert name/logo
preferences in all existing reports, and adjust the yloc/height of
existing fields to make way for the headers if they exist.
It would be nice to remove the "Award -- " off the front of each field
name, but if we do that it only displays "Name" after its' selected,
which can be confusing if there's an "Award -- Name" and a "Prize --
Name". But the division into optgroups still look nice.
- Fix a bug in the award query tha twas incorrectly linking judges teams with judges
- Add 'Judge Name' to the query so non mysql5 users can create an award report
that lists the judge names for each award.
enough.. Currently we can't produce both a list of judges and a list of awards for each
team with the generator (how the heck would we express that with an SQL statement)
