0xen 🎩 pfp
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 🌈 🎩 🐸 pfp
grant 🌈 🎩 🐸
@grunt.eth
Make sure to sanity check the winners before awarding :-) 🫑
1 reply
0 recast
0 reaction

grant 🌈 🎩 🐸 pfp
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 pfp
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 pfp
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