Query in postbit

[rogersnm]

I am trying to make a query inisde ta plugin with the location:postbit_display_complete but when i put $db->query_read or $vbulletin->db->query_read then you get:

Fatal error: Call to a member function on a non-object in /home/vbnova/public_html/includes/class_postbit.php(296) : eval()'d code on line 20

Which plugin location should i use?

It's in a class, so try:

PHP Code:

$this->registry->db-> 


[rogersnm]

now i have:

PHP Code:

$postuserid = $post['userid'];


$threadsmade = $this->registry->db->query_read("SELECT COUNT(*) AS threads FROM thread WHERE postuserid = '$postuserid'");


$post['threadsmade'] = $threadsmade['threads'];


echo $post['threadsmade'] . ", "; 


And all i get is: ", , , , , ," Any ideas?

[fabioski]

I have the same problem.
How can I query my DB in a postbit_display_complete location plug-in?

--------------- Added [DATE]1218810281[/DATE] at [TIME]1218810281[/TIME] ---------------

With:
$this->registry->db->query_read("
SELECT COUNT(*) AS numerolibri
FROM tab_mylib
WHERE myl_userid = '1'
");
$testo_libri .= "$this[numerolibri]";

I obtain this error:

Fatal error: Cannot use object of type vB_Postbit_Post as array in /var/www/web157/html/forum/includes/class_postbit.php(293) : eval()'d code on line 18

[Marco van Herwaarden]

Try:

PHP Code:

$query_result = $this->registry->db->query_first("
 SELECT COUNT(*) AS numerolibri
 FROM tab_mylib
 WHERE myl_userid = '1'
");
$testo_libri .= $query_result['numerolibri']; 


[fabioski]

Yeahhhh now it works!

I add some keywords for future searches:
query postbit
postbit plugin
query postbit_display_complete