目的:用于设计合理的数据库字段存储特定地址的历史

获取最近num个区块的方式:api.trongrid.io/wallet/getblockbylatestnum?num=num

以下例子基于区块ID为32378435的数据

TRX

示例:

"ret": [
    {
        "contractRet": "SUCCESS"
    }
],
"signature": [
    "910f1ba80fc530124c909a1d046251a356fa743c0e91fc6c77f3ec2e8eef1fc30be292ba42b1dc3bb6bb7572ac234a096fe9d37c2599ffc83b3cca64fd35723a01"
],
"txID": "196d9cb5072d05dd6c5ffe89b0cde71789800abfda4ce3adfb6bd7f1cfeb7aea",
"raw_data": {
    "data": "e4b893e6b3a8e4ba8ee58cbae59d97e993bee9a1b9e79baee58c85e8a385e7ad96e58892e8bf90e890a5e4b880e7ab99e5bc8fe69c8de58aa1efbc8ce4b880e994aee58f91e5b881efbc8c44415050e5bc80e58f91efbc8ce689b9e9878fe8bdace8b4a6efbc8ce6b5b7e58685e5a496e8b4a2e7bb8fe5aa92e4bd93e5aea3e58f91efbc8ce6b3a2e59cbae58aa9e6898b68747470733a2f2f74726f6e68656c702e696fe5aea2e69c8de5beaee4bfa174726f6e617373697374616e742f74726f6e61696465",
    "contract": [
        {
            "parameter": {
                "value": {
                    "amount": 1,
                    "owner_address": "410ac5e852004d831a3ba6e6c84f290bd39e189b5e",
                    "to_address": "410986687edcd493d062fd05c326de17a64eebd89a"
                },
                "type_url": "type.googleapis.com/protocol.TransferContract"
            },
            "type": "TransferContract"
        }
    ],
    "ref_block_bytes": "0e2f",
    "ref_block_hash": "443029efb0bf917c",
    "expiration": 1627611975000,
    "timestamp": 1627611917575
},
"raw_data_hex": "0a020e2f2208443029efb0bf917c40d89aefa9af2f52c601e4b893e6b3a8e4ba8ee58cbae59d97e993bee9a1b9e79baee58c85e8a385e7ad96e58892e8bf90e890a5e4b880e7ab99e5bc8fe69c8de58aa1efbc8ce4b880e994aee58f91e5b881efbc8c44415050e5bc80e58f91efbc8ce689b9e9878fe8bdace8b4a6efbc8ce6b5b7e58685e5a496e8b4a2e7bb8fe5aa92e4bd93e5aea3e58f91efbc8ce6b3a2e59cbae58aa9e6898b68747470733a2f2f74726f6e68656c702e696fe5aea2e69c8de5beaee4bfa174726f6e617373697374616e742f74726f6e616964655a65080112610a2d747970652e676f6f676c65617069732e636f6d2f70726f746f636f6c2e5472616e73666572436f6e747261637412300a15410ac5e852004d831a3ba6e6c84f290bd39e189b5e1215410986687edcd493d062fd05c326de17a64eebd89a18017087daeba9af2f"

字段含义:

  • "type": "TransferContract"表示这是一个TRX Transfer
  • "contractRet": "SUCCESS"表示成功
  • "amount": 1为发送数额,需要除以10^精度 才是真实值,TRX精度是6
  • owner_address为发送者地址的HEX格式
  • to_address为接收者地址的HEX格式
  • data是备注,转为Utf8即可看到备注文本,如果Transfer没备注则没这个字段

TRC10

示例

"ret": [
    {
        "contractRet": "SUCCESS"
    }
],
"signature": [
    "6be003e9ae8bc24b7c320ebf716d65bbf27d77339fa2223b5e87055fc20a6d49612e2e8d481cadb8941f3bc1ed14638ef374c2fdbe338723938a5fef9412d1a900"
],
"txID": "18f7ada1eac34435357a38b12baa188fae1914d15d24c7b129663fcee0838663",
"raw_data": {
    "data": "53707265616420756e636f6e646974696f6e616c206c6f76652c206d616b65206120686170707920776f726c64",
    "contract": [
        {
            "parameter": {
                "value": {
                    "amount": 7618406,
                    "asset_name": "31303034303331",
                    "owner_address": "41ef3ebcf4eeb3f16e511d7c94dced8f318d6625ec",
                    "to_address": "4119db9504e434508bfc5f29be11a69d387780d694"
                },
                "type_url": "type.googleapis.com/protocol.TransferAssetContract"
            },
            "type": "TransferAssetContract"
        }
    ],
    "ref_block_bytes": "0e2f",
    "ref_block_hash": "443029efb0bf917c",
    "expiration": 1627611927306,
    "timestamp": 1627611867306
},
"raw_data_hex": "0a020e2f2208443029efb0bf917c408aa6eca9af2f522d53707265616420756e636f6e646974696f6e616c206c6f76652c206d616b65206120686170707920776f726c645a76080212720a32747970652e676f6f676c65617069732e636f6d2f70726f746f636f6c2e5472616e736665724173736574436f6e7472616374123c0a0731303034303331121541ef3ebcf4eeb3f16e511d7c94dced8f318d6625ec1a154119db9504e434508bfc5f29be11a69d387780d69420e6fed00370aad1e8a9af2f"

