How to find users who post the most photos?

[trgreen]

I have PP integrated w/vB, and I need to sort all my users by number of photos posted. Basically, I'm trying to find the 20 or so most active photo posters. Is there an easy way to do this? I use phpMyAdmin and I know a bit of MySQL, but I'm having trouble getting it right. Any suggestions?

[Chuck S]

The top posters pal which shows on the sidebar or undercats pal should show this already. You can look at the code in pp-inc.php for this pal to see how thats done. We do have code mod forums outside the support forums where users may discuss code modification.