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