UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? Editing Links in Post

Hi all,

I am trying to find an easier way to edit links in post rather than doing one by one as we have over 100,000 thousand post and quite a lot of images that have been uploaded in the post as well.

We had the site moved to a new server and changed the url address from the following:

https://www.outdoorking.com/forum/

To the following:

https://www.outdoorking-forum.com.au/forum/

I would like to know if this can be done by a sql command to the database and if so what would the code be please.

You use a update query like
https://www.ubbcentral.com/forums/u...your-forum-from-http-to-https#Post260501

But you would do it for the path and not just https.

Remember there are two fields in ubbt_POSTS
POST BODY and POST BODY Default

Also there is no UNDO
So when you specify what to change grab a chunk of the path
like https://www.ubbcentral.com/forums to say https://www.ubbcentral.com/ubb/forums
not just something that could be part of another word or something you want unique to change

All in all it is very quick
I first created all the query's in notepad then copy paste to mysql

It runs very quick

Read through this thread, as it covers all of the places that need updating.
https://www.ubbcentral.com/forums/u...transition-your-forum-from-http-to-https

click the SHOW/HIDE button in that thread to reveal the SQL commands required to do your custom search/replace task


Search and Replace strings inside "text" fields. (COLUMN,'oldphrase','newphrase')
** BE VERY CAREFUL OF "POST_DEFAULT_BODY" and "POST_BODY" USAGE - DO NOT INTERCHANGE THEM
• POST_DEFAULT_BODY - [BBcode] This is the original post. CONTENT REBUILDER > REBUILD POSTS takes this and converts it to POST_BODY [HTML]
• POST_BODY - [HTML] This is shown to the user. it is generated from POST_DEFAULT_BODY

EXAMPLE 1.
UPDATE ubbt_POSTS
SET POST_DEFAULT_BODY = replace(POST_DEFAULT_BODY,'old','new');

UPDATE ubbt_POSTS
SET POST_BODY = replace(POST_BODY,'old','new');


pay close attention to NAMES USED FOR EVERYTHING.
always have a backups for anything like this.

Thank you all for the information supplied.

It all worked as ite should.

Thanks again.