$vars = array('input_id' => $row['id'], 'amount' => $row['amount'], 'txid' => $row['txid'], 'vout' => $row['vout'], 'sigscript' => $sigscript, 'keyindex' => $keyindexes); array_push($json['inputs'], $vars); } // Gather outputs $rows = DB::query("SELECT * FROM coin_sends WHERE status = 'pending' ORDER BY id"); foreach ($rows as $row) { // Gather recipients $recipients = array(); $arows = DB::query("SELECT * FROM coin_sends_addresses WHERE send_id = %d", $row['id']); foreach ($arows as $arow) { $vars = array('amount' => $arow['amount'], 'address' => $arow['address']); array_push($recipients, $vars); } // Get change address $change_address = $bip32->generate_address($wrow['id'], 0, 1); $change_sigscript = $bip32->address_to_sigscript($change_address); // Get key indexes of change address $change_keyindexes = array(); $addr_rows = DB::query("SELECT * FROM coin_addresses_multisig WHERE address = %s", $change_address); foreach ($addr_rows as $addr_row) { $change_keyindexes[] = '1/' . $addr_row['address_num']; } // Set vars $vars = array('output_id' => $arow['id'], 'recipients' => $recipients, 'change_keyindex' => $change_keyindexes, 'change_sigscript' => $change_sigscript); array_push($json['outputs'], $vars); } // Send file header("Content-disposition: attachment; filename=\"tx.json\""); header("Content-type: text/json"); echo json_encode($json); exit(0);