this post was submitted on 05 Sep 2023
23 points (100.0% liked)
Melbourne
1842 readers
86 users here now
This community is a place created for the people of Melbourne and Victoria. We are a positive, welcoming and inclusive community. We might not agree about everything, but we always strive to stay civil and respectful.
The focus of our discussions is based around things that effect Victoria, but we are also free to discuss our local perspective on wider issues. Or head to the regular Daily Random Discussion thread to talk about anything.
Ongoing discussions, FAQs & Resources (still under construction)
Adoption Certificate for Nellie, the Daily Thread numbat (with thanks to @Catfish)
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Have read this. I was particularly heartened by the statement on that TransJustice site:
This backs up what I was saying: You are surrounded by people who support you.
As to the downvoter: I did make an attempt at that. The database under the hood of Lemmy is overwhelming. Basically, it contains all the federated content. If a single aussie.zone user subscribes to a community on another instance, then that content is in the database. The example posted in the other thread doesn't work for us: It shows who has upvoted/downvoted a single thread. But that's not what we want to do in your case. I need to search comment tables for posts you have been in and then cross-reference the comment_like table for postid, userid and commentid.
I'm not a Database admin by trade, I'm ok at database stuff, but this is some complicated bit of table join logic. It might be beyond me, but I haven't given up, yet.
Maybe fuck the downvote button off while you’re at it? Why do we need it in DT? Everyone defaults to sort by new anyway.
Definitely looks like downvotes can be switched off but might be a community- or instance-wide thing.
Well we could trial it in c/Melbourne then. The only action is the DT anyway.
That setting exists, but it's instance-wide. It would be a pretty drastic change to all of aussie.zone. I wouldn't personally be against it, I never use downvote anyway. But, it isn't a change I could arbitarily make.
You're a legend Nath.
Assuming you are able to identify a serial downvoter (or downvoters), what do you intend to do with that information?
A fair question. And something that I have given thought to. It'll depend on what is turned up. Downvoting a comment on its own is not against the rules. So, potentially nothing.
Stalking a user across multiple communities, downvoting all their comments while otherwise not being engaged at all in those communities takes us into bullying territory. Reddit had a built-in defense against that activity. If you go to a user profile there and just downvote all the comments, they don't actually take effect against the target. Lemmy doesn't have that feature yet. From that point, we'll see. I honestly don't know if it's even possible to do more than just see the vote records. If I delete a downvote, Lemmy may simply restore it through the next federation sync.
Whatever it is, I'll be transparent about it. I'm also conscious of the precedent this might set. Neither Lodion nor I are much interested in poking through the database and manually touching anything lightly.