Lost admin privileges

[mhamdi]

Hi,
I lost the admin privileges by changing the permissions of the main account. How can I restore them without reinstalling from scratch. I have access to the files in the server.
Thanks

[Adrian Schneider]

You could run the query:
[sql]UPDATE user
SET usergroupid = 6
WHERE userid = 1
LIMIT 1[/sql]
This is assuming your are userID 1.

If you don't have SQL access, create a file and run it from the vBulletin directory:

PHP Code:

<?php

require_once('global.php');
$db->query_write("
    UPDATE user
    SET " . TABLE_PREFIX . "usergroupid = 6
    WHERE userid = 1
    LIMIT 1  
");

?>

or for 3.0.x.

PHP Code:

<?php

require_once('global.php');
$DB_site->query("
    UPDATE " . TABLE_PREFIX . "user
    SET usergroupid = 6
    WHERE userid = 1
    LIMIT 1  
");

?>

[mhamdi]

Thanks a lot

[Marco van Herwaarden]

There is a tools.php in your don_not_upload folder of your vB zip-file. You can use that to restore admin permissions.