rezarwzall configure TX
Updated 2024-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
SELECT
tx_hash,
ORIGIN_FUNCTION_SIGNATURE,
'configureContract' as function,
to_address as contarct_address,
'0x' || SUBSTRING(input_data, 35, 40) AS target_address,
cast(SUBSTRING(input_data, 138, 1) AS INT) as yield_mode,
CAST(SUBSTRING(input_data, 202, 1) AS INT) AS gasMode,
'0x' || SUBSTRING(input_data, 227, 40) AS newGovernor
FROM
blast.core.fact_transactions
where
origin_function_signature = '0x4c802f38'
and STATUS = 'SUCCESS'
UNION
all
SELECT
tx_hash,
ORIGIN_FUNCTION_SIGNATURE,
'configure' as function,
from_Address as contarct_address,
to_address AS target_address,
cast(SUBSTRING(input_data, 74, 1) AS INT) as yield_mode,
CAST(SUBSTRING(input_data, 138, 1) AS INT) AS gasMode,
'0x' || SUBSTRING(input_data, 163, 40) AS newGovernor
from
blast.core.fact_transactions
where
origin_function_signature = '0xc8992e61'
and STATUS = 'SUCCESS'
and to_Address='0x4300000000000000000000000000000000000002'
QueryRunArchived: QueryRun has been archived