I'm trying to figure a way to query the top 5 posters for a contest I'm having. However, I'd only like the post counts for certain forums of the board. How would I go about doing something like this?
Thanks.
That would require custom code, try asking over at vBulletin.org.
I don't quite understand your answer. I have one board, with several forums. These forums each have several child forums. The members post in all of the different forums. I'd like a way to count the top five posters of only certain forums combined. For example, I don't want to include the general discussion forum, but only actual informative forums.
Thanks.
You could list the memberlist on posts and limit it to 5 ?
Thanks Lats, that did the trick.
Try this query...
SELECT post.username, count( post.postid ) AS postcount
FROM post
LEFT
JOIN thread ON thread.threadid = post.threadid
WHERE thread.forumid IN (2,3,4)
GROUP BY post.username
ORDER BY postcount DESC
LIMIT 5
Replace 2,3,4 with the forumids of your choice.
 Nortel Unveils Vision, Strategy for Israeli High-Performance Net
 Busy Friday Leads to Strong Close for Net Stocks
|
