$output = '<< debug mode >>'; $newline = '<br>'; } else { //live mode $newline = "\n"; //output is sent via email \n is newline in email } //get options from api_options table $queryO = $db->query('SELECT * FROM ' . $context['optionsTable'] . ' ORDER BY opt'); $output .= $newline . $newline . 'api_options' . $newline; foreach ($queryO as $opt) { $output .= '[ ' . $opt['opt'] . ': ' . $opt['setting'] . ' ]'; $btc_e_option[$opt['opt']] = $opt['setting']; } echo $output; $acctInfo = $api->apiQuery('getInfo'); $acctFunds = $acctInfo['return']['funds']; $currency = $btc_e_option['btc_e_currency']; $pair = $currency . '_usd'; //database field $price_field = 'btce_' . $currency; $queryMA = $db->query('SELECT (AVG(' . $price_field . ')) AS ma_7 FROM ' . $context['pricesTable'] . ' WHERE count <= 7'); foreach ($queryMA as $row) { $ma_7 = $row['ma_7']; } $queryMA = $db->query('SELECT (AVG(' . $price_field . ')) AS ma_30 FROM ' . $context['pricesTable'] . ' WHERE count <= 30'); foreach ($queryMA as $row) { $ma_30 = $row['ma_30']; } $latestPrice = $allPrices[$pair]['lastPrice']; $btcPrice = $allPrices['btc_usd']['lastPrice'];
echo "MySQL error: " . $mysqli->error . PHP_EOL; exit; } // Clean database $result = $mysqli->query("DELETE FROM `bitbot`.`ticker` WHERE `ticker`.`timestamp` < " . (time() - 60 * 60 * 24 * 2)); if (!$result) { echo "MySQL error: " . $mysqli->error . PHP_EOL; exit; } //DELETE FROM `bitbot`.`ticker` WHERE `ticker`.`id` = 1 } catch (BTCeAPIException $e) { echo $e->getMessage(); } // Get account balance try { $accountInfo = $BTCeAPI->apiQuery('getInfo'); $ltc = $accountInfo['return']['funds']['ltc']; $btc = $accountInfo['return']['funds']['btc']; $nmc = $accountInfo['return']['funds']['nmc']; $nvc = $accountInfo['return']['funds']['nvc']; $ppc = $accountInfo['return']['funds']['ppc']; $usd = $accountInfo['return']['funds']['usd']; // Save to database $result = $mysqli->query("UPDATE `bitbot`.`balance` SET `ltc` = '" . $ltc . "', `btc` = '" . $btc . "', `nmc` = '" . $nmc . "', `nvc` = '" . $nvc . "', `ppc` = '" . $ppc . "', `usd` = '" . $usd . "', `timestamp` = '" . time() . "' WHERE `balance`.`id` = 1;"); if (!$result) { echo "MySQL error: " . $mysqli->error . PHP_EOL; exit; } } catch (BTCeAPIException $e) { echo $e->getMessage(); }
<?php /** * Example Usage of the BTCe API PHP Class * * @author marinu666 * @license MIT License - https://github.com/marinu666/PHP-btce-api */ require_once 'btce-api.php'; $BTCeAPI = new BTCeAPI('', ''); // Example getInfo try { // Perform the API Call $getInfo = $BTCeAPI->apiQuery('getInfo'); // Print so we can see the output print_r($getInfo); } catch (BTCeAPIException $e) { echo $e->getMessage(); } // Example Custom query try { // Input Parameters as an array (see: https://btc-e.com/api/documentation for list of parameters per call) $params = array('pair' => 'btc_usd'); // Show info for the btc_usd pair // Perform the API Query print_r($BTCeAPI->apiQuery('ActiveOrders', $params)); } catch (BTCeAPIException $e) { echo $e->getMessage(); } // Making an order try {
/** * @param BTCeAPI $api * @return mixed * @throws BTCeAPIException */ public function load(BTCeAPI &$api) { $qRes = $api->apiQuery('getInfo'); if (isset($qRes['return']) && isset($qRes['return']['funds'])) { log_msg("Connection success, server time: " . date('Y.m.d H:i:s', $qRes['return']['server_time'])); $qRes['return']['updated'] = time(); $this->import($qRes['return']['funds']); } else { throw new BTCeAPIException(StorageException::$messages[StorageException::NO_DATA_IN_RESULT]); } return true; }