function get_desc_npas($cache_id)
{
global $opt;
$npas = get_npas($cache_id);
if ($npas) {
$desc = "<p>" . str_replace('%1', helppagelink('npa'), _('This geocache is probably placed within the following protected areas (%1Info</a>):')) . "</p>\n" . "<ul>\n";
foreach ($npas as $npa) {
$desc .= "<li>" . $npa['npaTypeName'] . ": <a href='http://www.google.de/search?q=" . urlencode($npa['npaTypeName'] . ' ' . $npa['npaName']) . "' target='_blank'>" . $npa['npaName'] . "</a></li>\n";
}
$desc .= "</ul>\n";
} else {
$desc = "";
}
return $desc;
}
require_once 'lib/consts.inc.php';
$opt['gui'] = GUI_HTML;
require_once 'lib/common.inc.php';
require_once 'lib2/edithelper.inc.php';
$no_tpl_build = false;
//Preprocessing
if ($error == false) {
//must be logged in
if ($usr === false) {
$tplname = 'login';
tpl_set_var('username', '');
tpl_set_var('target', 'newcache.php');
tpl_set_var('message_start', "");
tpl_set_var('message_end', "");
tpl_set_var('message', $login_required);
tpl_set_var('helplink', helppagelink('login'));
} else {
$errors = false;
// set if there was any errors
//set here the template to process
$tplname = 'newcache';
require_once $stylepath . '/' . $tplname . '.inc.php';
//set template replacements
tpl_set_var('reset', $reset);
// obsolete
tpl_set_var('submit', $submit);
tpl_set_var('general_message', '');
tpl_set_var('hidden_since_message', '');
tpl_set_var('activate_on_message', '');
tpl_set_var('lon_message', '');
tpl_set_var('lat_message', ' ');
} else {
if (!isset($_COOKIE[$opt['session']['cookiename'] . 'data'])) {
$tpl->error(ERROR_NO_COOKIES);
} else {
$tpl->redirect($target);
}
}
} else {
if ($action == 'logout') {
$login->logout();
$tpl->assign('error', LOGIN_LOGOUT_OK);
} else {
if ($login->userid != 0) {
$tpl->error(ERROR_ALREADY_LOGGEDIN);
}
$username = isset($_POST['email']) ? $_POST['email'] : '';
// Ocprop
$password = isset($_POST['password']) ? $_POST['password'] : '';
// Ocprop
$retval = $login->try_login($username, $password, null);
$password = '';
if ($retval == LOGIN_OK) {
$tpl->redirect('login.php?action=cookieverify&target=' . urlencode($target));
}
$tpl->assign('username', $username);
$tpl->assign('error', $retval);
}
}
$tpl->assign('loginhelplink', helppagelink('login'));
$tpl->assign('target', $target);
$tpl->display();
function display($dummy1 = null, $dummy2 = null, $dummy3 = null)
{
global $opt, $db, $cookie, $login, $menu, $sqldebugger, $translate;
global $useragent_msie;
$cookie->close();
// if the user is an admin, dont cache the content
if (isset($login)) {
if ($login->admin) {
$this->caching = false;
}
}
//Give Smarty access to the whole options array.
$this->assign('siteSettings', $opt);
//Should we remove this whole block since we now have
//access using the siteSettings above?
// assign main template vars
// ... and some of the $opt
$locale = $opt['template']['locale'];
$optn['debug'] = $opt['debug'];
$optn['template']['locales'] = $opt['template']['locales'];
$optn['template']['locale'] = $opt['template']['locale'];
$optn['template']['style'] = $opt['template']['style'];
$optn['template']['country'] = $login->getUserCountry();
$optn['page']['subtitle1'] = isset($opt['locale'][$locale]['page']['subtitle1']) ? $opt['locale'][$locale]['page']['subtitle1'] : $opt['page']['subtitle1'];
$optn['page']['subtitle2'] = isset($opt['locale'][$locale]['page']['subtitle2']) ? $opt['locale'][$locale]['page']['subtitle2'] : $opt['page']['subtitle2'];
$optn['page']['headimagepath'] = $opt['page']['headimagepath'];
$optn['page']['headoverlay'] = $opt['page']['headoverlay'];
$optn['page']['max_logins_per_hour'] = $opt['page']['max_logins_per_hour'];
$optn['page']['absolute_url'] = $opt['page']['absolute_url'];
$optn['page']['absolute_urlpath'] = parse_url($opt['page']['absolute_url'], PHP_URL_PATH);
$optn['page']['target'] = $this->target;
$optn['page']['showdonations'] = $opt['page']['showdonations'];
$optn['page']['title'] = $opt['page']['title'];
$optn['page']['nowpsearch'] = $this->nowpsearch;
$optn['page']['header_javascript'] = $this->header_javascript;
$optn['page']['body_load'] = $this->body_load;
$optn['page']['body_unload'] = $this->body_unload;
$optn['page']['sponsor'] = $opt['page']['sponsor'];
$optn['page']['showsocialmedia'] = $opt['page']['showsocialmedia'];
$optn['template']['title'] = $this->title;
$optn['template']['caching'] = $this->caching;
$optn['template']['popup'] = $this->popup;
$optn['template']['popupmargin'] = $this->popupmargin;
$optn['format'] = $opt['locale'][$opt['template']['locale']]['format'];
$optn['mail'] = $opt['mail'];
$optn['lib'] = $opt['lib'];
$optn['cms'] = $opt['cms'];
$optn['geokrety'] = $opt['geokrety'];
$optn['template']['usercountrieslist'] = labels::getLabels('usercountrieslist');
$optn['help']['oconly'] = helppagelink('oconly', 'OConly');
$optn['msie'] = $useragent_msie;
// url-sessions? (for session timout display)
$optn['session']['url'] = false;
if ($opt['session']['mode'] == SAVE_SESSION && $login->userid != 0) {
if (isset($_GET['SESSION']) || isset($_POST['SESSION'])) {
$optn['session']['url'] = true;
}
$optn['session']['id'] = session_id();
}
if (isset($login)) {
$loginn['username'] = $login->username;
$loginn['userid'] = $login->userid;
$loginn['admin'] = $login->admin;
} else {
$loginn['username'] = '';
$loginn['userid'] = '';
$loginn['admin'] = '';
}
// build menu
if ($this->menuitem == null) {
$menu->SetSelectItem(MNU_ROOT);
} else {
$menu->SetSelectItem($this->menuitem);
}
$this->assign('topmenu', $menu->getTopMenu());
$this->assign('submenu', $menu->getSubMenu());
$this->assign('breadcrumb', $menu->getBreadcrumb());
$this->assign('menucolor', $menu->getMenuColor());
$this->assign('helplink', helppagelink($this->name));
$this->assign('greybg', !$this->caching && $loginn['username'] == 'HWR-Info');
if ($this->title == '') {
$optn['template']['title'] = $menu->GetMenuTitle();
}
// build address for switching locales
$locale_pageadr = $_SERVER['REQUEST_URI'];
// workaround for http://redmine.opencaching.de/issues/703
$strange_things_pos = strpos($locale_pageadr, ".php/");
if ($strange_things_pos) {
$locale_pageadr = substr($locale_pageadr, 0, $strange_things_pos + 4);
}
$lpos = strpos($locale_pageadr, "locale=");
if ($lpos) {
$locale_pageadr = substr($locale_pageadr, 0, $lpos);
} else {
$urx = explode('#', $locale_pageadr);
$locale_pageadr = $urx[0];
if (strpos($locale_pageadr, '?') == 0) {
$locale_pageadr .= '?';
} else {
$locale_pageadr .= '&';
}
}
$this->assign('locale_pageadr', $locale_pageadr);
if ($opt['logic']['license']['disclaimer']) {
if (isset($opt['locale'][$locale]['page']['license_url'])) {
$lurl = $opt['locale'][$locale]['page']['license_url'];
} else {
$lurl = $opt['locale']['EN']['page']['license_url'];
}
if (isset($opt['locale'][$locale]['page']['license'])) {
$ltext = $opt['locale'][$locale]['page']['license'];
} else {
$ltext = $opt['locale']['EN']['page']['license'];
}
$this->assign('license_disclaimer', mb_ereg_replace('%1', $lurl, $ltext));
} else {
$this->assign('license_disclaimer', '');
}
$this->assign('opt', $optn);
$this->assign('login', $loginn);
if ($db['connected'] == true) {
$this->assign('sys_dbconnected', true);
} else {
$this->assign('sys_dbconnected', false);
}
$this->assign('sys_dbslave', $db['slave_id'] != -1);
if ($this->template_exists($this->name . '.tpl')) {
$this->assign('template', $this->name);
} else {
if ($this->name != 'sys_error') {
$this->error(ERROR_TEMPLATE_NOT_FOUND);
}
}
$this->bench->stop();
$this->assign('sys_runtime', $this->bench->diff());
$this->assign('screen_css_time', filemtime($opt['rootpath'] . "resource2/" . $opt['template']['style'] . "/css/style_screen.css"));
$this->assign('screen_msie_css_time', filemtime($opt['rootpath'] . "resource2/" . $opt['template']['style'] . "/css/style_screen_msie.css"));
$this->assign('print_css_time', filemtime($opt['rootpath'] . "resource2/" . $opt['template']['style'] . "/css/style_print.css"));
// check if the template is compiled
// if not, check if translation works correct
$_smarty_compile_path = $this->_get_compile_path($this->name);
if (!$this->_is_compiled($this->name, $_smarty_compile_path) && $this->name != 'error') {
$internal_lang = $translate->t('INTERNAL_LANG', 'all', 'OcSmarty.class.php', '');
if ($internal_lang != $opt['template']['locale'] && $internal_lang != 'INTERNAL_LANG') {
$this->error(ERROR_COMPILATION_FAILED);
}
}
if ($this->is_cached() == true) {
$this->assign('sys_cached', true);
} else {
$this->assign('sys_cached', false);
}
if (($opt['debug'] & DEBUG_SQLDEBUGGER) == DEBUG_SQLDEBUGGER) {
require_once $opt['rootpath'] . 'lib2/sqldebugger.class.php';
parent::fetch($this->main_template . '.tpl', $this->get_cache_id(), $this->get_compile_id());
$this->clear_all_assign();
$this->main_template = 'sys_sqldebugger';
$this->assign('commands', $sqldebugger->getCommands());
$this->assign('cancel', $sqldebugger->getCancel());
unset($sqldebugger);
$this->assign('opt', $optn);
$this->assign('login', $loginn);
$this->caching = false;
// unset sqldebugger to allow proper translation of sqldebugger template
$opt['debug'] = $opt['debug'] & ~DEBUG_SQLDEBUGGER;
$this->header();
parent::display($this->main_template . '.tpl');
} else {
$this->header();
parent::display($this->main_template . '.tpl', $this->get_cache_id(), $this->get_compile_id());
}
exit;
}
$useroptions = new useroptions($login->userid);
$tpl->assign('opt_menumap', $useroptions->getOptValue(USR_OPT_MAP_MENU));
$tpl->assign('opt_overview', $useroptions->getOptValue(USR_OPT_MAP_OVERVIEW));
$tpl->assign('opt_maxcaches', $useroptions->getOptValue(USR_OPT_MAP_MAXCACHES));
$tpl->assign('opt_cacheicons', $useroptions->getOptValue(USR_OPT_MAP_ICONSET));
$tpl->assign('opt_pictures', $useroptions->getOptValue(USR_OPT_MAP_PREVIEW));
$tpl->assign('maxrecords', $opt['map']['maxrecords'] + 0);
$tpl->assign('min_maxrecords', $opt['map']['min_maxrecords']);
$tpl->assign('max_maxrecords', $opt['map']['max_maxrecords']);
$tpl->assign('msie', $useragent_msie);
$tpl->assign('old_msie', $useragent_msie && $useragent_msie_version <= 6);
$tpl->assign('help_oconly', helppagelink("OConly"));
$tpl->assign('help_map', helppagelink("*map2"));
$tpl->assign('help_wps', helppagelink("additional_waypoints"));
$tpl->assign('help_note', helppagelink("usernote"));
$tpl->assign('help_previewpics', helppagelink("previewpics"));
$tpl->display();
function cache_locate($nLat, $nLon, $nDistance)
{
global $login;
$rsCache = sql_slave("SELECT " . geomath::getSqlDistanceFormula($nLon, $nLat, $nDistance) . " AS `distance`, \n\t `caches`.`wp_oc`\n\t FROM `caches` \n\t INNER JOIN `cache_status` ON `caches`.`status`=`cache_status`.`id`\n\t WHERE `caches`.`latitude`>'&1' AND \n \t\t\t\t\t\t\t\t\t\t `caches`.`latitude`<'&2' AND \n\t\t\t\t\t\t\t\t\t\t `caches`.`longitude`>'&3' AND \n\t\t\t\t\t\t\t\t\t\t `caches`.`longitude`<'&4' AND\n\t\t\t\t\t\t\t\t\t\t (`cache_status`.`allow_user_view`=1 OR `caches`.`user_id`='&1')\n\t\t\t\t\t ORDER BY `distance` ASC LIMIT 1", geomath::getMinLat($nLon, $nLat, $nDistance), geomath::getMaxLat($nLon, $nLat, $nDistance), geomath::getMinLon($nLon, $nLat, $nDistance), geomath::getMaxLon($nLon, $nLat, $nDistance), $login->userid);
$rCache = sql_fetch_assoc($rsCache);
sql_free_result($rsCache);
if ($rCache === false) {
echo '<caches></caches>';
exit;
}
output_cachexml($rCache['wp_oc']);
}
function output_cachexml($sWaypoint)
{
<?php
/***************************************************************************
* For license information see doc/license.txt
*
* Unicode Reminder メモ
***************************************************************************/
require __DIR__ . '/lib2/web.inc.php';
$tpl->name = 'tops';
$tpl->menuitem = MNU_CACHES_TOPS;
$tpl->caching = true;
$tpl->cache_lifetime = 600;
if (!$tpl->is_cached()) {
$rs = sql("SELECT IFNULL(`sys_trans_text`.`text`,`countries`.`en`) AS `adm1`,\n IF(`cache_location`.`code1`=`caches`.`country`,`cache_location`.`adm3`,NULL) AS `adm3`,\n `caches`.`country` AS `code1`,\n `rating_tops`.`rating` AS `idx`, `stat_caches`.`toprating` AS `ratings`,\n `stat_caches`.`found` AS `founds`, `caches`.`name`, `caches`.`wp_oc` AS `wpoc`,\n `user`.`username`, `user`.`user_id` AS `userid`,\n `ca`.`attrib_id` IS NOT NULL AS `oconly`\n FROM `rating_tops`\n INNER JOIN `caches` ON `rating_tops`.`cache_id`=`caches`.`cache_id`\n INNER JOIN `cache_location` ON `rating_tops`.`cache_id`=`cache_location`.`cache_id`\n LEFT JOIN `countries` ON `countries`.`short`=`caches`.`country`\n LEFT JOIN `sys_trans_text`\n ON `sys_trans_text`.`trans_id`=`countries`.`trans_id` AND `sys_trans_text`.`lang`='&1'\n INNER JOIN `stat_caches` ON `rating_tops`.`cache_id`=`stat_caches`.`cache_id`\n INNER JOIN `user` ON `caches`.`user_id`=`user`.`user_id`\n LEFT JOIN `caches_attributes` `ca` ON `ca`.`cache_id`=`caches`.`cache_id` AND `ca`.`attrib_id`=6\n ORDER BY `adm1` ASC,\n `adm3` ASC,\n `rating_tops`.`rating` DESC,\n `caches`.`name` ASC", $opt['template']['locale']);
$tpl->assign_rs('tops', $rs);
sql_free_result($rs);
}
$tpl->assign('helppagelink', helppagelink('tops'));
$tpl->display();
sql_free_result($rs);
if ($record === false) {
$tpl->error(ERROR_USER_NOT_EXISTS);
}
$active = sql_value("SELECT COUNT(*) FROM `caches` WHERE `user_id`='&1' AND `status`=1", 0, $userid);
$rs = sql("SELECT IFNULL(`tt`.`text`, `p`.`name`) AS `name`, `u`.`option_value`, `u`.`option_id` AS `option_id`\n\t\t FROM `profile_options` AS `p`\n\t\t LEFT JOIN `user_options` AS `u` ON `p`.`id`=`u`.`option_id`\n\t\t LEFT JOIN `sys_trans` AS `st` ON `st`.`id`=`p`.`trans_id` AND `st`.`text`=`p`.`name`\n\t\t LEFT JOIN `sys_trans_text` AS `tt` ON `st`.`id`=`tt`.`trans_id` AND `tt`.`lang` = '&2'\n\t\t WHERE `u`.`option_visible`=1\n\t\t AND `p`.`internal_use`=0\n\t\t AND `u`.`user_id`='&1'\n\t\t ORDER BY `p`.`option_order`", $userid, $opt['template']['locale']);
$tpl->assign_rs('useroptions', $rs);
sql_free_result($rs);
$user_desc = sql_value("SELECT `description` FROM `user` WHERE `user_id`='&1'", "", $userid);
$user_desc = use_current_protocol_in_html($user_desc);
$tpl->assign('description', $user_desc);
$useropt = new useroptions($userid);
$show_statistics = $useropt->getOptValue(USR_OPT_SHOWSTATS);
$show_oconly81 = $useropt->getOptValue(USR_OPT_OCONLY81);
if ($show_oconly81) {
$tpl->assign('oco81_helplink', helppagelink('oconly81'));
}
if ($show_statistics) {
// detail statistics
$rs = sql("SELECT COUNT(*) AS `anzahl`, `t`.`id`, IFNULL(`tt`.`text`, `t`.`name`) AS `cachetype`\n\t\t\t FROM `caches` AS `c`\n\t\t\t LEFT JOIN `cache_type` AS `t` ON `t`.`id`=`c`.`type`\n\t\t\t LEFT JOIN `sys_trans` AS `st` ON `st`.`id`=`t`.`trans_id` AND `t`.`name`=`st`.`text`\n\t\t\t LEFT JOIN `sys_trans_text` AS `tt` ON `st`.`id`=`tt`.`trans_id` AND `tt`.`lang`='&2'\n\t\t\t LEFT JOIN `cache_status` ON `cache_status`.`id`=`c`.`status`\n\t\t\t WHERE `c`.`user_id`='&1' AND `allow_user_view`='1'\n\t\t\t GROUP BY `t`.`id`\n\t\t\t ORDER BY `anzahl` DESC, `t`.`ordinal` ASC", $userid, $opt['template']['locale']);
$tpl->assign_rs('userstatshidden', $rs);
sql_free_result($rs);
$rs = sql("SELECT COUNT(*) AS `anzahl`, `t`.`id`, IFNULL(`tt`.`text`, `t`.`name`) AS `cachetype`\n\t\t\t FROM `cache_logs` AS `l`\n\t\t\t LEFT JOIN `caches` AS `c` ON `l`.`cache_id`=`c`.`cache_id`\n\t\t\t LEFT JOIN `cache_type` AS `t` ON `t`.`id`=`c`.`type`\n\t\t\t LEFT JOIN `sys_trans` AS `st` ON `st`.`id`=`t`.`trans_id` AND `t`.`name`=`st`.`text`\n\t\t\t LEFT JOIN `sys_trans_text` AS `tt` ON `st`.`id`=`tt`.`trans_id` AND `tt`.`lang`='&2'\n\t\t\t WHERE `l`.`user_id`='&1' AND (`l`.`type`=1 OR `l`.`type`=7)\n\t\t\t GROUP BY `t`.`id`\n\t\t\t ORDER BY `anzahl` DESC, `t`.`ordinal` ASC", $userid, $opt['template']['locale']);
$tpl->assign_rs('userstatsfound', $rs);
sql_free_result($rs);
$rs = sql("\n\t\t\tSELECT\n\t\t\t\tCOUNT(*) AS `count`,\n\t\t\t\tIFNULL(`stt`.`text`, `caches`.`country`) AS `country`,\n\t\t\t\tIF(`caches`.`country`='&3' AND `cache_location`.`code1`='&3', `cache_location`.`adm2`, NULL) AS `state`,\n\t\t\t\t`caches`.`country` AS `countrycode`,\n\t\t\t\t`cache_location`.`code2` AS `adm2code`\n\t\t\tFROM\n\t\t\t\t`cache_logs`\n\t\t\t\tINNER JOIN `caches` ON `caches`.`cache_id`=`cache_logs`.`cache_id`\n\t\t\t\tINNER JOIN `cache_location` ON `cache_location`.`cache_id`=`cache_logs`.`cache_id`\n\t\t\t\tLEFT JOIN `countries` ON `countries`.`short`=`caches`.`country`\n\t\t\t\tLEFT JOIN `sys_trans_text` `stt` ON `stt`.`lang`='&2' AND `stt`.`trans_id`=`countries`.`trans_id`\n\t\t\tWHERE `cache_logs`.`user_id`='&1' AND `cache_logs`.`type` IN (1,7)\n\t\t\tGROUP BY `country`, `state`\n\t\t\tORDER BY `count` DESC, `country`, `state`", $userid, $opt['template']['locale'], $login->getUserCountry());
$tpl->assign_rs('regionstat', $rs);
sql_free_result($rs);
}
// OConly statistics
$oconly_hidden = sql_value("\n\t\tSELECT COUNT(*)\n\t\tFROM `caches`\n\t\tINNER JOIN `caches_attributes` ON `caches_attributes`.`cache_id`=`caches`.`cache_id` AND `caches_attributes`.`attrib_id`=6\n\t\tINNER JOIN `cache_status` ON `cache_status`.`id`=`caches`.`status` AND `allow_user_view`=1\n\t\tWHERE `user_id`='&1'", 0, $userid);
*/
$userzoom = 11;
if ($login->userid > 0) {
$useropt = new useroptions($login->userid);
$userzoom = $useropt->getOptValue(USR_OPT_GMZOOM);
$autoload_logs = $useropt->getOptValue(USR_OPT_LOG_AUTOLOAD);
} else {
$autoload_logs = true;
}
$tpl->assign('userzoom', $userzoom);
$tpl->assign('autoload_logs', $autoload_logs);
// get the correct mapkey
$sHost = strtolower($_SERVER['HTTP_HOST']);
$sGMKey = '';
if (isset($opt['lib']['google']['mapkey'][$sHost])) {
$sGMKey = $opt['lib']['google']['mapkey'][$sHost];
}
$cachemap['iframe'] = $opt['logic']['cachemaps']['iframe'];
$url = $opt['page']['protocol'] . strstr($opt['logic']['cachemaps']['url'], '://');
$url = str_replace('{userzoom}', $userzoom, $url);
$url = str_replace('{latitude}', $rCache['latitude'], $url);
$url = str_replace('{longitude}', $rCache['longitude'], $url);
$url = str_replace('{gmkey}', $sGMKey, $url);
$cachemap['url'] = $url;
$tpl->assign('cachemap', $cachemap);
$tpl->assign('shortlink_url', $opt['page']['shortlink_url']);
$tpl->assign('listing_admin', $login->listingAdmin());
$tpl->assign('npahelplink', helppagelink('npa'));
$tpl->assign('garmin_url', $opt['lib']['garmin']['page_url']);
// display the page
$tpl->display();
function mnu_EchoHelpLink($tplname)
{
$helplink = helppagelink($tplname);
if ($helplink != "") {
echo $helplink . '<img src="resource2/ocstyle/images/misc/32x32-help.png" /></a>';
}
}
function assignFromUser($user)
{
global $tpl;
$tpl->assign('username', $user->getUsername());
$tpl->assign('email', $user->getEMail());
$tpl->assign('firstName', $user->getFirstName());
$tpl->assign('lastName', $user->getLastName());
$tpl->assign('country', $user->getCountry());
$tpl->assign('countryCode', $user->getCountryCode());
$coords = new coordinate($user->getLatitude(), $user->getLongitude());
$tpl->assign('coords', $coords->getDecimalMinutes());
$tpl->assign('coordsDecimal', $coords->getFloat());
$tpl->assign('notifyRadius', $user->getNotifyRadius());
$tpl->assign('notifyOconly', $user->getNotifyOconly());
$oconly_helplink = helppagelink('oconly');
$tpl->assign('oconly_helpstart', $oconly_helplink);
$tpl->assign('oconly_helpend', $oconly_helplink != '' ? '</a>' : '');
$tpl->assign('registeredSince', $user->getDateRegistered());
$tpl->assign('accMailing', $user->getAccMailing());
$tpl->assign('usePMR', $user->getUsePMR());
$tpl->assign('permanentLogin', $user->getPermanentLogin());
$tpl->assign('noHTMLEditor', $user->getNoHTMLEditor());
$tpl->assign('sendUsermailAddress', $user->getUsermailSendAddress());
}
if ($bError == false) {
if ($cache->report($login->userid, $reportreason, $reportnote)) {
$reasontext = sql_value("\n SELECT IFNULL(`tt`.`text`, `crr`.`name`)\n FROM `cache_report_reasons` AS `crr`\n INNER JOIN `sys_trans_text` AS `tt` ON `tt`.`trans_id`=`crr`.`trans_id`\n WHERE `crr`.`id` =&1 AND `tt`.`lang`='&2'", 'unknown', $reportreason, $opt['template']['locale']);
$tpl->assign('reasontext', $reasontext);
$tpl->assign('success', true);
} else {
$tpl->assign('errorUnkown', true);
}
}
}
$rs = sql("\n SELECT\n `cache_report_reasons`.`id`,\n IFNULL(`sys_trans_text`.`text`,\n `cache_report_reasons`.`name`) AS `name`\n FROM `cache_report_reasons`\n LEFT JOIN `sys_trans`\n ON `cache_report_reasons`.`trans_id`=`sys_trans`.`id`\n AND `cache_report_reasons`.`name`=`sys_trans`.`text`\n LEFT JOIN `sys_trans_text`\n ON `sys_trans`.`id`=`sys_trans_text`.`trans_id`\n AND `sys_trans_text`.`lang`='&1'\n ORDER BY `order`", $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->assign('help_reportreasons', helppagelink('report_reasons'));
$open_reports = sql_value("SELECT COUNT(*) FROM `cache_reports` WHERE `status`=1", 0);
$processing_reports = sql_value("SELECT COUNT(*) FROM `cache_reports` WHERE `status`=2 AND DATEDIFF(NOW(),`lastmodified`) <= 180", 0);
$tpl->assign('open_reports', $open_reports);
$tpl->assign('processing_reports', $processing_reports);
if ($opt['logic']['cache_reports']['min_processperday'] > 0) {
$waitdays_min = 1 + floor(($open_reports + $opt['logic']['cache_reports']['max_processperday'] / 2) / $opt['logic']['cache_reports']['max_processperday']);
$waitdays_max = 1 + $opt['logic']['cache_reports']['delaydays'] + floor(($open_reports + $opt['logic']['cache_reports']['min_processperday'] / 2) / $opt['logic']['cache_reports']['min_processperday']);
$tpl->assign('waitdays_min', $waitdays_min);
$tpl->assign('waitdays_max', $waitdays_max);
} else {
$tpl->assign('waitdays_min', false);
}
$tpl->display();