| Server IP : 79.136.114.73 / Your IP : 216.73.216.3 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/appsrv.astacus.se/gps2xml/ |
Upload File : |
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("gps2xml");
$username = $_GET['username'];
$password = md5($_GET['password']);
$unitid = $_GET['id'];
$data = $_GET['data'];
$checksum = $_GET['checksum'];
/*if($unitid == "" || $unitid == "[OPTIONAL]"){
$unitid = 0;
}
$sql = "SELECT * from tblUsers where username = '".$username."' and password = '".$password."'";
$result = mysql_query($sql);
$logedin = false;
while ($row = mysql_fetch_assoc($result)){
$logedin = true;
}
*/
$logedin = true;
if($logedin){
$sql = "SELECT * from tblData where checksum = '".$checksum."'";
$result = mysql_query($sql);
// < 59.64837680, 17.93042580> /- 150.00m (speed -1.00 mps / course -1.00) @ 10/3/10 8:12:05 PM Central European Summer Time
$xml .= '<?xml version="1.0" encoding="UTF-8"?>';
$xml .= '<kml xmlns="http://www.google.com/earth/kml/2">';
$xml .= '<Document>';
$xml .= '<name>Locations.kml</name>';
$x = 0;
while ($row = mysql_fetch_assoc($result)){
$data = $row['data'];
$x++;
$xml .= '<Placemark>';
$xml .= '<name>Position '.$x.'</name>';
$temppos1 = strpos($data,"speed");
$temppos2= strpos($data,"mps");
$speed = substr($data,$temppos1+6,$temppos2-$temppos1-7);
$temppos1 = strpos($data,"/");
$temppos2 = strpos($data,"m (");
$accuracy = substr($data,$temppos1+3,$temppos2-$temppos1-3);
$temppos1 = strpos($data,"course");
$temppos2= strpos($data,")");
$course = substr($data,$temppos1+7,$temppos2-$temppos1-7);
$temppos = strpos($data,">");
$position = substr($data,2,$temppos-2);
$position = str_replace(' ','',$position);
$temppos = strpos($position,",");
$part1 = substr($position,0,$temppos-1);
$part2 = substr($position,$temppos+1,15);
$xml .= '<description><![CDATA[Location: '.$position.', Speed: '.$speed.', Accuracy: '.$accuracy .', Course: '.$course.']]></description>';
$xml .= '<Point>';
$xml .= '<coordinates>'.$part2.','.$part1.',0</coordinates>';
$xml .= '</Point>';
$xml .= '</Placemark>';
}
$xml .= '</Document>';
$xml .= '</kml>';
header("Content-type: text/xml");
//header('Content-Disposition: attachment; filename="'.$unitid.'.xml"');
echo($xml);
}
?>