Where to include a new variable?

[Defkalion]

Thankyou so much for your reply.

Originally Posted by Opserty

Have you tried $post['postuserid'] instead of just $post['userid'] maybe that will correct it?

I tried but this produced an SQL error whenever I tried to view any topic.

Originally Posted by Opserty

Also you can just say this for your query:
[sql]
SELECT COUNT(threadid) AS num FROM vbthread WHERE forumid IN (57, 58, 59..., 63) AND postuserid = $post['postuserid'][/sql]

This produced the same SQL error as the above.

Originally Posted by Opserty

Finally remember you are running a query on every postbit on every showthread so you may want to rethink what you are doing. You may be able to modify the showthread query using the showthread_query hook and add a join/count to the query.

I know and you are correct, but I do not know how to make this work in any other way. Thankyou for your suggestion but I cannot implement this without some help. You mean I should use the same query but insert it at the showthread_query hook? What do you mean add a join/count to the query?

Anyway my website is not that big so I don't have performance issues with this hack, so even if I could correct this problem with my RSS feeds I would keep it in the postbit.

Any other ideas?

Thankyou for your time.
Regards.

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

Ok someone else helped me, the solution is here:

http://www.vbnova.com/showthread.php?p=7259#post7259

Thanks for taking the time to read this.