Inserting a new user into multiple tables.

[Radon3k]

Currently on my site you have to register for the site and then again for the forums. What I would like is to be able to have one registration form that registers you for both the forums and the site. When you fill out the form and submit it, 2 queries are sent; 1 query to the actual website table that handles the user functions there and 1 query to the forum table to register the new user. However looking at the vBulletin code there were several queries made to the database for registering a new user. How does one go about accomplishing something like what I'm trying to do? When the user registers he/she should go into to standard usergroup. To make things a little more complex, I want to includ email activation through my site, not the forums. So when a user registers on the site, they are also registered on the forums and receive an email to activate their account. When the account is activated it updates both tables. Any ideas? Thanks.

[Zachery]

Originally Posted by Radon3k

Currently on my site you have to register for the site and then again for the forums. What I would like is to be able to have one registration form that registers you for both the forums and the site. When you fill out the form and submit it, 2 queries are sent; 1 query to the actual website table that handles the user functions there and 1 query to the forum table to register the new user. However looking at the vBulletin code there were several queries made to the database for registering a new user. How does one go about accomplishing something like what I'm trying to do? When the user registers he/she should go into to standard usergroup. To make things a little more complex, I want to includ email activation through my site, not the forums. So when a user registers on the site, they are also registered on the forums and receive an email to activate their account. When the account is activated it updates both tables. Any ideas? Thanks.

I would do it though the vB end personaly

You are going to want to look at register.php for abit of help

[Radon3k]

I don't want to do the registering through the vBulletin end. I want vBulletin to have almost nothing to do with my main site which is why I'm doing it this way. The way it is setup now on my site is you have to register both on the site and the forums and I'm fine with that but I'm sure users would like to ease of one registration process. Also, I have looked through register.php and there were several sections that could potentially be involved with the registration process hence why I'm asking here.

[Radon3k]

Originally Posted by Radon3k

I don't want to do the registering through the vBulletin end. I want vBulletin to have almost nothing to do with my main site which is why I'm doing it this way. The way it is setup now on my site is you have to register both on the site and the forums and I'm fine with that but I'm sure users would like to ease of one registration process. Also, I have looked through register.php and there were several sections that could potentially be involved with the registration process hence why I'm asking here.

Anybody have any suggestions?

[Zachery]

Originally Posted by Radon3k

Anybody have any suggestions?

You are going to need to populate at least three rows in 3 tables everytime someone registers, like i said look at the register.php file for help.

[Radon3k]

Originally Posted by Zachery

You are going to need to populate at least three rows in 3 tables everytime someone registers, like i said look at the register.php file for help.

I have looked in register.php and I don't see where it's inserting the user. It's checking so many conditions on where to put the user and I don't need that. I just want the user, when registered through my site, to go into the users awaiting validation usergroup. Everything else is normal and can be left as is. The password is also another issue I'm having as I don't understand the way vBulletin has encrypted the password (yes, I've looked in the correct functions file). I'm looking for a simple way to insert a user into the vBulletin database as well as mine (they are in separate databases and I can work around that).

[Radon3k]

I've looked through this file and maybe it's just that I don't understand it but I don't see where exactly this stuff is. I've looked through it and I see where the various actions are being done. I'm not looking for someone to write the code for me but instead point out the necessary code from the vBulletin files I need in order to make this work. I can write the code to integrate what I need as long as I have the right code from vBulletin.

[Brad]

Originally Posted by Radon3k

I've looked through this file and maybe it's just that I don't understand it but I don't see where exactly this stuff is. I've looked through it and I see where the various actions are being done. I'm not looking for someone to write the code for me but instead point out the necessary code from the vBulletin files I need in order to make this work. I can write the code to integrate what I need as long as I have the right code from vBulletin.

Check this area of register.php out.

PHP Code:

// ############################### start add member ###############################
if ($_POST['do'] == 'addmember')
{ 


[Radon3k]

Originally Posted by Brad.loo

Check this area of register.php out.

PHP Code:

// ############################### start add member ###############################
if ($_POST['do'] == 'addmember')
{ 


Thanks Brad. Do I need to include any file so that this works properly (aside from the file that holds the functions for the salt passwords)? I'm beginning to think it would be easier just to do the entire registration thing through vBulletin but I'll keep at it.

[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.