Ques/Help SQL code to get user messages count from specific forum only

M

makerz

Guest
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.

Continue reading...