-8
Downvote bots? (lemmy.ml)
submitted 2 years ago by [email protected] to c/[email protected]

am i being targeted by downvote bots?

top 5 comments
sorted by: hot top new old
[-] [email protected] 3 points 2 years ago* (last edited 2 years ago)
[-] [email protected] 0 points 2 years ago

Thanks, how did you get this information? it's something i'd like to keep track of

[-] [email protected] 3 points 2 years ago* (last edited 2 years ago)

I'm an admin of my own instance and I have direct access to the database.

On the database I run these two queries:

For comments:

select p.actor_id, c.content
from person p
         inner join comment_like cl on cl.person_id = p.id
         inner join comment c on cl.comment_id = c.id
where cl.comment_id = ?
  and cl.score = -1;

For posts:

select p.actor_id
from person p
         inner join post_like pl on p.id = pl.person_id
where pl.post_id = ?
  and pl.score = -1;

You can replace the question mark with post/comment id.

[-] [email protected] -1 points 2 years ago

Thanks, perhaps i'll roll my own instance then

[-] [email protected] -4 points 2 years ago

Comment test

this post was submitted on 03 Aug 2023
-8 points (21.4% liked)

test

951 readers
3 users here now

For when you need to see what happens.

You can help us test patch releases at https://enterprise.lemmy.ml/

Also there are two more testing instances:
https://voyager.lemmy.ml/
https://ds9.lemmy.ml/

founded 6 years ago
MODERATORS