• Announcements

    • Harken Unto Ye

      Logging in   05/10/2017

      If you had an account and can't log in as of 5/9/17, this may be because of a change in logins with new forum software. You can log in using your publicly displayed name (not your username) or your email address and the password you used before.   If you have problems with this, please ask any of the mods or admins. 
Sign in to follow this  
Followers 0
sylae

In which I abuse my access to the database for the purposes of statistics

89 posts in this topic

Correlation does not equal causation!

VCH likes this

Share this post


Link to post
Share on other sites

If the option to "dislike" was added I wonder how it would effect the ranking? With out the "dislike" every thing is skewed in favor of the "like" as choosing not to like is not the same as the "dislike" option.

VCH likes this

Share this post


Link to post
Share on other sites

If the option to "dislike" was added I wonder how it would effect the ranking?

Sylae would be the only one with a positive reputation, and everyone else would be between 0 and -589. Also, the only option for adding a dislike feature makes likes and dislikes anonymous, so we wouldn't be able to have statistics on it at all.

 

Dikiyoba has grown rather fond of the current like system. It's silly and pointless, and that's the true spirit of these boards.

Share this post


Link to post
Share on other sites

Besides, I often like a post, only to dislike it later, The overall "likedness" of a member doesn't decrease, but it gives me a giddy thrill the likes of which most people think is"weird".

VCH likes this

Share this post


Link to post
Share on other sites

Niiiiiiiiii-ki.

 

When Dikiyoba likes and then quickly unlikes that like, the reputation reverts back to the original count. Maybe it only does that for a short time after the original like, though?

VCH likes this

Share this post


Link to post
Share on other sites

Oh, no, that's what I mean. Once my like is retracted, there remains no evidence of the like except for a notification to say that I did like your post, and the realisation that I must have disliked it. Rowen clearly knows what I mean, if my 7 notifications are anything to go by.

 

(oh god. this could very easily be a facebook conversation. what has happened to my beautiful SW?)

Share this post


Link to post
Share on other sites
Rowen clearly knows what I mean, if my 7 notifications are anything to go by.

 

I was testing it out, repeatedly. :D

nikki. likes this

Share this post


Link to post
Share on other sites

Not to spoil the fun for you guys, but it is actually possible to dislike posts even now.

Share this post


Link to post
Share on other sites

Not to spoil the fun for you guys, but it is actually possible to dislike posts even now.

Oh? How so?

 

Dikiyoba.

Share this post


Link to post
Share on other sites

Oh? How so?

Go to your profile,click on the option for likes, become the master of the universe.

Share this post


Link to post
Share on other sites

Go to your profile,click on the option for likes, become the master of the universe.

That allows you to unlike the posts you have already liked (which results in no change to a reputation score, since it simply removes the positive reputation point you gave previously). That's different from having the ability to dislike a post (which would give a negative reputation point).

 

Dikiyoba.

Share this post


Link to post
Share on other sites

I love how the internet has made "like," "dislike," and "unlike" into technical terms.

VCH likes this

Share this post


Link to post
Share on other sites

That allows you to unlike the posts you have already liked (which results in no change to a reputation score, since it simply removes the positive reputation point you gave previously). That's different from having the ability to dislike a post (which would give a negative reputation point).

OOps I guess, I should have read the posts better.

Also I saw the graph, managed to understand it, but will someone tell me what is R2?

Share this post


Link to post
Share on other sites

.....having the ability to dislike a post

 

You can always like a post you really hate, so that you can unlike it later. :p

Share this post


Link to post
Share on other sites

