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.
