I have a problem...

[Xtrato]

I have seemed to have got myself locked out of the AdminCP and my account altogther(cant email recieve ether). I think it has something to do with a database backup that was installed on one of my sites. Im the only registered user also. Is there a way in the MqSQL databases that I can make a new account admin ? There has to be but where is the table where i can edit that.

Thanks :banana:

EDIT: I dont want to reinstall.

[Sean S]

well all the user information including the username and password is saved within the "user" table/column. However the only thing is that each password is encrypted, so I don't know when you edit, what value you should enter for the passwords. Maybe someone else knows better, sorry I can't be much of a help bud.

[Xtrato]

well the vb_administrator` table has a area for a user id and its set to 1 what if i changed it too 3 which is my new user account word that work?

[Adrian Schneider]

If your account is still intact, go into your database, find your salt value, and using a new PHP script, find the following hash out: echo md5(md5('your_password') . salt); and put that value as your password in the database.

[Xtrato]

ok i will try that