That sounds like a particularly horrible idea, there's no way to know. I would take the risk on electronics, not something you actually put into your body.
You can leave that blank if you're filling in a text post
Not super easily. It can be done by querying the postgresql dabase, but there is no built-in method to do it using the browser interface at the moment. When anyone from any instance does report them, you will see the report.
Do you have an example of a query I could use? I'm a bit rusty with databases :) with an example I can get chatgpt to build me something better
I see, occasionally I get reports from local users about something elsewhere from a 'foreign' user... which I can then delete. I assume that's not deleting from their server?
For example I get a report from a local user about a lemmy.ml user with a post in lemmy.world
I don't unfortunately, I deliberately don't log that due to some of the sensitive stuff on my own instance (we're China based)
Yup I've got them, luckily 5 or more repeating numbers in their email pretty much identified 99% of them. Would you like me to send the CSV somewhere? 27k+ bots
That's okay I found it, luckily there's a pattern here too... I dug up 27k with repeating numbers on emails which is a good start!
Huh adminer would definitely be an easier way to do this, do you have the part of the docker-compose you used with the env vars etc?
Yeah that's the issue I'm having, someone sent me a postgres command in DM earlier but it does seem to be a bit of a nuke/picking up ordinary users....
Nevermind, I'm in with user 'lemmy' :) I will start cleaning this up now...
About 80 total, but I'd say only a handful are active every day
I got march of shamed once because I genuinely forgot, it somehow shortcircuits my brain when I need to wait for approval, thinking I've already paid and walk out after waiting for the person to come tap some buttons :|