Thankyou so much for your reply.
Quote:
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.
Quote:
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.
Quote:
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.