Support Forum

How to replace terms in forums with other terms/hyperlinks

MA mann
mann
Member

We have a product on my website which we don’t offer anymore and that product has been replaced by a new product. Now the problem is that there are forum posts of the past mentioning that product and when new users browser through the forum they see those posts mentioning the product but they don’t find the product anywhere on the website.

Is there any way I can replace the name of the product with the name of the new product instead of having to edit tens of posts.

Also I’d like to know is there any way to auto convert certain text in the forum into hyperlinks.

For example, in phbb, the admin can set certain terms in such a way that whenever the term is mentioned it gets converted into a hyperlink. For example, if anyone mentions say an ipod in the forum, that term gets automatically hyperlinked to the thread to which it has been set. Let me know if you guys understood the question.

3 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

I can give you a quick and dirty way to do the first one but there is no automated method Can probably do it with sql queries but oddly I have never been asked to write an in-string replace before o have never investigated or tried it.

It is no to the second question as well although there are, I believe, some WP plugins that might do this for you. At least there have been on the past. The main problem is when they get intertwines with say, a link, as they can screw up the html but used with care might work.

MA mann
mann
Member

Thanks Andy so how do I implement the first thing ? What do I need to execute in phpmyadmin ?

YS Yellow Swordfish
Yellow Swordfish
Member

The quick and dirty way is to dump an export of the sfposts table into a text file. Edit it with a plain text editor. Perform a search and replace and then import it back into the database…