TOTAL_CONTRACTS | BASIC | BASIC_INTERN_DR | BASIC_RESEARCHER_DR | ADVANCED | ADVANCED_SCIENTIST_DR | ADVANCED_GENIUS_DR | EXPERT | EXPERT_GENIUSES_DR | EXPERT_BRAIN_DR | INTERNS | RESEARCHERS | SCIENTISTS | GENIUSES | BRAINS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 772 | 32 | 71.875 | 28.125 | 18 | 77.777777778 | 22.222222222 | 722 | 78.947368421 | 21.052631579 | 23 | 9 | 14 | 574 | 152 |
csp88gTinkers luck (summary)
Updated 2025-04-29
999
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
35
36
›
⌄
WITH mydata AS (
select
*
from
near.core.fact_actions_events_function_call
where
RECEIVER_ID = 'aa-harvest-moon.near'
and METHOD_NAME = 'recruit_tinkers'
AND RECEIPT_SUCCEEDED = 'true'
/*Apr-03-2024 02:47:31*/
and BLOCK_TIMESTAMP > '2024-04-01 04:31:54.771'
and signer_id = '{{Your_wallet_address}}'
/*and signer_id = 'interstellarmeteor.near'*/
),
container_lvl_up AS (
SELECT
BLOCK_ID,
reverse(
substring(
reverse(LOGS [1]),
1,
charindex(' ', reverse(LOGS [1])) -1
)
) as container_lvl,
CASE
WHEN container_lvl = '9' THEN 92
WHEN container_lvl = '8' THEN 91
WHEN container_lvl = '7' THEN 89
WHEN container_lvl = '6' THEN 75
WHEN container_lvl = '5' THEN 57
WHEN container_lvl = '4' THEN 50
WHEN container_lvl = '3' THEN 40
WHEN container_lvl = '2' THEN 33
WHEN container_lvl = '1' THEN 25
END AS contract_drop_rate,
Last run: about 2 months agoAuto-refreshes every 24 hours
1
99B
35s