Accessing $db object from within a sidebar block

[d1jsp]

Hello,

I'm trying to create my first sidebar block using PHP. I'm hitting an issue where I can't access the $db object from within the code. I've tried both $db and $vbulletin->db

here's a sample of my code:


...
require_once('./global.php');
require_once('./includes/functions.php');
$results = $vbulletin->db->query_read("SELECT blah FROM blah");
...


but I just keep getting
Fatal error: Call to a member function query_read() on a non-object in /home/content/04/7100404/html/includes/block/html.php(95) : eval()'d code on line 5

Any ideas?

[kh99]

That code is called from inside a function, so you need to declare any globals you want to use. You want to add:
global $vbulletin;

(or $db instead of $vbulletin, if you just want to access $db) at the beginning of your block code.

[d1jsp]

That code is called from inside a function, so you need to declare any globals you want to use. You want to add:
global $vbulletin;

(or $db instead of $vbulletin, if you just want to access $db) at the beginning of your block code.

That was it... I forgot one of the basics... Thanks kh99!