change user settings

[tefnut]

Here's my situation, the upgrade from a phpBB2 installation left everyone with avatars, images, PM's, etc., all disabled by means of options. Now, of course, the solution is for them to manually change them, but thousands of users can't be expected to do this by themselves, so I need to change it for them, at least to a set of standards (avatars, signatures, PM's and embedded images on) ... I need to run a query on the user preference field in the users table.

I looked at a couple of them, and I see things like:
2311
6151
2135

How do I decipher this, and what's the number than I'm looking for to run a SET query on everyone's preference fields?

[Zachery]

AdminCP > Import / Maitence > Execute SQL Query > You can eable each of these options by using the predefied querys in the drop down menu

[tefnut]

"You are not authorized to execute SQL queries"


This is with the account I made the forum installation with, so he should be able to do this. Is this a vB problem or a host problem?

[Steve Machol]

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** 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.
$canrunqueries = 'x';

...with x being your userid number.