$default_country = getDefaultCountry($usr, $lang);
if (isset($_REQUEST['newcache_info'])) {
$newcache_info = $_REQUEST['newcache_info'];
} else {
$newcache_info = 1;
}
if ($newcache_info == 1) {
// display info about register new cache
$tplname = 'newcache_info';
} else {
//set here the template to process
$tplname = 'newcache';
}
require_once $rootpath . '/lib/caches.inc.php';
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';
$default_country = getDefaultCountry($usr, $lang);
if (isset($_REQUEST['newcache_info'])) {
$newcache_info = $_REQUEST['newcache_info'];
} else {
$newcache_info = 1;
}
if ($newcache_info == 1) {
// display info about register new cache
$tplname = 'newcache_info';
} else {
//set here the template to process
$tplname = 'newcache';
}
require_once $rootpath . '/lib/caches.inc.php';
require_once $stylepath . '/newcache.inc.php';
$rs = XDb::xSql("SELECT `hide_flag` as hide_flag, `verify_all` as verify_all FROM `user`\n WHERE `user_id` = ? ", $user->getUserId());
$record = XDb::xFetchArray($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
$num_find_caches = XDb::xMultiVariableQueryValue("SELECT COUNT(`cache_logs`.`cache_id`) as num_fcaches FROM cache_logs, caches\n WHERE cache_logs.cache_id=caches.cache_id AND (caches.type='1'\n OR caches.type='2' OR caches.type='3' OR caches.type='7'\n OR caches.type='8') AND cache_logs.type='1'\n AND cache_logs.deleted='0' AND `cache_logs`.`user_id` = :1 ", 0, $usr['userid']);
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';
}
// force all caches to be verified - sql
if (isset($_GET['verify_all'])) {
if ($_GET['verify_all'] == 1 && $usr['admin']) {
$sql = "UPDATE user SET verify_all = '1' WHERE user_id = '" . intval($user_id) . "'";
mysql_query($sql) or die(mysql_error());
}
if ($_GET['verify_all'] == 0 && $usr['admin']) {
$sql = "UPDATE user SET verify_all = 0 WHERE user_id = " . intval($user_id);
mysql_query($sql);
}
}
// end force
if (isset($_REQUEST['ignoreFoundLimit']) && $_REQUEST['ignoreFoundLimit'] != '') {
$newIgnoreFoundLimit = intval($_REQUEST['ignoreFoundLimit']);
$db = \lib\Database\DataBaseSingleton::Instance();
$db->multiVariableQuery('INSERT INTO user_settings (user_id, newcaches_no_limit) VALUES (:2, :1) ON DUPLICATE KEY UPDATE newcaches_no_limit = :1', $newIgnoreFoundLimit, $user->getUserId());
$db->reset();
unset($user);
$user = new \lib\Objects\User\User(array('userId' => $_REQUEST['userid']));
$user->loadExtendedSettings();
}
if (isset($_GET['is_active_flag']) && $_GET['is_active_flag'] == 1 && $usr['admin']) {
$sql = "UPDATE user SET is_active_flag = 1 - is_active_flag, `activation_code`='' WHERE user_id = " . intval($user_id);
mysql_query($sql);
}
if ($usr['userid'] == $super_admin_id) {
tpl_set_var('remove_all_logs', '<p><img src="tpl/stdstyle/images/blue/arrow2.png" alt="" align="middle" /> <a href="removelog.php?userid=' . $user_id . '"><font color="#ff0000">' . tr('admin_users_remove_logs') . '</font></a> <img src="' . $stylepath . '/images/blue/atten-red.png" align="top" alt="" /></p>');
} else {
tpl_set_var('remove_all_logs', '');
}
if (checkField('countries', $lang)) {
$record["verify_all"] = 1;
lib\Objects\User\AdminNote::addAdminNote($usr['userid'], $user_id, true, lib\Objects\User\AdminNote::VERIFY_ALL);
XDb::xQuery($q);
}
if ($_GET['verify_all'] == 0 && $usr['admin']) {
$q = "UPDATE user SET verify_all = 0 WHERE user_id = " . intval($user_id);
lib\Objects\User\AdminNote::addAdminNote($usr['userid'], $user_id, true, lib\Objects\User\AdminNote::NO_VERIFY_ALL);
$record["verify_all"] = 0;
XDb::xQuery($q);
}
}
// end force
if (isset($_REQUEST['ignoreFoundLimit']) && $_REQUEST['ignoreFoundLimit'] != '') {
$newIgnoreFoundLimit = intval($_REQUEST['ignoreFoundLimit']);
if ($newIgnoreFoundLimit == 1) {
lib\Objects\User\AdminNote::addAdminNote($usr['userid'], $user->getUserId(), true, lib\Objects\User\AdminNote::IGNORE_FOUND_LIMIT);
} else {
lib\Objects\User\AdminNote::addAdminNote($usr['userid'], $user->getUserId(), true, lib\Objects\User\AdminNote::IGNORE_FOUND_LIMIT_RM);
}
$db = OcDb::instance();
$db->multiVariableQuery('INSERT INTO user_settings (user_id, newcaches_no_limit) VALUES (:2, :1) ON DUPLICATE KEY UPDATE newcaches_no_limit = :1', $newIgnoreFoundLimit, $user->getUserId());
$user = new \lib\Objects\User\User(array('userId' => $_REQUEST['userid']));
$user->loadExtendedSettings();
}
//ban
if (isset($_GET['is_active_flag']) && $_GET['is_active_flag'] == 1 && $usr['admin']) {
$q = "UPDATE user SET is_active_flag = 1 - is_active_flag, `activation_code`='' WHERE user_id = " . intval($user_id);
if ($record["is_active_flag"] == 0) {
$record["is_active_flag"] = 1;
lib\Objects\User\AdminNote::addAdminNote($usr['userid'], $user_id, true, lib\Objects\User\AdminNote::UNBAN);
} else {
