Hello,

I've been doing a lot of reading throughout any VB resource I could find, but still cannot figure out how to get this to work;

I have built an SQL query that returns the count of a user's topics in certain forums. I want to use this as a variable, so I can use it in my postbit templates, next to each user avatar for example.


The code I THINK I should use to define the variable with this SQL query is this;

$stories = $vbulletin->db->query_read("
SELECT
Count(vbthread.threadid)
FROM vbthread
WHERE
(vbthread.forumid = '57' OR
vbthread.forumid = '58' OR
vbthread.forumid = '59' OR
vbthread.forumid = '60' OR
vbthread.forumid = '61' OR
vbthread.forumid = '62' OR
vbthread.forumid = '63' ) AND
vbthread.postuserid = '$post[userid]'
");


1. Is this correct? If not, what is the way to define my query as a variable?

2. Where should I use this code to define the variable and then be able to use the $stories variable inside my postbit template? I tried creating a new plugin using a hook from postbit_start or postbit_complete, but it does not work.

Any ideas please? I've been trying to make this work for quite a few days now.

Thanks.

I posted an XML file that allowed you to do this, a fairly long time ago. To sum up you should use something like this; Comment says the rest

Woooooot!!! It worked!!!

Thankyou so much for your help!!!

Can I send you a Christmas present or something?


Best regards from Athens, Greece.

You can if you want but the postage would be a killer :p.

LOL I came back with another question regarding this hack.

I now have it as a plugin, located in the postbit_start hook. But I need to use it in other pages as well, for example the memberinfo page. How could I do that? Is there any other hook location I could place this code so that it would work more "globally" instead of just the postbit?

Can anyone help me on this ? I use the abovementioned code as a plugin, and then call the $stories[num] variable in the postbit templates, and it's working ok.

But it's messing up my rss feeds now, they are not working and I get database errors pointing at this hack.

I think it is a problem with the hook location I'm using. I'm using postbit_display_start , should I use it in another hook location?????