$dbusr = "******";
// database username
$dbpwd = "Your_password";
// database password
$dbtbl = "Your_DB_Name";
// database name
// connect to the database
$db_handle = mysql_connect($dbhst, $dbusr, $dbpwd) or die("cannot connect");
$db_found = mysql_select_db($dbtbl) or die("cannot select DB");
$user_session = $_SESSION['user_session'];
// set session and check if logged in
if (!$user_session) {
$Logged_In = 2;
} else {
$Logged_In = 7;
$RPC_Host = "127.0.0.1";
// host for bitcoin rpc
$RPC_Port = "8333";
// port for bitcoin rpc
$RPC_User = "******";
// username for bitcoin rpc
$RPC_Pass = "******";
// password for bitcoin rpc
// dont change below here
$nu92u5p9u2np8uj5wr = "http://" . $RPC_User . ":" . $RPC_Pass . "@" . $RPC_Host . ":" . $RPC_Port . "/";
$Bytecoind = new jsonRPCClient($nu92u5p9u2np8uj5wr);
$wallet_id = "zelles(" . $user_session . ")";
$Bytecoind_Balance = $Bytecoind->getbalance($wallet_id, 6);
$Bytecoind_accountaddresses = $Bytecoind->getaddressesbyaccount($wallet_id);
$Bytecoind_List_Transactions = $Bytecoind->listtransactions($wallet_id, 10);
}
function getWalletsFromAccount($token = "Unset")
{
if ($token == "Unset") {
return null;
} else {
$bitcoind = new jsonRPCClient('http://' . $this->__get("username") . ':' . $this->__get("password") . '@' . $this->__get("btcserver") . ':' . $this->__get("btcport") . '/');
$newaddr = $bitcoind->getaddressesbyaccount(md5($token));
return $newaddr;
}
return null;
}
<?php
try {
$bitcoin->getinfo();
} catch (Exception $e) {
echo 'Error: Bitcoin server is down. Please email system administrator.';
$down = true;
}
if (!$down) {
global $db;
$accounts = $bitcoin->listaccounts();
//print_r($accounts);
$count = 0;
foreach ($accounts as $a => $t) {
//if($a!==''){
$bc = $bitcoin->getaddressesbyaccount($a);
print '<tr><td align="left">' . $a . '</td><td border="1px">';
foreach ($bc as $b) {
$v = $bitcoin->getreceivedbyaddress($b);
print $b . '<br />';
$sql = 'SELECT * FROM ' . TABLE_ORDERS_STATUS_HISTORY . ' AS osh LEFT JOIN ' . TABLE_ORDERS_STATUS . ' AS os ON os.orders_status_id = osh.orders_status_id WHERE os.orders_status_name = "' . Pending . '" AND osh.comments LIKE "%' . $b . '%"';
$result = $db->Execute($sql);
if ($result->RecordCount() > 0) {
while (!$result->EOF) {
$sql = 'SELECT * FROM ' . TABLE_ORDERS . ' LEFT JOIN ' . TABLE_ORDERS_STATUS . ' on orders_status_id WHERE orders_id = ' . $result->fields['orders_id'] . ' AND orders_status = "1"';
$order = $db->Execute($sql);
echo '<a href="' . zen_href_link('orders.php?page=1&oID=' . $result->fields['orders_id'] . '&action=edit', '', 'NONSSL') . '">Order ' . $result->fields['orders_id'] . '</a> | Due ' . $order->fields['order_total'] * $order->fields['currency_value'] . ' BTC | Received ' . $v . ' BTC | ' . $result->fields['orders_status_name'] . '<br />';
$result->MoveNext();
}
}
$count++;
