Content
@
0 reply
20 recasts
20 reactions
Ghostlinkz
@ghostlinkz.eth
This week's most active users on Farcaster: 1. @cameron 2. @kmacb.eth 3. @gokhan.eth 4. @antimofm.eth 5. @july Snapshot 025: outcasters.xyz/snapshot-025
15 replies
6 recasts
23 reactions
Q🎩
@qsteak.eth
Might we be able to see the weekly top 30 by Activity Score in addition to number of casts?
1 reply
0 recast
0 reaction
Ghostlinkz
@ghostlinkz.eth
Yes I think we can do that. But what would you use to calculate the activity score?
1 reply
0 recast
0 reaction
Q🎩
@qsteak.eth
Why not use the official formula? https://warpcast.notion.site/Active-badge-d81fea2e953e4dafae7c85295ffaf3ae
1 reply
0 recast
0 reaction
Ghostlinkz
@ghostlinkz.eth
Counting replies is a bit tricky as each reply contains the parent hash of the cast it directly responded to, rather than the original top-level cast. I’ve done recursive counting but not sure if my query is accounting for all levels of replies. It’s doable I just need to make sure my calculations are correct.
2 replies
0 recast
0 reaction
Manan
@manan
@ghostlinkz.eth we added a column named root_parent_hash to the casts table that should point to the highest level parent. It’ll save you from doing the recursion logic.
1 reply
0 recast
0 reaction
Q🎩
@qsteak.eth
O yah that does sound challenging. I guess I was assuming FC already had it calculated and it would just need to be pulled.
1 reply
0 recast
0 reaction
