$tpl->add_header_javascript('resource2/tinymce/config/log.js.php?logid=0&lang=' . strtolower($opt['template']['locale']));
} else {
$tpl->assign('smileys', smileys::getSmileysArray());
}
// build logtype list
$rs = sql("SELECT `log_types`.`id`, IFNULL(`sys_trans_text`.`text`, `log_types`.`name`) AS `name`\r\n\t FROM `caches` \r\n\t INNER JOIN `cache_type` ON `caches`.`type`=`cache_type`.`id` \r\n\t INNER JOIN `cache_logtype` ON `cache_type`.`id`=`cache_logtype`.`cache_type_id` \r\n\t INNER JOIN `log_types` ON `cache_logtype`.`log_type_id`=`log_types`.`id` \r\n\t LEFT JOIN `sys_trans` ON `log_types`.`trans_id`=`sys_trans`.`id` \r\n\t LEFT JOIN `sys_trans_text` ON `sys_trans`.`id`=`sys_trans_text`.`trans_id` AND `sys_trans_text`.`lang`='&1' \r\n\t WHERE `caches`.`cache_id`='&2'", $opt['template']['locale'], $nCacheId);
$tpl->assign_rs('logtypes', $rs);
sql_free_result($rs);
$tpl->assign('logType', $nLogType);
$tpl->assign('descMode', $nDescMode);
if ($nDescMode != 1) {
$tpl->assign('logText', htmlspecialchars($sLogText, ENT_COMPAT, 'UTF-8'), true);
} else {
$tpl->assign('logText', $sLogText);
}
$tpl->assign('noLogTypeSelected', $noLogTypeSelected);
$tpl->assign('dateFormatInvalid', !$bDateFormatValid);
$tpl->assign('requireLogPW', $cache->requireLogPW());
$tpl->assign('logPWValid', $bLogPWValid);
$tpl->assign('logDateDay', $nLogDateDay);
$tpl->assign('logDateMonth', $nLogDateMonth);
$tpl->assign('logDateYear', $nLogDateYear);
$tpl->assign('userRecommended', $cache->isRecommendedByUser($login->userid));
$tpl->assign('userRecommendationPossible', $nUserRecommendationPossible);
$tpl->assign('userRecommendationUsed', $nUserRecommendationUsed);
$tpl->assign('userRecommendationRequiredFinds', $nUserRecommendationRequiredFinds);
// TODO: $cache->getTemplateInfo()
$rCache['cacheid'] = $nCacheId;
$rCache['cachename'] = $cache->getName();
$tpl->assign('cache', $rCache);
$tpl->display();
function listRequestsByCacheId($cacheid)
{
global $tpl, $login;
// cache exists?
$cache = new cache($cacheid);
if ($cache->exist() == false) {
$tpl->error(ERROR_CACHE_NOT_EXISTS);
}
// is the current user the owner of the cache?
if ($cache->getUserId() != $login->userid) {
$tpl->error(ERROR_NO_ACCESS);
}
$rs = sql("SELECT \n `caches`.`cache_id` AS `id`,\n `user`.`user_id` AS `userid`,\n `user`.`username` AS `username`, \n `cache_adoption`.`date_created`\n\t FROM `caches`\n\t INNER JOIN `cache_adoption` \n\t ON `caches`.`cache_id` = `cache_adoption`.`cache_id`\n\t INNER JOIN `user` \n\t ON `cache_adoption`.`user_id`=`user`.`user_id`\n\t\t WHERE `caches`.`cache_id`='&1'", $cacheid);
$tpl->assign_rs('adoptions', $rs);
sql_free_result($rs);
$tpl->assign('cachename', $cache->getName());
$tpl->display();
}
$reportreason = isset($_REQUEST['reason']) ? $_REQUEST['reason'] + 0 : 0;
$reportnote = isset($_REQUEST['note']) ? $_REQUEST['note'] : '';
$maxreason = sql_value('SELECT MAX(`id`) FROM `cache_report_reasons`', 0);
if (isset($_REQUEST['ok'])) {
$bError = false;
if ($reportnote == '') {
$bError = true;
$tpl->assign('errorNoteEmpty', true);
}
if ($reportreason < 1 || $reportreason > $maxreason) {
$bError = true;
$tpl->assign('errorReasonEmpty', true);
}
if ($bError == false) {
if ($cache->report($login->userid, $reportreason, $reportnote)) {
$reasontext = sql_value("SELECT IFNULL(`tt`.`text`, `crr`.`name`)\r\n\t\t\t\t\t\t\t FROM `cache_report_reasons` AS `crr`\r\n\t\t\t\t\t\t\t INNER JOIN `sys_trans_text` AS `tt` ON `tt`.`trans_id`=`crr`.`trans_id`\r\n\t\t\t\t\t\t\t WHERE `crr`.`id` =&1\r\n\t\t\t\t\t\t\t AND `tt`.`lang`='&2'", 'unknown', $reportreason, $opt['template']['locale']);
$tpl->assign('reasontext', $reasontext);
$tpl->assign('success', true);
} else {
$tpl->assign('errorUnkown', true);
}
}
}
$rs = sql("SELECT `cache_report_reasons`.`id`, IFNULL(`sys_trans_text`.`text`, `cache_report_reasons`.`name`) AS `name`\r\n\t FROM `cache_report_reasons`\r\n\t LEFT JOIN `sys_trans` ON `cache_report_reasons`.`trans_id`=`sys_trans`.`id` AND `cache_report_reasons`.`name`=`sys_trans`.`text`\r\n\t LEFT JOIN `sys_trans_text` ON `sys_trans`.`id`=`sys_trans_text`.`trans_id` AND `sys_trans_text`.`lang`='&1'", $opt['template']['locale']);
$tpl->assign_rs('reasons', $rs);
sql_free_result($rs);
$tpl->assign('reason', $reportreason);
$tpl->assign('note', $reportnote);
$tpl->assign('cacheid', $cacheid);
$tpl->assign('cachename', $cache->getName());
$tpl->display();
