Lies, Damn Lies, and Forum Statistics

Vixen

So.......

Out of curiosity, is there any way to see how many likes users have given out? I've figured out how to see uses with the highest total rep (ORDER BY MAX(likesReceived-dislikesReceived) DESC) and I was wondering if there's an equivalent stat for likesGiven - dislikesGiven?

It would be interesting to see who gives the most karma points....

topspin

@Vixen the answer is @Tsaukpaetra. Next question.

Vixen

@topspin said in Lies, Damn Lies, and Forum Statistics:

@Vixen the answer is @Tsaukpaetra. Next question.

I mean that's abundantly obvious, but who is #2*?

* Inb4

Tsaukpaetra

Paying @julianlam @barisu

error

Apparently it's privileged information.

@error_bot query user tsaukpaetra

error_bot

uid	897
username	Tsaukpaetra
userslug	tsaukpaetra
groups	area_usa binned by-joining-this-group-you-agree-to-be-mentioned-randomly-for-no-reason-is-that-okay-yes-no discourse-touched-me-in-a-no-no-place impossible-mission-a kills-dumbledore programmers_testers regular sekret-pm-club self-serve-mafia self-serve-mafia-players the-freakin-president trolleybus-garage-mechanics trust_level_3
roles

hungrier

@error said in Lies, Damn Lies, and Forum Statistics:

Apparently it's privileged information.

Even then, you don't get a count, just a list sorted by most recent

mott555

We have a thread that's going to totally screw that statistic up anyway.

https://what.thedailywtf.com/topic/11847/the-official-likes-topic

Vixen

@mott555 said in Lies, Damn Lies, and Forum Statistics:

We have a thread that's going to totally screw that statistic up anyway.

https://what.thedailywtf.com/topic/11847/the-official-likes-topic

in theory it'll break both statistics in the same way (for users who participate) so its effect should be able to be statisticed out of the aggregate?

error

@Vixen said in Lies, Damn Lies, and Forum Statistics:

theory it'll break both statistics in the same way (for users who participate) so its effect should be able to be statisticed out of the aggregate?

Users can participate an arbitrary number of times.

jinpa

@Vixen said in Lies, Damn Lies, and Forum Statistics:

So.......

Out of curiosity, is there any way to see how many likes users have given out? I've figured out how to see uses with the highest total rep (ORDER BY MAX(likesReceived-dislikesReceived) DESC) and I was wondering if there's an equivalent stat for likesGiven - dislikesGiven?

It would be interesting to see who gives the most karma points....

I would also like to see likesGiven/postsRead. This way you can tell whether they give out their likes cheaply, and thus can reasonably decide the magnitude of the warm fuzzy you should get from the like.

Tsaukpaetra

@jinpa said in Lies, Damn Lies, and Forum Statistics:

postsRead

This isn't . The individual has-been-seen status of posts is not stored anywhere!

barisu

# of upvotes given by user 1 is db.sortedSetCard('uid:1:upvote');

# of downvotes given by user 1 is db.sortedSetCard('uid:1:downvote');

So

const netVotesGiven = await db.sortedSetCard('uid:1:upvote') - await db.sortedSetCard('uid:1:downvote');

The individual has-been-seen status of posts is not stored anywhere!

NodeBB stores a single value per topic per user to determine where a user has left of a topic. It is used used to take you back to that index when you re enter the topic.

Vixen

@barisu said in Lies, Damn Lies, and Forum Statistics:

# of upvotes given by user 1 is db.sortedSetCard('uid:1:upvote');

# of downvotes given by user 1 is db.sortedSetCard('uid:1:downvote');

So
const netVotesGiven = await db.sortedSetCard('uid:1:upvote') - await db.sortedSetCard('uid:1:downvote');
The individual has-been-seen status of posts is not stored anywhere!

NodeBB stores a single value per topic per user to determine where a user has left of a topic. It is used used to take you back to that index when you re enter the topic.

So...... not something that one without database access could get..... right.

Well then..... do I try to fix that.... or do I decide I'm not really prepared to wear a pair of linked silver bracelets that clash horribly with my fur?

Decisions.... decisions......

hungrier

@Vixen It's rumoured that PRs are accepted. Although I think publicly exposing this sort of thing might not be

JBert

@Vixen You could try asking administrators @PJH or @ben_lubar to run that query?

Zecc

@Tsaukpaetra said in Lies, Damn Lies, and Forum Statistics:

Paying @julianlam @barisu

How much?

Zecc

@barisu , not only do you grace us with your presence in this dark side of the internet, but you carry the Trolleybus Mechanic badge?

pie_flavor

@Zecc It's a NodeBB ~~bug~~feature where if you join a group, and you don't have a yet, that group is instantly selected as your . I'm guessing he just never bothered to deselect it.

Tsaukpaetra

@Zecc said in Lies, Damn Lies, and Forum Statistics:

@barisu , not only do you grace us with your presence in this dark side of the internet, but you carry the Trolleybus Mechanic badge?

I assume he doesn't know what it actually means get...

Luhmann

@jinpa said in Lies, Damn Lies, and Forum Statistics:

they give out their likes cheaply

Aka pulling a Tsaukpaetra

error

@Luhmann said in Lies, Damn Lies, and Forum Statistics:

@jinpa said in Lies, Damn Lies, and Forum Statistics:

they give out their likes cheaply

Aka pulling a Tsaukpaetra

Enough with the slut shaming!!11one

boomzilla

@JBert said in Lies, Damn Lies, and Forum Statistics:

@Vixen You could try asking administrators @PJH or @ben_lubar to run that query?

Not @PJH. @ben_lubar could probably do it. Also, we don't run Mongo so the details might be different. Ben did some stuff like this back in the day:

https://what.thedailywtf.com/topic/22416/ben_lubar-s-mongodb-science-thread/

Tsaukpaetra

@error said in Lies, Damn Lies, and Forum Statistics:

@Luhmann said in Lies, Damn Lies, and Forum Statistics:

@jinpa said in Lies, Damn Lies, and Forum Statistics:

they give out their likes cheaply

Aka pulling a Tsaukpaetra

Enough with the slut shaming!!11one

And yet I have yet to lay down. Something seems wrong with the conception I've been given...

topspin

@Tsaukpaetra do you sleep upright?!

Tsaukpaetra

@topspin said in Lies, Damn Lies, and Forum Statistics:

@Tsaukpaetra do you sleep upright?!

That might help, but the harness doesn't properly support that position...

I think I need a new one anyways, lying face-up isn't working for me anymore...

barisu

The commands are using the javascript database object so they would work on all dbs. If you want to get it directly from the database someone has to run psql queries to count those entries.

ben_lubar

@barisu said in Lies, Damn Lies, and Forum Statistics:

The commands are using the javascript database object so they would work on all dbs. If you want to get it directly from the database someone has to run psql queries to count those entries.

This is just personal preference, but I like using SQL over loading the entire database into memory.

PJH

@JBert said in Lies, Damn Lies, and Forum Statistics:

@Vixen You could try asking administrators @PJH or @ben_lubar to run that query?

I'm not an admin (or mod for that matter.) Haven't been for quite some time.

Tsaukpaetra

@PJH said in Lies, Damn Lies, and Forum Statistics:

@JBert said in Lies, Damn Lies, and Forum Statistics:

@Vixen You could try asking administrators @PJH or @ben_lubar to run that query?

I'm not an admin (or mod for that matter.) Haven't been for quite some time.

Couldn't handle being constantly blue balled?