1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[SIGPIC] Removal?

Discussion in 'Installation, Upgrade, and Import Support' started by IFeelYourPain13, Dec 19, 2011.

  1. IFeelYourPain13

    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.
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

    Alfa1, Nicky, Kintaro and 1 other person like this.
  3. IFeelYourPain13

    IFeelYourPain13 Active Member

    Thank you it worked!
  4. Alfa1

    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.
    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]', '');
  5. Mike

    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.
    Alfa1 likes this.
  6. Nirjonadda

    Nirjonadda Active Member

     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?

Share This Page