Linking with VBULLETIN database

Anon

Hi there
I have vbulletin installed on my server, however, i want to make a seperate login script that verifies that the username/password in the VBULLITIN user table are correct, if so it will take it to a members area.

The idea is it will enable users to have the same username/passwords to access all areas of the site.

The problem is that if you look in the database, the passwords are encrypted. How do i go about decrypting the passwords in order to get my login screen functioning correctly.

Thanx for your help

Jonathan

jsagara

I don't have access to the vBulletin code, but I'm assuming they're using a function similar to MySQL's PASSWORD() function to encrpyt each password before it's stored in the DB. So, in order to compare the two passwords, encrypt the password the the user enters into the form and compare that to the password stored in the database.

Take a look at http://www.mysql.com/doc/C/o/Connection_access.html

Anon

Easy...

Just md5(); the password of the form and compair it with the forums.

md5 is what they use, and its the same every time so just the var threw it.