function BackendClearEarnings() { // debuglog(__FUNCTION__); $delay = time() - 150 * 60; $total_cleared = 0; $list = getdbolist('db_earnings', "status=1 and mature_time<{$delay}"); foreach ($list as $earning) { $user = getdbo('db_accounts', $earning->userid); if (!$user) { $earning->delete(); continue; } $coin = getdbo('db_coins', $earning->coinid); if (!$coin) { $earning->delete(); continue; } $earning->status = 2; // cleared $earning->price = $coin->price; $earning->save(); // $refcoin = getdbo('db_coins', $user->coinid); // if($refcoin && $refcoin->price<=0) continue; // $value = $earning->amount * $coin->price / ($refcoin? $refcoin->price: 1); $value = yaamp_convert_amount_user($coin, $earning->amount, $user); $user->balance += $value; $user->save(); if ($user->coinid == 6) { $total_cleared += $value; } } if ($total_cleared > 0) { debuglog("total cleared from mining {$total_cleared} BTC"); } }
$list = dbolist("select coinid from earnings where userid={$user->id} group by coinid"); if (!count($list)) { echo "<tr><td></td><td colspan=5><i>-none-</i></td></tr>"; } else { // sort by value foreach ($list as $item) { $coin = getdbo('db_coins', $item['coinid']); if (!$coin) { continue; } $name = substr($coin->name, 0, 12); $confirmed = controller()->memcache->get_database_scalar("wallet_confirmed-{$user->id}-{$coin->id}", "select sum(amount) from earnings where status=1 and userid={$user->id} and coinid={$coin->id}"); $unconfirmed = controller()->memcache->get_database_scalar("wallet_unconfirmed-{$user->id}-{$coin->id}", "select sum(amount) from earnings where status=0 and userid={$user->id} and coinid={$coin->id}"); $total = $confirmed + $unconfirmed; // $value = bitcoinvaluetoa($total * $coin->price / $refcoin->price); $value = bitcoinvaluetoa(yaamp_convert_amount_user($coin, $total, $user)); $confirmed = altcoinvaluetoa($confirmed); $unconfirmed = altcoinvaluetoa($unconfirmed); $total = altcoinvaluetoa($total); echo "<tr class='ssrow'>"; echo "<td width=18><img width=16 src='{$coin->image}'></td>"; echo "<td><b><a href='/site/block?id={$coin->id}' title='{$coin->version}'>{$name}</a></b><span style='font-size: .8em'> ({$coin->algo})</span></td>"; echo "<td align=right style='font-size: .8em;'>{$unconfirmed}</td>"; echo "<td align=right style='font-size: .8em;'>{$confirmed}</td>"; echo "<td align=right style='font-size: .8em;'>{$total}</td>"; echo "<td align=right style='font-size: .8em;'>{$value} {$refcoin->symbol}</td>"; echo "</tr>"; } } $d1 = microtime(true) - $t1; controller()->memcache->add_monitoring_function('wallet_results-1', $d1);