Is this SQL query correct?

[powerful_rogue]

Originally Posted by Lynne

Again, look at register.php. That is the best thing to do. Find this right around line 1000:

PHP Code:

    $userinfo = verify_id('user', $vbulletin->GPC['u'], 1, 1);

    ($hook = vBulletinHook::fetch_hook('register_activate_start')) ? eval($hook) : false; 


You really need to look at the page you are using plugins for to see what is already going on.

Hi Lynne,
Thank you ever so much. I have learnt a very valuable lesson. By changing the hook it now works a treat.
They say you learn by your mistakes and this has certainly taught me to check hooks and the code before and after.

One very final thing if it would be possible to pick your brains once more! In the code ive got the following line

PHP Code:

$bbuserinfo    =& $vbulletin->userinfo; 


So I can use the following code to place a link to the new members profile in the text of the post

PHP Code:

[URL="$vboptions[bburl]/member.php?u=$userid"]$bbuserinfo[username][/url] 


At present its still coming up with unregistered within the text of the post and the link has no userid at the end. Ive tried having a play around with this but at the moment am drawing a blank.

Would you be able to suggestions on how to get this to reflect the name shown in

PHP Code:

$username = $userdata['username']; 


along with the userid?

As this is happening before the member is signed in, am I correct in thinking it would be a case of adding more database queries to get this information?