pull down to refresh
in a few hours 316 comments, not bad :)
reply
reply
your the 1st
Rock it :P
reply
swamped by trash
reply
swim
SHAMELESS
reply
you do ?
Pathetic
reply
in the cupboard
Shit
reply
good dog
reply
🫡
hole
ohhh, I didn't exclude freebie comments! Will fix in the next update.
reply
no worries
Post
reply
what is your point of posting "post, shit" ?
reply
Shit post over and over again
reply
over
SHAMELESS
reply
again
I was thinking the script would just fetch all comments on the post and reduce to calculate the leaderboard, instead of having to specify a nym manually
reply
I wanted to do that, but I realized the API makes this hard because of all the nested replies. I would have to assume some upper limit of how deeply nested replies are and then it might kill the server unnecessarily increase server load if everybody runs that script all the time.
So I decided to just use this simple SQL query for the leaderboard:
SELECT users.name, count("Item".id) AS nreplies
FROM "Item"
JOIN users ON users.id = "Item"."userId"
WHERE "rootId" = 948515 AND freebie = 'f'
GROUP BY users.name
ORDER BY nreplies DESC;
and give everyone a way to verify their own number by fetching all their own comments from last week (the items you can see in someone's profile) and then only counting the replies to this post.
What a terrible showing
reply
@coinsreporter is trying to move up the board. You guys can battle it out for 2nd.
reply
I thought I wouldn't compete for the first place. But now that you've given me a reason by encouraging others so ...
You're welcome as your worst enemy.
reply
No one's catching @grayruby. We can only hope to distract him with this and beat him at something else.
reply
This is now a between he and I. I want a fair play. You'll soon come to know @grayruby's an incompetent man.
reply
We work together closely. I know what I know and we can leave it at that.
reply
You're welcome once again and the same here.
Are you doing overtime today?
reply
This maniac edits the pod after we record and then wakes up early for Easter Morning
Or, have you given me another comment to reply to?
reply
Yes, v4v comment please.
What is this in reference to?
Indeed
reply
yes
reply
reply
What is?
I’m surprised the @OneOneSeven hasn’t throw his hat in the ring yet.
reply
reply
Don't show off your counting skills please. You're no better than RBD spamming with numbers!!
reply
this was a disaster
reply
reply
reply
reply
reply
reply
reply
reply
Yea a bunch from @Undisciplined and @denlillaapan are just gone.
reply
Well, they were low-quality shitposting anyway. No harm done
When I double clicked the script I got an error and couldn't figure out how to run it from from the prompt. I'm not very technical, but i trust that there's enough other people that are to verify. The absolute worst case scenario is that there's a miscount that results in me not getting a bounty that I otherwise would have, and in that case, I'm still having fun so whatever I guess. 😜
reply
Will you update this every day? 🥹
reply
Ok so gotta pump it up
reply
WOOF
thks :)
node nreplies.js roll
fetching all comments of last week for user roll ... 73 filtering by root.id = 948515 ... 30 roll has 30 replies in item 948515
fetching all comments of last week for user roll ... 73 filtering by root.id = 948515 ... 30 roll has 30 replies in item 948515
reply
I did a spoiler alert #948979
I was correct except for the 4th place.
I couldn't guess @WeAreAllSatoshi made so many comments.
reply
@ek44