= (Select StartTime FROM ".$database.".Races WHERE UUID = '$race') AND SampleTime <= (Select EndTime FROM ".$database.".Races WHERE UUID = '$race') AND Reduced = 0 ORDER BY SampleTime";
  $result = mysql_query($query);
  if (mysql_check_query($result,$query)) {
    while ($row = mysql_fetch_assoc($result)) {
      $gpsid = $row['TrackingDeviceId'];
      $gpscount[$gpsid] = $gpscount[$gpsid]+1;
      $lat = $row['Latitude'];
      $lon = $row['Longitude'];


      if ($lat >= 0) {
        $latstr = "N";
      } else {
        $latstr = "S";
      }
      $lat = abs($lat);
      $deg = ((int)floor($lat));
      $min = ($lat-$deg)*60;
      #if ($deg < 10) { $deg = "0".$deg; }
      if ($min < 10) { $min = "0".$min; }
      $latstr .= $deg.".".$min;
      if ($lon >= 0) {
        $lonstr = "E";
      } else {
        $lonstr = "W";
      }
      $lon = abs($lon);
      $deg = ((int)floor($lon));
      $min = ($lon-$deg)*60;
      #if ($deg < 10) { $deg = "0".$deg; }
      if ($min < 10) { $min = "0".$min; }
      $lonstr .= $deg.".".$min;

      // 2007.03.12 08:00:18 : -18,UNITSTAT,20070312,070011,7000931435,N60.31.9159,E8.12.5665,13,251,9,3922,-61,2,24201,766,9,1893
      //fwrite($fp,logdatestr($row['ReceivedTime'])." : ");
      fwrite($fp, "-".$gpscount[$gpsid].",");
      fwrite($fp, "UNITSTAT,");
      fwrite($fp,sampledatestr($row['SampleTime']).",");
      fwrite($fp,$gpsid.",");
      fwrite($fp,$latstr.",");
      fwrite($fp,$lonstr.",");
      fwrite($fp,sprintf("%1.0f,", $row['Speed']));
      fwrite($fp,sprintf("%1.0f,", $row['Direction']));
      fwrite($fp,sprintf("%d,",    $row['Satellites']));
      fwrite($fp,sprintf("%1.0f,", $row['Voltage']));
      fwrite($fp,sprintf("-00,"));   // Signal strength
      fwrite($fp,sprintf("0000,"));  // Unit State
      fwrite($fp,sprintf("00000,")); // Current network
      fwrite($fp,sprintf("%1.0f,", $row['Elevation']));
      fwrite($fp,sprintf("000,"));   // HDOP
      fwrite($fp,sprintf("0000"));   // CellId
      fwrite($fp,"\n");
    }
    mysql_free_result($result);
  }
  fclose($fp);
  }

  #Clear the existing markroundings
  $sql = "DELETE FROM ControlPointResults WHERE RaceObjectId IN (SELECT UUID FROM RaceObject WHERE RaceId = '$raceid')";
  mysql_query($sql) or die(mysql_error());

  #reset devicehandler and broker
  system("sudo -u tractrac /home/tractrac/services/system-main/broker-recalc/reset > /dev/null 2> /dev/null");
  system("sudo -u tractrac /home/tractrac/services/system-main/devicehandler-recalc/reset > /dev/null 2> /dev/null");

  #Run lommysim
  system("java -jar /data/software/2.0/lommysimpipe/dist-current/LommySim.jar dest=localhost:13400 sourcetext=\"$filename\" speedup=100 replaytime=sample gui=0 reloaddataserver=1 gmsdestport=3411 eventid=$eventid raceid=$raceid");


?>

Please wait a few minutes for the recalculation to finish

\n"; echo xmlcode($message); echo "\n"; //die($message); return false; } return true; } function xmlcode($str) { //return(htmlentities($str)); $str = str_replace("ö","o",$str); $str = str_replace("ä","a",$str); $str = str_replace("é","e",$str); $str = str_replace("ü","u",$str); $str = str_replace("º","_",$str); //$str = urlencode($str); //$str = iconv('UTF-8', 'ISO-8859-1//TRANSLIT//IGNORE', $str); return(htmlspecialchars($str)); } ?>