IPB's "Most active in" profile feature for vBulletin?

[Ingmar]

Hello guys and gals,

I really like the IPB "Most active in" profile feature... is there anything out there like this for vBulletin?

Thanks in advance.

[Paul M]

What does it actually do ?

[Ingmar]

Hi Paul,

It shows which forum the user is most active in (i.e.: Most active in: vBulletin Discussions).

I haven't looked at at the vBulletin db structure yet but

select forumid
from posts
where user = '$user'
group by forumid
order by postcount desc

that type of thing...

Just thought I would ask if there was an existing hack before I mess around with it myself.

Thanks for the reply.