If you're like us, you've been extremely excited about the launch of Regulars Jobs. Regulars are exciting for a few reasons. First, the art is different than anything else out there (see for yourself). Second, jobs!!! Regulars can work, get on-chain names from NFT owners, and earn $REG tokens from their jobs. Could this be the beginning of a de-centralized sims? It will be interesting to watch the ecosystem around Regulars continue to grow.
On-chain names
Regulars can get on-chain names, let's create a Sort query to see what users are naming their Regulars!
select
params[2].value as name,
params[1].value as token_id,
transaction_hash,
timestamp,
from
ethereum.transaction_log l
where
function_address = '0x1ffe4026573cead0f49355b9d1b276a78f79924f'
and name = 'NameChange'
order by
timestamp desc
limit
1000
Latest Regulars Jobs Minted
select
params[1].value as regular_id,
params[2].value as new_job_id,
params[3].value as company_id,
params[4].value as sender,
transaction_hash,
timestamp,
from
ethereum.transaction_log l
where
function_address = '0x7e300bb12e416a9242e17ec44bbd9ae4e97f3f54'
and name = 'jobIDCreated'
order by
timestamp desc
limit
10000
Hopefully these queries are enough to get started ingesting Regulars data into your app!
Feel free to ask any questions (or for query help) on our Discord.
Top comments (0)