[Help] Trying to run simple query to pull data and display in template

[SkyCatcher]

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...



$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?