[SIGPIC] Removal?

[IFeelYourPain13]

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.

 

[Jake Bunce]

Run this query on your XenForo database to remove the sigpic 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/

 

[IFeelYourPain13]

Thank you it worked!

 

[Alpha1]

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.:

UPDATE xf_user_profile
SET signature = REPLACE(signature, '[SIGPIC]*[/SIGPIC]', '');

 

[Mike]

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

 

[Nirjonadda]

Run this query on your XenForo database to remove the sigpic 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/

 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?

 

[ulric]

Thanks for this, most helpful.

 

[mqudsi]

A straightforward solution is to create a custom bbcode for

sigpic

and making sure to enable the "replace with HTML when empty" option, and map it to

<!--{text}-->

 

[MySiteGuy]

Okay, I found the "Access unknown getter 'thread' errors are not Tapatalk.

They are not fatal errors, but I will track i down and resolve it.