The serious answer is that the people who were downvoted noticed that they were downvoted. That was the whole point. At that moment, they should contact a moderator and report a suspicion. And we should make this visible somehow...
Anyway, the main damage was from knowing that someone mass-downvotes you anonymously, and you don’t know who, and you can’t defend. (And that it keeps happening to multiple people, for months.) This shouldn’t happen again, because it would be easier to fix the next time.
Using reddit’s database schema? Challenge accepted. I’m at work right now (writing SQL queries for my college, in fact), but I’ll gladly contribute something useful when I get home.
EDIT: This is a lot more difficult than anticipated. :( I’m going to have to do some serious research before I can produce something useful, given reddit’s flat kvp schema.
Now rewrite what you said as an SQL query...
:D
The serious answer is that the people who were downvoted noticed that they were downvoted. That was the whole point. At that moment, they should contact a moderator and report a suspicion. And we should make this visible somehow...
Anyway, the main damage was from knowing that someone mass-downvotes you anonymously, and you don’t know who, and you can’t defend. (And that it keeps happening to multiple people, for months.) This shouldn’t happen again, because it would be easier to fix the next time.
Using reddit’s database schema? Challenge accepted. I’m at work right now (writing SQL queries for my college, in fact), but I’ll gladly contribute something useful when I get home.
EDIT: This is a lot more difficult than anticipated. :( I’m going to have to do some serious research before I can produce something useful, given reddit’s flat kvp schema.