🔥example
BRC-20 version Spirt stone
Story
In ancient times, there was a legendary inscription that possessed immense spiritual power, yet its energy seemed to be out of place in that era. To prevent this power from causing havoc in the mortal realm, the gods joined forces to seal its power away. For millions of time block, it lay quietly among the ruins of the gods' temple, amidst a pile of rubble, devoid of any vitality. Until block 793000...
Rule
There is no initial allocation, all tokens are generated through minting.
Anyone can mint since block height 793000 (around June 5 18:00 UTC) until block height 800000.
The first 100 inscriptions of every 10 blocks are considered valid.
The maximum limit for each individual inscription is 1000 tokens, and the reward halves every 144 blocks until the individual reward decreases to 125 tokens. After that, the reward remains unchanged until reach max supply.
Minting will stop when the total number of tokens reaches 21,000,000.
If there is any discrepancy between above textual description and the actual results of the code, the results of the code should be considered authoritative.
Deployment
{
"p": "brc-20c",
"tick": "oicp",
"op": "deploy",
"donation": "bc1q8lweg0c8pthyuhlsaxhjt4sf056cxg6k6gz8lz",
"code": {
"engine": "trino",
"version": "386",
"body": "with inputs as( select block_height, tx_id, array_join(witness_data,',') payload from bitcoin.inputs t where t.block_height>=793000 and t.block_height<800000 and t.index=0), txns as ( select t.id txid, t.index from bitcoin.transactions t where t.block_height>=793000 and t.block_height<800000 ), rawdata as ( SELECT '{' || from_utf8( from_hex( substr( payload, position('2270223a226272632d3230' in payload), position('7d68' in payload) - position('2270223a226272632d3230' in payload) ) ) ) || '}' as body, block_height, t.tx_id as txid FROM inputs t WHERE 1=1 AND t.payload LIKE '%0063036f726401%' AND t.payload LIKE '%2270223a226272632d3230%' AND t.payload LIKE '%227469636b223a226f69637022%' ), formatted as ( select *, COALESCE(TRY(JSON_PARSE(body)), NULL) as data from rawdata ), parsed as ( SELECT t.txid, block_height, json_extract_scalar(t.data, '$.p') as p, json_extract_scalar(t.data, '$.tick') as tick, json_extract_scalar(t.data, '$.op') as op, COALESCE( TRY( CAST (json_extract_scalar(t.data, '$.amt') AS integer) ), 0 ) as amt FROM formatted t where t.data is not null ), filtered as ( select * from parsed t where (t.p='brc-20' or t.p='brc-20c') and t.tick='oicp' and t.op='mint' and t.amt>0 and t.amt<=1000 ), integrated as ( select t.*, f.index from filtered t join txns f on t.txid=f.txid ), sequenced as ( select row_number() OVER (ORDER BY t.block_height ASC,t.index ASC) as seq, t.* from integrated t ), decodes as ( select * from sequenced order by seq asc ), temp1 as ( select ROW_NUMBER() OVER (PARTITION BY block_height/10 ORDER BY seq ASC) emission, * from decodes t where t.block_height>=793000 AND t.amt<=CASE WHEN 1000/POWER(2,(block_height-793000)/144) > 125 THEN 1000/POWER(2,(block_height-793000)/144) ELSE 125 END ), temp2 as ( select SUM(t.amt) over (order by seq) as supply, * from temp1 t where t.emission<=100 order by seq ASC ), oicp as ( select * from temp2 t where t.supply<2100*10000 )"
},
"oops": {
"mint": "select * from oicp"
}
}Inscription ID #10835888
Donation
The inclusion of the "Donation" field in the deployment was initially intended for demonstrating a conditional whitelist. However, it was later realized that such an approach might not be considered cool. If you appreciate this protocol, you are welcome to make a donation within your means. However, please do not expect any form of return or compensation.
Mint
In this example, both "p":"brc-20" and "p":"brc-20c" will be considered valid in order to demonstrate compatibility.
{"p":"brc-20","op":"mint","tick":"oicp","amt":"1000"}OR
{"p":"brc-20c","op":"mint","tick":"oicp","amt":"1000"}Other operations
As we discussed in the previous chapter, the upper-layer protocol inherits all the behaviors of the lower-layer protocol by default. Therefore, in this case, except for the overridden operation "mint", brc-20c inherits all the operations from brc-20. So, for other operations, please refer to the original protocol documentation for more details.
Verification
I suggest you guys run your own query...
Code explain
emmm, i suppose the code is quite straightforward and easy to understand, anything i need to explain?
with inputs as (
select block_height, tx_id, array_join(witness_data,',') payload
from
bitcoin.inputs t
where t.block_height>=793000 and t.block_height<800000 and t.index=0
),
txns as (
select t.id txid,
t.index
from bitcoin.transactions t
where t.block_height>=793000 and t.block_height<800000
),
rawdata as (
SELECT
'{' || from_utf8(
from_hex(
substr(
payload,
position('2270223a226272632d3230' in payload),
position('7d68' in payload) - position('2270223a226272632d3230' in payload)
)
)
) || '}' as body,
block_height,
t.tx_id as txid
FROM inputs t
WHERE 1=1
AND t.payload LIKE '%0063036f726401%'
AND t.payload LIKE '%2270223a226272632d3230%'
AND t.payload LIKE '%227469636b223a226f69637022%'
),
formatted as (
select *, COALESCE(TRY(JSON_PARSE(body)), NULL) as data from rawdata
),
parsed as (
SELECT t.txid,
block_height,
json_extract_scalar(t.data, '$.p') as p,
json_extract_scalar(t.data, '$.tick') as tick,
json_extract_scalar(t.data, '$.op') as op,
COALESCE(
TRY(
CAST (json_extract_scalar(t.data, '$.amt') AS integer)
),
0
) as amt
FROM formatted t
where t.data is not null
),
filtered as (
select * from parsed t where (t.p='brc-20' or t.p='brc-20c') and t.tick='oicp' and t.op='mint' and t.amt>0 and t.amt<=1000
),
integrated as (
select
t.*, f.index
from
filtered t
join
txns f on t.txid=f.txid
),
sequenced as (
select
row_number() OVER (ORDER BY t.block_height ASC,t.index ASC) as seq,
t.*
from
integrated t
),
decodes as (
select * from sequenced order by seq asc
),
temp1 as (
select ROW_NUMBER() OVER (PARTITION BY block_height/10 ORDER BY seq ASC) emission, * from decodes t
where
t.block_height>=793000
AND
t.amt<=CASE WHEN 1000/POWER(2,(block_height-793000)/144) > 125 THEN 1000/POWER(2,(block_height-793000)/144) ELSE 125 END
),
temp2 as (
select SUM(t.amt) over (order by seq) as supply, * from temp1 t
where
t.emission<=100
order by seq ASC
),
oicp as (
select * from temp2 t where t.supply<2100*10000
)Further work
OICP has many more interesting feature waiting to be explored, such as the polymorphism mentioned earlier, which has not been fully demonstrated in this example. Additionally, intelligent conditions can become even more interesting. Anyway, have fun and look forward.
Last updated