Turn on Signature Display for all uses?

[Mobo]

Hello, is there a query or another way to change all users at one time to display signatures? When I first setup my site, I did not have this set to ON when someone joined the site. We are now using sig images to help connect local members with each other and I need signatures to display for all uses. Is this possible?

Thanks for your time and help,

Keith

[ProFifaLeagues]

I'm sure you can run a update in the admin cp under the maintance option then update couters
Empty Signature Cache If you have made changes that affect the output of signatures, you may use this to empty the cache and force signatures to be rebuilt with the new settings.

[Mobo]

I ran that, but it did not change any of the user settings to display signatures.

[borbole]

I ran that, but it did not change any of the user settings to display signatures.

Do you mean to show them in posts? If so, make first a backup of your post table and then run this query at the phpmyadmin in the cp of your host:

UPDATE post SET showsignature = 1;

And if your db tables have a prefix you should apend it next to the tables name at the queries above.

[Mobo]

borbole, thanks. I did that and I can see in my database table where the default was changed to 1. However, if I open up a random user in my vB ACP, they are still showing up as not displaying signatures (in the post as you correctly assumed).

[borbole]

borbole, thanks. I did that and I can see in my database table where the default was changed to 1. However, if I open up a random user in my vB ACP, they are still showing up as not displaying signatures (in the post as you correctly assumed).

Can you go to: Admin CP -> Maintenance -> Update Counters and run Empty Signature Cache and see if the signatures will sow up?

[Mobo]

Updating the counters after running your query still did not change the setting for members that have already signed up on the forum.

[BirdOPrey5]

I think he needs to update the database to turn on signature display for all users, not to enable sigs in posts... I can't access my db at the moment but I'd guess "show signatures" is an option in the user table somewhere.

[borbole]

I think he needs to update the database to turn on signature display for all users, not to enable sigs in posts... I can't access my db at the moment but I'd guess "show signatures" is an option in the user table somewhere.

From his post above which I will quote below it looks like he wanted to show them in posts:

borbole, thanks. I did that and I can see in my database table where the default was changed to 1. However, if I open up a random user in my vB ACP, they are still showing up as not displaying signatures (in the post as you correctly assumed).

[BirdOPrey5]

I agree it's a bit confusing, I base my assumption on his first post:

When I first setup my site, I did not have this set to ON when someone joined the site. We are now using sig images to help connect local members with each other and I need signatures to display for all uses. Is this possible?


Coupled with the fact the first suggestion didn't accomplish what he wanted.

[borbole]

I agree it's a bit confusing, I base my assumption on his first post:



Coupled with the fact the first suggestion didn't accomplish what he wanted.

Yes, that looks a little confusing. Because the query I posted above shows all the signatures in posts for everyone. Bt if the OP wants to turn on signature display for all users instead, then that is another matter which can be accomplished with this other query:

UPDATE user SET options = options + 1 WHERE NOT (options & 1)

[Mobo]

Sorry guys, I guess I did not word this every well. The last query posted, so I need to run that in the vB ACP or from the database? And does any of it need to be changed to match my forums/database ?

Thanks for all the help on this one!

[borbole]

Sorry guys, I guess I did not word this every well. The last query posted, so I need to run that in the vB ACP or from the database? And does any of it need to be changed to match my forums/database ?

Thanks for all the help on this one!

You can run it either from the Acp and/or at phpmyadmin. And as stated at the other query above, if your db tables have a prefix you should apend it next to the tables name at the query above :)

[Mobo]

Okay, I ran that one and still have users with " Browsing Options > Display Signatures > On" when i view their profile in the ACP.