}
//$content .= '</div>';
// ----------- begin Find section -------------------------------------
$content .= '<p> </p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1"> <img src="tpl/stdstyle/images/blue/cache-open.png" class="icon32" alt="Caches Find" title="Caches Find" /> ' . tr('stat_number_found') . '</p></div><br />';
$seek = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM cache_logs\n WHERE (type=1 OR type=2) AND cache_logs.deleted='0' AND user_id= :1\n GROUP BY YEAR(`date`), MONTH(`date`), DAY(`date`)", 0, $user_id);
if ($seek == 0) {
$content .= '<br /><p> <b>' . tr('not_found_caches') . '</b></p>';
} else {
$events_count = XDb::xMultiVariableQueryValue("SELECT COUNT(*) events_count FROM cache_logs\n WHERE user_id= :1 AND type=7 AND deleted=0", 0, $user_id);
$days_since_first_find = XDb::xMultiVariableQueryValue("SELECT datediff(now(), date) as old FROM cache_logs\n WHERE deleted=0 AND user_id = :1 AND type=1 ORDER BY date LIMIT 1", 0, $user_id);
$rsfc2 = XDb::xSql("SELECT cache_logs.cache_id cache_id, DATE_FORMAT(cache_logs.date,'%d-%m-%Y') data, caches.wp_oc cache_wp\n FROM cache_logs, caches\n WHERE caches.cache_id=cache_logs.cache_id AND cache_logs.type='1'\n AND cache_logs.user_id= ? AND cache_logs.deleted='0'\n ORDER BY cache_logs.date DESC LIMIT 1", $user_id);
$rfc2 = XDb::xFetchArray($rsfc2);
$rcNumber = XDb::xMultiVariableQueryValue("SELECT COUNT(*) number FROM cache_logs\n WHERE type=1 AND cache_logs.deleted='0' AND user_id= :1\n GROUP BY YEAR(`date`), MONTH(`date`), DAY(`date`)\n ORDER BY number DESC LIMIT 1", 0, $user_id);
$moved = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM `cache_logs`\n WHERE type=4 AND cache_logs.deleted='0' AND user_id= :1", 0, $user_id);
$num_rows = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM (\n SELECT COUNT(*) FROM cache_logs\n WHERE type=1 AND cache_logs.deleted='0' AND user_id= :1\n GROUP BY YEAR(`date`), MONTH(`date`), DAY(`date`)\n ) AS COUNTS_IN_DAYS", 0, $user_id);
$found = $user->getFoundGeocachesCount();
if ($num_rows == 0) {
$aver2 = 0;
} else {
$aver2 = round($found / $num_rows, 2);
}
if (date('m') == 4 and date('d') == 1) {
//prima aprilis :)
$found = rand(-10, 10);
$user_record['notfounds_count'] = rand(666, 9999);
}
$content .= '<p><span class="content-title-noshade txt-blue08">' . tr('total_number_found_caches') . ':</span><strong> ' . $found . '</strong>';
if ($found == 0) {
$content .= '</p>';
} else {
$content .= ' <img src="tpl/stdstyle/images/blue/arrow.png" alt="" /> [<a class="links" href="my_logsFind.php?userid=' . $user_id . '">' . tr('show') . '</a>]</p>';