字段含义

  • "type": "TransferAssetContract"表示这是一个TRC10 Transfer
  • "contractRet": "SUCCESS"表示成功,除了SUCCESS之外还有OUT_OF_ENERGY,表示能量不足。
  • "asset_name": "31303034303331"为TRC10通证ID的HEX格式,将31303034303331转为ASCII或者Utf8字符串可得到1004031,1004031就是通证ID
  • "amount": 7618406为Transfer数额,需要除以通证的10^精度 才是真实值
  • owner_address为发送者地址的HEX格式
  • to_address为接收者地址的HEX格式
  • data是备注,转为Utf8即可看到备注文本,如果转账没备注则没这个字段
  • 遗留问题:通证的精度从哪里解析?目前只能根据通证ID再去查一遍

TRC20

示例

"ret": [
    {
        "contractRet": "SUCCESS"
    }
],
"signature": [
    "cce3f2ae7f1ed71f8221a9f1c1e17e0d6e5522acf6d9ee1a3e6947548e9dc000665eb09ede7c2918552a69ec7b995fe8c4d0c913e4c07eadce1f3fb4691a0da800"
],
"txID": "24190ffd0ef9aeac092cdbc1cb72608aa6878100b60df376e44d41772edc8b56",
"raw_data": {
    "data": "6d656d6f",
    "contract": [
        {
            "parameter": {
                "value": {
                    "data": "a9059cbb00000000000000000000000045c1098b64c646b2766ba322a704d12e709d7ba800000000000000000000000000000000000000000000001ba5abf9e779380000",
                    "owner_address": "41568b3b208d915cce7d0d785b4437e177cd2181c5",
                    "contract_address": "411fc796d0601456996b9a9c85a2fcc09a91c51065"
                },
                "type_url": "type.googleapis.com/protocol.TriggerSmartContract"
            },
            "type": "TriggerSmartContract"
        }
    ],
    "ref_block_bytes": "0e42",
    "ref_block_hash": "0d97e93a1faed6fa",
    "expiration": 1627647918000,
    "scripts": "73637269707473",
    "fee_limit": 10000000,
    "timestamp": 1627611918000
},
"raw_data_hex": "0a020e4222080d97e93a1faed6fa40b0ff80bbaf2f52046d656d6f5aae01081f12a9010a31747970652e676f6f676c65617069732e636f6d2f70726f746f636f6c2e54726967676572536d617274436f6e747261637412740a1541568b3b208d915cce7d0d785b4437e177cd2181c51215411fc796d0601456996b9a9c85a2fcc09a91c510652244a9059cbb00000000000000000000000045c1098b64c646b2766ba322a704d12e709d7ba800000000000000000000000000000000000000000000001ba5abf9e77938000062077363726970747370b0ddeba9af2f900180ade204"

字段含义:

  • raw_data_hex包含2244a9059cbb为transfer方法转账,不包含则可能是其它function的智能合约触发
  • "type": "TriggerSmartContract"表示当前为一个TRC20 Transfer
  • "contractRet": "SUCCESS"表示成功,除了SUCCESS之外还有OUT_OF_ENERGY,表示能量不足。
  • 第一个data是备注,转为Utf8即可看到备注文本,如果转账没备注则没这个字段
  • owner_address为发送者地址的HEX格式
  • contract_address为TRC20发行合约的HEX格式
  • 第二个data参数,从第33位开始连续40位抽取出来(45c1098b64c646b2766ba322a704d12e709d7ba8),前面增加“41”即为收款人的地址HEX(4145c1098b64c646b2766ba322a704d12e709d7ba8)
  • 第二个data参数,倒数64位为Transfer数量的16进制,转10进制除以该合约的10^精度 可得到真实数量

其它注意事项

  • 有些TRC20 Transfer没有timestamp字段,例如:
    703f7451e23293a629f8a5ddd62305bb2173d5efece482aef5d58d1f641752cb
    这个时候可以用expiration这个时间戳
  • 有些TRC20转账多了个call_value字段,这种不是常规的TRC20转账,第二个data字段也无法解析出相应信息,例如:
    b00b60c2c25ec540b7a65456c4001881ceb36ee36992e57cd56da104c0ac8e5e
    这个时候就放弃该条历史

如何获取所有区块上的接收者地址?

  • 遍历,如果是TRX或TRC10,则直接把to_address转base58;如果是TRC20,判断不存在call_value后,第二个data参数,从第33位开始连续40位抽取出来,前面增加“41”再转base58即为接收者的地址
  • 得到所有base58地址和对应的txID后,去跟数据库的地址取交集即需要记录历史信息的地址

添加新评论