How to run a query

[Colin F]

In the vB3 Admin CP:

To run a single query 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.
$config['SpecialUsers']['canrunqueries'] = '[B][COLOR=Red]X[/COLOR][/B]';

...with X being your userid number.
To add more than one user, list the userid numbers seperated by commas. Example:

$config['SpecialUsers']['canrunqueries'] = '1,5,354';

Then to run a query:

Admin CP -> Import & Maintenance -> Execute SQL Query

Using phpMyAdmin:

1. Open your database in phpMyAdmin.
2. Click on the SQL tab
3. Enter the query in the Run SQL query box.