vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   how to Enterd Users to 2 Table (https://vborg.vbsupport.ru/showthread.php?t=245707)

Aram-GSM 07-02-2010 10:03 AM

how to Enterd Users to 2 Table
 
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 07-02-2010 11:30 AM

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 07-02-2010 04:09 PM

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 09-19-2010 07:11 AM

Please Help Me...


All times are GMT. The time now is 03:32 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00960 seconds
  • Memory Usage 1,716KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete