When an instance goes down, all of the images on it go with it. there’s going to be a lot from lemm.ee, especially given its size.
When an instance goes down, all of the images on it go with it. there’s going to be a lot from lemm.ee, especially given its size.
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.