XF 1.1 Regular Expressions

[DBA]

With this thread being closed...
http://xenforo.com/community/threads/post-content-find-replace.6548/


I'm trying to remove the /content from my urls.

http://www.domain.com/content/threads/blah-blah.4493/

to

http://www.domain.com/threads/blah-blah.4493/

Any help would be appreciated.

 

[Paul B]

A simple SQL query will do that.

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

So in your case:

UPDATE xf_post SET message = REPLACE(message,'http://www.domain.com/content/','http://www.domain.com/threads/');

Take a backup first, just in case.

 

[DBA]

Thanks, I was over thinking it, forgot I could do it this way.

UPDATE xf_post SET message = REPLACE(message,'http://www.domain.com/content/','http://www.domain.com/threads/');

BTW shouldn't the replace be http://www.domain.com/ otherwise it'd end up being http://www.domain.com/thread/thread/?

 

[Jake Bunce]

Thanks, I was over thinking it, forgot I could do it this way.


BTW shouldn't the replace be http://www.domain.com/ otherwise it'd end up being http://www.domain.com/thread/thread/?

In your case, yes.