Update signature throughout all posts

[bbakes25]

Hello,

I used to know how to do this, but now I don't

What I need to do is how can I have a members signature updated throughout all posts, even ones that were posted before the member had a signature. Please help. Thanks!

[Kirk Y]

I believe as soon as a new post is made after the Signature is set, all old posts have the Signature as well -- at least, that's been my experience on my own site, however I could be wrong.

[Paul M]

A members signature is seperate from the posts (i.e. it only exists once) - so when it's updated it will display the same on all posts - previous as well as new.

[bbakes25]

Hello,

For example. This thread:
http://clashforums.com/showthread.php?p=15#post15

user: gtbakes89

1st one has a signature, 2nd one by me doesn't. How can I get that first one to have one?

[MJM]

Update users past posts without signatures:
Maintenance > Execute SQL Query > Manual Query >

UPDATE post
SET showsignature = 1
WHERE userid = X (enter user id #)

> Continue ... Done

[pokerie]

Just having this problem now myself, is there a query that can be used to update ALL users and not just one so that it will automatically update everyones signature in all posts as they create it?

For anyone else looking, this is the response to my above question I got from vbulletin.com support

UPDATE post SET showsignature = 1

This will set signature = 1 on all posts. If the user doesn't have a sig set no sig will show.

[daydie]

im having this problem but i cant enter what he said, i get error, i know this is old post but, i got this problem

[RLShare]

Do you have a table prefix?

[daydie]

default prefix i think (if there is a default one, If not nope)

[daydie]

Can any1 help please?