problem with variables in plugin

[Schluml]

hi,

i've got a plugin with a query which is gettin the threads in different forums for each user.

My problem is, i save the query result in a variable and want to print it in the postbit, but the variable seems to be empty in postbit. As hook i'm using
"showthread_postbit_create"

query code:

PHP Code:

$tresult = $vbulletin->db->query_first("SELECT COUNT(*) AS anzahl FROM ". TABLE_PREFIX ."thread WHERE forumid IN (1,4,8) AND postuserid=".$post['userid'].""); 


in postbit i'm using:

PHP Code:

$result[anzahl] 


but, nothing happens...

the qery seems to be ok, i tested it.

so, whats the problem?

P.S. my english isnt perfect, hope u understand me

[calorie]

Try setting $tresult_anzahl = $tresult['anzahl']; and then use $tresult_anzahl in postbit.

[Schluml]

hi, thx but still the same problem...

[calorie]

Try setting $post['anzahl'] = $tresult['anzahl']; and then use $post[anzahl] in postbit.

[tnguy3n]

you declared the variable to be $tresult, so to print your result in postbit, you should put $tresult[anzahl]

[merk]

showthread_postbit_create is the wrong hook.

Use postbit_display_complete.

[Marco van Herwaarden]

$tresult != $result

Use $tresult[anzahl] in your postbit.
If it still don't show, add the following line to the top of your plugin:

PHP Code:

global $tresult; 


PS A much better/nicer way of doing this would be:

PHP Code:

$tresult = $vbulletin->db->query_first("SELECT COUNT(*) AS anzahl FROM ". TABLE_PREFIX ."thread WHERE forumid IN (1,4,8) AND postuserid=".$post['userid']."");  
$post['anzahl'] = $tresult['anzahl']; 


This is because $post is the array that is used everywhere else to store the values of a single post.

Please also note that this should be optimized to avoid performance issues. Your plugin (and the query inside) will be executed for each post on a page, also if the same member has posted more then once on the same page. It would be better to retrieve the values of each user that has posted only once.

[calorie]

ignore... being dumb or tired or both

[merk]

$this->registry->db

[calorie]

Thanks merk, didn't think of that, duh on me.