<?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 . ')';