Inserting a new user into multiple tables.

[Radon3k]

Originally Posted by rake

yeah. doing it through vbulletin would be much easier. check for the query that inserts the info in the user table (look for something like $userid = $DB_site->insert_id(); ) and then switch databases and insert the stuff you need into your site database. don't forget to switch back to the vbulletin database after that.

I understand it would be easier doing it through vBulletin but to be honest I really don't want to. I would think I could just copy and paste the necessary information to my register file and link it to the vBulletin database but I'm curious as to which files I would have to include in order to do that. Any ideas?

[Radon3k]

Originally Posted by Radon3k

I understand it would be easier doing it through vBulletin but to be honest I really don't want to. I would think I could just copy and paste the necessary information to my register file and link it to the vBulletin database but I'm curious as to which files I would have to include in order to do that. Any ideas?

I would think for some of the more experienced hackers this would be very easy. I've tried messing about with this and I'm not having much luck and I would really appreciate some help. Thanks.

[psalzmann]

Not that it helps, but try this:

1. install vb fresh, locally
2. register in your fresh vb as a new user
3. monitor the tables

Questions:
1. What table(s) was populated?
2. Anything needing done to usergroups?
3. Anything else noticable?

I would start there. You can then do it manually once you know what vb requires as a new user. I do think you'll need to have the password for the vb user manually salted and hashed while adding to the vb user table. The email address for that vb user can be associated with your user table in your other app. That could be the common key here.

This can actually be approached in many ways but if I was to do this right now, I'd spend 10 minutes installing fresh and doing that I've mentioned above just to be safe .. if you are not fully understanding the vb datastorage methods and coding.

Peter

[Eikinskjaldi]

I haven't done this for user, but basically what you want is the user datamanager

your code will look *something* like this

PHP Code:

require_once('includes/functions.php');
$userdm = datamanager_init("User");
$userdm->do_set('username', $username);
$userdm->do_set('email', $email);
//heaps more stuff here
$userdm->save(); 


have a look at includes/class_dm_user.php, and note that some of the required params are bitfields, and will need to be set with set_bitfield.

Its not trivial.