function doCCexTrading($quick = false)
{
$flushall = rand(0, 4) == 0;
if ($quick) {
$flushall = false;
}
// debuglog("-------------- doCCexTrading() $flushall");
$ccex = new CcexAPI();
// upgrade orders
$coins = getdbolist('db_coins', "enable and id in (select distinct coinid from markets where name='c-cex')");
foreach ($coins as $coin) {
if ($coin->dontsell) {
continue;
}
$market2 = getdbosql('db_markets', "coinid={$coin->id} and (name='bittrex' or name='cryptsy')");
if ($market2) {
continue;
}
$pair = strtolower($coin->symbol) . '-btc';
// debuglog("c-cex list order for $pair");
sleep(5);
$orders = $ccex->getOrders($pair, 1);
if (!$orders || isset($orders['error'])) {
continue;
}
foreach ($orders['return'] as $uuid => $order) {
$ticker = $ccex->getTickerInfo($pair);
if (!$ticker) {
continue;
}
if ($order['price'] > $ticker['sell'] + 5.0E-8 || $flushall) {
// debuglog("c-cex cancel order for $pair $uuid");
sleep(5);
$ccex->cancelOrder($uuid);
$db_order = getdbosql('db_orders', "uuid=:uuid", array(':uuid' => $uuid));
if ($db_order) {
$db_order->delete();
}
sleep(1);
} else {
$db_order = getdbosql('db_orders', "uuid=:uuid", array(':uuid' => $uuid));
if ($db_order) {
continue;
}
debuglog("c-cex adding order {$coin->symbol}");
$db_order = new db_orders();
$db_order->market = 'c-cex';
$db_order->coinid = $coin->id;
$db_order->amount = $order['amount'];
$db_order->price = $order['price'];
$db_order->ask = $ticker['sell'];
$db_order->bid = $ticker['buy'];
$db_order->uuid = $uuid;
$db_order->created = time();
$db_order->save();
}
}
$list = getdbolist('db_orders', "coinid={$coin->id} and market='c-cex'");
foreach ($list as $db_order) {
$found = false;
foreach ($orders['return'] as $uuid => $order) {
if ($uuid == $db_order->uuid) {
$found = true;
break;
}
}
if (!$found) {
debuglog("c-cex deleting order {$coin->name} {$db_order->amount}");
$db_order->delete();
}
}
}
sleep(2);
//////////////////////////////////////////////////////////////////////////////////////////////////
$savebalance = getdbosql('db_balances', "name='c-cex'");
$savebalance->balance = 0;
// debuglog("c-cex getbalance");
sleep(5);
$balances = $ccex->getBalance();
if (!$balances || !isset($balances['return'])) {
return;
}
foreach ($balances['return'] as $balance) {
foreach ($balance as $symbol => $amount) {
if (!$amount) {
continue;
}
if ($symbol == 'btc') {
$savebalance->balance = $amount;
continue;
}
$coin = getdbosql('db_coins', "symbol=:symbol", array(':symbol' => $symbol));
if (!$coin || $coin->dontsell) {
continue;
}
$market = getdbosql('db_markets', "coinid={$coin->id} and name='c-cex'");
if ($market) {
$market->lasttraded = time();
$market->save();
}
if ($amount * $coin->price < 1.0E-5) {
continue;
}
$pair = "{$symbol}-btc";
////////////////////////
$maxprice = 0;
$maxamount = 0;
// debuglog("c-cex list order for $pair all");
sleep(5);
$orders = $ccex->getOrders($pair, 0);
foreach ($orders['return'] as $order) {
if ($order['type'] == 'sell') {
continue;
}
if ($order['price'] > $maxprice) {
$maxprice = $order['price'];
$maxamount = $order['amount'];
}
}
// debuglog("maxbuy for $pair $maxamount $maxprice");
if ($amount >= $maxamount && $maxamount * $maxprice > 1.0E-5) {
$sellprice = bitcoinvaluetoa($maxprice);
debuglog("c-cex selling market {$pair}, {$maxamount}, {$sellprice}");
sleep(5);
$res = $ccex->makeOrder('sell', $pair, $maxamount, $sellprice);
if (!$res || !isset($res['return'])) {
debuglog($res);
} else {
$amount -= $maxamount;
}
sleep(1);
}
///
$ticker = $ccex->getTickerInfo($pair);
if (!$ticker) {
continue;
}
$sellprice = bitcoinvaluetoa($ticker['sell']);
// debuglog("c-cex selling $pair, $amount, $sellprice");
sleep(5);
$res = $ccex->makeOrder('sell', $pair, $amount, $sellprice);
if (!$res || !isset($res['return'])) {
continue;
}
$db_order = new db_orders();
$db_order->market = 'c-cex';
$db_order->coinid = $coin->id;
$db_order->amount = $amount;
$db_order->price = $sellprice;
$db_order->ask = $ticker['sell'];
$db_order->bid = $ticker['buy'];
$db_order->uuid = $res['return'];
$db_order->created = time();
$db_order->save();
}
}
$savebalance->save();
// debuglog('-------------- doCCexTrading() done');
}
function updateCCexMarkets()
{
// dborun("update markets set price=0 where name='c-cex'"); <- add that line
$ccex = new CcexAPI();
$list = $ccex->getPairs();
foreach ($list as $item) {
$e = explode('-', $item);
if (!isset($e[1])) {
continue;
}
if ($e[1] != 'btc') {
continue;
}
$symbol = strtoupper($e[0]);
$coin = getdbosql('db_coins', "symbol=:symbol", array(':symbol' => $symbol));
if (!$coin || !$coin->installed) {
continue;
}
$market = getdbosql('db_markets', "coinid={$coin->id} and name='c-cex'");
if (!$market) {
$market = new db_markets();
$market->coinid = $coin->id;
$market->name = 'c-cex';
}
$market->save();
$ticker = $ccex->getTickerInfo($item);
if (!$ticker) {
continue;
}
$price2 = ($ticker['buy'] + $ticker['sell']) / 2;
$market->price2 = AverageIncrement($market->price2, $price2);
$market->price = AverageIncrement($market->price, $ticker['buy']);
$market->save();
}
}
function updateRawcoins()
{
// debuglog(__FUNCTION__);
$list = bittrex_api_query('public/getcurrencies');
if (isset($list->result)) {
dborun("update markets set deleted=true where name='bittrex'");
foreach ($list->result as $currency) {
updateRawCoin('bittrex', $currency->Currency, $currency->CurrencyLong);
}
}
$list = bleutrade_api_query('public/getcurrencies');
if (isset($list->result)) {
dborun("update markets set deleted=true where name='bleutrade'");
foreach ($list->result as $currency) {
updateRawCoin('bleutrade', $currency->Currency, $currency->CurrencyLong);
}
}
$list = cryptsy_api_query('getmarkets');
if (isset($list['return'])) {
dborun("update markets set deleted=true where name='cryptsy'");
foreach ($list['return'] as $item) {
updateRawCoin('cryptsy', $item['primary_currency_code'], $item['primary_currency_name']);
}
}
$ccex = new CcexAPI();
$list = $ccex->getPairs();
if ($list) {
dborun("update markets set deleted=true where name='c-cex'");
foreach ($list as $item) {
$e = explode('-', $item);
$symbol = strtoupper($e[0]);
updateRawCoin('c-cex', $symbol);
}
}
$poloniex = new poloniex();
$tickers = $poloniex->get_currencies();
dborun("update markets set deleted=true where name='poloniex'");
foreach ($tickers as $symbol => $ticker) {
if ($ticker['disabled']) {
continue;
}
if ($ticker['delisted']) {
continue;
}
updateRawCoin('poloniex', $symbol);
}
$res = yobit_api_query('info');
if ($res) {
dborun("update markets set deleted=true where name='yobit'");
foreach ($res->pairs as $i => $item) {
$e = explode('_', $i);
$symbol = strtoupper($e[0]);
updateRawCoin('yobit', $symbol);
}
}
//////////////////////////////////////////////////////////
dborun("delete from markets where deleted");
$list = getdbolist('db_coins', "not enable and not installed and id not in (select distinct coinid from markets)");
foreach ($list as $coin) {
debuglog("{$coin->symbol} is not longer active");
$coin->delete();
}
}
