adding users to VB manually via DB....
 

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

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

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.

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.

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.

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

I have been thinking of it logically...

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

I guess that will work....