`caches`.`difficulty` `difficulty`,
`caches`.`terrain` `terrain`,
`caches`.`founds` `founds`,
`caches`.`status` `status`,
`caches`.`user_id` `user_id`
FROM `caches`
WHERE `caches`.`cache_id` NOT IN (SELECT `cache_ignore`.`cache_id` FROM `cache_ignore` WHERE `cache_ignore`.`user_id`=\'' . $user_id . '\') AND caches.status<>4 AND caches.status<>5 AND caches.status <>6
AND `longitude` > ' . ($lon - $max_lon_diff) . '
AND `longitude` < ' . ($lon + $max_lon_diff) . '
AND `latitude` > ' . ($lat - $max_lat_diff) . '
AND `latitude` < ' . ($lat + $max_lat_diff) . '
HAVING `distance` < ' . $distance);
sql('ALTER TABLE local_caches ADD PRIMARY KEY ( `cache_id` ),
ADD INDEX(`cache_id`), ADD INDEX (`wp_oc`), ADD INDEX(`type`), ADD INDEX(`name`), ADD INDEX(`user_id`), ADD INDEX(`date_hidden`), ADD INDEX(`date_created`)');
// Read coordinates of the newest caches
$markerpositions = get_marker_positions($latitude, $longitude, $radius, $user_id);
// Generate include file for map with new caches
tpl_set_var('local_cache_map', '<img src="' . create_map_url($markerpositions, -1, $latitude, $longitude) . '" basesrc="' . create_map_url($markerpositions, -1, $latitude, $longitude) . '" id="main-cachemap" name="main-cachemap" alt="mapa" />');
// $file_content = '<img src="' . create_map_url($markerpositions, -1,$latitude,$longitude) . '" basesrc="' . create_map_url($markerpositions, -1,$latitude,$longitude) . '" id="main-cachemap" name="main-cachemap" alt="mapa" />';
// $n_file = fopen($dynstylepath . "local_cachemap.inc.php", 'w');
// fwrite($n_file, $file_content);
// fclose($n_file);
//start_newcaches.include
$rs = sql("SELECT `user`.`user_id` `user_id`,\n `user`.`username` `username`,\n `caches`.`cache_id` `cache_id`,\n `caches`.`name` `name`,\n `caches`.`longitude` `longitude`,\n `caches`.`latitude` `latitude`,\n `caches`.`date_hidden` `date_hidden`,\n `caches`.`date_created` `date_created`,\n IF((`caches`.`date_hidden`>`caches`.`date_created`), `caches`.`date_hidden`, `caches`.`date_created`) AS `date`,\n `caches`.`country` `country`,\n `caches`.`difficulty` `difficulty`,\n `caches`.`terrain` `terrain`,\n `cache_type`.`icon_large` `icon_large`\n FROM local_caches `caches` INNER JOIN `user` ON (`caches`.`user_id`=`user`.`user_id`), `cache_type`\n WHERE `caches`.`type`!=6\n AND `caches`.`status`=1\n AND `caches`.`type`=`cache_type`.`id`\n AND `caches`.`date_created` <= NOW()\n AND `caches`.`date_hidden` <= NOW()\n ORDER BY `date` DESC, `caches`.`cache_id` DESC\n LIMIT 0 , 10");
$rsc = sql("SELECT `user`.`user_id` `user_id`,\n `user`.`username` `username`,\n `caches`.`cache_id` `cache_id`,\n `caches`.`name` `name`,\n `caches`.`longitude` `longitude`,\n `caches`.`latitude` `latitude`,\n `caches`.`date_hidden` `date_hidden`,\n `caches`.`date_created` `date_created`,\n IF((`caches`.`date_hidden`>`caches`.`date_created`), `caches`.`date_hidden`, `caches`.`date_created`) AS `date`,\n `caches`.`country` `country`,\n `caches`.`difficulty` `difficulty`,\n `caches`.`terrain` `terrain`,\n `cache_type`.`icon_large` `icon_large`\n FROM local_caches `caches` INNER JOIN `user` ON (`caches`.`user_id`=`user`.`user_id`), `cache_type`\n WHERE `caches`.`type`!=6\n AND `caches`.`status`=1\n AND `caches`.`type`=`cache_type`.`id`\n AND `caches`.`date_created` <= NOW()\n AND `caches`.`date_hidden` <= NOW()\n ORDER BY `date` DESC, `caches`.`cache_id` DESC");
if (mysql_num_rows($rsc) > 10) {
tpl_set_var('more_caches', '<a class="links" href="myn_newcaches.php">[' . tr("show_more") . '...]</a>');
}
mysql_free_result($rsc);
if (mysql_num_rows($rs) == 0) {
$file_content = "<p> <b>" . tr('list_of_caches_is_empty') . "</b></p><br>";
setlocale(LC_TIME, 'pl_PL.UTF-8');
global $lang, $rootpath;
if (!isset($rootpath)) {
$rootpath = __DIR__ . '/../../../';
}
//include template handling
require_once $rootpath . 'lib/common.inc.php';
require_once $rootpath . 'lib/cache_icon.inc.php';
// Map parameters
$map_center_lat = $main_page_map_center_lat;
$map_center_lon = $main_page_map_center_lon;
$map_zoom = $main_page_map_zoom;
$map_width = $main_page_map_width;
$map_height = $main_page_map_height;
// Read coordinates of the newest caches
$markerpositions = get_marker_positions();
// Generate include file for map with new caches
$google_map = sprintf("//maps.google.com/maps/api/staticmap?center=%F,%F&zoom=%d&size=%dx%d&maptype=roadmap&key=%s&sensor=false", $map_center_lat, $map_center_lon, $map_zoom, $map_width, $map_height, $googlemap_key);
$file_content = '<img src="' . $google_map . '" id="main-cachemap" name="main-cachemap" alt="{{map}}" />';
// Calculate positions for small and large images highlighting recent caches and events
$markers = $markerpositions['markers'];
$small_markers = '';
$big_markers = '';
foreach ($markers as $i => $marker) {
$markerposleft = lon_offset($marker['lon'], $map_center_lon, $map_width, $map_zoom);
$markerpostop = lat_offset($marker['lat'], $map_center_lat, $map_height, $map_zoom);
$type = strtoupper(typeToLetter($marker['type']));
if (strcmp($type, 'E') == 0) {
$small_marker = 'mark-small-orange.png';
$big_marker = 'marker-orangeE.png';
} else {
