Query to count user's Threads and Posts

[discussionarena]

What is the query to discover the exact number of threads of a member and the number of posts ?

Thanks

.

[Xenon]

[sql]SELECT count(*) FROM thread WHERE postuserid = xx[/sql]
[sql]SELECT count(*) FROM post WHERE userid = xx[/sql]

note: that will also show soft deleted and under moderation posts/threads

[discussionarena]

Thanks

[Xenon]

you're welcome

[WoGuziczek]

thanks

[romputer]

Following the logic, what would be the query to discover the exact number of posts for each forum the group "Registered Users" can see, per member?

Output something like this:
Member Name, Each Forum Name and Post Number
Frank, Forum1: 261, Forum2: 197, Forum3: 367

Thanks!

[Dismounted]

Not sure what you want there. Do you want the number of posts user X has done in each forum?

[romputer]

Originally Posted by Dismounted

Not sure what you want there. Do you want the number of posts user X has done in each forum?

Yes. Exactly. For every member of the usergroup "Registered Members" who has at least made one post in any forum.

Frank, Forum1: 261, Forum2: 197, Forum3: 367
Hank, Forum1: 11, Forum2: 39, Forum3: 912
Tank, Forum1: 732, Forum2: 1, Forum3: 214
Spanky, Forum1: 635, Forum2: 90, Forum3: 453

[Dismounted]

There is no "easy" query for that. You would have to select every post, and join the thread table to get the forum ID. Then loop through the results and increment the count of each user (this would be server intensive). However, doing this for just one user is much easier on the server, just limit the select to one user only.

[romputer]

okay, thanks.

I know I need a query but can't figure out how to write it. Anyone have an idea?

I want to have a more detailed post number listed for each member instead of just "posts". I have ten boards on the forum and would like to show how many posts each member has in each board.