$intBalance = $row["balance"]; $intBalance = number_format($intBalance, 8); //balance of BTC //get bitcoin rate if ($strCryptoCode == "btc") { $intRate_BTC_USD = funct_Billing_GetRate("btc"); //get usd value of BTC - coindesk, gox, bitstamp $intCrypto2Fiat_rate = $intRate_BTC_USD; $total_fiat_balance = (double) ($intBalance * $intRate_BTC_USD); // $intBalance_Fiat = money_format('%i', $total_fiat_balance); $intBalance_Fiat = $total_fiat_balance; } //convert to other fiat if not dollars if ($strFiatCode != "usd") { //get fiat rate $intBalance_Fiat2USD = funct_Billing_UpdateRate_Fiat($strFiatCode); //echo "fiat $strFiatCode - $intBalance_Fiat2USD <br>"; //get other crypto rate //$intCrypto2Fiat_rate = $intRate_BTC_USD ; $intCrypto2Fiat_rate = $intBalance_Fiat2USD * $intRate_BTC_USD; //no rate found so stick to dollars if (!$intBalance_Fiat2USD) { //set crypto back to usd $strFiatCode = "usd"; } } //get fiat info $query = "SELECT * FROM " . TBL_CURRENCY . " WHERE currency_code='" . $strFiatCode . "'"; //echo "SQL STMNT = " . $query . "<br>"; $rs = mysqli_query($DB_LINK, $query) or die(mysqli_error()); $row = mysqli_fetch_array($rs);
//echo "satoshi= ".$value_in_satoshi." <br> "; //we need to make sure this function works. a backup may be needed! Gox, blockchain, coinbase, bitpay ? $intRate = funct_Billing_UpdateRate("btc", RATE_HUD_EXCHANGE); //bitstamp.. lower the rate the bigger the spread //get value of BTC to convert to fiat $intBTC_Convert2Fiat = $crypto_amt * (1 / $intFiatConversionPercent); //calculate final BTC to add to BTC balance $intBTC_Add2Balance = $crypto_amt - $intBTC_Convert2Fiat; //calculate final FIAT to add to balance $intTotalUSD = $intRate * $intBTC_Convert2Fiat; //echo "userid: $intUserID"; //IF THEY have specified a different currency then we need to convert BTC to that currency if ($intCurrencyID != 144) { //if fiat currency is NOT USD then we need to get the exchange rate and adjust the amount of fiat they earned //get fiat rate, fiat code and $intFiatRate = funct_Billing_UpdateRate_Fiat($strCurrencyCode); //convert to value of btc.. we store all this into the orders table //ex. 0.7 for usd-eur $intTotalFiat = $intFiatRate * $intTotalUSD; } else { $intFiatRate = 1; $strCurrencyCode = "USD"; $intTotalFiat = $intTotalUSD; //defualt fiat is usd } //echo "BTC= ".$crypto_amt." <br> - USD= ".$intTotalUSD." \n <br>"; $strDebugSqlTxt = $strDebugSqlTxt . "BTC= " . $crypto_amt . " - USD= " . $intTotalUSD . " \n <br>"; //########################################## //echo $strDebugSqlTxt ; //add a new transaction record //btc recieved (amt_btc), btc2 add to btc balance, btc 2 convert to fiat, btc2usd (rate), btc recieved worth in usd (amt_usd), worth in fiat (fiat_earned), btc2 (fiat_rate) if ($intUserID) {