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]

Originally Posted by Mobo

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]

Originally Posted by 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).

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]

Originally Posted by 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.

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

Originally Posted by 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).

[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.