<?
header('Content-type: application/json');
include_once('../db_vars.php');
require_once 'geoIP/vendor/autoload.php';
use GeoIp2\Database\Reader;

$json = array();
$udid = isset($_GET['udid']) ? $_GET['udid'] : '';
$limit = 50;

// Ger User Country - No City
$reader_country = new Reader('geoIP/GeoLite2-Country.mmdb');
$record_country = $reader_country->country($_SERVER['REMOTE_ADDR']);
$country = $record_country->country->isoCode;

$count = 1;
$query = "SELECT id, conn_type, time, local_timedate, download_mbps, upload_mbps, ping, server, isp, latitude, longitude, data, ssid FROM speedsmart_results WHERE device_key = '$udid' and is_visible = 1 ORDER BY id DESC LIMIT 0,$limit";
$result = mysqli_query($db, $query);
while($r = mysqli_fetch_array($result, MYSQLI_ASSOC))
{

$id = $r['id'];
$conn_type = $r['conn_type'];
$server_time = $r['time'];
$local_timedate = $r['local_timedate'];
$download_mbps = $r['download_mbps'];
$upload_mbps = $r['upload_mbps'];
$ping = $r['ping'];
$server = $r['server'];
$isp = $r['isp'];
$latitude = $r['latitude'];
$longitude = $r['longitude'];
$data = $r['data'];
$ssid = $r['ssid'];

// Format date for Region
$date = new DateTime(preg_replace('/(.*?)-(.*)/', '$1', $local_timedate));  ;
$longTime = preg_replace('/.*-/', '$1', $local_timedate);  

$pull_datetime  	= explode('-',$local_timedate);
$result_date 		= $pull_datetime[0];
$result_time 		= $pull_datetime[1];
$pull_date 			= explode('/',$result_date);

if (($country === 'FM') || ($country === 'US') || ($country === 'CA') || ($country === 'ZW')) {
	$longDate 			= $date->format("F d, Y");
	$local_timedate 		= $local_timedate;
} elseif (($country === 'CN') || ($country === 'LT') || ($country === 'JP') || ($country === 'KR') || ($country === 'MN') || ($country === 'TW')) {
	$longDate 			= $date->format("Y, F d");
	$world_date_format	= $pull_date[2].'/'.$pull_date[1].'/'.$pull_date[0];
	$local_timedate 		= $world_date_format.'-'.$result_time;
} else {
	$longDate 			= $date->format("d F, Y");
	$world_date_format	= $pull_date[1].'/'.$pull_date[0].'/'.$pull_date[2];
	$local_timedate 		= $world_date_format.'-'.$result_time;
}


$json[] = array(
	'resultID'		=>$id, 
	'connType'		=>$conn_type, 
	'localDate'		=> $local_timedate, 
	'longDate'		=> $longDate, 
	'longTime'		=> $longTime, 
	'download'		=> $download_mbps, 
	'upload'		=> $upload_mbps, 
	'ping'		=> $ping, 
	'server'		=> $server, 
	'isp'			=> $isp, 
	'latitude'		=> $latitude, 
	'longitude'		=> $longitude,
	'data'		=> $data,
	'ssid'		=> $ssid
);

$count ++;
}
echo json_encode(array('resultHistory' => $json), JSON_PRETTY_PRINT);
?>