vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   [Help] Trying to run simple query to pull data and display in template (https://vborg.vbsupport.ru/showthread.php?t=110226)

SkyCatcher 03-13-2006 09:40 AM
[Help] Trying to run simple query to pull data and display in template
 
I'm very very confused right now. Since the new coder's forum opened up I've decided to pickup vb modification again and have been trying to work with the new plugin system.

I've added a new plugin with the hook global_start, figuring that the variables would be global...

PHP Code:

$mytestevent = $db->query_read("SELECT event.eventid, event.userid FROM " . TABLE_PREFIX . "event where session.userid=event.userid
        LEFT JOIN " . TABLE_PREFIX . "sesion AS session
        "ORDER BY eventid ASC" . "
    ");


$mytesteventdata = $db->fetch_array($mytestevent);


$eventdata = unserialize($mytestevent['eventid']);

foreach($eventdata => $result) 
{ 
  if ($vbulletin->userinfo['userid'] = event.userid) 
  { 
       $show[testing] .= $result." ";
  }

} 
$show[testing] does not show anything in my template. Every now and then I can modify it and it'll show Resource ID's but not values.

I'm trying to show this in postbit_legacy

What am I doing wrong?


All times are GMT. The time now is 06:39 AM.

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.01469 seconds
  • Memory Usage 1,707KB
  • 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
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete