// check XY home if OK redirect to myn
if ($usr == true) {
$ulat = $applicationContainer->getLoggedUser()->getHomeCoordinates()->getLatitude();
$ulon = $applicationContainer->getLoggedUser()->getHomeCoordinates()->getLongitude();
if ($ulon != NULL && $ulat != NULL || $ulon != 0 && $ulat != 0) {
$distancecache = sprintf("%.2f", calcDistance($ulat, $ulon, $geocache->getCoordinates()->getLatitude(), $geocache->getCoordinates()->getLongitude()));
tpl_set_var('distance_cache', '<img src="tpl/stdstyle/images/free_icons/car.png" class="icon16" alt="distance" title="" align="middle" /> ' . tr('distance_to_cache') . ': <b>' . $distancecache . ' km</b><br />');
} else {
tpl_set_var('distance_cache', '');
}
} else {
tpl_set_var('distance_cache', '');
}
// check if there is geokret in this cache
$thatquery = "SELECT gk_item.id, name, distancetravelled as distance FROM gk_item INNER JOIN gk_item_waypoint ON (gk_item.id = gk_item_waypoint.id) WHERE gk_item_waypoint.wp = :v1 AND stateid<>1 AND stateid<>4 AND stateid <>5 AND typeid<>2 AND missing=0";
$params['v1']['value'] = (string) $geocache->getGeocacheWaypointId();
$params['v1']['data_type'] = 'string';
$s = $dbc->paramQuery($thatquery, $params);
unset($params);
//clear to avoid overlaping on next paramQuery (if any))
$geokrety_all_count = $dbc->rowCount($s);
if ($geokrety_all_count == 0) {
// no geokrets in this cache
tpl_set_var('geokrety_begin', '<!--');
tpl_set_var('geokrety_end', '-->');
tpl_set_var('geokrety_content', '');
} else {
// geokret is present in this cache
$geokrety_content = '';
$geokrety_all = $dbc->dbResultFetchAll($s);
for ($i = 0; $i < $geokrety_all_count; $i++) {