#!/usr/bin/php
<?php

require_once('common.php');

/*
function fatal($string) {
	die("fatal:$string\n");
}

function checksetarray($base, $keys) {
        foreach ($keys as $key) {
                if (!isset($base[$key])) return false;
        }

        return true;
}

require('vendor/autoload.php');
require('secret.php');

require('db.php');

use BitWasp\Bitcoin\Address\AddressCreator;
use BitWasp\Bitcoin\Bitcoin;
use BitWasp\Bitcoin\Key\KeyToScript\KeyToScriptHelper;
use BitWasp\Bitcoin\Network\NetworkFactory;
use BitWasp\Bitcoin\Key\Deterministic\Slip132\Slip132;
use BitWasp\Bitcoin\Network\Slip132\BitcoinRegistry;
use BitWasp\Bitcoin\Key\Deterministic\HdPrefix\GlobalPrefixConfig;
use BitWasp\Bitcoin\Key\Deterministic\HdPrefix\NetworkConfig;
use BitWasp\Bitcoin\Serializer\Key\HierarchicalKey\Base58ExtendedKeySerializer;
use BitWasp\Bitcoin\Serializer\Key\HierarchicalKey\ExtendedKeySerializer;
 */

$addresses_group = db_query(<<<EOQ
SELECT walletpath_id, IF(COUNT(address_id) = MAX(idx) + 1, 'OK', 'ERROR') status, wallet_desc, path_desc
FROM addresses
JOIN walletpaths USING (walletpath_id)
JOIN paths USING (path_id)
JOIN wallets USING (wallet_id)
JOIN xpubs USING (xpub_id)
GROUP BY walletpath_id
EOQ);

while (($row = mysqli_fetch_assoc($addresses_group))) {
	echo($row['wallet_desc'].' / '.$row['path_desc'].': '.$row['status']."\n");
}

$scriptpubkeys = db_query(<<<EOQ
SELECT * FROM scriptpubkeys WHERE reverse_scriptpubkey_hash IS NULL
EOQ);

while (($row = mysqli_fetch_assoc($scriptpubkeys))) {
	echo(bin2hex($row['scriptpubkey'])."\n");
	db_exec("UPDATE scriptpubkeys SET reverse_scriptpubkey_hash = ? WHERE scriptpubkey_id = ?",
			calcReverseHash($row['scriptpubkey']), $row['scriptpubkey_id']);
}

$addresses = db_query(<<<EOQ
SELECT *
FROM addresses
JOIN walletpaths USING (walletpath_id)
JOIN paths USING (path_id)
JOIN wallets USING (wallet_id)
JOIN xpubs USING (xpub_id)
JOIN scriptpubkeys USING (address_id)
EOQ);

while (($row = mysqli_fetch_assoc($addresses))) {
	echo("-----\n");
	echo("xpub: ".$row['xpub']."\n");
	echo("path: ".$row['leaf'].$row['idx']."\n");
	echo("stored address: ".$row['address']."\n");
	/*$addrKey = $serializer->parse($btc, $row['xpub'])->derivePath($row['leaf'].$row['idx']);
	$address = $addrKey->getAddress($addrCreator)->getAddress($btc);*/
	$address = getAddress($row['xpub'], $row['leaf'].$row['idx']);
	echo("computed address: ".$address."\n");
	//print_r($addrKey);

/*
	//print_r($row);
	$txs = db_query("SELECT * FROM txs JOIN txos ON ( txos.create_txid_id = txs.txid_id OR txos.destroy_txid_id = txs.txid_id ) JOIN txids USING ( txid_id ) WHERE scriptpubkey_id = ?", $row['scriptpubkey_id']);
	$status = '';
	foreach ($txs as $tx) {
		$status .= $tx['txid'].':'.$tx['tx_height'].':';
	}
	echo("status=$status, status_hash=".hash('sha256', $status)."\n");
 */
	$scripthash_status = compute_scripthash_status($row['scriptpubkey_id']);
	echo("computed scripthash_status=$scripthash_status\n");
	$rwsh = getReverseScriptHash($address);
	$json = rpc_electrum('blockchain.scripthash.subscribe', $rwsh);
	echo("received scripthash_status=$json\n");
	echo(bin2hex(getScriptPubKey($address))."\n");
	$rwsh2 = bin2hex(strrev(hash('sha256', getScriptPubKey($address), true)));
	echo("rwsh=$rwsh\n");
	echo("rwsh2=$rwsh2\n");
	exit;
}


//echo(getReverseScriptHash('1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa')."\n");
?>