How to Set Existing Users Option to Show Signatures?

[perfectweddings]

Hello,

I just noticed when I first setup vbulletin I accidentally set Display Signatures to Unchecked in VB settings -> User Registration Options

Now that I have changed that and set it to Checked, it does not seem to apply to the change to existing users. Is there a way to mass edit all existing users profile now to set Show Signatures to Yes?

Appreciate any help! Thanks!

[LifesGreatestGift]

First off, make sure your userid is set in includes/config.php to be able to run queries

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';

Then refer to attached image.

[perfectweddings]

Thank you very much windows7site! That works but I had to choose On instead of Off for the option.