Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 11-12-2011, 12:33 PM
Mark.B Mark.B is offline
Senior Member
 
Join Date: Feb 2004
Posts: 1,354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Group Messagebit Plugin Query

Right this one has me totally baffled and I can't fix it.

On vB3 I was able to query custom user fields (at the hook group_messagebit_display_complete) so the data could be used in the template group_message as follows:

Code:
$username = $message['username'];

$sql = "SELECT user.userid, user.usergroupid, userfield.field14, userfield.field13, userfield.field15
FROM user AS user
LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid)
WHERE user.username = '" . mysql_real_escape_string($username) . "' LIMIT 1";

$query = mysql_query($sql);

// Do our error checking first...
if(!$query)
{
echo 'Username: Invalid';
}
else
{
// Use mysql_fetch_assoc to return [field] => [value] array result
$data = mysql_fetch_assoc($query);

$message['field14'] = $data['field14'];
$message['field13'] = $data['field13'];
$message['field15'] = $data['field15'];
}
Parts of this are borrowed from hacks on here.

Anyway this worked fine on vB3.

Now that I have reopened my groups on vB4 I thought I'd use the same code but it simply doesn't work.

Some diagnostics have revealed that the hook itself works, the problem seems to be that the variable $message is no longer recognised at this hook.

My test for that has been to add the following line:
Code:
$template_hook['field15'] = "Test";
I can then output {vb:raw template_hook.message15} in the template and it works.
But if I try:
Code:
$template_hook['field15'] = $message['username'];
Then {vb:raw template_hook.field15} returns nothing.

It can't be a variable registration issue as $message is definitely available in the template, it is already used throughout.

Therefore, I'm finally stumped. Anyone got any idea how I can plug this code in? Even if it means editing a file I don't mind.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06981 seconds
  • Memory Usage 2,185KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete