this post was submitted on 04 Jun 2025
110 points (99.1% liked)
Fediverse
34120 readers
559 users here now
A community to talk about the Fediverse and all it's related services using ActivityPub (Mastodon, Lemmy, KBin, etc).
If you wanted to get help with moderating your own community then head over to !moderators@lemmy.world!
Rules
- Posts must be on topic.
- Be respectful of others.
- Cite the sources used for graphs and other statistics.
- Follow the general Lemmy.world rules.
Learn more at these websites: Join The Fediverse Wiki, Fediverse.info, Wikipedia Page, The Federation Info (Stats), FediDB (Stats), Sub Rehab (Reddit Migration)
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I'm still putting that together, but it's basically something like:
UPDATE post set url = thumbnail_url where thumbnail_url like 'https://dubvee.org/pictrs/image/%' and url like 'https://lemm.ee/pictrs/image/%'For the Kbin users to clear out their avatar/banners, I just did:
UPDATE person set avatar=NULL, banner=NULL where instance_id=(select id from instance where domain='kbin.run')UPDATE community set icon=NULL, banner=NULL where instance_id=(select id from instance where domain='kbin.run')...and will update that for lemm.ee
I'm working on a Bun/NodeJS script to download the avatars, icons, and banners for all the lemm.ee users/communities, upload them to my pictrs, and then update the DB with the new values referencing the local images.
Prob gonna have to break that up into two steps so I can download and file the images before lemm.ee goes down and upload/assign them after (so they're not overwritten by federation).
Not sure if I'm gonna do that for comment / post body images. Basically, I just want the archived communities to look nice.