NettoHikari

joined 2 years ago
MODERATOR OF

Hey, sorry. Kinda overlooked your comment. This is the query I'm using:

DELETE FROM local_user WHERE email_verified = 'f' AND validator_time < NOW() - INTERVAL '$DELETE_INTERVAL';

  • $DELETE_INTERVAL is a variable in the bash script. You could use 1 days, for example
  • I'm not 100% sure if validator_time is the account creation date, but it seemed like it when I implemented this
  • If you wanted it to be cleaner, you'd also have to delete the record from the "people" table by comparing loal_user_id
[–] NettoHikari@social.fossware.space 3 points 2 years ago (2 children)

I don't get this "rule" thing. Someone enlighten me, please?

[–] NettoHikari@social.fossware.space 5 points 2 years ago (4 children)

Looking at the Wim Hof website, I get scam vibes.

I run an instance, which hasn't got much traction yet. It's okay for me, if it does or if it doesn't. At the moment, I'm financing it myself and I'm not asking for donations.

[–] NettoHikari@social.fossware.space 3 points 2 years ago* (last edited 2 years ago) (1 children)

We also have our own Nitter instance here: https://t.donttrackme.fossware.space

Along with a Teddit instance: https://r.donttrackme.fossware.space

And last, but not least, we also provide Piped: https://y.donttrackme.fossware.space

[–] NettoHikari@social.fossware.space 3 points 2 years ago (1 children)

I couldn't find anything like that on F-Droid, unfortunately.

[–] NettoHikari@social.fossware.space 8 points 2 years ago (1 children)

There's a "purge post" button, which seems to actually remove content or access to it. I didn't try it out yet, because there wasn't a lot of moderation necessary so far, to be honest.

War irgendwie zu erwarten, finde ich.

You may try these ARM images, too. I'm currently fiddling around with them, while my wife is chatting with her mom on the phone, haha.

Well, it looks to me that you're doing the install from scratch. So if /usr/bin/lemmy_server is missing, you dungoofed.

view more: ‹ prev next ›