vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Is this SQL query correct? (https://vborg.vbsupport.ru/showthread.php?t=215348)

powerful_rogue 06-10-2009 06:37 PM

Quote:

Originally Posted by Lynne (Post 1826978)
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'], 11);

    (
$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 06-10-2009 07:55 PM

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 06-11-2009 07:05 AM

1 Attachment(s)
Hi Lynne,

In the pluggin I have this line
PHP Code:

$bbuserinfo    =& $vbulletin->userinfo

Within the ACP you can type

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 06-11-2009 03:37 PM

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 06-11-2009 08:04 PM

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
Quote:

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 06-11-2009 08:28 PM

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

powerful_rogue 06-11-2009 08:38 PM

1 Attachment(s)
Hi Lynne,
Thanks for your reply.

Im using it in the ACP

Lynne 06-11-2009 08:48 PM

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.


All times are GMT. The time now is 07:23 PM.

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.01134 seconds
  • Memory Usage 1,755KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete