Registration/Activation Process

[consolegaming]

Hi, basically we're coding a website to run alongside a vBulletin forum and are using vB for all the user information etc and we're basically trying to come up with our own registration script.

We know how to code with php, html and how to work with databases etc so that's not the issue but I'm simply trying to find out what tables the vB registration script inserts data to at the time of registration and then again at the time of activation so that we can duplicate this effect with our own scripts.

i.e. We're well aware a row gets inserted into the user table and they're usergroupid is the unactivated usergroup. But I am aware there are multiple tables that concern users and obviously want to duplicate the effect properly so as to not screw up any information.

If any help could be given on listing the appropriate steps for both the registration and activation process. I.e. which tables require data inserting to, and any particular fields which may be crucial to the overall process.

Thanks in advance.