$sLogTypeText = t("%1 wants to visit the event", $log_record['log_username']);
break;
default:
$sLogTypeText = $log_record['log_username'];
break;
}
tpl_set_var('cachename', htmlspecialchars($log_record['cache_name'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('cacheid', htmlspecialchars($log_record['cache_id'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('logid_urlencode', htmlspecialchars(urlencode($log_id), ENT_COMPAT, 'UTF-8'));
tpl_set_var('logid', htmlspecialchars($log_id, ENT_COMPAT, 'UTF-8'));
if ($log_record['oc_team_comment']) {
$teamimg = '<img src="resource2/ocstyle/images/oclogo/oc-team-comment.png" title="' . t('OC team comment') . '" /> ';
} else {
$teamimg = "";
}
tpl_set_var('logimage', $teamimg . icon_log_type($log_record['icon_small'], ""));
tpl_set_var('date', htmlspecialchars(strftime($dateformat, strtotime($log_record['log_date'])), ENT_COMPAT, 'UTF-8'));
tpl_set_var('time', substr($log_record['log_date'], 11) == "00:00:00" ? "" : ", " . substr($log_record['log_date'], 11, 5));
tpl_set_var('userid', htmlspecialchars($log_record['log_user_id'] + 0, ENT_COMPAT, 'UTF-8'));
tpl_set_var('username', htmlspecialchars($log_record['log_username'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('typetext', htmlspecialchars($sLogTypeText, ENT_COMPAT, 'UTF-8'));
tpl_set_var('logtext', $log_record['log_text']);
tpl_set_var('log_user_name', htmlspecialchars($log_record['log_username'], ENT_COMPAT, 'UTF-8'));
} else {
//TODO: hm ... no permission to remove the log
}
} else {
//TODO: log doesn't exist
}
}
}
}
$content .= '</p><br /><div><ul style="margin: -0.9em 0px 0.9em 0px; padding: 0px 0px 0px 10px; list-style-type: none; line-height: 1.6em; font-size: 12px;">';
for ($i = 0; $i < mysql_num_rows($rs_logs); $i++) {
$record_logs = sql_fetch_array($rs_logs);
$tmp_log = $cache_line_my_caches;
if ($record_logs['geokret_in'] != '0') {
$tmp_log = mb_ereg_replace('{gkimage}', '<img src="images/gk.png" border="0" alt="" title="GeoKret" />', $tmp_log);
} else {
$tmp_log = mb_ereg_replace('{gkimage}', '<img src="images/rating-star-empty.png" border="0" alt=""/>', $tmp_log);
}
if ($record_logs['recommended'] == 1 && $record_logs['log_type'] == 1) {
$tmp_log = mb_ereg_replace('{rateimage}', '<img src="images/rating-star.png" border="0" alt=""/>', $tmp_log);
} else {
$tmp_log = mb_ereg_replace('{rateimage}', '<img src="images/rating-star-empty.png" border="0" alt=""/>', $tmp_log);
}
$tmp_log = mb_ereg_replace('{logimage}', icon_log_type($record_logs['icon_small'], "..."), $tmp_log);
$tmp_log = mb_ereg_replace('{cacheimage}', $record_logs['cache_icon_small'], $tmp_log);
$tmp_log = mb_ereg_replace('{date}', $record_logs['log_date'], $tmp_log);
$tmp_log = mb_ereg_replace('{cachename}', htmlspecialchars($record_logs['cache_name'], ENT_COMPAT, 'UTF-8'), $tmp_log);
$tmp_log = mb_ereg_replace('{wpname}', htmlspecialchars($record_logs['wp_name'], ENT_COMPAT, 'UTF-8'), $tmp_log);
$tmp_log = mb_ereg_replace('{cacheid}', htmlspecialchars($record_logs['cache_id'], ENT_COMPAT, 'UTF-8'), $tmp_log);
// ukrywanie nicka autora komentarza COG przed zwykłym userem
// (Łza)
if ($record_logs['log_type'] == 12 && !$usr['admin']) {
$record_logs['user_name'] = 'Centrum Obsługi Geocachera';
$record_logs['user_id'] = 0;
}
// koniec ukrywania nicka autora komentarza COG
$tmp_log = mb_ereg_replace('{userid}', htmlspecialchars($record_logs['user_id'], ENT_COMPAT, 'UTF-8'), $tmp_log);
$tmp_log = mb_ereg_replace('{username}', htmlspecialchars($record_logs['user_name'], ENT_COMPAT, 'UTF-8'), $tmp_log);
$tmp_log = mb_ereg_replace('{logid}', htmlspecialchars(urlencode($record_logs['id']), ENT_COMPAT, 'UTF-8'), $tmp_log);
function removelog($log_id, $language, $lang)
{
global $tplname, $usr, $lang, $stylepath, $oc_nodeid, $error_wrong_node, $removed_message_title, $removed_message_end, $emailheaders, $rootpath, $cacheid, $log_record, $cache_types, $cache_size, $cache_status, $dblink, $octeamEmailsSignature;
$log_rs = sql("SELECT `cache_logs`.`node` AS `node`, `cache_logs`.`uuid` AS `uuid`, `cache_logs`.`cache_id` AS `cache_id`, `caches`.`user_id` AS `cache_owner_id`,\n `caches`.`name` AS `cache_name`, `cache_logs`.`text` AS `log_text`, `cache_logs`.`type` AS `log_type`,\n `cache_logs`.`user_id` AS `log_user_id`, `cache_logs`.`date` AS `log_date`,\n `log_types`.`icon_small` AS `icon_small`,\n `log_types_text`.`text_listing` AS `text_listing`,\n `user`.`username` as `log_username`\n FROM `log_types`, `log_types_text`, `cache_logs`, `caches`, `user`\n WHERE `cache_logs`.`id`='&1'\n AND `cache_logs`.`user_id`=`user`.`user_id`\n AND `caches`.`cache_id`=`cache_logs`.`cache_id`\n AND `log_types_text`.`log_types_id`=`log_types`.`id` AND `log_types_text`.`lang`='&2'\n AND `cache_logs`.`deleted` = &3\n AND `log_types`.`id`=`cache_logs`.`type`", $log_id, $lang, 0);
//log exists?
if (mysql_num_rows($log_rs) == 1) {
$log_record = sql_fetch_array($log_rs);
mysql_free_result($log_rs);
include $stylepath . '/removelog.inc.php';
if ($log_record['node'] != $oc_nodeid) {
tpl_errorMsg('removelog', $error_wrong_node);
exit;
}
//cache-owner or log-owner
if ($log_record['log_user_id'] == $usr['userid'] || $log_record['cache_owner_id'] == $usr['userid'] || $usr['admin']) {
if ($usr['admin'] && isset($_POST['userid'])) {
$commit = 1;
} else {
$commit = isset($_REQUEST['commit']) ? $_REQUEST['commit'] : 0;
}
//we are the logger
if ($log_record['log_user_id'] == $usr['userid']) {
$tplname = 'removelog_logowner';
} else {
$tplname = 'removelog_cacheowner';
if ($commit == 1) {
//send email to logowner schicken
$email_content = read_file($stylepath . '/email/removed_log.email');
$message = isset($_POST['logowner_message']) ? $_POST['logowner_message'] : '';
if ($message != '') {
//message to logowner
$message = $removed_message_title . "\n" . $message . "\n" . $removed_message_end;
}
//get cache owner name
$cache_owner_rs = sql("SELECT `username` FROM `user` WHERE `user_id`='&1'", $log_record['cache_owner_id']);
$cache_owner_record = sql_fetch_array($cache_owner_rs);
//get email address of logowner
$log_user_rs = sql("SELECT `email`, `username` FROM `user` WHERE `user_id`='&1'", $log_record['log_user_id']);
$log_user_record = sql_fetch_array($log_user_rs);
$email_content = mb_ereg_replace('{log_owner}', $log_user_record['username'], $email_content);
$email_content = mb_ereg_replace('{cache_owner}', $cache_owner_record['username'], $email_content);
$email_content = mb_ereg_replace('{cache_name}', $log_record['cache_name'], $email_content);
$email_content = mb_ereg_replace('{log_entry}', $log_record['log_text'], $email_content);
$email_content = mb_ereg_replace('{comment}', $message, $email_content);
$email_content = mb_ereg_replace('{removedLog_01}', tr('removedLog_01'), $email_content);
$email_content = mb_ereg_replace('{removedLog_02}', tr('removedLog_02'), $email_content);
$email_content = mb_ereg_replace('{removedLog_03}', tr('removedLog_03'), $email_content);
$email_content = mb_ereg_replace('{octeamEmailsSignature}', $octeamEmailsSignature, $email_content);
$email_content = mb_ereg_replace('{removedLog_04}', tr('removedLog_04'), $email_content);
//send email (only on single removement)
mb_send_mail($log_user_record['email'], $removed_log_title, $email_content, $emailheaders);
}
}
if ($commit == 1) {
// do not acually delete logs - just mark them as deleted.
sql("UPDATE `cache_logs` SET deleted = 1, `del_by_user_id` =" . $usr['userid'] . " , `last_modified`=NOW(), `last_deleted`=NOW() WHERE `cache_logs`.`id`='&1' LIMIT 1", $log_id);
recalculateUserStats($log_record['log_user_id']);
// remove from cache_moved for log "MOVED" (mobilniaki by Łza)
// (kod istniejący wcześniej, zaadaptowany)
if ($log_record['log_type'] == 4) {
// jesli log jest ostatni - przywrocenie kordow z przedostatniego "przeniesiona"
$check_cml = sql("SELECT `latitude`,`longitude`,`id` FROM `cache_moved` WHERE `log_id`='&1'", $log_id);
if (mysql_num_rows($check_cml) != 0) {
$xy_log = sql_fetch_array($check_cml);
$check_cmc = sql("SELECT `latitude`,`longitude` FROM `caches` WHERE `cache_id`='&1'", $log_record['cache_id']);
if (mysql_num_rows($check_cmc) != 0) {
$xy_cache = sql_fetch_array($check_cmc);
if ($xy_cache['latitude'] == $xy_log['latitude'] && $xy_cache['longitude'] == $xy_log['longitude']) {
sql("DELETE FROM `cache_moved` WHERE `log_id`='&1' LIMIT 1", $log_id);
$get_xy = sql("SELECT `latitude`,`longitude` FROM `cache_moved` WHERE `cache_id`='&1' ORDER BY `date` DESC LIMIT 1", $log_record['cache_id']);
$old_xy = sql_fetch_array($get_xy);
if ($old_xy['longitude'] != '' && $old_xy['latitude'] != '') {
sql("UPDATE `caches` SET `last_modified`=NOW(), `longitude`='&1', `latitude`='&2' WHERE `cache_id`='&3'", $old_xy['longitude'], $old_xy['latitude'], $log_record['cache_id']);
}
} else {
sql("DELETE FROM `cache_moved` WHERE `log_id`='&1' LIMIT 1", $log_id);
}
} else {
sql("DELETE FROM `cache_moved` WHERE `log_id`='&1' LIMIT 1", $log_id);
}
}
}
if ($log_record['log_type'] == 1 || $log_record['log_type'] == 7) {
// remove cache from users top caches, because the found log was deleted for some reason
sql("DELETE FROM `cache_rating` WHERE `user_id` = '&1' AND `cache_id` = '&2'", $log_record['log_user_id'], $log_record['cache_id']);
// Notify OKAPI's replicate module of the change.
// Details: https://github.com/opencaching/okapi/issues/265
require_once $rootpath . 'okapi/facade.php';
\okapi\Facade::schedule_user_entries_check($log_record['cache_id'], $log_record['log_user_id']);
\okapi\Facade::disable_error_handling();
// recalc scores for this cache
sql("DELETE FROM `scores` WHERE `user_id` = '&1' AND `cache_id` = '&2'", $log_record['log_user_id'], $log_record['cache_id']);
$sql = "SELECT count(*) FROM scores WHERE cache_id='" . sql_escape($log_record['cache_id']) . "'";
$liczba = mysql_result(mysql_query($sql), 0);
$sql = "SELECT SUM(score) FROM scores WHERE cache_id='" . sql_escape($log_record['cache_id']) . "'";
$suma = @mysql_result(@mysql_query($sql), 0) + 0;
// obliczenie nowej sredniej
if ($liczba != 0) {
$srednia = $suma / $liczba;
} else {
$srednia = 0;
}
$sql = "UPDATE caches SET votes='" . sql_escape($liczba) . "', score='" . sql_escape($srednia) . "' WHERE cache_id='" . sql_escape($log_record['cache_id']) . "'";
mysql_query($sql);
}
//call eventhandler
require_once $rootpath . 'lib/eventhandler.inc.php';
event_remove_log($cacheid, $usr['userid'] + 0);
//update cache-stat if type or log_date changed
$cache_rs = sql("SELECT `founds`, `notfounds`, `notes` FROM `caches` WHERE `cache_id`='&1'", $log_record['cache_id']);
$cache_record = sql_fetch_array($cache_rs);
mysql_free_result($cache_rs);
if ($log_record['log_type'] == 1 || $log_record['log_type'] == 7) {
$cache_record['founds']--;
} elseif ($log_record['log_type'] == 2 || $log_record['log_type'] == 8) {
$cache_record['notfounds']--;
} elseif ($log_record['log_type'] == 3) {
$cache_record['notes']--;
}
//Update last found
$last_tmp = $log_record['cache_id'];
$lastfound_rs = sql("SELECT MAX(`cache_logs`.`date`) AS `date` FROM `cache_logs` WHERE ((cache_logs.`type`=1) AND (cache_logs.`cache_id`='{$last_tmp}'))");
$lastfound_record = sql_fetch_array($lastfound_rs);
if ($lastfound_record['date'] === NULL) {
$lastfound = 'NULL';
} else {
$lastfound = $lastfound_record['date'];
}
sql("UPDATE `caches` SET `last_found`='&1', `founds`='&2', `notfounds`='&3', `notes`='&4' WHERE `cache_id`='&5'", $lastfound, $cache_record['founds'], $cache_record['notfounds'], $cache_record['notes'], $log_record['cache_id']);
unset($cache_record);
if (!isset($_POST['userid'])) {
//cache anzeigen
$_GET['cacheid'] = $log_record['cache_id'];
$_REQUEST['cacheid'] = $log_record['cache_id'];
require 'viewcache.php';
}
} else {
tpl_set_var('cachename', htmlspecialchars($log_record['cache_name'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('cacheid', htmlspecialchars($log_record['cache_id'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('logid_urlencode', htmlspecialchars(urlencode($log_id), ENT_COMPAT, 'UTF-8'));
tpl_set_var('logid', htmlspecialchars($log_id, ENT_COMPAT, 'UTF-8'));
$log = read_file($stylepath . '/viewcache_log.tpl.php');
$log = mb_ereg_replace('{date}', htmlspecialchars(strftime("%d %B %Y", strtotime($log_record['log_date'])), ENT_COMPAT, 'UTF-8'), $log);
if (isset($log_record['recommended']) && $log_record['recommended'] == 1) {
$log = mb_ereg_replace('{ratingimage}', $rating_picture, $log);
} else {
$log = mb_ereg_replace('{ratingimage}', '', $log);
}
$log = mb_ereg_replace('{username}', htmlspecialchars($log_record['log_username'], ENT_COMPAT, 'UTF-8'), $log);
$log = mb_ereg_replace('{userid}', htmlspecialchars($log_record['log_user_id'] + 0, ENT_COMPAT, 'UTF-8'), $log);
tpl_set_var('log_user_name', htmlspecialchars($log_record['log_username'], ENT_COMPAT, 'UTF-8'));
$log = mb_ereg_replace('{type}', htmlspecialchars($log_record['text_listing'], ENT_COMPAT, 'UTF-8'), $log);
$log = mb_ereg_replace('{logimage}', icon_log_type($log_record['icon_small'], ""), $log);
$log = mb_ereg_replace('{logfunctions}', '', $log);
$log = mb_ereg_replace('{logpictures}', '', $log);
$log = mb_ereg_replace('{logtext}', $log_record['log_text'], $log);
$log = mb_ereg_replace('{username_aktywnosc}', '', $log);
$log = mb_ereg_replace('{kordy_mobilniaka}', '', $log);
tpl_set_var('log', $log);
//make the template and send it out
tpl_BuildTemplate();
}
} else {
//TODO: hm ... no permission to remove the log
d('no permission to remove the log');
}
} else {
//TODO: log doesn't exist
d('log doesn\'t exist');
}
}
$sql = 'SELECT `cache_logs`.`id` `id`, `cache_logs`.`type` `type`, `cache_logs`.`date` `date`, `log_types`.`icon_small` `icon_small`
FROM `cache_logs`, `log_types`
WHERE `cache_logs`.`cache_id`=\'' . sql_escape($caches_record['cache_id']) . '\'
AND `log_types`.`id`=`cache_logs`.`type`
ORDER BY `cache_logs`.`date` DESC LIMIT 6';
$result = sql_slave($sql);
if ($row = sql_fetch_array($result)) {
$tmpline = mb_ereg_replace('{logimage1}', icon_log_type($row['icon_small'], "") . '<a href=\'viewlogs.php?cacheid=' . htmlspecialchars($caches_record['cache_id'], ENT_COMPAT, 'UTF-8') . '#' . htmlspecialchars($row['id'], ENT_COMPAT, 'UTF-8') . '\'>{gray_s}' . date($logdateformat, strtotime($row['date'])) . '{gray_e}</a>', $tmpline);
$tmpline = mb_ereg_replace('{logdate1}', "", $tmpline);
} else {
$tmpline = mb_ereg_replace('{logimage1}', "<img src='images/trans.gif' border='0' width='16' height='16' />", $tmpline);
$tmpline = mb_ereg_replace('{logdate1}', "--.--.----", $tmpline);
}
$lastlogs = "";
while ($row = sql_fetch_array($result)) {
$lastlogs .= '<a href=\'viewlogs.php?cacheid=' . urlencode($caches_record['cache_id']) . '#' . htmlspecialchars($row['id'], ENT_COMPAT, 'UTF-8') . '\'>' . icon_log_type($row['icon_small'], '') . '</a> ';
}
$tmpline = mb_ereg_replace('{lastlogs}', $lastlogs, $tmpline);
// und jetzt noch die Richtung ...
if ($caches_record['distance'] > 0) {
$tmpline = mb_ereg_replace('{direction}', Bearing2Text(calcBearing($lat_rad / 3.14159 * 180, $lon_rad / 3.14159 * 180, $caches_record['latitude'], $caches_record['longitude']), 1), $tmpline);
} else {
$tmpline = mb_ereg_replace('{direction}', '', $tmpline);
}
$desclangs = '';
$aLangs = mb_split(',', $caches_record['desc_languages']);
foreach ($aLangs as $thislang) {
$desclangs .= '<a href="viewcache.php?cacheid=' . urlencode($caches_record['cache_id']) . '&desclang=' . urlencode($thislang) . '" style="text-decoration:none;"><b><font color="blue">' . htmlspecialchars($thislang, ENT_COMPAT, 'UTF-8') . '</font></b></a> ';
}
$tmpline = mb_ereg_replace('{desclangs}', $desclangs, $tmpline);
$tmpline = mb_ereg_replace('{cachename}', htmlspecialchars($caches_record['name'], ENT_COMPAT, 'UTF-8'), $tmpline);
}
$tmp_cache = mb_ereg_replace('{cachename}', htmlspecialchars($record_caches['name'], ENT_COMPAT, 'UTF-8'), $tmp_cache);
$caches .= "\n" . $tmp_cache;
}
tpl_set_var('notpublishedcaches', $caches);
}
//get last logs in your caches
$rs_logs = sql("\n SELECT `cache_logs`.`cache_id` `cache_id`, `cache_logs`.`type` `type`, `cache_logs`.`date` `date`, `caches`.`name` `name`,\n `log_types`.`icon_small`, `log_types_text`.`text_combo`, `cache_logs`.`user_id` `user_id`, `user`.`username` `username`\n FROM `cache_logs`, `caches`, `log_types`, `log_types_text`, `user`\n WHERE `caches`.`user_id`='&1'\n AND `cache_logs`.`cache_id`=`caches`.`cache_id`\n AND `cache_logs`.`deleted`=0\n AND `user`.`user_id`=`cache_logs`.`user_id`\n AND `log_types`.`id`=`cache_logs`.`type`\n AND `log_types_text`.`log_types_id`=`log_types`.`id` AND `log_types_text`.`lang`='&2'\n ORDER BY `cache_logs`.`date` DESC, `cache_logs`.`date_created` DESC\n LIMIT 10", $usr['userid'], $lang);
if (mysql_num_rows($rs_logs) == 0) {
tpl_set_var('last_logs_in_your_caches', $no_logs);
} else {
$logs = '';
for ($i = 0; $i < mysql_num_rows($rs_logs); $i++) {
$record_logs = sql_fetch_array($rs_logs);
$tmp_log = $cache_line_my_caches;
$tmp_log = mb_ereg_replace('{logimage}', icon_log_type($record_logs['icon_small'], ucfirst(tr('logType' . $record_logs['type']))), $tmp_log);
$tmp_log = mb_ereg_replace('{logtype}', ucfirst(tr('logType' . $record_logs['type'])), $tmp_log);
$tmp_log = mb_ereg_replace('{date}', fixPlMonth(strftime($dateformat, strtotime($record_logs['date']))), $tmp_log);
$tmp_log = mb_ereg_replace('{cachename}', htmlspecialchars($record_logs['name'], ENT_COMPAT, 'UTF-8'), $tmp_log);
$tmp_log = mb_ereg_replace('{cacheid}', htmlspecialchars($record_logs['cache_id'], ENT_COMPAT, 'UTF-8'), $tmp_log);
// ukrywanie nicka autora komentarza COG
// (Łza)
if ($record_logs['type'] == 12 && !$usr['admin']) {
$tmp_log = mb_ereg_replace('{userid}', htmlspecialchars('0', ENT_COMPAT, 'UTF-8'), $tmp_log);
$tmp_log = mb_ereg_replace('{username}', htmlspecialchars('Centrum Obsługi Geocachera', ENT_COMPAT, 'UTF-8'), $tmp_log);
} else {
$tmp_log = mb_ereg_replace('{username}', htmlspecialchars($record_logs['username'], ENT_COMPAT, 'UTF-8'), $tmp_log);
$tmp_log = mb_ereg_replace('{userid}', htmlspecialchars($record_logs['user_id'], ENT_COMPAT, 'UTF-8'), $tmp_log);
}
// koniec ukrywania nicka autora komentarza COG
$logs .= "\n" . $tmp_log;
}
if ($record['text_html'] == 0) {
$processed_text = htmlspecialchars($processed_text, ENT_COMPAT, 'UTF-8');
$processed_text = help_addHyperlinkToURL($processed_text);
} else {
$processed_text = userInputFilter::purifyHtmlStringAndDecodeHtmlSpecialChars($processed_text);
}
$processed_text = str_replace($smileytext, $smileyimage, $processed_text);
$tmplog_text = $processed_text . $edit_footer;
$tmplog = mb_ereg_replace('{show_deleted}', $show_deleted, $tmplog);
$tmplog = mb_ereg_replace('{username}', $tmplog_username, $tmplog);
$tmplog = mb_ereg_replace('{userid}', $record['userid'], $tmplog);
$tmplog = mb_ereg_replace('{date}', $tmplog_date, $tmplog);
$tmplog = mb_ereg_replace('{type}', $record['text_listing'], $tmplog);
$tmplog = mb_ereg_replace('{logtext}', $tmplog_text, $tmplog);
$tmplog = mb_ereg_replace('{logimage}', '<a href="viewlogs.php?logid=' . $record['log_id'] . '">' . icon_log_type($record['icon_small'], $record['log_id']) . '</a>', $tmplog);
$tmplog = mb_ereg_replace('{log_id}', $record['log_id'], $tmplog);
//$rating_picture
if ($record['recommended'] == 1 && $record['type'] == 1) {
$tmplog = mb_ereg_replace('{ratingimage}', '<img src="images/rating-star.png" alt="' . tr('recommendation') . '" />', $tmplog);
} else {
$tmplog = mb_ereg_replace('{ratingimage}', '', $tmplog);
}
//user der owner
$logfunctions = '';
$tmpedit = mb_ereg_replace('{logid}', $record['log_id'], $edit_log);
$tmpremove = mb_ereg_replace('{logid}', $record['log_id'], $remove_log);
$tmpRevert = mb_ereg_replace('{logid}', $record['log_id'], $revertLog);
$tmpnewpic = mb_ereg_replace('{logid}', $record['log_id'], $upload_picture);
if (!isset($record['deleted'])) {
$record['deleted'] = false;
// das letzte found suchen
if ($CalcEntry) {
$sql = 'SELECT `cache_logs`.`id` `id`, `cache_logs`.`type` `type`, `cache_logs`.`date` `date`,
`log_types`.`icon_small` `icon_small`,
cache_logs.text AS log_text
FROM `cache_logs`, `log_types`
WHERE `cache_logs`.`deleted`=0
AND `cache_logs`.`cache_id`=\'' . sql_escape($caches_record['cache_id']) . '\'
AND `log_types`.`id`=`cache_logs`.`type`
ORDER BY `cache_logs`.`date` DESC LIMIT 1';
$dbc->simpleQuery($sql);
if ($row = $dbc->dbResultFetch()) {
$tmpline = str_replace('{logimage1}', icon_log_type($row['icon_small'], "") . '<a href=\'viewlogs.php?cacheid=' . htmlspecialchars($caches_record['cache_id'], ENT_COMPAT, 'UTF-8') . '#' . htmlspecialchars($row['id'], ENT_COMPAT, 'UTF-8') . '\'>{gray_s}' . date($logdateformat, strtotime($row['date'])) . '{gray_e}</a>', $tmpline);
$log_text = PrepareText($row['log_text']);
$tmpline = str_replace('{logimage2}', "<span='" . date($logdateformat_ymd, strtotime($row['date'])) . "'/>" . icon_log_type($row['icon_small'], $log_text) . date($dateFormat, strtotime($row['date'])), $tmpline);
$tmpline = str_replace('{logtype}', icon_log_type($row['icon_small'], $log_text), $tmpline);
$tmpline = str_replace('{logdate}', date($logdateformat_ymd, strtotime($row['date'])), $tmpline);
$tmpline = str_replace('{logdesc}', $log_text, $tmpline);
$tmpline = str_replace('{logdate1}', "", $tmpline);
//
} else {
$tmpline = str_replace('{logimage1}', "<img src='images/trans.gif' border='0' width='16' height='16' />", $tmpline);
$tmpline = str_replace('{logimage2}', "", $tmpline);
$tmpline = str_replace('{logdate1}', "", $tmpline);
$tmpline = str_replace('{logdate}', "", $tmpline);
$tmpline = str_replace('{logtype}', "", $tmpline);
$tmpline = str_replace('{logdesc}', "", $tmpline);
}
$dbc->reset();
}
$lastlogs = "";
