how to Enterd Users to 2 Table

[Aram-GSM]

I want users, after membership (when the database is compiled informations) informations inside a table, another is entered.

The profile of each user is within 2 table.

Now there are two for this job:

1 - changed the table name. So that the user profile into the "user" is recorded, within the "users" should be recorded and can be read from there.

2 - I add a query code to vBulletin after this information into its own table (user) will, within the table that I want (users) excitement. (Ie 2 is here)

I desired query code. I searched the register.php code. But a good place to put the query code did not.

Because to enter the user profile database function is used.

I hope you understand my order ....

please help me to do this job.

[marrr]

From the looks of it you would create a new plugin Plugins & Products > Add New Plugin . Use the hook register_addmember_complete . Then use code similar to below:

PHP Code:

$db->query_write("REPLACE INTO *YOUR_TABLE_NAME* (*FIELD_NAMES*) VALUES (*FIELD_VALUES*)"); 


NOTE: You would replace the values between the *'s and not include the *'s in your final code! Each field name and field value is delimited by a comma.

Any time a person registers then the data you specify from the registration process will be inserted into your other table, granted it is in the same database. You would need additional code if it was a separate database. Unfortunately I do not know the variable names for all the data being posted, you may need someone with more knowledge on that to help.

[Aram-GSM]

Thank you so much from the answer

I know the name of the destination table fields.

But I do not know what function, for example username is located.

Please name the function that the user name and password ... Say they are.

Now I put this code and the error was related to the database:

PHP Code:

$db->query_write("REPLACE INTO " . TABLE_PREFIX . "users (user_id, name, username, user_email, user_avatar, user_password) VALUES (userid, username,  username, email, 'gallery/blank.gif', password)"); 


[Aram-GSM]

Please Help Me...