$max_other_currencies_time = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\tSELECT max(`time`)\n\t\tFROM `" . DB_PREFIX . "max_other_currencies_time`\n\t\t", 'fetch_one');
if ($time - $max_other_currencies_time > $variables['new_max_other_currencies']) {
// берем все голоса
$res = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT `currency_id`,\n\t\t\t\t\t\t `count`,\n\t\t\t\t\t\t count(`user_id`) as `votes`\n\t\t\tFROM `" . DB_PREFIX . "votes_max_other_currencies`\n\t\t\tGROUP BY `currency_id`, `count`\n\t\t\t");
while ($row = $db->fetchArray($res)) {
$max_other_currencies_votes[$row['currency_id']][$row['count']] = $row['votes'];
}
if (!isset($max_other_currencies_votes)) {
debug_print('!isset($max_other_currencies_votes)', __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
main_unlock();
exit;
}
debug_print($max_other_currencies_votes, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$total_count_currencies = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT count(`id`)\n\t\t\tFROM `" . DB_PREFIX . "currency`\n\t\t\t", 'fetch_one');
foreach ($max_other_currencies_votes as $currency_id => $count_and_votes) {
$new_max_other_currencies[$currency_id] = get_max_vote($count_and_votes, 0, $total_count_currencies, 10);
}
if (get_community_users($db)) {
$my_prefix = $testBlock->user_id . '_';
} else {
$my_prefix = '';
}
$node_private_key = get_node_private_key($db, $my_prefix);
$json_data = json_encode($new_max_other_currencies);
// подписываем нашим нод-ключем данные транзакции
$data_for_sign = ParseData::findType('new_max_other_currencies') . ",{$time},{$my_user_id},{$json_data}";
$rsa = new Crypt_RSA();
$rsa->loadKey($node_private_key);
$rsa->setSignatureMode(CRYPT_RSA_SIGNATURE_PKCS1);
$signature = $rsa->sign($data_for_sign);
debug_print('$data_for_sign=' . $data_for_sign . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$res = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT `currency_id`,\n\t\t\t\t\t\t `amount`,\n\t\t\t\t\t\t count(`user_id`) as `votes`\n\t\t\tFROM `" . DB_PREFIX . "votes_max_promised_amount`\n\t\t\tGROUP BY `currency_id`, `amount`\n\t\t\t");
while ($row = $db->fetchArray($res)) {
$max_promised_amount_votes[$row['currency_id']][$row['amount']] = $row['votes'];
}
if (!isset($max_promised_amount_votes)) {
debug_print('!isset($max_promised_amount_votes)', __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
main_unlock();
exit;
}
debug_print($max_promised_amount_votes, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$new_max_promised_amounts = array();
foreach ($max_promised_amount_votes as $currency_id => $amounts_and_votes) {
//$valid_amounts_and_votes = ParseData::makeMaxPromisedAmount($amounts_and_votes);
//$key = get_max_vote($valid_amounts_and_votes, 0, 1000, 100);
//$new_max_promised_amounts[$currency_id] = ParseData::getPctValue($key);
$new_max_promised_amounts[$currency_id] = get_max_vote($amounts_and_votes, 0, 165, 10);
}
if (get_community_users($db)) {
$my_prefix = $testBlock->user_id . '_';
} else {
$my_prefix = '';
}
$node_private_key = get_node_private_key($db, $my_prefix);
$json_data = json_encode($new_max_promised_amounts);
// подписываем нашим нод-ключем данные транзакции
$data_for_sign = ParseData::findType('new_max_promised_amounts') . ",{$time},{$my_user_id},{$json_data}";
$rsa = new Crypt_RSA();
$rsa->loadKey($node_private_key);
$rsa->setSignatureMode(CRYPT_RSA_SIGNATURE_PKCS1);
$signature = $rsa->sign($data_for_sign);
debug_print('$data_for_sign=' . $data_for_sign . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$PctArray = ParseData::getPctArray();
$new_pct = array();
foreach ($pct_votes as $currency_id => $data) {
// определяем % для майнеров
$pct_arr = ParseData::makePctArray($data['miner_pct']);
$key = get_max_vote($pct_arr, 0, 390, 100);
$new_pct['currency'][$currency_id]['miner_pct'] = ParseData::getPctValue($key);
$tpl['new_pct'][$currency_id]['miner_pct'] = round((pow(1 + ParseData::getPctValue($key), 3600 * 24 * 365) - 1) * 100, 2);
// определяем % для юзеров
$pct_arr = ParseData::makePctArray($data['user_pct']);
$pct_y = array_search($new_pct['currency'][$currency_id]['miner_pct'], $PctArray);
$max_user_pct_y = round($pct_y / 2, 2);
$user_max_key = find_user_pct($max_user_pct_y);
// отрезаем лишнее, т.к. поиск идет ровно до макимального возможного, т.е. до miner_pct/2
$pct_arr = del_user_pct($pct_arr, $user_max_key);
$key = get_max_vote($pct_arr, 0, $user_max_key, 100);
$new_pct['currency'][$currency_id]['user_pct'] = ParseData::getPctValue($key);
$tpl['new_pct'][$currency_id]['user_pct'] = round((pow(1 + ParseData::getPctValue($key), 3600 * 24 * 365) - 1) * 100, 2);
}
/*
* %/год
* */
$res = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\tSELECT *\n\t\tFROM `" . DB_PREFIX . "currency`\n\t\t");
while ($row = $db->fetchArray($res)) {
$pct = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT *\n\t\t\tFROM `" . DB_PREFIX . "pct`\n\t\t\tWHERE `currency_id` = {$row['id']}\n\t\t\tORDER BY `block_id` DESC\n\t\t\tLIMIT 1\n\t\t\t", 'fetch_array');
$tpl['currency_pct'][$row['id']]['name'] = $row['name'];
$tpl['currency_pct'][$row['id']]['miner'] = round((pow(1 + $pct['miner'], 120) - 1) * 100, 6);
$tpl['currency_pct'][$row['id']]['user'] = round((pow(1 + $pct['user'], 120) - 1) * 100, 6);
}
$tpl['currency_list'] = get_currency_list($db, 'full');
require_once ABSPATH . 'templates/statistic_voting.tpl';
function get_max_vote($array, $min, $max, $step)
{
debug_print('$array=' . print_r_hex($array) . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print('$min=' . $min . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print('$max=' . $max . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print('$step=' . $step . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
// если <=10 то тупо берем максимальное кол-во голосов
if (sizeof($array) <= 10) {
if (sizeof($array) > 0) {
$max_votes = max($array);
$max_pct = array_search($max_votes, $array);
} else {
$max_pct = 0;
}
return $max_pct;
}
// делим набор данных от $min до $max на секции кратные $step
// таких секций будет 100 при $max=1000
// цель такого деления - найти ту секцию, где больше всего голосов
for ($i = $min; $i < $max; $i = $i + $step / 10) {
$min_0 = $i;
$max_0 = $i + $step;
// берем из массива те данные, которые попадают в данную секцию
foreach ($array as $number => $votes) {
if ($number >= $min_0 && $number < $max_0) {
$data_bank[$i][$number] = $votes;
//debug_print( '$min_0='.$min_0."\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
//debug_print( '$max_0='.$max_0."\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
}
}
if (isset($data_bank[$i])) {
$sums[$i] = array_sum($data_bank[$i]);
}
}
debug_print('$data_bank=' . print_r_hex($data_bank) . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print('$sums=' . print_r_hex($sums) . "\n", __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
// ищем id секции, где больше всего голосов
$max_sum = max($sums);
$max_i = array_search($max_sum, $sums);
debug_print('$max_sum:' . $max_sum, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print('$max_i:' . $max_i, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print('$data_bank[$max_i]:' . print_r_hex($data_bank[$max_i]), __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
// если в этой секции <= 10-и элементов, то просто выбираем максимальное кол-во голосов
if (sizeof($data_bank[$max_i]) <= 10) {
debug_print('sizeof($data_bank[$max_i])<=10', __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$max_votes = max($data_bank[$max_i]);
$max_pct = array_search($max_votes, $data_bank[$max_i]);
return $max_pct;
} else {
// без рекурсии, просто один раз вызываем свою функцию
return get_max_vote($data_bank[$max_i], $max_i, $max_i + $step, $step / 10);
}
}
function new_pct_front()
{
$error = $this->general_check();
if ($error) {
return $error;
}
// является ли данный юзер майнером
if (!$this->check_miner($this->tx_data['user_id'])) {
return 'error miner id';
}
// получим public_key
$this->node_public_key = $this->db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT `node_public_key`\n\t\t\t\tFROM `" . DB_PREFIX . "miners_data`\n\t\t\t\tWHERE `user_id` = {$this->tx_data['user_id']}\n\t\t\t\t", 'fetch_one');
////print $this->db->printsql();
if (!$this->node_public_key) {
return 'error user_id';
}
$new_pct_tx = json_decode($this->tx_data['new_pct'], true);
if (!$new_pct_tx) {
return 'error $new_pct_tx';
}
// раньше не было рефских
if (isset($this->block_data['block_id']) && $this->block_data['block_id'] <= 77951) {
$new_pct_tx['currency'] = $new_pct_tx;
} else {
if (!isset($new_pct_tx['currency'], $new_pct_tx['referral'])) {
return 'error currency referral';
}
}
if (!is_array($new_pct_tx['currency'])) {
return 'error $new_pct_tx[currency])';
}
// проверим, верно ли указаны ID валют
$currency_ids_sql = '';
$count_currency = 0;
foreach ($new_pct_tx['currency'] as $id => $_data) {
$currency_ids_sql .= $id . ',';
$count_currency++;
}
$currency_ids_sql = substr($currency_ids_sql, 0, -1);
$count = $this->db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT count(`id`)\n\t\t\t\tFROM `" . DB_PREFIX . "currency`\n\t\t\t\tWHERE `id` IN ({$currency_ids_sql})\n\t\t\t\t", 'fetch_one');
if ($count != $count_currency) {
return 'error count_currency';
}
// проверяем подпись
$for_sign = "{$this->tx_data['type']},{$this->tx_data['time']},{$this->tx_data['user_id']},{$this->tx_data['new_pct']}";
$error = self::checkSign($this->node_public_key, $for_sign, $this->tx_data['sign'], true);
if ($error) {
return $error;
}
// проверим, прошло ли 2 недели с момента последнего обновления pct
$pct_time = $this->db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT max(`time`)\n\t\t\t\tFROM `" . DB_PREFIX . "pct`", 'fetch_one');
if ($this->tx_data['time'] - $pct_time <= $this->variables['new_pct_period']) {
return '14 day error';
}
// берем все голоса miner_pct
$res = $this->db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT `currency_id`,\n\t\t\t\t\t\t\t `pct`,\n\t\t\t\t\t\t\t count(`user_id`) as `votes`\n\t\t\t\tFROM `" . DB_PREFIX . "votes_miner_pct`\n\t\t\t\tGROUP BY `currency_id`, `pct`\n\t\t\t\t");
while ($row = $this->db->fetchArray($res)) {
$pct_votes[$row['currency_id']]['miner_pct'][$row['pct']] = $row['votes'];
}
// берем все голоса user_pct
$res = $this->db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT `currency_id`,\n\t\t\t\t\t\t\t `pct`,\n\t\t\t\t\t\t\t count(`user_id`) as `votes`\n\t\t\t\tFROM `" . DB_PREFIX . "votes_user_pct`\n\t\t\t\tGROUP BY `currency_id`, `pct`\n\t\t\t\t");
while ($row = $this->db->fetchArray($res)) {
$pct_votes[$row['currency_id']]['user_pct'][$row['pct']] = $row['votes'];
}
debug_print($pct_votes, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$PctArray = ParseData::getPctArray();
$new_pct = array();
foreach ($pct_votes as $currency_id => $data) {
// определяем % для майнеров
$pct_arr = ParseData::makePctArray($data['miner_pct']);
$key = get_max_vote($pct_arr, 0, 390, 100);
$new_pct['currency'][$currency_id]['miner_pct'] = ParseData::getPctValue($key);
debug_print('$key miner_pct=' . $key, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
// определяем % для юзеров
$pct_arr = ParseData::makePctArray($data['user_pct']);
// раньше не было завимости юзерского % от майнерского
if (isset($this->block_data['block_id']) && $this->block_data['block_id'] <= 95263) {
$user_max_key = 390;
} else {
$pct_y = array_search($new_pct['currency'][$currency_id]['miner_pct'], $PctArray);
debug_print('miner_pct $pct_y=' . $pct_y, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$max_user_pct_y = round($pct_y / 2, 2);
debug_print('$max_user_pct=' . $max_user_pct_y, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$user_max_key = find_user_pct($max_user_pct_y);
debug_print('$user_max_key=' . $user_max_key, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
// отрезаем лишнее, т.к. поиск идет ровно до макимального возможного, т.е. до miner_pct/2
$pct_arr = del_user_pct($pct_arr, $user_max_key);
debug_print('$user_$pct_arr=' . print_r_hex($pct_arr), __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
}
$key = get_max_vote($pct_arr, 0, $user_max_key, 100);
debug_print('$key user_pct=' . $key, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$new_pct['currency'][$currency_id]['user_pct'] = ParseData::getPctValue($key);
debug_print('user_pct=' . $new_pct['currency'][$currency_id]['user_pct'], __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print('user pct y=' . array_search($new_pct['currency'][$currency_id]['user_pct'], $PctArray), __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
}
// раньше не было рефских
if (isset($this->block_data['block_id']) && $this->block_data['block_id'] <= 77951) {
$new_pct = $new_pct['currency'];
} else {
$ref_levels = array('first', 'second', 'third');
for ($i = 0; $i < sizeof($ref_levels); $i++) {
$level = $ref_levels[$i];
$votes_referral = array();
// берем все голоса
$res = $this->db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\t\t\tSELECT `{$level}`,\n\t\t\t\t\t\t\t\t\t count(`user_id`) as `votes`\n\t\t\t\t\t\tFROM `" . DB_PREFIX . "votes_referral`\n\t\t\t\t\t\tGROUP BY `{$level}`\n\t\t\t\t\t\t");
while ($row = $this->db->fetchArray($res)) {
$votes_referral[$row[$level]] = $row['votes'];
}
$new_pct['referral'][$level] = get_max_vote($votes_referral, 0, 30, 10);
}
}
debug_print($new_pct, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
$json_data = json_encode($new_pct);
debug_print($json_data, __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
debug_print($this->tx_data['new_pct'], __FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__);
if ($this->tx_data['new_pct'] != $json_data) {
return 'new_pct error ' . $json_data;
}
}
