How to use the optional function to check the square in your online log?

Due to the fact that this function is optional, you have to ensure following steps:

1. You need to have a file of your worked squares online available. This file must contain all of your worked squares, for example JN58, JN48, etc.
You can use a simple txt file with whitespaces between your squares. The squares dont need to be in any order.
Example, plain text:

JO00 JO01 JO02 JO03 JO04 ...

But you may even use a php script to extract your squares from a database, if you have your log online. All the html tags are removed by the script.
Example, php script which extracts all squares which are worked on 2m band:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html lang="en">
<body>
<?php
$connection = mysql_connect($hostname,$username,$password) or die ("No connection!");
mysql_select_db($databaseName) or die ("No Database!");
$query = "SELECT DISTINCT SUBSTRING(locator, 1, 4) AS locator FROM $Tab WHERE band = '2' ORDER by 1";
$result = mysql_query($query);
while($row = mysql_fetch_object($result)) {
	if ($row->locator != "-") { 
	echo "$row->locator "; 
	}
}
mysql_close($connection);
?>
</body>
</html>

2. You need to check a "Y" in the "Check square:" preferences.
3. You need to insert the link to your squares file in the "Logfile" preferences, for example: http://www.dg2kbc.de/worked-squares.txt

Your done! From now on, every locator you insert in the locator field, will be checked in your text file / database extract if you already worked this square!
To disable the check, just insert the "N" in the "Check square:" preferences again.

If you have any questions or need any assistance, just drop me mail via my webside at http:www.dg2kbc.de/contact.html

73 de Ansgar / DG2KBC
February 2006
