UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Using Active Text to replace changed domain in posts

I recently changed my domain name from da7.com to audiotalkback.com

I'd like to use the Active Text feature to replace any instances in old posts. So for example I might have http://www.da7.com/filearchive I want to make the da7 part become audiotalkback

Can I do this - can I do this for links? How do you do wildcards?

Thanks!

I think the censor may do a better job of this; neither the Censor nor ActiveText however deal with wildcards; they'd replace a word (or in this case a section in a link) with another string. I haven't tested either with a URL but I think the Censor is more suited.

Gizzy, the censor will only effect posts made after the censor has been changed, so that wouldn't work on old posts.

Actually, the best way to do this is with a mysql regex. You should probably backup your database before doing this, because this will check all rows, and a typo could be a problem You should probably close your board while you do this as well as it might take quite awhile run.

UPDATE ubbt_POSTS SET POST_BODY = REPLACE(POST_BODY, 'www.da7.com','www.audiotalkback.com'),POST_DEFAULT_BODY = REPLACE(POST_DEFAULT_BODY,'www.da7.com','www.audiotalkback.com')

Thanks. I'll definately backup the database before trying this.

Interesting method; and yeh I guess you're right about the method I outlined

Rick - the mysql regex command you gave above worked like a charm. On a table that was 110 MB it only took a few minutes to complete. Thanks!