Topic: [ANNOUNCE] Abe 0.7: Open Source Block Explorer Knockoff - page 47. (Read 221044 times)

    {"chain":"SolidCoin",
     "code3":"SCN", "address_version":"\x7d", "magic":"\xde\xad\xba\xbe"},

format_satoshis(decimal.Decimal('12.3456'), 1)

1.23456E-7.012.3456

    def q_getreceivedbyaddress(abe, page, chain):
        """getreceivedbyaddress"""
        addr = wsgiref.util.shift_path_info(page['env'])
        if chain is None or addr is None:
            return 'returns amount of money received by given address (not balance, sends are not subtracted)\n' \
                '/chain/CHAIN/q/getreceivedbyaddress/ADDRESS\n'

        if ADDRESS_RE.match(addr):
          version, hash = decode_address(addr)
          sql = """
            SELECT 
              CONVERT(COALESCE(SUM(txout.txout_value),0), UNSIGNED) from pubkey 
            JOIN txout on txout.pubkey_id=pubkey.pubkey_id 
            JOIN block_tx on block_tx.tx_id=txout.tx_id 
            JOIN block b on b.block_id=block_tx.block_id 
            JOIN chain_candidate cc on cc.block_id=b.block_id 
            WHERE 
              pubkey_hash=? AND
              cc.chain_id=? AND
              cc.in_longest=1
            ;"""
          row = abe.store.selectrow(sql, (binascii.hexlify(hash), chain['id']))
          ret = format_satoshis(row[0], chain);
        else:
          ret = 'ERROR: address invalid'

        return ret
        
    def q_getsentbyaddress(abe, page, chain):
        """getsentbyaddress"""
        addr = wsgiref.util.shift_path_info(page['env'])
        if chain is None or addr is None:
            return 'returns amount of money sent from given address\n' \
                '/chain/CHAIN/q/getsentbyaddress/ADDRESS\n'

        if ADDRESS_RE.match(addr):
          version, hash = decode_address(addr)
          sql = """
            SELECT 
              CONVERT(COALESCE(SUM(txout.txout_value),0), UNSIGNED) from pubkey 
            JOIN txout txout on txout.pubkey_id=pubkey.pubkey_id 
            JOIN txin on txin.txout_id=txout.txout_id
            JOIN block_tx on block_tx.tx_id=txout.tx_id 
            JOIN block b on b.block_id=block_tx.block_id 
            JOIN chain_candidate cc on cc.block_id=b.block_id 
            WHERE 
              pubkey_hash=? AND
              cc.chain_id=? AND
              cc.in_longest=1
            ;"""
          row = abe.store.selectrow(sql, (binascii.hexlify(hash), chain['id']))
          ret = format_satoshis(row[0], chain);
        else:
          ret = 'ERROR: address invalid'

        return ret

C:\abe>python ab.py
at 169336263 of 698256440: '\x00\x00\x00\x00'
at 169394422: '\xf9\xbe\xb4\xd9'

format_satoshis(satoshis, chain)

UPDATE datadir SET blkfile_number = 1, blkfile_offset = 0

#!/usr/bin/env python
import BCDataStream
ds = BCDataStream.BCDataStream()
ds.map_file(open(r"C:\Users\user\AppData\Roaming\Bitcoin\blk0001.dat", "rb"),
            169336263)
offset = ds.read_cursor
magic = ds.read_bytes(4)
print "at %d of %d: %s" % (offset, len(ds.input), repr(magic))
if magic[0] == chr(0):
    ds.read_cursor = offset
    while ds.read_cursor < len(ds.input):
        b = ds.read_bytes(1)[0]
        if b != chr(0):
            ds.read_cursor -= 1
            break
    if ds.read_cursor + 4 <= len(ds.input):
        magic = ds.read_bytes(4)
        print "at %d: %s" % (ds.read_cursor, repr(magic))
    else:
        print "%d near end %d" % (ds.read_cursor, len(ds.input))

UPDATE datadir SET blkfile_offset=0 WHERE dirname='C:\Users\user\AppData\Roaming\Bitcoin'