<?php
function WriteBoxHeader($title)
{
echo "<div class='main-left-box'>";
echo "<div class='main-left-title'>{$title}</div>";
echo "<div class='main-left-inner'>";
}
$algo = user()->getState('yaamp-algo');
$total_rate = Itoa2(yaamp_pool_rate());
$list = getdbolist('db_coins', "enable and algo=:algo order by index_avg desc", array(':algo' => $algo));
$count = count($list);
$worker = getdbocount('db_workers', "algo=:algo", array(':algo' => $algo));
$services = getdbolist('db_services', "algo=:algo order by price desc", array(':algo' => $algo));
////////////
$table = array('scrypt' => 0, 'sha256' => 1, 'scryptn' => 2, 'x11' => 3, 'x13' => 4, 'x15' => 6, 'nist5' => 7, 'neoscrypt' => 8, 'lyra2' => 9);
$res = fetch_url("https://www.nicehash.com/api?method=orders.get&algo={$table[$algo]}");
if (!$res) {
return;
}
$a = json_decode($res);
$niceorders = $a->result->orders;
$allorders = array();
$nicehash = getdbosql('db_nicehash', "algo=:algo and orderid!=0", array(':algo' => $algo));
if ($nicehash) {
$index = $nicehash->price * 1000 + 1;
$allorders[$index] = array();
$allorders[$index]['speed'] = $nicehash->accepted;
$allorders[$index]['price'] = $nicehash->price;
$allorders[$index]['workers'] = $nicehash->workers;
$allorders[$index]['btc'] = $nicehash->btc;
function BackendStatsUpdate()
{
// debuglog(__FUNCTION__);
// $t1xx = microtime(true);
$t = time() - 2 * 60;
$errors = '';
$list = getdbolist('db_stratums', "time<{$t}");
foreach ($list as $stratum) {
debuglog("stratum {$stratum->algo} terminated");
$errors .= "{$stratum->algo}, ";
}
if (!empty($errors)) {
send_email_alert('stratums', "stratums restarted {$errors}", "stratums were restarted: {$errors}");
}
dborun("delete from stratums where time<{$t}");
dborun("delete from workers where pid not in (select pid from stratums)");
//////////////////////////////////////////////////////////////////////////////////////////////////////
// long term stats
$t = floor(time() / 60 / 60) * 60 * 60;
foreach (yaamp_get_algos() as $algo) {
$pool_rate = yaamp_pool_rate($algo);
$stats = getdbosql('db_hashstats', "time={$t} and algo=:algo", array(':algo' => $algo));
if (!$stats) {
$stats = new db_hashstats();
$stats->time = $t;
$stats->hashrate = $pool_rate;
$stats->algo = $algo;
} else {
$percent = 1;
$stats->hashrate = round(($stats->hashrate * (100 - $percent) + $pool_rate * $percent) / 100);
}
$stats->earnings = dboscalar("select sum(amount*price) from blocks where time>{$t} and category!='orphan' and algo=:algo", array(':algo' => $algo));
$stats->save();
}
////////////////////////////////////////////////////////////////////////////////////////////////////
// short term stats
$step = 15;
$t = floor(time() / $step / 60) * $step * 60;
foreach (yaamp_get_algos() as $algo) {
$stats = getdbosql('db_hashrate', "time={$t} and algo=:algo", array(':algo' => $algo));
if (!$stats) {
$stats = new db_hashrate();
$stats->time = $t;
$stats->hashrate = dboscalar("select hashrate from hashrate where algo=:algo order by time desc limit 1", array(':algo' => $algo));
$stats->hashrate_bad = 0;
//dboscalar("select hashrate_bad from hashrate where algo=:algo order by time desc limit 1", array(':algo'=>$algo));
$stats->price = dboscalar("select price from hashrate where algo=:algo order by time desc limit 1", array(':algo' => $algo));
$stats->rent = dboscalar("select rent from hashrate where algo=:algo order by time desc limit 1", array(':algo' => $algo));
$stats->algo = $algo;
}
$pool_rate = yaamp_pool_rate($algo);
$stats->hashrate = $pool_rate;
//round(($stats->hashrate*(100-$percent) + $pool_rate*$percent) / 100);
$pool_rate_bad = yaamp_pool_rate_bad($algo);
$stats->hashrate_bad = $pool_rate_bad;
//round(($stats->hashrate_bad*(100-$percent) + $pool_rate_bad*$percent) / 100);
if ($stats->hashrate < 1000) {
$stats->hashrate = 0;
}
$t1 = time() - 5 * 60;
$total_rentable = dboscalar("select sum(difficulty) from shares where valid and extranonce1 and algo=:algo and time>{$t1}", array(':algo' => $algo));
$total_diff = dboscalar("select sum(difficulty) from shares where valid and algo=:algo and time>{$t1}", array(':algo' => $algo));
$total_rented = 0;
if (!$total_diff) {
$t1 = time() - 15 * 60;
$total_diff = dboscalar("select sum(difficulty) from shares where valid and algo=:algo and time>{$t1}", array(':algo' => $algo));
}
if ($total_diff > 0) {
$price = 0;
$rent = 0;
$list = dbolist("select coinid, sum(difficulty) as d from shares where valid and algo=:algo and time>{$t1} group by coinid", array(':algo' => $algo));
foreach ($list as $item) {
if ($item['coinid'] == 0) {
if (!$total_rentable) {
continue;
}
$total_rented = $item['d'];
$price += $stats->rent * $item['d'] / $total_diff;
$rent += $stats->rent * $item['d'] / $total_rentable;
} else {
$coin = getdbo('db_coins', $item['coinid']);
if (!$coin) {
continue;
}
$btcghd = yaamp_profitability($coin);
$price += $btcghd * $item['d'] / $total_diff;
$rent += $btcghd * $item['d'] / $total_diff;
}
}
$percent = 33;
$rent = max($price, ($stats->rent * (100 - $percent) + $rent * $percent) / 100);
$target = yaamp_hashrate_constant($algo);
$interval = yaamp_hashrate_step();
$aa = $total_rentable * $target / $interval / 1000;
$bb = dboscalar("select sum(speed) from jobs where active and ready and price>{$rent} and algo=:algo", array(':algo' => $algo));
if ($total_rented * 1.3 < $total_rentable || $bb > $aa) {
$rent += $price * YAAMP_FEES_RENTING / 100;
} else {
$rent -= $price * YAAMP_FEES_RENTING / 100;
}
$stats->price = $price;
$stats->rent = $rent;
} else {
$coin = getdbosql('db_coins', "enable and auto_ready and algo=:algo order by index_avg desc", array(':algo' => $algo));
if ($coin) {
$btcghd = yaamp_profitability($coin);
$stats->price = $btcghd;
$stats->rent = $stats->price + $stats->price * YAAMP_FEES_RENTING / 100;
}
}
if (YAAMP_LIMIT_ESTIMATE) {
$t1 = time() - 24 * 60 * 60;
$avg = dboscalar("select avg(price) from hashrate where time>{$t1} and algo=:algo", array(':algo' => $algo));
if ($avg) {
$stats->price = min($stats->price, $avg * 1.5);
}
}
$stats->difficulty = dboscalar("select sum(difficulty) from coins where enable and auto_ready and algo=:algo", array(':algo' => $algo));
$stats->save();
}
//////////////////////////////////////////////////////////////
$step = 15;
$t = floor(time() / $step / 60) * $step * 60;
$btc = getdbosql('db_coins', "symbol='BTC'");
$topay = dboscalar("select sum(balance) from accounts where coinid={$btc->id}");
//here: take other currencies too
$margin = $btc->balance - $topay;
$balances = dboscalar("select sum(balance) from balances");
$onsell = dboscalar("select sum(amount*bid) from orders");
$immature = dboscalar("select sum(amount*price) from earnings where status=0");
$confirmed = dboscalar("select sum(amount*price) from earnings where status=1");
$wallets = dboscalar("select sum(balance*price) from coins where enable and symbol!='BTC'");
$renters = dboscalar("select sum(balance) from renters");
$mints = dboscalar("select sum(mint*price) from coins where enable");
$off = $mints - $immature;
// debuglog("mint $mints $immature $off");
$total_profit = $btc->balance + $balances + $onsell + $wallets - $topay - $renters;
$stats = getdbosql('db_stats', "time={$t}");
if (!$stats) {
$stats = new db_stats();
$stats->time = $t;
}
$stats->profit = $total_profit;
$stats->wallet = $btc->balance;
$stats->wallets = $wallets;
$stats->margin = $margin;
$stats->balances = $balances;
$stats->onsell = $onsell;
$stats->immature = $immature;
$stats->waiting = $confirmed;
$stats->renters = $renters;
$stats->save();
/////////////////////////////////////////////////////////////////////////////
foreach (yaamp_get_algos() as $algo) {
$factor = yaamp_get_algo_norm($algo);
$dbalgo = getdbosql('db_algos', "name='{$algo}'");
if (!$dbalgo) {
$dbalgo = new db_algos();
$dbalgo->name = $algo;
}
$dbalgo->profit = dboscalar("select price from hashrate where algo=:algo order by time desc limit 1", array(':algo' => $algo));
$dbalgo->rent = dboscalar("select rent from hashrate where algo=:algo order by time desc limit 1", array(':algo' => $algo));
$dbalgo->factor = $factor;
$dbalgo->save();
}
// $d1 = microtime(true) - $t1xx;
// controller()->memcache->add_monitoring_function(__METHOD__, $d1);
}
$price = controller()->memcache->get_database_scalar("current_price-{$algo}", "select price from hashrate where algo=:algo order by time desc limit 1", array(':algo' => $algo));
$norm = $price * $algo_norm;
$norm = take_yaamp_fee($norm, $algo);
$algos[] = array($norm, $algo);
}
function cmp($a, $b)
{
return $a[0] < $b[0];
}
usort($algos, 'cmp');
foreach ($algos as $item) {
$norm = $item[0];
$algo = $item[1];
$count1 = getdbocount('db_jobs', "algo=:algo and ready and active", array(':algo' => $algo));
$count2 = getdbocount('db_jobs', "algo=:algo and ready", array(':algo' => $algo));
$total = yaamp_pool_rate($algo);
$hashrate = yaamp_pool_rate_rentable($algo);
$hashrate_jobs = yaamp_rented_rate($algo);
$hashrate = min($total, $hashrate);
$hashrate_jobs = min($hashrate, $hashrate_jobs);
$available = $hashrate - $hashrate_jobs;
$percent = $hashrate_jobs && $hashrate ? '(' . round($hashrate_jobs / $hashrate * 100, 1) . '%)' : '';
$hashrate_jobs = $hashrate_jobs > 0 ? Itoa2($hashrate_jobs) . 'h/s' : '';
$available = $available > 0 ? Itoa2($available) . 'h/s' : '';
$hashrate = $hashrate > 0 ? Itoa2($hashrate) . 'h/s' : '';
$total = $total > 0 ? Itoa2($total) . 'h/s' : '';
$renting = controller()->memcache->get_database_scalar("current_renting-{$algo}", "select rent from hashrate where algo=:algo order by time desc limit 1", array(':algo' => $algo));
$renting = mbitcoinvaluetoa($renting);
if ($defaultalgo == $algo) {
echo "<tr style='cursor: pointer; background-color: #e0d3e8;' onclick='javascript:select_algo(\"{$algo}\")'>";
} else {
<?php
function WriteBoxHeader($title)
{
echo "<div class='main-left-box'>";
echo "<div class='main-left-title'>{$title}</div>";
echo "<div class='main-left-inner'>";
}
$algo = user()->getState('yaamp-algo');
$total_rate = yaamp_pool_rate();
$total_rate_d = $total_rate ? Itoa2($total_rate) . 'h/s' : '';
if ($algo == 'all') {
$list = getdbolist('db_coins', "enable and visible order by index_avg desc");
} else {
$list = getdbolist('db_coins', "enable and visible and algo=:algo order by index_avg desc", array(':algo' => $algo));
}
$count = count($list);
if ($algo == 'all') {
$worker = getdbocount('db_workers');
} else {
$worker = getdbocount('db_workers', "algo=:algo", array(':algo' => $algo));
}
$services = getdbolist('db_services', "algo=:algo order by price desc", array(':algo' => $algo));
////////////////////////////////////////////////////////////////////////////////////
WriteBoxHeader("Mining {$count} coins at {$total_rate_d} * with {$worker} miners ({$algo})");
//echo "<table class='dataGrid2'>";
showTableSorter('maintable3');
echo "<thead>";
echo "<tr>";
echo "<th></th>";
echo "<th>Name</th>";
function BackendCoinsUpdate()
{
// debuglog(__FUNCTION__);
$t1 = microtime(true);
$pool_rate = array();
foreach (yaamp_get_algos() as $algo) {
$pool_rate[$algo] = yaamp_pool_rate($algo);
}
$coins = getdbolist('db_coins', "installed");
foreach ($coins as $coin) {
// debuglog("doing $coin->name");
$coin = getdbo('db_coins', $coin->id);
if (!$coin) {
continue;
}
$remote = new Bitcoin($coin->rpcuser, $coin->rpcpasswd, $coin->rpchost, $coin->rpcport);
$info = $remote->getinfo();
if (!$info) {
$coin->enable = false;
// $coin->auto_ready = false;
$coin->connections = 0;
$coin->save();
continue;
}
// debuglog($info);
$coin->enable = true;
if (isset($info['difficulty'])) {
$difficulty = $info['difficulty'];
} else {
$difficulty = $remote->getdifficulty();
}
if (is_array($difficulty)) {
$coin->difficulty = $difficulty['proof-of-work'];
if (isset($difficulty['proof-of-stake'])) {
$coin->difficulty_pos = $difficulty['proof-of-stake'];
}
} else {
$coin->difficulty = $difficulty;
}
if ($coin->algo == 'quark') {
$coin->difficulty /= 0x100;
}
if ($coin->difficulty == 0) {
$coin->difficulty = 1;
}
$coin->errors = isset($info['errors']) ? $info['errors'] : '';
$coin->txfee = isset($info['paytxfee']) ? $info['paytxfee'] : '';
$coin->connections = isset($info['connections']) ? $info['connections'] : '';
$coin->balance = isset($info['balance']) ? $info['balance'] : 0;
$coin->mint = dboscalar("select sum(amount) from blocks where coin_id={$coin->id} and category='immature'");
if (empty($coin->master_wallet)) {
$coin->master_wallet = $remote->getaccountaddress('');
// debuglog($coin->master_wallet);
}
if (empty($coin->rpcencoding)) {
$difficulty = $remote->getdifficulty();
if (is_array($difficulty)) {
$coin->rpcencoding = 'POS';
} else {
$coin->rpcencoding = 'POW';
}
}
if ($coin->hassubmitblock == NULL) {
$remote->submitblock('');
if (strcasecmp($remote->error, 'method not found') == 0) {
$coin->hassubmitblock = false;
} else {
$coin->hassubmitblock = true;
}
}
if ($coin->auxpow == NULL) {
$ret = $remote->getauxblock();
if (strcasecmp($remote->error, 'method not found') == 0) {
$coin->auxpow = false;
} else {
$coin->auxpow = true;
}
}
// if($coin->symbol != 'BTC')
// {
// if($coin->symbol == 'PPC')
// $template = $remote->getblocktemplate('');
// else
$template = $remote->getblocktemplate('{}');
if ($template && isset($template['coinbasevalue'])) {
$coin->reward = $template['coinbasevalue'] / 100000000 * $coin->reward_mul;
if ($coin->symbol == 'TAC' && isset($template['_V2'])) {
$coin->charity_amount = $template['_V2'] / 100000000;
}
if (isset($template['payee_amount']) && $coin->symbol != 'LIMX') {
$coin->charity_amount = $template['payee_amount'] / 100000000;
$coin->reward -= $coin->charity_amount;
// debuglog("$coin->symbol $coin->charity_amount $coin->reward");
} else {
if (!empty($coin->charity_address)) {
if ($coin->charity_amount) {
} else {
$coin->reward -= $coin->reward * $coin->charity_percent / 100;
}
}
}
if (isset($template['bits'])) {
$target = decode_compact($template['bits']);
$coin->difficulty = target_to_diff($target);
}
} else {
if (strcasecmp($remote->error, 'method not found') == 0) {
$template = $remote->getmemorypool();
if ($template && isset($template['coinbasevalue'])) {
$coin->usememorypool = true;
$coin->reward = $template['coinbasevalue'] / 100000000 * $coin->reward_mul;
if (isset($template['bits'])) {
$target = decode_compact($template['bits']);
$coin->difficulty = target_to_diff($target);
}
} else {
$coin->auto_ready = false;
$coin->errors = $remote->error;
}
} else {
$coin->auto_ready = false;
$coin->errors = $remote->error;
}
}
if (strcasecmp($coin->errors, 'No more PoW blocks') == 0) {
$coin->dontsell = true;
$coin->auto_ready = false;
}
// }
if ($coin->block_height != $info['blocks']) {
$count = $info['blocks'] - $coin->block_height;
$ttf = (time() - $coin->last_network_found) / $count;
if (empty($coin->actual_ttf)) {
$coin->actual_ttf = $ttf;
}
$coin->actual_ttf = percent_feedback($coin->actual_ttf, $ttf, 5);
$coin->last_network_found = time();
}
$coin->version = $info['version'];
$coin->block_height = $info['blocks'];
$coin->save();
// debuglog(" end $coin->name");
}
$coins = getdbolist('db_coins', "enable order by auxpow desc");
foreach ($coins as $coin) {
$coin = getdbo('db_coins', $coin->id);
if (!$coin) {
continue;
}
if ($coin->difficulty) {
$coin->index_avg = $coin->reward * $coin->price * 10000 / $coin->difficulty;
if (!$coin->auxpow && $coin->rpcencoding == 'POW') {
$indexaux = dboscalar("select sum(index_avg) from coins where enable and visible and auto_ready and auxpow and algo='{$coin->algo}'");
$coin->index_avg += $indexaux;
}
}
if ($coin->network_hash) {
$coin->network_ttf = $coin->difficulty * 0x100000000 / $coin->network_hash;
}
if (isset($pool_rate[$coin->algo])) {
$coin->pool_ttf = $coin->difficulty * 0x100000000 / $pool_rate[$coin->algo];
}
if (strstr($coin->image, 'http')) {
$data = file_get_contents($coin->image);
$coin->image = "/images/coin-{$coin->id}.png";
@unlink(YAAMP_HTDOCS . $coin->image);
file_put_contents(YAAMP_HTDOCS . $coin->image, $data);
}
$coin->save();
}
$d1 = microtime(true) - $t1;
controller()->memcache->add_monitoring_function(__METHOD__, $d1);
}
