GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Embed Notice

HTML Code

Corresponding Notice

  1. Embed this notice
     (mint@ryona.agency)'s status on Tuesday, 13-Feb-2024 07:20:58 JST
    in reply to
    • 
    • iced depresso
    • Lumeinshin
    • Gingermilk
    • histoire ??☢️??
    @icedquinn @Lumeinshin @gingermilk @histoire Wasn't that hard.
    1. select data->>'attachment' from objects where data->>'actor' like 'https://lab.nyanide.com/users/%' order by id asc;2. extract urls however you want and download them all with wget or whatever
    3. put the images on server
    4. update objects set data = REPLACE(data::TEXT, 'https://meds.lab.nyanide.com/media/', 'https://zetsubou.ryona.agency/media/nyanide/')::jsonb where data->>'actor' like 'https://lab.nyanide.com/users/%'; (this takes shitton of time, one should probably limit the id as well to avoid overwriting paths for images that would be uploaded inbetween)
    In conversationTuesday, 13-Feb-2024 07:20:58 JST from ryona.agencypermalink

    Attachments




  • Help
  • About
  • FAQ
  • TOS
  • Privacy
  • Source
  • Version
  • Contact

GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.