Originally posted by thire
BTW: how do you make the "batch routine"?
I was thinking in a simple shellscript or program that is run once a day, perhaps at 0h2min, that queries the site database for games completed at the past day, and feeds the chess (Scid?) database with it.
The exact way it will be implemented depends on the operating system used and it's resources/features, the database used at the web sites (RHP and TFC), and the chess datababase used (Scid?).
If we are talking about a LAMP system (Linux+Apache+MySQL+PHP = LAMP), you can use a shellscript that is started by the standard UNIX tool 'cron' (it watches the system clock and start any routine in the time it was programmed to start). The shellscript will do the MySQL queries and feed the Scid database someway (read 'using resources provided by the database system used'
Batch routines are used to run unattended jobs at computers that runs 24x7. Before the computers become interative, batch jobs was the way tasks where done in it (think punch cards, etc.).
About that Scid Search thing, http://scid.sourceforge.net/help/Searches.html