One of my many admirers just went through literally every single post or comment I’ve ever made to downvote. Is there a way to see who it is and save them from having to see my posts in the future?
Also, is that how blocking works? I know that I won’t see posts from someone I’ve blocked but does it also stop them from seeing/interacting with my content?
If you run a server…
#!/bin/sh INSTANCE=myinstance.com psql -U lemmy -c "SELECT (person.name || '@' || instance.domain) AS user, ('https://' || instance.domain || '/u/' || person.name) AS their_instance_url, ('https://${INSTANCE}/u/' || person.name || '@' || instance.domain) AS url, comment_like.score FROM comment_like JOIN person ON comment_like.person_id = person.id JOIN instance ON person.instance_id = instance.id WHERE comment_id = $1;"Edit: lol@ the downvotes. Do people think lemmy operates on the principles of magic? Sorry my SQL offends you.