can I strip everyones avatar and sig?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wolfy
    Senior Member
    • Apr 2005
    • 194
    • 3.5.x

    can I strip everyones avatar and sig?

    How would i go about doing this? I would like to remove everyones avatar and sigs
  • Slacker
    Senior Member
    • Dec 2001
    • 207
    • 3.0.0 Release Candidate 2

    #2
    There are SQL commands that'll do it, or you could just remove the code that displays both items from the postbit template. I'll let someone smarter than me help with the SQL. I'm confident enough to run queries on my own DB, but I don't want to kill someone elses. :P
    slackercentral messageboard - Running vBulletin 3.7.0
    Check out my reformatted vBulletin blog here: http://www.slackercentral.com

    Comment

    • wolfy
      Senior Member
      • Apr 2005
      • 194
      • 3.5.x

      #3
      I definately want to do it via sql.... I have 14000 members though, won't that be a pretty heavy sql process?

      you know what - I'll test it on a backup db first, go ahead and post the command you think will work.

      Hmm.. could it be as simple as dropping a sig and avatar table, then readding them so it's blank? (I'm stabbing in the dark :P)

      Comment

      • Lats
        Senior Member
        • Mar 2002
        • 3671

        #4
        Try these 3...
        Code:
        TRUNCATE TABLE customavatar
        ---
        UPDATE
            usertextfield
        SET
            signature = ''
        ---
        UPDATE
            user
        SET
            avatarid = 0
        Lats...

        Comment

        • wolfy
          Senior Member
          • Apr 2005
          • 194
          • 3.5.x

          #5
          that worked, thanks

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...