$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++;