Nobody likes me :(

That's got to be the most innovative and the most ironic way of getting a bagful of likes.

(even worse, you beat me to it. :( )

Share this post


Link to post
Share on other sites
Also, the only option for adding a dislike feature makes likes and dislikes anonymous, so we wouldn't be able to have statistics on it at all.

Actually, no. It would just not display them publicly, the information has to be stored, otherwise users would be able to downvote something to oblivion relatively easily. If you look at the database, all reputation things are stored in reputation_index. You might also find core_like interesting, it's what seems to handle the display of who liked things, but doesn't do anything besides caching, as I discovered after two hours of SQLing.

 

For reference, here's the SQL I used for my data.

select author_name, count(id) as likes, n_posts, count(id)/n_posts as lpp from
 (select * from reputation_index left join posts on posts.pid = reputation_index.type_id where type='pid') as likes join
   (select member_id as n_uid, count(pid) as n_posts from posts join members on posts.author_id = members.member_id where post_date > 1350540000 group by author_id) as mposts
on likes.author_id = mposts.n_uid group by author_id order by count(id)/n_posts desc

Share this post


Link to post
Share on other sites

That's got to be the most innovative and the most ironic way of getting a bagful of likes.

(even worse, you beat me to it. :( )

 

I'd call it underhanded and manipulative, but since I cooperated with it, I have no room to complain.

Share this post


Link to post
Share on other sites

I'd call it underhanded and manipulative, but since I cooperated with it, I have no room to complain.

HAHA SUCCESS!!

Share this post


Link to post
Share on other sites

Well that's interesting, apparently there's a quota of positive votes for each day, which I just reached. :p

Share this post


Link to post
Share on other sites

Might be interesting to see the stats split by General / Game fora, to identify the impact of game releases more clearly.

okay

 

001b9e1d.png

 

it's combined into four categories, BoX, Exile (and Exile Remake (And Exile Remake Remake)), Geneforge, and Avadon. Nethergate is not shown, if you're curious imagine a very small line.

 

oh and the darker lines are 20-period moving averages

Edited by sylae
general/misc/techsupport is not shown because it's huge always

Share this post


Link to post
Share on other sites

Clearly, this chart says that Geneforge needs more faction debates. Down with the Shaper acid-spitting reptile-dogs! All hail the servile cultists!

 

Dikiyoba.

Share this post


Link to post
Share on other sites

To my partially color-blind eyes, this chart says, "There's some colors and a lot of spikes." Can there be a text summary?

Share this post


Link to post
Share on other sites

You need to mark when games are released on sale with third party distributors to help remove the noise of new members complaining that the games don't work.

Share this post


Link to post
Share on other sites

Nethergate is also the oldest of the Spiderweb series and has the fewest games except for the much newer Avadon since it's not actually a series. Its engine is markedly the oldest, too.

 

—Alorael, who definitely think game number is contributory. Release date is harder. N:R is actually newer than G4, but its engine is much older. It received a Steam rerelease that didn't generate much forum buzz.

Share this post


Link to post
Share on other sites
Nethergate is also the oldest of the Spiderweb series [....] It's engine is markedly the oldest, too.

Exile called, they're on line three.

Actaeon and Tyranicus like this

Share this post


Link to post
Share on other sites

Exile - Avernum: The Original Series

 

Exile was the first version of the series now known as Avernum. A six person party and different spells and wepons.

Share this post


Link to post
Share on other sites

1. When I change sentences such that a noun becomes an adjective, the apostrophe must go.

 

2. By oldest I meant the most recent entry in the series is oldest, not that it is the series that has existed for longest. There's less discussion because most of the discussion has already been had and most of the players have already played or aren't going to.

 

—Alorael, who suspects, without bothering to check, that Nethergate's traffic is close to where the Exile trilogy's is. The Avernum trilogy is more active, but if you want the story you still have to play those original trilogy games, and there are much newer games to act as bait.

Share this post


Link to post
Share on other sites

in related news, have another graph. this one is more intricate, and measures the appearance of certain phrases occurring in message bodies. It's pretty advanced, and certainly not a glorified Ctrl-F :p

 

582339ba.png

Edited by sylae
guess what i became a fan of around april

Share this post


Link to post
Share on other sites

MLP: Friendship is 70% magic with a 95% confidence interval from 45-95%

 

—Alorael, who is quite sure that statistics are magic.

Share this post


Link to post
Share on other sites

—Alorael, who is quite sure that statistics are magic.

You are now Twilight Sparkle.

Share this post


Link to post
Share on other sites

I want to know whether the ponies like Avernum, Geneforge, or Avadon...or if they have true taste and realize Nethergate is the best pony game forum to post in.

 

Also, what about Spike?

Edited by Triumph
Dragon.
Tyranicus likes this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0