importing users (clean passwords)

[ghostrifle]

Hi there,

I want to import users from system X into vbulletin. The passwords of the users are not encrypted.

So how can I encrypt the passwords so that they are in the format of vbulletin ??

greetings, alex

[Marco van Herwaarden]

What is System X?
Do you only want to import users?
How are the users stored in System X?

[Dismounted]

Do you know PHP? If you do, loop each password until you have them encrypted, in the form of md5(md5($password . $salt)).

[ghostrifle]

Well yeah,

System X is just any kind of system with clean passwords. I imported users now this way:

PHP Code:

function vb_add_user(&$vb_adodb,$user_id,$username,$password,$email)
{
    $values = array();
    array_push($values,$user_id);
    array_push($values,2);
    array_push($values,$username);
    array_push($values,md5(md5($password . $salt)));
    array_push($values,date('Y-M-d'));
    array_push($values,$email);
    array_push($values,'');
    //$vb_adodb->debug = true;
    $vb_adodb->Execute('INSERT INTO user (userid,usergroupid,username ,password,passworddate,email,salt) VALUES(?,?,?,?,?,?,?);',$values);
} 


(salt is empty for me! and it works fine)

The users can log in without any problems But there's one thing I noticed... the post count doesn't get increased !??

Also, the overall amount of user doesn't gets displayed in the stats... but I can see all users in the 'user overview'.

Bye,
Alex

[Marco van Herwaarden]

Unless there is no other option, you should not do this by inserting rows into the user table manually.

Creating a new user requires more tehn only a row in the user table.

If it is a 1 time action, use ImpEx, probably using the CSV file import option. Otherwise use the vBulletin DataManagers to create the account.

[ghostrifle]

Well...yeah... but how do I use the datamange to create user accounts ??

[Marco van Herwaarden]

See our Articles section.

[ghostrifle]

thanx a lot !

But I've run into the problem, that $vbulletin is null.. therefore I can't import the users. Look at this: https://vborg.vbsupport.ru/showthread.php?t=143583

[Marco van Herwaarden]

See the other thread you started on this.