XF 2.2 Remove bold from signature after import

Black Tiger

Well-known member
I've set "Allow basic text formatting (bold, italic, etc)" to "never" for registerd users (so this will be applied to everyone).
However, after the ipb import, this was not changed, so several users have signatures in bold.

Is there an easy way, like a mysql query, to remove all bold from signatures?
 
Solution
Untested but these queries should work.

SQL:
UPDATE xf_user_profile SET signature = REPLACE(signature, '[B]', '');

UPDATE xf_user_profile SET signature = REPLACE(signature, '[/B]', '');
Untested but these queries should work.

SQL:
UPDATE xf_user_profile SET signature = REPLACE(signature, '[B]', '');

UPDATE xf_user_profile SET signature = REPLACE(signature, '[/B]', '');
 
Solution
Top Bottom