0xen π©
@0xen
Back on thanks to @grunt.eth and @drewf.eth making Dune dashboards. This is still just an experiment. I've been iterating on this since back in the FarCats Rodeo days and have some more ideas moving forward re FarCasino. Enjoy β¨ β¨ https://zora.co/collect/base:0x22d3fa035f0a2cf949537684b3d8b37dbc66b0ce/1
5 replies
3 recasts
61 reactions
grant π π© πΈ
@grunt.eth
Make sure to sanity check the winners before awarding :-) π«‘
1 reply
0 recast
0 reaction
grant π π© πΈ
@grunt.eth
@drewf.eth is there a better way than just manually writing these groups of 50 mints out in a case statement? https://dune.com/queries/3577333
1 reply
0 recast
0 reaction
Drew Fisher
@drewf.eth
Yeah, you can have a mint row have the accumulated counts with and without their mints. Then, you do integer division on both by 50. Then subtract the quotients (before from the after), and the difference is how many 50th/100th etc tokens were minted in that event. (Exclude the first mint though)
1 reply
0 recast
1 reaction
Drew Fisher
@drewf.eth
https://dune.com/0xdrewf/farcasino I learned about unnesting sequences for this, but this dashboard now does this to make it easy to list each of the wins, even if they mint more than 50 tokens at once.
0 reply
0 recast
1 reaction