Password encryption in the table user
 

Hello,

I have the problem, that we must register the user from an other database. There we have generate for every user a password that we want to use in vbulletin-forum, too. How must I encrypt the password(How can I do so?).
Please help!

Jörg

you have to run this query:
[sql]UPDATE user SET password=MD5(password)[/sql]

and how to decrypt it?

I have vb 2.8 in which password are encrypted. I stopped my forums for about one week to migrate from ubb to vb. Now migration is done but there are many users who forgot their usernames (since they mix between ubb's usernames and userids), and passwords.
I want to send each member his login information without the need to provide a link that generates a random password to them.

Is there a way in the control panel to send them their login info without the need to regenerate the passwords? Or I need to write a script to decrypt the passwords and send them to the users?

I dont believe you are able to decrypt the passwords but I may be wrong.

I doubt if anyone will tell you either because it's a security risk :)

- miSt

@izz: i want to see you write a script to decrypt passwords....
the MD5 encryption is an undecryptable encryption, md5 is no bijectiv function and so cannot be decrypted, just hacker methods like brute force or lexican comparision can work, but it's not decryptable...

Thank you all..
I understand the situation now. But I have another question.

Now I want to mass email all the users their usernames and the link to regenerate their passwords.

what is the way?

you can send out an email from within your ACP to all users.
just include this link for them:
https://vborg.vbsupport.ru/member.php?s=&action=lostpw

and they can do what is needed :)