UBB.threads PHP Forum Software Community Forums Thread Like Summary - 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.

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.