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?

[Lynne]

I really can't say since I have no clue where you placed that link - is that in the plugin? In a template? Seeing that line alone tells me nothing about the variables. What plugin code are you currently using an which hook location?

[powerful_rogue]

Hi Lynne,

In the pluggin I have this line

PHP Code:

$bbuserinfo    =& $vbulletin->userinfo; 


Within the ACP you can type

$bbuserinfo[username]

So when the thread is created within the text it will place the new members username linking it to their profile. The only issue I have now is getting this to work with the "register_activate_start" hook as its comes up as "Unregistered" and the link has "userid=" on the end.

[Lynne]

You need to follow the trail of what happens when - when during this whole process is the thread being created? And how do you know what variables are available at that time - have you looked at the code around where the thread is created? Also, $bbuserinfo gets used at other places and perhaps it is getting written over. So, perhaps try using a different variable name.

[powerful_rogue]

Hi Lynne,
Im almost there, just got one final hurdle!

I created a query to get the userid of the member. The code below works fine in linking to their profile

Hi $username, welcome to the forum!

PHP Code:

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


However im having problems trying to get the username to show!

PHP Code:

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


shows "powerful_rogue"

PHP Code:

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


shows \'powerful_rogue\'

PHP Code:

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


throws the following error

Parse error: syntax error, unexpected '/', expecting T_STRING or T_VARIABLE or T_NUM_STRING

[Lynne]

How come you are using bbcode and not html? I don't know where that code is being used.

[powerful_rogue]

Hi Lynne,
Thanks for your reply.

Im using it in the ACP

[Lynne]

Then you need to look at the code that is parsing the field. I've always created fields in the ACP that allow html to be used so I'm not sure what else to suggest.