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?

  • amiganEnglish
    3•1 year ago

    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.