$marketurl = "https://bleutrade.com/exchange/{$coin->symbol}/BTC";
} else {
$marketurl = "";
}
}
}
}
}
}
if ($exchange->status == 'waiting') {
echo "<tr style='background-color: #e0d3e8;'>";
} else {
echo "<tr class='ssrow'>";
}
$sent = datetoa2($exchange->send_time) . ' ago';
$received = $exchange->receive_time ? sectoa($exchange->receive_time - $exchange->send_time) : '';
$price = $exchange->price ? bitcoinvaluetoa($exchange->price) : bitcoinvaluetoa($coin->price);
$estimate = bitcoinvaluetoa($exchange->price_estimate);
$total = $exchange->price ? bitcoinvaluetoa($exchange->quantity * $exchange->price) : bitcoinvaluetoa($exchange->quantity * $coin->price);
echo "<td><img width=16 src='{$coin->image}'></td>";
echo "<td><b><a href='/site/coin?id={$coin->id}'>{$coin->name} ({$coin->symbol})</a></b></td>";
echo "<td><b><a href='{$marketurl}' target=_blank>{$exchange->market}</a></b></td>";
echo "<td>{$sent}</td>";
echo "<td>{$exchange->quantity}</td>";
echo "<td>{$estimate}</td>";
echo "<td>{$price}</td>";
echo $total > 0.01 ? "<td><b>{$total}</b></td>" : "<td>{$total}</td>";
echo "<td>";
if ($exchange->status == 'waiting') {
// echo "<a href='/site/clearexchange?id=$exchange->id'>[clear]</a>";
echo "<a href='/site/deleteexchange?id={$exchange->id}'>[del]</a>";
//echo "<table class='dataGrid'>";
showTableSorter('maintable');
echo "<thead>";
echo "<tr>";
echo "<th>ID</th>";
echo "<th>User</th>";
echo "<th>Host</th>";
echo "<th>Db</th>";
echo "<th>Idle</th>";
echo "<th>Created</th>";
echo "<th>Last</th>";
echo "<th></th>";
echo "</tr>";
echo "</thead><tbody>";
foreach ($list as $conn) {
echo "<tr class='ssrow'>";
$d1 = sectoa($conn->idle);
$d2 = datetoa2($conn->created);
$d3 = datetoa2($conn->last);
$b = Booltoa($conn->last == $last);
echo "<td>{$conn->id}</td>";
echo "<td>{$conn->user}</td>";
echo "<td>{$conn->host}</td>";
echo "<td>{$conn->db}</td>";
echo "<td>{$d1}</td>";
echo "<td>{$d2}</td>";
echo "<td>{$d3}</td>";
echo "<td>{$b}</td>";
echo "</tr>";
}
echo "</tbody></table><br>";
// {
// $state = memcache_get($this->memcache->memcache, "cronjob_block_state_$i");
// if($state) echo "block $i ";
// }
if ($i != $state_main - 1 && $state_main > 0) {
$state = memcache_get($this->memcache->memcache, "cronjob_main_state_{$i}");
if ($state) {
echo "main {$i} ";
}
}
}
echo "</span>";
$block_time = sectoa(time() - memcache_get($this->memcache->memcache, "cronjob_block_time_start"));
$loop2_time = sectoa(time() - memcache_get($this->memcache->memcache, "cronjob_loop2_time_start"));
$main_time2 = sectoa(time() - memcache_get($this->memcache->memcache, "cronjob_main_time_start"));
$main_time = sectoa(memcache_get($this->memcache->memcache, "cronjob_main_time"));
$main_text = cronstate2text($state_main);
echo "*** main ({$main_time}) {$state_main} {$main_text} ({$main_time2}), loop2 ({$loop2_time}), block ({$block_time})<br>";
$topay = dboscalar("select sum(balance) from accounts where coinid={$btc->id}");
//here: take other currencies too
$topay2 = bitcoinvaluetoa(dboscalar("select sum(balance) from accounts where coinid={$btc->id} and balance>0.001"));
$renter = dboscalar("select sum(balance) from renters");
$stats = getdbosql('db_stats', "1 order by time desc");
$margin2 = bitcoinvaluetoa($btc->balance - $topay - $renter + $stats->balances + $stats->onsell + $stats->wallets);
$margin = bitcoinvaluetoa($btc->balance - $topay - $renter);
$topay = bitcoinvaluetoa($topay);
$renter = bitcoinvaluetoa($renter);
$immature = dboscalar("select sum(amount*price) from earnings where status=0");
$mints = dboscalar("select sum(mint*price) from coins where enable");
$off = $mints - $immature;
$immature = bitcoinvaluetoa($immature);
