require_once $stylepath . '/newcache.inc.php'; $rs = sql("SELECT `hide_flag` as hide_flag, `verify_all` as verify_all FROM `user` WHERE `user_id` = " . $user->getUserId()); $record = sql_fetch_array($rs); $hide_flag = $record['hide_flag']; $verify_all = $record['verify_all']; if ($hide_flag == 10) { // user is banned for creating new caches for some reason $tplname = 'newcache_forbidden'; require_once $rootpath . '/lib/caches.inc.php'; } // display info for begginner about number of find caches to possible register first cache $rsnfc = sql("SELECT COUNT(`cache_logs`.`cache_id`) as num_fcaches FROM cache_logs,caches WHERE cache_logs.cache_id=caches.cache_id AND (caches.type='1' OR caches.type='2' OR caches.type='3' OR caches.type='7' OR caches.type='8') AND cache_logs.type='1' AND cache_logs.deleted='0' AND `cache_logs`.`user_id` = " . sql_escape($usr['userid']) . ""); $rec = sql_fetch_array($rsnfc); $num_find_caches = $rec['num_fcaches']; tpl_set_var('number_finds_caches', $num_find_caches); if ($num_find_caches < $NEED_FIND_LIMIT && !$user->isIngnoreGeocacheLimitWhileCreatingNewGeocache()) { $tplname = 'newcache_beginner'; require_once $rootpath . '/lib/caches.inc.php'; } $errors = false; // set if there was any errors $rsnc = sql("SELECT COUNT(`caches`.`cache_id`) as num_caches FROM `caches` WHERE `user_id` = " . sql_escape($usr['userid']) . "\n AND status = 1"); $record = sql_fetch_array($rsnc); $num_caches = $record['num_caches']; $cacheLimitByTypePerUser = common::getUserActiveCacheCountByType($db, $usr['userid']); if ($num_caches < $NEED_APPROVE_LIMIT) { // user needs approvement for first 3 caches to be published $needs_approvement = true; tpl_set_var('hide_publish_start', '<!--'); tpl_set_var('hide_publish_end', '-->'); tpl_set_var('approvement_note', '<div class="notice"><font color="red"><b>' . tr('first_cache_approvement') . '</b></font></div>');
tpl_set_var('country', htmlspecialchars($record['country'], ENT_COMPAT, 'UTF-8')); tpl_set_var('registered', strftime("%d-%m-%Y", strtotime($record['date_created']))); tpl_set_var('email', strip_tags($record['email'])); tpl_set_var('description', nl2br($record['description'])); if ($record['is_active_flag']) { tpl_set_var('is_active_flags', ' <a href="admin_users.php?userid=' . $user_id . '&is_active_flag=1"><font color="#ff0000">' . tr('lock') . ' ' . tr('user_account') . '</font></a> <img src="' . $stylepath . '/images/blue/atten-red.png" align="top" alt="" />'); } else { tpl_set_var('is_active_flags', ' <a href="admin_users.php?userid=' . $user_id . '&is_active_flag=1"><font color="#228b22">' . tr('unlock') . ' ' . tr('user_account') . '</font></a> <img src="' . $stylepath . '/images/blue/atten-green.png" align="bottom" alt="" />'); } if (!$record['stat_ban']) { tpl_set_var('stat_ban', ' <a href="admin_users.php?userid=' . $user_id . '&stat_ban=1"><font color="#ff0000">' . tr('lock') . ' ' . tr('user_stats') . '</font></a> <img src="' . $stylepath . '/images/blue/atten-red.png" align="top" alt="" />'); } else { tpl_set_var('stat_ban', ' <a href="admin_users.php?userid=' . $user_id . '&stat_ban=1"><font color="#228b22">' . tr('unlock') . ' ' . tr('user_stats') . '</font></a> <img src="' . $stylepath . '/images/blue/atten-green.png" align="top" alt="" />'); } if ($user->getFoundGeocachesCount() < 10) { $ignoreFoundLimit = $user->isIngnoreGeocacheLimitWhileCreatingNewGeocache(); if ($ignoreFoundLimit) { $translation = tr('ignoreFoundLimitRm'); } else { $translation = tr('ignoreFoundLimitAdd'); } $ignoreFoundLimitHtml = '<a href="admin_users.php?userid=' . $user_id . '&ignoreFoundLimit=' . (int) (!$ignoreFoundLimit) . '"><font color="#ff0000">' . $translation . '</font></a><img src="' . $stylepath . '/images/blue/atten-red.png" align="top" alt="" />'; tpl_set_var('ignoreFoundLimit', $ignoreFoundLimitHtml); } else { tpl_set_var('ignoreFoundLimit', 'n/d'); } // force all caches to be verified - form $verify_all = $record['verify_all']; if ($verify_all == 0) { tpl_set_var('hide_flag', '<p><img src="tpl/stdstyle/images/blue/arrow2.png" alt="" align="middle" /> <a href="admin_users.php?userid=' . $user_id . '&verify_all=1"><font color="#ff0000">' . tr('admin_users_verify_all') . '</font></a> <img src="' . $stylepath . '/images/blue/atten-red.png" align="top" alt="" /></p>'); } else {