<?
$srs = null;
$i = 0;
$j = 1;
$srs_sync = 0;
$srs_nosync = 0;

$f = fopen('epsg',r);
while (!feof($f)) {
 $line = trim(fgets($f));
 if ($line[0] != '#' && $line != '') {
  $chunks = explode('>',$line);
  $srs[$i]['id'] = substr($chunks[0],1);
  $srs[$i]['param'] = trim(substr($chunks[1],0,-1));
  $srs[$i]['linenb'] = $j; //debugging info
  $i++;
 }
 $j++;
}
fclose($f);

$f = fopen('update.sql',w);
$sqlite = new SQLite3('srs.db');
$r = $sqlite->query("SELECT srid, parameters FROM tbl_srs");
while ($row = $r->fetchArray(SQLITE3_ASSOC)) {
 foreach($srs as $s) {
  if ($row['srid'] == $s['id']) {
   if ($row['parameters'] != $s['param']) {
    fwrite($f,"UPDATE tbl_srs SET parameters='".$s['param']."' WHERE srid='".$s['id']."'".chr(13).chr(10));
	$srs_sync++;
   } else { $srs_nosync++; }
   break;
  }
 }
}
$sqlite->close();
fclose($f);

echo $srs_sync.' -- '.$srs_nosync;
?>