}
$loganz = sizeof($logs);
$tpl->assign('logs', $logs);
$tpl->assign('loganz', $loganz);
/*end insertion Uwe 20091215*/
/* nature protection areas
*/
$rs = sql("SELECT `npa_areas`.`id` AS `npaId`, `npa_areas`.`type_id` AS `npaType`, `npa_areas`.`name` AS `npaName`, `npa_types`.`name` AS `npaTypeName` \r\n\t FROM `cache_npa_areas` \r\n\t INNER JOIN `npa_areas` ON `cache_npa_areas`.`npa_id`=`npa_areas`.`id` \r\n\t INNER JOIN `npa_types` ON `npa_areas`.`type_id`=`npa_types`.`id` \r\n\t WHERE `cache_npa_areas`.`cache_id`='&1' AND `npa_types`.`no_warning`=0\r\n\t GROUP BY `npa_areas`.`type_id`, `npa_areas`.`name`\r\n\t ORDER BY `npa_types`.`ordinal` ASC", $cacheid);
$tpl->assign_rs('npaareasWarning', $rs);
sql_free_result($rs);
$rs = sql("SELECT `npa_areas`.`id` AS `npaId`, `npa_areas`.`type_id` AS `npaType`, `npa_areas`.`name` AS `npaName`, `npa_types`.`name` AS `npaTypeName` \r\n\t FROM `cache_npa_areas` \r\n\t INNER JOIN `npa_areas` ON `cache_npa_areas`.`npa_id`=`npa_areas`.`id` \r\n\t INNER JOIN `npa_types` ON `npa_areas`.`type_id`=`npa_types`.`id` \r\n\t WHERE `cache_npa_areas`.`cache_id`='&1' AND `npa_types`.`no_warning`=1\r\n\t GROUP BY `npa_areas`.`type_id`, `npa_areas`.`name`\r\n\t ORDER BY `npa_types`.`ordinal` ASC", $cacheid);
$tpl->assign_rs('npaareasNoWarning', $rs);
sql_free_result($rs);
/* attributes
*/
$tpl->assign('attributes', attribute::getAttrbutesListArrayByCacheId($cacheid));
/* geokrets
*/
$rsGeoKret = sql("SELECT `gk_item`.`id`, `gk_item`.`name` AS `itemname`, `gk_user`.`name` AS `username` FROM `gk_item` INNER JOIN `gk_item_waypoint` ON `gk_item`.`id`=`gk_item_waypoint`.`id` INNER JOIN `gk_user` ON `gk_item`.`userid`=`gk_user`.`id` INNER JOIN `caches` ON `gk_item_waypoint`.`wp`=`caches`.`wp_oc` WHERE `caches`.`cache_id`='&1' AND `gk_item`.`typeid`!=2 AND `gk_item`.`stateid` IN (0, 3) AND `gk_item_waypoint`.`wp`!='' UNION \r\n\t SELECT `gk_item`.`id`, `gk_item`.`name` AS `itemname`, `gk_user`.`name` AS `username` FROM `gk_item` INNER JOIN `gk_item_waypoint` ON `gk_item`.`id`=`gk_item_waypoint`.`id` INNER JOIN `gk_user` ON `gk_item`.`userid`=`gk_user`.`id` INNER JOIN `caches` ON `gk_item_waypoint`.`wp`=`caches`.`wp_gc` WHERE `caches`.`cache_id`='&1' AND `gk_item`.`typeid`!=2 AND `gk_item`.`stateid` IN (0, 3) AND `gk_item_waypoint`.`wp`!='' UNION \r\n\t SELECT `gk_item`.`id`, `gk_item`.`name` AS `itemname`, `gk_user`.`name` AS `username` FROM `gk_item` INNER JOIN `gk_item_waypoint` ON `gk_item`.`id`=`gk_item_waypoint`.`id` INNER JOIN `gk_user` ON `gk_item`.`userid`=`gk_user`.`id` INNER JOIN `caches` ON `gk_item_waypoint`.`wp`=`caches`.`wp_nc` WHERE `caches`.`cache_id`='&1' AND `gk_item`.`typeid`!=2 AND `gk_item`.`stateid` IN (0, 3) AND `gk_item_waypoint`.`wp`!='' ORDER BY `itemname`", $cacheid);
$tpl->assign_rs('geokret', $rsGeoKret);
$tpl->assign('geokret_count', sql_num_rows($rsGeoKret));
sql_free_result($rsGeoKret);
if (isset($_REQUEST['print']) && $_REQUEST['print'] == 'y') {
$tpl->popup = 1;
$tpl->assign('print', true);
$tpl->name = 'viewcache_print';
$tpl->assign('log', $_REQUEST['log']);
}
if ($login->userid > 0) {
$useropt = new useroptions($login->userid);
$tpl->assign('userzoom', $useropt->getOptValue(USR_OPT_GMZOOM));
