Retroactive Signature?

Is there a hack that if a user has never had a signature, and has post a few times, then adds a signature and forces that signature into all of their old posts?

[amykhar]

A hack isn't needed. By design, when the sig changes it affects all posts.

Amy

[Steve Machol]

Not quite right. If the post was from a time when they did not have a sig, then this will not be inserted retroactively. It will update all posts that did have a sig though.

[Chris Gwynne]

That's not what ogden2k is asking, I think?

He wants to be able to force a signature on users after they've made say 10 posts.

[Steve Machol]

Hmm...that's not the way I read it.

Is there a hack that if a user has never had a signiture, and has post a few times, then adds a signiture and forces that signiture into all of their old posts

[ogden2k]

Yesterday at 08:52 PM Steve Machol said this in Post #3
Not quite right. If the post was from a time when they did not have a sig, then this will not be inserted retroactively. It will update all posts that did have a sig though.

Sorry for the confusion.. . Steve is right, that's what I ment. Is there a mod for this?

[filburt1]

[sql]
UPDATE post SET showsignature = 1 WHERE userid = their userid
[/sql]
That wll show it for all of their posts. Also it's signature.

[ogden2k]

Do I have to run this everytime someone updates their sig, or just once and it's fixed for good?

[filburt1]

Theoretically just once.

[ogden2k]

Oh, Ok I read the sql command closer. Is there something I can do where I don't have to do this per user?