PDA

View Full Version : Update signature throughout all posts

bbakes25
08-14-2006, 03:31 AM
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
08-14-2006, 07:30 PM
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
08-14-2006, 09:33 PM
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
08-16-2006, 05:46 AM
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
08-16-2006, 08:26 AM
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
09-27-2006, 07:28 AM
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
03-17-2009, 08:52 PM
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
03-17-2009, 09:13 PM
Do you have a table prefix?
daydie
03-18-2009, 06:10 PM
default prefix i think (if there is a default one, If not nope)
daydie
03-25-2009, 10:28 PM
Can any1 help please?
Lynne
03-25-2009, 10:42 PM
If you are getting an error, you should say what the error is.
JonSidneyB
03-05-2010, 09:08 AM
does this work in vb4?
JonSidneyB
04-14-2010, 08:00 AM
I have managed to get this to work two different times.

It seems to no longer work.

UPDATE post
SET showsignature = 1
WHERE userid = 25982

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'jsbur2_vb4edc.post' doesn't exist

Any ideas on what is going on?
Marco van Herwaarden
04-14-2010, 10:34 AM
Are you maybe using table prefixes?