Unifying signature for all of user's posts

[mathforum]

Hi everyone,

I'm trying to figure out how to make it so all posts by any user display the latest signature that user has chosen. I've done a Google search, tried various update tools in the admincp and looked around here but haven't found anything.

Ideas?

[kh99]

I think all the user's posts should show the latest signature, except if the user had no signature when the post was written (or unchecked the "Show Your Signature" box), then that posts "showsignature" column in the databse will be 0 and it won't show a signature.

[mathforum]

Thank you. So is there a SQL query I could run to add the current signature into those 0 columns?

[kh99]

Yes, you could do this:

UPDATE post SET showsignature = 1 WHERE showsignature = 0

but of course even after you do that, users without signatures will continue to create posts with showsignature = 0.