Need to have posts per forum per user

[kerpen]

On my site we elect moderators. To be eligible to vote in a given forum a user must have more than a minimum number of posts in that forum. When I used UBB I wrote a script that parsed all the forum indexes and created a file with an array of postcount values for each user. What would be the best way to accomplish this in VB/MySQL? I think it shoudl be a relatively straightforward query, but I figured I'd ask the experts before fumbling through MySQL docs.

Thanks.

[g-force2k2]

depending upon the quries you use and such it can create alot of queries... i personally have been planning a hack along these lines... you can take a look at my profile... probably the closest thing to what you're looking for would be my user activeness hack... regards... i will try and work on the hack soon... regards...

g-force2k2