adding users to VB manually via DB....

[shazzy]

We have registerations on VB disabled, and in v2.x.x we used the following SQL query to add users..

PHP Code:

  $sql_users="INSERT INTO user (userid,usergroupid,username,password,email,joindate,signature) VALUES ($player_id,2,'".addslashes($row["user_name"])."','".$set_pass."','".$row["email"]."',".time().",'')"; 


This worked great, however in VB3 this dosent seem to work ... The user gets added but the "Welcome to our newest member" still shows the last user, when I go directly to the USERID for this user it says "Invalid User specified" ...

Is there something else I need to pass to the user table, which is new in V3 that I am missing?


Thanks in advance.

[Zachery]

Originally Posted by shazzy

We have registerations on VB disabled, and in v2.x.x we used the following SQL query to add users..

PHP Code:

  $sql_users="INSERT INTO user (userid,usergroupid,username,password,email,joindate,signature) VALUES ($player_id,2,'".addslashes($row["user_name"])."','".$set_pass."','".$row["email"]."',".time().",'')"; 


This worked great, however in VB3 this dosent seem to work ... The user gets added but the "Welcome to our newest member" still shows the last user, when I go directly to the USERID for this user it says "Invalid User specified" ...

Is there something else I need to pass to the user table, which is new in V3 that I am missing?


Thanks in advance.

You can just add them via the ACP.......

the password is now stored differntly with a salt, i assume this is at least one problem

[r00t3d]

Originally Posted by Zachery

You can just add them via the ACP.......

the password is now stored differntly with a salt, i assume this is at least one problem

Is there no easier way to add user apart from manually via the acp, as adding 100s of users daily is not going to be an interesting task?
I am aware of the salt password problem, but is there any work around this?

Tnx.

[Zachery]

Why not just allow registration with moderation?

[r00t3d]

Originally Posted by Zachery

Why not just allow registration with moderation?

The userid needs to match the userid on our league backend system: so when a user logs into the league they are automatically logged into the forum.

[red hot machine]

I have a simalar problem. I'm moving a phpnuke user database over to vb3. I've added all the users the same way as you have. I've also added them to the userfield table aswell, but I get invalid links when trying to click on a user's profile.

[r00t3d]

The main problem that we seem to have atm is with the passwords.

If someone changes there password on our backend which is a league or a new user is added, the passwords should be synced with the password on the forum vb3. Now all is good with vb 2.3.x but vb3 uses the salt, what I havent been able to figure out is how to generate a salt password on our backend and then insert that into the vb3 user profile so that both passwords are synced, on new user creation and password changes.

Any help on the above would be greatly appreciated.

Thanks

[shazzy]

I have been thinking of it logically...

On our side of the system we do this : [Customer chooses to change password.....]

if userid exists in VB database, get the value of the salt field.
MD5 password with the salt key and store it both in our database and in the vbulletin database....
Both of these passwords should now be in the format VB likes and insync with our database.

I guess that will work....