starboard-ventures / fevm-event-tracing

0 stars 0 forks source link

运行一个 SQL 脚本来检索 TransferShares Event 中所有的“from”和“to”用户 #8

Closed YeeeeeHan closed 3 months ago

YeeeeeHan commented 3 months ago

Code: PFIL.sol

Event: event TransferShares(address indexed from, address indexed to, uint256 sharesValue);

Keccak256 hash: TransferShares(address,address,uint256) = 0x9d9c909296d9c674451c0c24f02cb64981eb3b727f99865939192f880a755dcb

PFIL Mainnet: 0xAaa93ac72bECfbBc9149f293466bbdAa4b5Ef68C PFIL Calibration: 0xADD77Cb736Db6F4223776A3E4b173657D0d7F8c8

Obtain the results from the following command:

select transaction_has, "from", "to" from evm_receipt where logs like '%0x9d9c909296d9c674451c0c24f02cb64981eb3b727f99865939192f880a755dcb% 

我想获取所有出现在“from”和“to”列中的用户