jackk mentioned the possibility of reversing Eugine’s votes by running a script to upvote the comments that he had downvoted.
Villiam’s solution is better, I think. The system certainly keeps track of who downvoted what and allows reversions, because I can see and revert my own up or downvotes.
Further improvement: Remove only downvotes against users he specifically targeted. Whatever remains is probably still a valid signal. That might be a more complex script, though.
Find all sets of Eugine’s votes on comments by particular users, filter out any sets such that there are less than ten votes within that set or the ratio of upvotes to downvotes is greater than, say, 0.2, and reverse any downvotes in the remaining sets? That sounds like it should be compactly doable with SQL, although I don’t know a thing about the LW database.
Villiam’s solution is better, I think. The system certainly keeps track of who downvoted what and allows reversions, because I can see and revert my own up or downvotes.
Further improvement: Remove only downvotes against users he specifically targeted. Whatever remains is probably still a valid signal. That might be a more complex script, though.
Find all sets of Eugine’s votes on comments by particular users, filter out any sets such that there are less than ten votes within that set or the ratio of upvotes to downvotes is greater than, say, 0.2, and reverse any downvotes in the remaining sets? That sounds like it should be compactly doable with SQL, although I don’t know a thing about the LW database.
That’s why I hedged a bit. I know SQL is capable of doing such a thing, but I don’t know anything about the LW database either.