add new lines to a table, when user register

[basketmen]

Originally Posted by basketmen

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

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

Originally Posted by Lynne

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