sqlite> alter table qso add column rst_sent text;
sqlite> alter table qso add column rst_rcvd text;
sqlite> alter table qso add column cqz integer;
sqlite> alter table qso add column calc1 text;
perl scorer.cgi call=KJ4IZW contest_id=VOLTA-RTTY year=2010 | grep -A5 SUMMARY

2010-12-22
	* Added 2011DX-S5 endorsement
	* Added 2011DX-TA endorsement
	* Added The WOTMC-2011 endorsements
	* Set expiration date for VK endorsement

2010-07-21
	* Much improved support for incremental endorsements (Golf, SouthAmerica)

2010-06-29
	* Added new South American PSK31 endorsement

2010-06-25
	* Fixed WARC checks for unique calls 

2010-06-23
	* Benelux -- added 12/31/2010 expiration
	* Added new Baltic States endorsement

2010-04-19
	* Added Statistics page
	* Added Trophy room
	* Added links to trophies, statistics, standings
	* autocommit when adding to db

2010-04-13
	* Show endorsements as confirmed even if qso's aren't met.
	  For case of missing adif cols (e.g. state in DigiPan)
	* Updated standings to 4/13
	* On standings page, ignore portable call area
	  (e.g. count N6YIH and N6YIH/7 as the same)
	* Report layout -- now 3 cols for:
	    completed, in-progress, not started

2010-04-09
	* Support for the Standings page -- now indicates which
	  endorsements are confirmed (i.e. are posted on the
	  Standings page).
	* Added QRP endorsement.
	* Added W0PE, AG4CZ to list of valid QCWA contacts.
	* Added PB7XYL, PS7YL to list of valid YL contacts.

2010-03-27
	* Support for hide_reqs_for_not_started ... to clean
	  up display of the "red" awards (no qsos yet).

2010-03-25
	* Report layout change -- show partial-progress awards
	  in separate column from completed/not-started ones.

2010-03-24
	* More memory/perforance updates. Tested w/large (8000+) logs.

2010-03-18
	* REFACTORED for performance and memory footprint.
		==> Should be ~10x faster.
		Now uses sqlite (with indexes) instead of un-indexed
		in-memory tables.
	* support for 'BPSK31' and 'QPSK31' modes.
	* Added 'Ragchewers 3/30' award.
		Needs 'time_off' ADIF column. (calculate length_min)
	* Added grid to log info for PSK Golf.

2010-03-10
	* Ability to toggle on/off the list of QSO log info for each award.

2010-03-09
	* In data file (070.inc), add group attributes to data structure,
	  including first-pass filter to apply to all checks.
	* Removed 2009DX-SP, 2009DX-CT, and IOTA20_2009 award checks
	* Removed BARTG check
	* Added QRP Tri-Band check
	* Updated lables (e.g. country names)
	* Show only columns needed for submission.
		Default is: date, time, station worked and band.
		e.g. WAC now also shows continent.
	* qsodate sort order bugfix
	* award order now by last update (instead of completed ones first)
	* show qso info of incomplete awards in certain cases (e.g. QCWA)
	* No longer fatal error if DXCC is missing.
		just won't get progress for most awards.
		e.g. log from ADIFMaster can still see WARC progress.
	* Calculate band from freq if band is missing (e.g. from ADIFMaster)
	* Updated text/info.
	* state sort order  (by abrev instead of name)

2010-01-19
	* Updated WALC requirements to enforce >= 3/19/2009
	* If state (and ve_prov for VE) is missing,
		use arrl_sect for state (needed for HRD).

2010-01-13
	* Initial release

• Input a ADIF file. I wanted to use the standard format, to support as many logging programs as possible.
• Parse the ADIF into data structures in memory. Currently doing this w/regular expressions in perl. (eventually i'll break that out to a ADIF-parsing perl module)
• Create a database table of the data, so that SQL can be used to query it. Currenty using DBD::AnyData to create an in-memory table. The table schema includes these ADIF columns:

  	call
  	band
  	freq
  	mode
  	qso_date
  	time_on
  
  	dxcc
  	state
  	iota
  	cont
  	gridsquare
  	pfx
  	ve_prov
  

  And these columns are calculated:

  	grid2
  	grid4
  	dxccprefix
  	spc
  	sfx
  

• Read in config file that includes SQL::Abstract filter 'where clause' definitions. For example:

    {
      award => 'WALC-NA',
      filter => { mode => 'PSK31' },
      checks => [
          { ct => 1, label => 'CA', where => { dxccprefix => 'K', state => 'CA' } },
          { ct => 1, label => 'OR', where => { dxccprefix => 'K', state => 'OR' } },
          { ct => 1, label => 'WA', where => { dxccprefix => 'K', state => 'WA' } },
          { ct => 1, label => 'BC', where => { dxccprefix => 'VE', state => 'BC' } },
          { ct => 1, label => 'AK', where => { dxccprefix => 'KL7' } },
      ],
    },
  

• Create & execute SQL statements that check the requirements.
• Report the results in HTML format.

Available Reports