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?

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

Amy

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.

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.

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

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

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

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

Theoretically just once.

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

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????

Ok how can I update the post table to

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

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

I got an error message. :(

Whenever you get an error message, you need to post it...
[sql]
UPDATE post SET post.showsignature = 1 WHERE user.signature != "" AND post.userid = user.userid;[/sql]

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.