XF 2.2 quickly remove a url from posts

[interforo]

Hi,
I'm looking for a quick way to remove a URL that has been repeatedly posted in multiple posts (around 100) on my forum.
Can you help me out?

 

[JustinHawk]

Hi,
I'm looking for a quick way to remove a URL that has been repeatedly posted in multiple posts (around 100) on my forum.
Can you help me out?

You can try using this addon >> https://xenforo.com/community/resources/post-content-find-replace.5748/

 

[jeb35]

Can you use the sensor words option?

 

[interforo]

Hi
I just need the query to run into phpMyAdmin to delete post containing url ‘xxxx’ in all my posts

 

[duderuud]

Use the add-on posted by @JustinHawk

Editing the database directly can cause problems.

 

[Bob de Bouwer]

Hi,

I saw this topic, sorry to hijack it .
I have downloaded an installed the "find and replace plugin", in the hope i could adjust picture url's from an import of a old Vbulletin forum of mine. There are say 75.000 topics with an old URL and i want to change all of them to get the pictures working again.

Example:

Now it is "www.mysite.com/images"

It needs to become "https://thisis.mysite.com/images"

However, the plugin can't handle this it seems like.
Any ideas?

Regards and again sorry for hijacking

 

[Bob de Bouwer]

Fixed it via phpmyadmin

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