Post Content Find / Replace 2.0.1

[unproperlypropagated]

broken in 2.3

 

[unproperlypropagated]

This works:

UPDATE xf_post
SET message = REPLACE(message, '<SEARCH_STRING>', '<REPLACE_WITH>')
WHERE message LIKE '%<SEARCH_STRING>%';

 

[Kirby]

@Chris D
Not a big issue, but the Add-on does not check if all fields contain non-empty values.
If for example Regular expression is left empty PHP errors like those in https://xenforo.com/community/threads/post-content-find-replace.135904/post-1769938 are generated.

 

[Kirby]

Another issue:
The code gets the message via $post->message.
Depending on installed Add-ons this might use a getter with modifies the value retrieved from the DB so preg_match / preg_replace may fail if the regex doesn't match the value retrieved from the getter (but would match the original DB value).

It might be better to (optionally) use $post->_message to bypass getters.

 

[tenis]

I just want to remove this color, not all colors:

[COLOR=rgb(138, 138, 138)]

If i use SQL to replace with nothing I will have to deal with the remaining

[/COLOR]

Hello, can anyone help me ? How to use this add-on to delete a specific color code from all forum posts?