[SIGPIC] Removal?

IFeelYourPain13

Active member
anyway to remove the annoying tag from XenForo after vbulletin import? It's in most of the signatures, and so is some <img src=""> tags.
 

Alfa1

Well-known member
The above query works well for [SIGPIC][/SIGPIC]
However, I would also like to replace / remove all sigpic code with anything inbetween. i.e.
[SIGPIC]whatever[/SIGPIC]
How do I do this? Can I simply throw a * in the query? i.e.:
Code:
UPDATE xf_user_profile
SET signature = REPLACE(signature, '[SIGPIC]*[/SIGPIC]', '');
 

Mike

XenForo developer
Staff member
I don't believe MySQL supports regex replacement out of the box, so you'd likely need a supporting PHP script.
 

Nirjonadda

Well-known member
Run this query on your XenForo database to remove the sigpic code:

Code:
UPDATE xf_user_profile
SET signature = REPLACE(signature, '[SIGPIC][/SIGPIC]', '');
For codes inside of posts (not signatures) you can use Kier's addon to make appropriate replacements (requires regex ability):

http://xenforo.com/community/threads/post-content-find-replace.6548/
Code:
 11 rows affected. (Query took 0.0632 seconds.)
UPDATE xf_user_profile SET signature = REPLACE(signature, '[SIGPIC][/SIGPIC]', '')
Still are showing [SIGPIC][/SIGPIC] , Please let me know this fix?
 
Top