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.