$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);