I have external PHP page and I want to show a list like that;
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.
Username | Total Post Count In That Forum |
---|---|
Jack | 24 |
Max | 13 |
Sam | 11 |
Kyle | 5 |
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.