Sbhn_NPScope Try
Updated 2024-12-07
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
32
33
34
›
⌄
select DISTINCT substr(utils.udf_base58_to_hex(instruction:data),3,1000) as raw_data,
regexp_substr_all(SUBSTR(raw_data, 3, len(raw_data)), '.{8}') as segmented_data,
utils.udf_hex_to_string((segmented_data [0])) as test0,
utils.udf_hex_to_string((segmented_data [1])) as test1,
utils.udf_hex_to_string((segmented_data [2])) as test2,
utils.udf_hex_to_string((segmented_data [3])) as test3,
utils.udf_hex_to_string((segmented_data [4])) as test4,
from eclipse.core.fact_events_inner
where tx_id = '7tb2yQhgh2W3ifvnxTQasLo28eitDibDf4DGdzwZq57mNuHjqpGGfL6XwN5GHX8ctmQh3DQvQ6rx4ZSqjVu7mCe'
and program_id = 'Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic'
select DISTINCT to_varchar(base64_decode_binary(instruction:data))
from eclipse.core.fact_events_inner
where tx_id = '7tb2yQhgh2W3ifvnxTQasLo28eitDibDf4DGdzwZq57mNuHjqpGGfL6XwN5GHX8ctmQh3DQvQ6rx4ZSqjVu7mCe'
and program_id = 'Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic'
select
-- INNER_INSTRUCTION HEX SIGNATURE: 0xe445a52e51cb9a1d
replace(substr(utils.udf_base58_to_hex(INSTRUCTION:data), 3, 1000), '') AS hex_data
, utils.udf_hex_to_int('s2c', to_char(reverse(to_binary(substr(hex_data, 17, 8))))) AS length_of_name
, 25 + (length_of_name * 2) AS symbol_start
, utils.udf_hex_to_string(substr(hex_data, 25, length_of_name * 2)) AS name
, cast(name as varchar) as main
, utils.udf_hex_to_int('s2c', to_char(reverse(to_binary(substr(hex_data, symbol_start, 8))))) AS length_of_symbol
, utils.udf_hex_to_string(substr(hex_data, symbol_start + 8, length_of_symbol * 2)) AS symbol
from eclipse.core.fact_events_inner
where tx_id = '27jW9f9B4oKVTz8Q1Lu9dB1hVgmVB6YdZ6VuWB6DWcUw3Wz5QpKQrDm4TSwM4WrkLp5CRHc7KWxFNwwKtozDW5Vt'
and program_id = 'Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic'
-- select *
-- from eclipse.core.fact_events
-- where tx_id = '7tb2yQhgh2W3ifvnxTQasLo28eitDibDf4DGdzwZq57mNuHjqpGGfL6XwN5GHX8ctmQh3DQvQ6rx4ZSqjVu7mCe'