Error comments on [moderator action] Eugine_Nier is now banned for mass downvote harassment - Less Wrong

107 Post author: Kaj_Sotala 03 July 2014 12:04PM

You are viewing a comment permalink. View the original post to see all comments and the full post content.

Comments (366)

You are viewing a single comment's thread. Show more comments above.

Comment author: Viliam_Bur 03 July 2014 01:32:18PM 15 points [-]

Does the system keep track about individual downvotes (who downvoted what)? If yes, then it could be possible to simply revert all votes ever by Eugine. Which should solve all the problems: everyone would have the same total karma and comment karma as if this whole thing never happened.

Comment author: ialdabaoth 03 July 2014 08:52:06PM *  45 points [-]

It has to - otherwise you wouldn't be able to see what YOU upvoted/downvoted.

Also, otherwise you would be able to upvote or downvote something multiple times.

So clearly, it has to track somewhere.

If you guys need a SQL guy to help do some development work to make meta-moderation easier, let me know; I'll happily volunteer a few hours a week.

EDIT: AAAUUUGH REDDIT'S DB USES KEY-VALUE PAIRS AIIEEEE IT ONLY HAS TWO TABLES OH GOD WHY WHY SAVE ME YOG-SOTHOTH I HAVE GAZED INTO THE ABYSS AAAAAAAIIIIGH okay. I'll still do it. whimper

Comment author: Error 03 July 2014 11:40:53PM *  12 points [-]

Maybe that's why volunteer dev work for LW is so hard to come by. Everybody takes one look at the DB and decides they would prefer a very long vacation in Sarlacc, Tatooine.

Comment author: KnaveOfAllTrades 04 July 2014 02:07:28AM *  4 points [-]

Didn't even get to the point of getting the DB up and running when I looked into it before I ran out of motviation (at that time). LW-hacking is not particularly accessible, though it's not clear how high making it more accessible is as a priority.

Comment author: jackk 04 July 2014 04:31:48AM *  4 points [-]

When did you last try? You should be able to more-or-less go git checkout -> vagrant up and have everything pretty much ready to go. https://github.com/tricycle/lesswrong/wiki/Development-VM-Image