vBulletin Password Hash

[kevinmanphp]

I would like to import the usernames and passwords over into another database application so that my existing vB members don't need to register the same username with this other app.

How are the passwords stored in the database? Does it just use SHA() hashing? MD5?? Is there a salt used? Thanks!

[Scott MacVicar]

UPDATE user SET password = MD5(CONCAT(MD5(other_password), salt)) WHERE password = ''

Thats a query which will do it, presuming your password field is blank and there is a field called other_password that stores the plain text password. salt also needs to contain 3 random characters.

[Colin F]

Actually, I think salt has to contain the same value as the salt field in vBulletin.