XF 2.2 SQL code to get user messages count from specific forum only

punisher1

Member
I have external PHP page and I want to show a list like that;

UsernameTotal Post Count In That Forum
Jack24
Max13
Sam11
Kyle5

But the message count should come from specific forum only. I need the SQL query code for it. I've checked xf_post table but there I can't find the forum ID and I am stuck and don't know how can I achieve this.
 
Back
Top Bottom