$last_block_bin = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT `data`\n\t\t\tFROM `" . DB_PREFIX . "block_chain`\n\t\t\tORDER BY `id` DESC\n\t\t\tLIMIT 1\n\t\t\t", 'fetch_one');
ParseData::string_shift($last_block_bin, 5);
$block_time = ParseData::binary_dec_string_shift($last_block_bin, 4);
// дождемся загрузки свежих блоков
// if (time() - $block_time < 600) { закомменчено, т.к. при ручном откате до какого-то блока время будет старое
$my_node_key = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT `private_key`\n\t\t\t\tFROM `" . DB_PREFIX . MY_PREFIX . "my_node_keys`\n\t\t\t\tWHERE `block_id` > 0\n\t\t\t\tLIMIT 1\n\t\t\t\t", 'fetch_one');
$my_miner_id = get_my_miner_id($db);
if (!$my_node_key && $my_miner_id > 0) {
echo "\n\t\t\t\t\t <div class=\"alert alert-danger alert-dismissable\" style='margin-top: 30px'><button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>\n\t\t\t\t <h4>Warning!</h4>\n\t\t\t\t <div>{$lng['alert_change_node_key']}</div>\n\t\t\t\t </div>\n\t\t\t\t ";
}
//}
}
// просто информируем, что в данном разделе у юзера нет прав
$skip_community = array('node_config', 'nulling', 'start_stop');
$skip_restricted_users = array('node_config', 'change_node_key', 'nulling', 'start_stop', 'cash_requests_in', 'cash_requests_out', 'upgrade', 'notifications', 'interface');
if (!node_admin_access($db) && in_array($tpl_name, $skip_community) || !empty($_SESSION['restricted']) && in_array($tpl_name, $skip_restricted_users)) {
echo "\n\t\t\t <div class=\"alert alert-danger alert-dismissable\" style='margin-top: 30px'><button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>\n\t\t\t <h4>Warning!</h4>\n\t\t\t <div>{$lng['permission_denied']}</div>\n\t\t\t </div>\n\t\t\t ";
}
// информируем, что у юзера нет прав и нужно стать майнером
$miners_only = array('my_cf_projects', 'new_cf_project', 'cash_requests_in', 'cash_requests_out', 'change_node_key', 'voting', 'geolocation', 'promised_amount_list', 'promised_amount_add', 'holidays_list', 'new_holidays', 'points', 'tasks', 'change_host', 'new_user', 'change_commission');
if (in_array($tpl_name, $miners_only)) {
$miner_id = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT `miner_id`\n\t\t\tFROM `" . DB_PREFIX . "users`\n\t\t\tLEFT JOIN `" . DB_PREFIX . "miners_data` ON `" . DB_PREFIX . "users`.`user_id` = `" . DB_PREFIX . "miners_data`.`user_id`\n\t\t\tWHERE `" . DB_PREFIX . "users`.`user_id` = {$user_id}\n\t\t\tLIMIT 1\n\t\t\t", 'fetch_one');
//print $db->printsql();
if (!$miner_id) {
echo "\n\t\t\t\t <div class=\"alert alert-danger alert-dismissable\" style='margin-top: 30px'><button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>\n\t\t\t\t <h4>Warning!</h4>\n\t\t\t\t <div>{$lng['only_for_miners']}</div>\n\t\t\t\t </div>\n\t\t\t\t ";
}
}
// информируем, что необходимо вначале сменить праймари-ключ
//$primary_key_alert = array('wallets_list', 'upgrade', 'upgrade_0', 'upgrade_1', 'upgrade_2', 'upgrade_3', 'upgrade_4', 'upgrade_5', 'notifications');
//if (in_array($tpl_name, $primary_key_alert)) {
$log_id = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT `log_id`\n\t\t\tFROM `" . DB_PREFIX . "users`\n\t\t\tWHERE `user_id` = {$user_id}\n\t\t\tLIMIT 1\n\t\t\t", 'fetch_one');
<?php
if (!defined('DC')) {
die("!defined('DC')");
}
if (!node_admin_access($db)) {
die('Permission denied');
}
// удаление юзера с пула
$del_id = intval(@$_REQUEST['parameters']['del_id']);
if ($del_id) {
$tables_array = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSHOW TABLES\n\t\t\t", 'array');
foreach ($my_tables as $table) {
if (in_array(DB_PREFIX . "{$del_id}_{$table}", $tables_array)) {
$db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\t\tDROP TABLE `" . DB_PREFIX . "{$del_id}_{$table}`\n\t\t\t\t\t");
}
}
$db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tDELETE FROM `" . DB_PREFIX . "community`\n\t\t\tWHERE `user_id` = {$del_id}\n\t\t\t");
}
if (isset($_REQUEST['parameters']['pool_tech_works'])) {
$pool_tech_works = intval($_REQUEST['parameters']['pool_tech_works']);
$pool_max_users = intval($_REQUEST['parameters']['pool_max_users']);
$commission = $_REQUEST['parameters']['commission'];
if (!check_input_data($commission, 'commission')) {
die('bad commission');
}
$db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tUPDATE `" . DB_PREFIX . "config`\n\t\t\tSET `pool_tech_works` = {$pool_tech_works},\n\t\t\t\t `pool_max_users` = {$pool_max_users},\n\t\t\t\t `commission` = '{$commission}'\n\t\t\t");
}
$tables_array = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSHOW TABLES\n\t\t\t", 'array');
$tpl['users'] = array();
$community = get_community_users($db);
