Signatures

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Link00seven
    Member
    • Aug 2004
    • 67
    • 3.6.x

    Signatures

    Hello,

    I've posted a lot of messages without having a signature, and I just added one. However, none of my messages that I have already posted have the signature attached and it would seem I'd have to edit each post and manually add it...is it possible to attach the signature to current posts automatically without having to edit each individual post?

    EDIT: I'm talking about on my personal site...not here.
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74167

    #2
    You could probably run the following query:

    update XXX_post set showsignature=1 where userid = YYY

    Replace XXX_ with your table prefix if you have one, remove it if you don't.
    Replace YYY with your userid.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • Link00seven
      Member
      • Aug 2004
      • 67
      • 3.6.x

      #3
      That worked. Thanks!

      Comment

      • Kadi
        Senior Member
        • Aug 2006
        • 118
        • 3.8.x

        #4
        Originally posted by Wayne Luke
        You could probably run the following query:

        update XXX_post set showsignature=1 where userid = YYY

        Replace XXX_ with your table prefix if you have one, remove it if you don't.
        Replace YYY with your userid.
        Hi, I've never run a query before and I need this one.

        Should I back up first? Do I run it in Manual Query?

        Thanks in advance
        Last edited by Kadi; Wed 13 Jun '07, 6:34am.

        Comment

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