vBulletin Plugin programming help

[flOid]

I'm just at programming my first vBulletin plugin. It's supposed to display current users in a IRC chat room using the a mysql statserv database. Here's the code, hook location is forumhome_start (should display within the "What's going on" section):

PHP Code:

$doQuery=$db->query_read("SELECT nick FROM denora.user WHERE hostname  NOT LIKE 'localhost.net' AND hostname NOT LIKE '%mydomain.tld%' AND online = 'Y'");
$numrows=mysql_num_rows($doQuery);
$chatters2 = "";
if($numrows>0)
{
 while($chatters=mysql_fetch_array($doQuery))
  {
   $chatters2 .= $chatters[0];
   $chatters2 .= ", ";
  }
}

$chatusers = substr_replace($chatters2,"",-2); 


The general code used to work in my previous IPB. However, it's just not working when I put the $chatusers variable now in the forumhome template.

What am I missing?

[Opserty]

Try this though I don't think it will work:

PHP Code:

$query = $db->query_read("SELECT nick FROM denora.user WHERE hostname  NOT LIKE 'localhost.net' AND hostname NOT LIKE '%mydomain.tld%' AND online = 'Y'");
if($db->num_rows($query))
{
    $chatters = '';
    while($chatter = $db->fetch_array($query))
    {
        $chatters .= $chatter['nick'];
        $chatters .= ', ';
    }
}

$chatusers = substr_replace($chatters, '', -2); 


Can you verify that the query is returning users? (Try executing in the AdminCP [> Maintenance > Execute SQL Query])

[flOid]

Yes, it is. Already tried that.

[Opserty]

At the bottom of your plugin temporarily run this (on the last line):

PHP Code:

var_dump($chatusers); 


What do you get returned when you view the page? (There should be something right at the top).

[flOid]

I got it working now, tnx!

[Opserty]

Ok, what was wrong?

[flOid]

I did use your suggested code and it did work.