They should have been forced to do it the other way. “You advertise as free, so you have to provide this for free.”

I’m providing a best guess on that. I may be wrong. Who knows maybe it’ll be “xtxt” or xt^2 pronounced “extasy.”

Glad to be of service.

It’s cute how you think I’m going to take legal advice from you. You do you, have a nice evening.

I’m basing what I have said off of work I have done with attorneys in similar situations. I don’t know evidentiary law, but I wouldn’t want to be accused of destroying evidence of something. But my question stands. Why should someone who has doxed someone get away with it by deleting their account? How is that ethical?

That’s a hard question to answer. My position is based on where I live and what legal council I have worked with has said in situations I’ve dealt with. My recommendation is, check with an attorney.

I’m at a loss. You’re saying that things that you said publicly are private? Or you’re saying that they become private because you delete your account? Assume you dox someone. I need to find out if that happened. As an admin I’d be able to see that

1. you
2. publicly posted
3. their data

I would need to be able to provide this to authorities if they provided needed legal documentation. Why do you think that privacy dictates you should be able to commit a crime, and get away with it by deleting your account?

I created a process to remove the bot accounts from my database without crashing my site. I have tested and it looks like all functions are working. If you need help because you suddenly have thousands more accounts than you would suspect ask me for the procedure. I’ll gladly provide it.

I was able to identify bot accounts by looking at creation times. They accounts are grouped by “batches” where the account creation times are within seconds of each other. That’s not typically going to happen with random humans creating accounts.

At this point, I’m not certain anymore. Luckily all the accounts use values that are easy to identify them. I’ll figure out how to remove them. Sorry for the false alarm work.

I always assume I’m wrong first, I may have put that in the wrong spot. Where should I put that in the query? I put it under the Select statement.

SELECT * from local_user; provides a list of users that has a password_encrypted field. That list is exactly equal (all the same accounts are listed) to what I get from: select   p.name,   p.display_name,   a.person_id,   a.email,   a.email_verified,   a.accepted_application from   local_user a,   person p where   a.person_id = p.id;

So I can see a persons a.email (email address), a.person_id, and their password_encrypted (hash) by correlating these tables, can I not?

These accounts are NOT ALL local to my server… So I MUST be being passed hashes, right?

I don’t know how to make this not about me. So, I’m just going to say it. Friday I closed a 13 year old Reddit account. Saturday and Sunday I brought up multiple Fediverse servers. I now have Mastodon, Lemmy, PixelFed, Owncast, and NextCloud working. I have yet to get Element Chat and PeerTube running. They will happen by Friday. When I opened my Owncast I killed my Twitch account. When PeerTube is up and running I drop YouTube. My point is, I want to thank Reddit for providing me the motivation to leave corporate social media and switch to my own platform. I’m not going back… I’m going forward.