????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.216.55 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'];
/*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 username = '".$username."' and unitid = '".$unitid."'";
$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="iso-8859-1"?>';
$xml .= '<gpsdata>';
$xml .= '<info>';
$xml .= '<username>'.$username.'</username>';
$xml .= '<unitid>'.$unitid.'</unitid>';
$xml .= '</info>';
$xml .= '<data>';
while ($row = mysql_fetch_assoc($result)){
$data = $row['data'];
$xml .= '<placemark>';
$temppos = strpos($data,">");
$position = substr($data,2,$temppos-2);
$xml .= '<coordinates>'.$position.'</coordinates>';
$temppos1 = strpos($data,"/");
$temppos2 = strpos($data,"m (");
$accuracy = substr($data,$temppos1+3,$temppos2-$temppos1-3);
$xml .= '<accuracy>'.$accuracy.'</accuracy>';
$temppos1 = strpos($data,"speed");
$temppos2= strpos($data,"mps");
$speed = substr($data,$temppos1+6,$temppos2-$temppos1-7);
$xml .= '<speed>'.$speed.'</speed>';
$temppos1 = strpos($data,"course");
$temppos2= strpos($data,")");
$course = substr($data,$temppos1+7,$temppos2-$temppos1-7);
$xml .= '<course>'.$course.'</course>';
$temppos = strpos($data,"@");
$date = substr($data,$temppos+2,100);
$xml .= '<date>'.$date.'</date>';
$xml .= '</placemark>';
}
$xml .= '</data>';
$xml .= '</gpsdata>';
header("Content-type: application/octet-stream");
header('Content-Disposition: attachment; filename="'.$unitid.'.xml"');
echo($xml);
}
?>