migrating images from a 3rd party hosting

GorjancB · Post by **GorjancB** » Fri Oct 22, 2021 10:40 pm

I'm trying to create a script which will download all images linked in posts that are hosted elsewhere, then upload the files to my hosting and add attachment records into the table and insert attachment entry into the post_text. Where I'm having problems is figuring out why is there a seemingly random string in attachment tag?
Can anyone please clarify?

Post by **thecoalman** » Sat Oct 23, 2021 10:12 am

I believe that is the bbcode_uid or something similar, that column is in posts table. Suggest upgrading as the newer format is easier to work with. Newest version of phpBB does not use that format and will be something like this:

Code: Select all

<ATTACHMENT filename="filename.jpg" index="6"><s>[attachment=6]</s>filename.jpg<e>[/attachment]</e></ATTACHMENT>

Instead of trying to attach them to posts it would be easier to upload them to single directory and then use find and replace in phpmyadmin to change the source URL.

GorjancB · Post by **GorjancB** » Sat Oct 23, 2021 1:18 pm

Yes, you're right, bbcode_uid is the field.

Also good idea about the find-replace, it really should be easier. Thank you!

3Di · Post by **3Di** » Tue Oct 26, 2021 1:06 am

GorjancB wrote: ↑Sat Oct 23, 2021 1:18 pm Yes, you're right, bbcode_uid is the field.

Also good idea about the find-replace, it really should be easier. Thank you!

You can start from here, no need to re-invent the wheel
https://github.com/v12mike/fetch-external-images