Some basic help?

[Wolfplayer]

Hi, we've just taken over the moderation of some gaming based forums using VBulletin.

We received a dump of a database and a set of files for the site which we have installed fine. I then purchased a 3.0.1 license and upgraded the site which also went fine.

Trouble is the company that provided us with the site did not supply any administrator user passwords, and I am unable them. We need to preserve all the historical content in these forums for obvious reasons, so I cannot install 3.0.1 from scratch and make a new administrator.

So, I'm wondering how to manually add an admin to the database, or to retrieve one of the admins passwords and decrypt it.

I tried to turn the site back on after the upgrade by setting the field BBActive to 1 in the Setting table, but this did not work (I thought maybe I could get the email at the mailserver when requesting a password reset by entering an Admin username).

Not sure if this is a stupid question or not, but hopefully it's ok and in the right forum. Look forward to any answers.

p.s I absolutely loved the upgrade interface for v2 to v3, great work.

[Scrub]

If you're still using vB3, I'd recommend uploading the tools.php file locaed in the download of vB3. Uplaod that file to yuor admincp directory and call it in your browser and make your account an administrator. Then edit the config.php file and put your userid in the super admin option near the bottom in the file. :).

Tehn you should be able to edit those other admin passwords and accounts if you want.

If this is not whayt you're wanting, just reply. :p

[Wolfplayer]

Great, that looks good. Trouble is I don't have an account in the forums, and I can't register as one as the upgrade turned the forums off. If I could manually turn them on I imagine this would be great.

I tried searching these forums and found this:



UPDATE template REPLACE(template, '$bbactive=1', '$bbactive=0') WHERE title='options'



but this didn't work, there is no row in the Template table with a title of 'options', and I tried selecting anything from the table with '%bbactive%' in the template field but nothing was returned. Has it changed in v3.01?

Thanks again guys.

[Scrub]

Do you have access to the database? If so, try going into the database table "user" and change an admins (usergroupid should be 6) password, then try logging in thorugh the admincp with the admins username and the password you changed.

[Wolfplayer]

That's great, thanks a heap Scrub.