<?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); }