Intergrating a user database to a forum database??

[karimali831]

Hey,

Is it possible to intergrate two user database's together so that the members don't have to register on two systems?

"www.clan-wars.net" (has a user database)
"www.clan-wars.net/forum" (has a user database)

Anyway?

[jon123]

Yes it is possible, you would need to use php to insert the registration details into both dbs. This needs to be done when the new user clicks the link on the email validation, so another $query would need to be created for the other db.
I haven't used vbullitin before but should imagine the table you need to add to is pretty self evident by its name.

[karimali831]

Originally Posted by jon123

Yes it is possible, you would need to use php to insert the registration details into both dbs. This needs to be done when the new user clicks the link on the email validation, so another $query would need to be created for the other db.
I haven't used vbullitin before but should imagine the table you need to add to is pretty self evident by its name.

Thanks for your post, I have no knowledge of how this process works. Is it possible if you could do this for me? (I wouldn't mind paying you) I really would like this to be done.

Cheers

[jon123]

I am all for making money, but not from offering advice.

As mentioned I have never used VBulletin so cannot offer you a script that i have written previously.
Have a look at this link

"vbulletin.org/forum/showthread.php?t=98233&page=4"]http://www.vbulletin.org/forum/showthread.php?t=98233&page=4"

[karimali831]

Hey,

very sorry I meant SMF - Forums. I wouldn't mind paying if you could possible do this.

Thanks.

[unknown4]

could someone possibly type out the code for such an event. There may be a possibility I, also will need this feature since I am thinking of placing a forums into my site
thanks
-unknown4

[jon123]

Originally Posted by karimali831

Hey,

very sorry I meant SMF - Forums. I wouldn't mind paying if you could possible do this.

Thanks.

Sry only just noticed this reply.

I haven't done SMF either and don't have time to write a script. I only only just started using SMF myself but had a quick look and can point you in the right direction.

First of all though I think you need to be clear on what you really want to achieve here and the best method of doing what you need.

All the registration and validation is done in the 'register.php' file in the sources folder. You scroll down to 'function (activate) and you need to pick the bones out of the "insert into database.

First glance at the validation email uses "u" as the variable to identify the new user with the details contained in the database. (from registering)
This "u" is the members id field in the database.

Therefore: If you scroll down register.php file until you see where is states that the activation was successful, you could then query that database for the user datails and then insert those details into the other database.

i.e; SELECT ALL FROM {$db_prefix}members WHERE ID_MEMBER='u';

Then you can create the login details for the other database and
INSERT INTO ID_MEMBERS....................

Don't know if that makes any sense at all! but it is one of the ways to do what you need.

You could also remove the registering from one forum and redirect registering only on the other, then create a cron job to periodically copy the members table.

[jon123]

top should read:

Then you can create the login details for the other database and then insert the new member details,
INSERT INTO {$db_prefix}members ....................

[Armavia]

Did this solve your problem?