$content .= adminNoteTable(lib\Objects\User\AdminNote::getAllUserNotes($user_id));
}
$ars = XDb::xSql("SELECT\n `user`.`hidden_count` AS `ukryte`,\n `user`.`founds_count` AS `znalezione`,\n `user`.`notfounds_count` AS `nieznalezione`\n FROM `user` WHERE `user_id`= ? ", $user_id);
$record = XDb::xFetchArray($ars);
$act = $record['ukryte'] + $record['znalezione'] + $record['nieznalezione'];
if (date('m') == 4 and date('d') == 1) {
$act = rand(-10, 10);
}
$content .= '<br /><p> </p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1"> <img src="tpl/stdstyle/images/blue/event.png" class="icon32" alt="Caches Find" title="Caches Find" /> ' . tr('user_activity01') . '</p></div><br /><p><span class="content-title-noshade txt-blue08">' . tr('user_activity02') . '</span>: <strong>' . $act . '</strong></p>';
// PowerTrails stats
if ($powerTrailModuleSwitchOn) {
$content .= '<div class="content2-container bg-blue02">
<p class="content-title-noshade-size1">
<img src="tpl/stdstyle/images/blue/powerTrailGenericLogo.png" width="33" class="icon32" alt="geoPaths" title="geoPaths" /> ' . tr('pt001') . '</div>';
//geoPaths medals
$content .= buildPowerTrailIcons($user->getPowerTrailCompleted());
$content .= '<p><span class="content-title-noshade txt-blue08">' . tr('pt140') . '</span>: <strong>' . powerTrailBase::getUserPoints($user_id) . '</strong> (' . tr('pt093') . ' ' . powerTrailBase::getPoweTrailCompletedCountByUser($user_id) . ')</p>';
$pointsEarnedForPlacedCaches = powerTrailBase::getOwnerPoints($user_id);
$content .= buildPowerTrailIcons($user->getPowerTrailOwed());
$content .= '<p><span class="content-title-noshade txt-blue08">' . tr('pt224') . '</span>: <strong>' . $pointsEarnedForPlacedCaches['totalPoints'] . '</strong></p>';
}
//$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);
