if (sizeof($listed_on) == 0) {
tpl_set_var('hidelistingsites_start', '<!--');
tpl_set_var('hidelistingsites_end', '-->');
} else {
tpl_set_var('hidelistingsites_start', '');
tpl_set_var('hidelistingsites_end', '');
}
//cache available
$st = $geocache->dictionary->getCacheStatuses();
if ($geocache->getStatus() != 1) {
tpl_set_var('status', $error_prefix . htmlspecialchars(tr($st[$geocache->getStatus()]['translation']), ENT_COMPAT, 'UTF-8') . $error_suffix);
} else {
tpl_set_var('status', '<span style="color:green;font-weight:bold;">' . htmlspecialchars(tr($st[$geocache->getStatus()]['translation']), ENT_COMPAT, 'UTF-8') . '</span>');
}
tpl_set_var('date_created', $geocache->getDateCreated()->format($applicationContainer->getOcConfig()->getDateFormat()));
tpl_set_var('difficulty_icon_diff', icon_difficulty("diff", $geocache->getDifficulty()));
tpl_set_var('difficulty_text_diff', htmlspecialchars(sprintf($difficulty_text_diff, $geocache->getDifficulty() / 2), ENT_COMPAT, 'UTF-8'));
tpl_set_var('difficulty_icon_terr', icon_difficulty("terr", $geocache->getTerrain()));
tpl_set_var('difficulty_text_terr', htmlspecialchars(sprintf($difficulty_text_terr, $geocache->getTerrain() / 2), ENT_COMPAT, 'UTF-8'));
tpl_set_var('founds', htmlspecialchars($geocache->getFounds(), ENT_COMPAT, 'UTF-8'));
tpl_set_var('notfounds', htmlspecialchars($geocache->getNotFounds(), ENT_COMPAT, 'UTF-8'));
tpl_set_var('notes', htmlspecialchars($geocache->getNotesCount(), ENT_COMPAT, 'UTF-8'));
tpl_set_var('total_number_of_logs', htmlspecialchars($geocache->getFounds() + $geocache->getNotFounds() + $geocache->getNotesCount(), ENT_COMPAT, 'UTF-8'));
// Personal cache notes
//user logged in?
if ($usr == true) {
$s = $dbc->multiVariableQuery("SELECT `cache_notes`.`note_id` `note_id`,`cache_notes`.`date` `date`, `cache_notes`.`desc` `desc`, `cache_notes`.`desc_html` `desc_html` FROM `cache_notes` WHERE `cache_notes` .`user_id`=:1 AND `cache_notes`.`cache_id`=:2", $usr['userid'], $cache_id);
$cacheNotesRowCount = $dbc->rowCount($s);
if ($cacheNotesRowCount > 0) {
$notes_record = $dbc->dbResultFetchOneRowOnly($s);
}