UBB.Developers Forums Community Development Programming PHP and Server-side Scripting Changed Threads install folder, and now...

I changed the location of my Threads installation. Now I'm looking for a script that will help me change the referenced location of images within posts bodies from "old-folder" to "new-folder" -- I'm not talking about post attachments mind you (they changed), I mean gremlins.

I had a script that helped me move the avatars from the "old-folder" to the "new-folder". Normally I can figure out how to simply massage a script to adapt it but I'm a little leery about fooling around and risking messing up my database.

Here's the avatar-mover script I successfully used in case that helps:




I appreciate your help!


DeltaJo

you could create a symbloic link at the old location to the new location for the folder in question.

Thanks, but no I have an .htaccess redirect from that old folder location and don't want the folder to remain open just to enable old image-links to work. I want the image-links to refer to the correct, new location. It would be neater and tidier and more properly organized.

You can do that using the REPLACE function of MySQL

In phpMyAdmin type:

UPDATE w3t_Posts SET B_Body = REPLACE(B_Body, 'old setting', 'new setting');

Make sure that the old setting is unique. For instance in a forum that I did this we had everything under ubbthreads/ whereas now it is under forum/ so the statement was:

UPDATE w3t_Posts SET B_Body = REPLACE(B_Body, 'ubbthreads/graemlins', 'forum/graemlins/');

I hope this helps.

Wow thanks -- that was too easy!

For some reason I always thought that to use the REPLACE function, it had to replace all of a field, not just part of it. But it worked!

Thanks a lot -- that was a huge help.

I did too until recently. Very handy query.