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.

Share This Page