vb.org Archive - add new lines to a table, when user register

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - add new lines to a table, when user register (https://vborg.vbsupport.ru/showthread.php?t=305237)

add new lines to a table, when user register

Hi guys, i am looking for a product or thread about this, but still cant found it yet

so when user register, i need to add new line to a table, for example
i have a customtable in database
the user is register & the userid is 10
i need to add this line in customtable :

Quote:

userid : 10
friendid : 1 (this is constant value that i set)

maybe using a plugin, with register_addmember_complete hook?

please help if you can, GBU for replying

--------------- Added [DATE]1386005901[/DATE] at [TIME]1386005901[/TIME] ---------------

update, i already get the code for the plugin, its like this

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
(1, " . $vbulletin->userinfo['userid'] . ")
");

the problem now is only what hook i need to use?

- using global_start is working, but its inserting more than one lines for each member, only need 1 line for each member

- using register_start, the line is created, but userid is still not created yet, still get 0 value

- using register_addmember_complete, not working at all

please help guys, only which hook question i need to choose now

I think you would want to use register_addmember_complete, but I don't know why it won't work for you. I think you'd want to use $userid for the new user's id instead of $vbulletin->userinfo['userid'].

already tried this code

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
(1, " . $userid . ")
");

or this

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
(1, $userid)
");

with hook register_addmember_complete, but nothing new line created in the table, is it i already right write the code?

btw my first code

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
(1, " . $vbulletin->userinfo['userid'] . ")
");

work created new line & get the userid, with hook global_start, maybe this is alternative way, but only need 1 line for each member, that is after registering,
i try wrap with these if conditional but its still not right :

if ($show['member'])
{
if (THIS_SCRIPT == 'register')
{

// above my first code

}
}

please give suggestion any hook or methode that will work like i need above

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
($userid, $friendid)
");

$userid should work for the actual userid if the person who just registered. So, you should define $friendid and use that as the $friendid.

Quote:

Originally Posted by basketmen (Post 2465487)

already tried this code

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
(1, " . $userid . ")
");

or this

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
(1, $userid)
");

with hook register_addmember_complete, but nothing new line created in the table, is it i already right write the code?

btw my first code

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
(1, " . $vbulletin->userinfo['userid'] . ")
");

ah its already working with hook register_addmember_complete, so its need Execution Order 1, instead 5

Quote:

Originally Posted by Lynne (Post 2465488)

PHP Code:


		
			
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "customtable 
(userid, friendid)
VALUES
($userid, $friendid)
");

$userid should work for the actual userid if the person who just registered. So, you should define $friendid and use that as the $friendid.

thank you for answering, in my case i need the new registered member as friendid, but i can change to the opposite if needed later

thank you very much & GBU for kh99 & Lynne
hope this thread can help others that need similar information too

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01863 seconds Memory Usage 1,748KB 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 (9)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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
Messages: