Query: Display most participating users from actual forum

[ThorstenA]

This query displays the most participating users from actual forum - you can place it in plugin forumdisplay_start:

SELECT user.userid, user.username, count( * ) AS postcount 
FROM user, post, thread, 
(SELECT " . $foruminfo[forumid] . " AS forumid UNION  
SELECT forumid  
FROM forum  
WHERE parentlist LIKE \"%," . $foruminfo[forumid] . ",%\"  
) AS tmp_a 
WHERE thread.forumid = tmp_a.forumid 
AND user.userid = post.userid 
AND post.threadid = thread.threadid 
GROUP BY user.username 
ORDER BY postcount DESC  
LIMIT 5

[borbole]

SHouldn''t this be better posted at the Add on''s section?

[ThorstenA]

I have done several plugins for myself however I do not have currently the time to publish them as real products. Therefore I provide here my queries and if a developer likes to write a product out of it - that's cool