<?php
global $rootpath;
require_once './lib/common.inc.php';
require_once './lib/class.polylineEncoder.php';
$route_id = $_REQUEST['routeid'];
$rscp = XDb::xSql("SELECT `lat` ,`lon`\n FROM `route_points`\n WHERE `route_id`= ? ", $route_id);
$p = array();
$points = array();
for ($i = 0; false != ($record = XDb::xFetchArray($rscp)); $i++) {
$y = $record['lon'];
$x = $record['lat'];
$p[0] = $x;
$p[1] = $y;
$points[$i] = $p;
}
$encoder = new PolylineEncoder();
$polyline = $encoder->encode($points);
?>
<script type="text/javascript" src="/lib/jsts/attache.array.min.js"></script>
<script type="text/javascript" src="/lib/jsts/javascript.util.js"></script>
<script type="text/javascript" src="/lib/jsts/jsts.0.13.2.js"></script>
<script type="text/javascript" src="/lib/js/myroutes_map.<?php
echo date("YmdHis", filemtime($rootpath . 'lib/js/myroutes_map.js'));
?>
.js"></script>
<script type="text/javascript">
//<![CDATA[
var currentinfowindow = null;
// 'Mobile'
$uamType[10] = 'D';
// 'Drive-in'
if ($usr || !$hide_coords) {
// prepare the output
$caches_per_page = 20;
$query = 'SELECT ';
if (isset($lat_rad) && isset($lon_rad)) {
$query .= getSqlDistanceFormula($lon_rad * 180 / 3.14159, $lat_rad * 180 / 3.14159, 0, $multiplier[$distance_unit]) . ' `distance`, ';
} else {
if ($usr === false) {
$query .= '0 distance, ';
} else {
// get the users home coords
$rs_coords = XDb::xSql("SELECT `latitude`, `longitude` FROM `user` WHERE `user_id`= ? LIMIT 1", $usr['userid']);
$record_coords = XDb::xFetchArray($rs_coords);
if ($record_coords['latitude'] == NULL || $record_coords['longitude'] == NULL || ($record_coords['latitude'] == 0 || $record_coords['longitude'] == 0)) {
$query .= '0 distance, ';
} else {
// TODO: load from the users-profile
$distance_unit = 'km';
$lon_rad = $record_coords['longitude'] * 3.14159 / 180;
$lat_rad = $record_coords['latitude'] * 3.14159 / 180;
$query .= getSqlDistanceFormula($record_coords['longitude'], $record_coords['latitude'], 0, $multiplier[$distance_unit]) . ' `distance`, ';
}
XDb::xFreeResults($rs_coords);
}
}
$query .= '`caches`.`cache_id` `cache_id`, `caches`.`status` `status`, `caches`.`type` `type`, `caches`.`size` `size`, `caches`.`longitude` `longitude`, `caches`.`latitude` `latitude`, `caches`.`user_id` `user_id`
FROM `caches`
WHERE `caches`.`cache_id` IN (' . $queryFilter . ')';
