pull down to refresh

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

Are you now cheering for him??

reply

Read it however you like.

Thank you for giving me another comment to reply to.

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

reply

I am listening back to the pod before I post it.

reply

I realized we didn't do an audio check before we started

reply

Or, have you given me another comment to reply to?

reply

Yes, v4v comment please.

reply

What is this in reference to?

reply

I don't know. Take a guess. I only need 4 more. A little guessing game should put me over the top.

reply

Animal, mineral, or vegetable?

reply
reply

What was that?

reply
reply
reply

it's still early

reply
reply

The game. You still have 8 days to fall even lower.

reply

Sounds right. There's always some dumbass thing you can do to sink even lower.

reply

in a few hours 316 comments, not bad :)

reply

Just getting started

reply

your the 1st

Rock it :P

reply
reply

good dog

reply

swamped by trash

reply

Look again.

reply
reply

Pathetic

reply

in the cupboard

ohhh, I didn't exclude freebie comments! Will fix in the next update.

reply

no worries

reply

what is your point of posting "post, shit" ?

reply

Shit post over and over again

reply

That's kind of my thing

reply

I’m surprised the @OneOneSeven hasn’t throw his hat in the ring yet.

reply

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.

reply

How does this stop a bot?

reply

Nice query!

reply

We are all nakamoto

reply
reply
reply
reply

I tried by best to get the script to work but I keep getting an error message.

reply

What is the error message?

reply

syntax error. I downloaded file to my computer then opened the node.js and cut and pasted your command with my username but it said syntax error.

reply

Can you give me the full error message?

reply

Uncaught SyntaxError: Unexpected identifier 'node'

reply

Oh, try to remove the first line and run again. That might be needed to run it on Windows.

reply

You mean the first line of the script?

reply

Yes, I mean the

#!/usr/bin/env node

I think that's only a linux thing

I tried for quite a while to figure that out. Couldn't get the script to run so I promptly gave up.

reply

Did you get any error message?

Or any other information for me to help you out?

reply

Actually something is going on and I'm not getting any notifications from a lot of users all of the sudden, and the ones I had disappeared.... I didn't mute anyone, does SN have some sort of internal mechanism that thinks I'm a bot?

reply
I'm not getting any notifications from a lot of users all of the sudden, and the ones I had disappeared

you mean you saw a reply in your notification and now it's gone?

does SN have some sort of internal mechanism that thinks I'm a bot?

no

reply

Yea a bunch from @Undisciplined and @denlillaapan are just gone.

reply

Well, they were low-quality shitposting anyway. No harm done

reply

mhhh, weird, we might be hitting some edge case with this post

reply

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
reply

Don't show off your counting skills please. You're no better than RBD spamming with numbers!!

reply

this was a disaster

reply

As usual iI'm not in the list. :D

reply

Will you update this every day? 🥹

reply

Look again

reply

I got this

reply

Good god grayruby is going hard.

reply

Ok so gotta pump it up

reply
reply

Chitter

reply

Rbd is clearly not the fairest of them all, but the silliest

reply

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

reply
reply
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

This is 94

reply