Add a new Block with PHP content?

[mokujin]

hello,
I just tried to add a new block (Forum Blocks Manager) with PHP content type but there is always error.
just tried:

PHP Code:

$users = $vbulletin->db->query_read_slave("
            SELECT userid,username,posts
            FROM ".TABLE_PREFIX."user ORDER BY posts
        "); 


[Lynne]

And the error is?

[ragtek]

Is this the only code you're using?
That wount work

1. You have to use vB::$db-> instead of $vbulletin->db
2. You'll need to fetch the query.
3. You'll need to add the results to an array or to a template
4. You'll need to return it

[mokujin]

Originally Posted by ragtek

Is this the only code you're using?
That wount work

1. You have to use vB::$db-> instead of $vbulletin->db
2. You'll need to fetch the query.
3. You'll need to add the results to an array or to a template
4. You'll need to return it

Can you please give me an example? Thank you

[Lynne]

If you want to see an example, here's a real simple block that just spits out the user's username:

PHP Code:

$result = vB::$vbulletin->db->query_first("SELECT username, userid FROM user where userid = ". vB::$vbulletin->userinfo['userid'] ." LIMIT 1"); 

return $result[username]; 


[Dunhamzzz]

I've done things in a slightly different way....

I was making widget (not sure how these differ from sidebar blocks)

But I made completely blank template, with just {vb:raw output} in it, and in my php area just include() an external file and have the out stored in $output.

Means I can edit the included file however I want, and I can re-use that template too.