Retroactive Signature?

[ogden2k]

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 (https://vborg.vbsupport.ru/showthread.php?postid=391016#post391016)
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]

UPDATE post SET showsignature = 1 WHERE userid = their userid

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?

[007]

Interesting. Is there a way to make it so if someone has a signature it is automatically shown in all of their posts and do away with the "Show sig in this post" feature altogether????

[007]

Ok how can I update the post table to

UPDATE post SET showsignature = 1 WHERE (see below)

...WHERE the user who posted the post actually has a signature?

[filburt1]

UPDATE p.post SET p.showsignature = 1 WHERE u.signature != "" AND p.userid = u.userid;

[007]

I got an error message. :(

[filburt1]

Whenever you get an error message, you need to post it...

UPDATE post SET post.showsignature = 1 WHERE user.signature != "" AND post.userid = user.userid;

[007]

Sorry

K, got this this time:

Error

SQL-query :

UPDATE post SET post.showsignature = 1 WHERE user.signature != "" AND post.userid = user.userid

MySQL said:

Unknown table 'user' in where clause

I have the user table too... obviously. Weird.